Job Description

At Pacific Programming and Tech Inc., we are passionate about crafting innovative software solutions that empower businesses and enhance user experiences. Our team thrives on collaboration, creativity, and a commitment to excellence. We are a leading software development firm specializing in the development of various systems and related applications, and we are currently seeking a highly skilled

Data Engineer Lead

to join our growing team.



In this role, you will be responsible for designing, building, and maintaining reliable data pipelines and platforms that power analytics, reporting, and data-driven decision-making across the organization. You will work closely with analysts, data scientists, and software engineers to ensure data is accurate, accessible, and scalable.

Key Responsibilities

Design, implement, and maintain ETL/ELT pipelines using Apache Airflow and dbt Core. Develop real-time and batch data ingestion solutions with Apache Kafka. Manage and optimize relational databases, with a focus on SQL Server. Write efficient, reusable, and reliable code in Python for data processing and automation. Integrate pipelines into CI/CD workflows for reliable deployments. Monitor data pipelines for reliability and performance, resolving issues proactively. Collaborate with cross-functional teams to define data models and schemas that support analytics and operational needs. Implement data quality checks, testing, and validation processes. Mentor other members of the team. Participate in architectural discussions.

Qualifications

Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent work experience). Proven experience as a Data Engineer or similar role. Strong hands-on experience with Airflow for workflow orchestration. Practical knowledge of Kafka for event streaming and messaging. Proficiency in SQL and database administration, preferably SQL Server. Solid programming skills in Python (data pipelines, APIs, automation). Experience with dbt Core for data modeling and transformations. Familiarity with CI/CD practices for automated testing and deployment. Strong problem-solving skills and ability to work in fast-paced environments.

What We Offer

Competitive salary based on your level of experience. A benefits package that includes an extensive health insurance package, as well annual vacation, sick and personal days. A remote-hybrid work environment and flexible work arrangements to promote work-life balance. A collaborative and supportive work culture. Opportunities for professional growth and development. * Offices located in the heart of Montreal and Vancouver, with direct access to public transit.