Data Engineer

Ace1Media; Vancouver; On-site; CAD 90,000 - 130,000; Full time

Job summary

Ace1 Media, a Vancouver-based data-focused media company, seeks a Data Engineer to build and maintain scalable data pipelines, ETL processes, and data integration across projects.

You will work with Python and SQL, relational databases, and Airflow to orchestrate workflows, ensure data quality, and support analytics-driven solutions for business growth.

Qualifications

• Bachelor's degree in CS/Engineering/IT or related field or equivalent work experience.
• Familiarity with ETL processes and data modeling concepts.
• Basic experience with programming languages such as Python and SQL.
• Strong understanding of relational databases (MySQL, PostgreSQL).
• Familiarity with data pipeline orchestration tools like Apache Airflow.
• Experience with version control systems like Git.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to work independently and collaboratively in a fast-paced environment.

Responsibilities

• Design, build, and maintain scalable data pipelines to support data integration, ETL processes, and data modeling.
• Implement and manage data workflows using Apache Airflow to orchestrate complex data processes.
• Develop efficient and reusable code in Python and SQL for data processing and automation.
• Work with relational databases to ensure proper data storage, access, and retrieval (MySQL, PostgreSQL, etc.).
• Ensure data quality, integrity, and consistency across different systems.
• Manage version control processes using Git to maintain codebase consistency and collaboration.
• Troubleshoot and optimize data processes to ensure performance and reliability of data pipelines.
• Stay current with industry trends and emerging technologies in data engineering.

Skills

Python

SQL

ETL concepts

Data modeling

Apache Airflow

Git

Relational databases

Education

Bachelor's degree in CS/Engineering/IT

Tools

MySQL

PostgreSQL

Apache Airflow

Git

Job description

Ace1 Media is a dynamic and innovative media company specializing in creating high-quality content and data-driven solutions to support business growth. We leverage cutting-edge technology to streamline processes and deliver exceptional results. Our team is passionate about developing transformative solutions that harness the power of data to drive better decisions and impactful outcomes.

Position Overview:

We are seeking a motivated Data Engineer to join our growing team at Ace1 Media. In this role, you will be responsible for building and maintaining efficient data pipelines, developing ETL processes, and supporting the integration of complex datasets to ensure seamless data workflows for our various projects. The ideal candidate will have a strong foundation in data engineering concepts, be comfortable working with Python and SQL, and possess a deep understanding of relational databases. This is an exciting opportunity to help shape the data infrastructure that powers our media and analytics-driven solutions.

Key Responsibilities:

• Design, build, and maintain scalable data pipelines to support data integration, ETL processes, and data modeling.
• Implement and manage data workflows using Apache Airflow to orchestrate complex data processes.
• Develop efficient and reusable code in Python and SQL for data processing and automation.
• Work with relational databases to ensure proper data storage, access, and retrieval (MySQL, PostgreSQL, etc.).
• Ensure data quality, integrity, and consistency across different systems.
• Manage version control processes using Git to maintain codebase consistency and collaboration.
• Troubleshoot and optimize data processes to ensure performance and reliability of data pipelines.
• Stay current with industry trends and emerging technologies in the data engineering space to continuously improve our data practices.

Required Qualifications:

• Bachelor's degree in Computer Science, Engineering, Information Technology, or a related field (or equivalent work experience).
• Familiarity with ETL processes (Extract, Transform, Load) and data modeling concepts.
• Basic experience with programming languages such as Python and SQL.
• Strong understanding of relational databases (e.g., MySQL, PostgreSQL).
• Familiarity with data pipeline orchestration tools like Apache Airflow.
• Experience with version control systems like Git.
• Strong analytical and problem-solving skills with great attention to detail.
• Ability to work independently and collaboratively in a fast-paced environment.

Why Join Ace1 Media?

• Innovative Environment: Work with a team of forward-thinking professionals passionate about leveraging data for creative and business success.
• Growth Opportunities: As a growing media company, we offer opportunities for personal and professional development.
• Collaborative Culture: Join a team that values collaboration, innovation, and continuous learning.
• Competitive Compensation: We offer competitive salaries, benefits, and perks.