Designs, develops, and maintains scalable data pipelines, warehouses, lakes, and cloud-based data architectures using Snowflake and Azure services. Builds transformations with dbt and orchestrates ETL workflows using Azure Data Factory or similar tools. Implements data quality checks, governance policies, metadata management, data dictionaries, lineage, and classification standards. Collaborates with business and data teams to create efficient models and standards while mentoring developers and promoting best practices.
Job Description
As a Data Developer II, you will be responsible for designing, implementing, and maintaining GEM's data infrastructure and systems with a strong emphasis on leveraging modern data technologies and cloud platforms. The ideal candidate will have a proven track record in building scalable data solutions to enable advanced analytics and data management capabilities. This role will also involve driving the adoption of best practices in data engineering, promoting a data-centric culture, and providing mentorship within the development team.
What does your typical day look like?
- Design, develop, and maintain modern data pipelines, data warehouses, and data lakes using Snowflake and Azure Data Services.
- Architect data solutions leveraging DBT for data transformation and Azure Data Factory for pipeline orchestration.
- Collaborate with business and data teams to translate data requirements into efficient data models, ensuring compliance with data governance and architecture standards.
- Utilize cloud-native data services, including Azure Storage, to optimize data management and scalability.
- Implement and automate data quality checks using tools like DBT tests.
- Implement and enforce data governance policies and procedures to ensure data quality, consistency, and compliance.
- Develop and maintain data dictionaries, data lineage, and metadata management processes.
- Collaborate with stakeholders to define data standards, naming conventions, and data classification.
What skills and training do you need?
- Bachelor's or graduate degree in computer engineering, mathematics, data science, or related disciplines.
- 4-6 years of professional experience in a related field.
- Experience using the following software/tools:
- Relational and NoSQL databases (e.g., MS SQL Server, Snowflake, PostgreSQL, MariaDB).
- Cloud platforms (Azure preferred) and cloud-based data services.
- Data modeling and transformation tools like DBT.
- ETL tools such as Azure Data Factory, Airflow, or Informatica.
- Knowledge of APIs and data integration strategies.
- Relevant certifications in Azure Data Services or Snowflake are a plus.
- Advanced proficiency in modern data technologies such as Snowflake, DBT, and Azure Data Factory.
- Strong experience with SQL and data pipeline automation.
- Deep understanding of data governance frameworks, data quality management, and security protocols.
- Ability to collaborate across teams, communicate complex technical solutions, and drive consensus on best practices.
- Proven track record of designing and implementing cloud-based data architectures with a focus on scalability, security, and cost-efficiency.
When you apply:
If you require assistance or accommodation during our recruitment process, please notify Human Resources so that we can review and consider how we may be able to assist you based on your individual needs.
We offer youGlobal Excel offers more than a position;
- We offer a competitive compensation package that includes a base salary, performance bonus and an extensive benefits package;
- A professional future with opportunities for development, growth, and advancement;
- RRSP Match program;
- Financial assistance to employees who wish to continue their education;
- Work/life balance, health and wellness initiatives including an excellent EAP program;
- Employee engagement programs that focus on fitness, food, and fun;
- Windsor, Ontario Candidates: base hourly salary scale ($35.06/hour - $46.00/hour). Relevant candidate experience considered;
- Other locations, salary to be discussed based on geographic differential.
To get a taste of the Global Excel life and for more information on our company, visit our Facebook page and website:
Similar Jobs
Fintech • Insurance • Financial Services
Develops complex data models, ETL jobs, and data engineering frameworks using Azure, Databricks, PySpark, Python, SQL, and ADF. Analyzes data requirements, supports ingestion and data quality, maintains governance, metadata, and lineage, and resolves complex data issues. Leads design reviews, testing, deployment, release activities, and engineering initiatives while collaborating with technical and business stakeholders and mentoring team members.
Top Skills:
Azure Data FactoryCi/CdDatabricksETLAzurePysparkPythonSQL
Fintech • Insurance • Financial Services
Designs and maintains scalable data pipelines, warehouses, lakes, and cloud-based data architectures using Snowflake and Azure services. Develops dbt transformations, Azure Data Factory orchestration, automated data quality checks, and data governance processes. Creates data dictionaries, lineage, metadata, and standards while collaborating with business and data teams. The role also involves mentoring developers and promoting secure, scalable, and cost-efficient data engineering practices.
Top Skills:
Apache AirflowAPIsAzure Data FactoryAzure Data ServicesAzure StorageDbtInformaticaMariadbMicrosoft Sql ServerNosql DatabasesPostgresSnowflakeSQL
Fintech • Insurance • Financial Services
Enhance, modernize, and support critical credit risk applications through data modeling, profiling, quality management, acquisition, ingestion, ETL, metadata, lineage, and governance. Develop complex data models and ETL frameworks, troubleshoot production and testing issues, support deployments and releases, participate in architecture reviews, and lead data engineering initiatives. The role also requires collaboration with business and technology partners, regulatory compliance, risk management, mentoring, and knowledge sharing.
Top Skills:
Asp.Net CoreAzure SqlC#Ci/CdData GovernanceData LineageData ModelingDevOpsETLMetadata ManagementServicenowSql Server 2022SsisTelerik Controls
What you need to know about the Calgary Tech Scene
Employees can spend up to one-third of their life at work, so choosing the right company is crucial, not just for the job itself but for the company culture as well. While startups often offer dynamic culture and growth opportunities, large corporations provide benefits like career development and networking, especially appealing to recent graduates. Fortunately, Calgary stands out as a hub for both, recognized as one of Startup Genome's Top 100 Emerging Ecosystems, while also playing host to a number of multinational enterprises. In Calgary, job seekers can find a wide range of opportunities.
