Senior Data Engineer

Global Excel; Windsor; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading company in data solutions is seeking a Data Developer II to enhance its data infrastructure. The role involves designing and maintaining data pipelines using modern technologies like Snowflake and Azure. Ideal candidates will have a strong background in data engineering, excellent collaboration skills, and a commitment to data governance and quality management.

Benefits

Competitive compensation

Performance bonuses

Benefits package

Qualifications

• 4-6 years of professional experience in data-related roles.
• Experience with Azure cloud platforms and data services.
• Certifications in Azure Data Services or Snowflake are advantageous.

Responsibilities

• Design, develop, and maintain data pipelines and data lakes using Snowflake and Azure Data Services.
• Implement automated data quality checks with tools like DBT tests.
• Enforce data governance policies to ensure data quality and compliance.

Skills

Data modeling

Data governance

SQL

Data pipeline automation

Collaboration

Communication

Education

Bachelor's or higher degree in computer engineering, mathematics, data science

Tools

Snowflake

Azure Data Factory

DBT

MS SQL Server

PostgreSQL

Job description

Job Description

As a Data Developer II, you will be responsible for designing, implementing, and maintaining GEM's data infrastructure and systems, with an emphasis on 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 also involves promoting best practices in data engineering, fostering a data-centric culture, and mentoring team members.

What does your typical day look like?

1. Design, develop, and maintain data pipelines, data warehouses, and data lakes using Snowflake and Azure Data Services.
2. Architect data solutions utilizing DBT for transformations and Azure Data Factory for orchestration.
3. Collaborate with business and data teams to translate requirements into efficient data models, ensuring compliance with governance and architecture standards.
4. Leverage cloud-native data services, including Azure Storage, to optimize data management and scalability.
5. Implement automated data quality checks with tools like DBT tests.
6. Enforce data governance policies to ensure data quality, consistency, and compliance.
7. Maintain data dictionaries, lineage, and metadata management processes.
8. Work with stakeholders to define data standards, naming conventions, and classifications.

What skills and training do you need?

1. Bachelor's or higher degree in computer engineering, mathematics, data science, or related fields.
2. 4-6 years of professional experience in data-related roles.
3. Experience with:
4. Relational and NoSQL databases (e.g., MS SQL Server, Snowflake, PostgreSQL, MariaDB).
5. Azure cloud platforms and data services.
6. Data modeling and transformation tools like DBT.
7. ETL tools such as Azure Data Factory, Airflow, or Informatica.
8. APIs and data integration strategies.
9. Certifications in Azure Data Services or Snowflake are advantageous.
10. Proficiency in Snowflake, DBT, and Azure Data Factory.
11. Strong SQL and data pipeline automation skills.
12. Knowledge of data governance, quality management, and security protocols.
13. Excellent collaboration, communication, and consensus-building skills.
14. Experience designing scalable, secure, and cost-effective cloud data architectures.

When you apply:

If you need assistance or accommodations during the recruitment process, please notify Human Resources so we can support your needs.

We offer:

• A professional future with competitive compensation, including base salary, performance bonuses, and benefits.
• Contact your local HR for more information about benefits in your location.

For more about our company and culture:

Visit our Facebook page and website for insights into the Global Excel life.