Data & Analytics lead

Location: Markham, ON (Hybrid – 3 days on-site)
Language: Strong written and verbal communication skills in English are required.
Salary: $100,000–$125,000 annually

About the Opportunity

Our client, a well-established organization in the corporate sector, is seeking a Senior Data Engineer / Senior BI / Analytics Engineering Lead to design, build, and optimize scalable data solutions that support business intelligence, reporting, and advanced analytics. This is an exciting opportunity to join a growing team where you'll play a key role in developing reliable data pipelines, improving data quality, and enabling data-driven decision-making across the organization.

This role is ideal for an experienced data engineering professional who enjoys solving complex data challenges, working with large datasets, and building modern data solutions using SQL and Python (Pandas).

What's In It for You

• Join a collaborative and innovative team that values continuous improvement
• Work on impactful enterprise data initiatives with modern technologies
• Opportunity to influence the organization's data architecture and engineering best practices
• Hybrid work environment with opportunities for professional growth and career advancement

Your Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines to ingest, transform, and deliver high-quality data.
• Write, optimize, and troubleshoot complex SQL queries, stored procedures, and database objects to support business and analytical needs.
• Develop robust data transformation workflows using Python, with a strong emphasis on the Pandas library for data manipulation and processing.
• Build and maintain enterprise data models, data warehouses, and data marts to support reporting and analytics.
• Ensure data accuracy, consistency, and integrity through validation, testing, and monitoring processes.
• Collaborate with business stakeholders, analysts, and developers to understand data requirements and deliver scalable solutions.
• Identify opportunities to improve data pipeline performance, automation, and overall system efficiency.
• Support data governance initiatives by implementing best practices for data quality, security, and documentation.
• Contribute to code reviews, technical documentation, and continuous improvement of engineering standards.

Skills and Qualifications

• 5+ years of experience as a Data Engineer, ETL Developer, or similar data-focused role.
• Advanced SQL skills with demonstrated experience writing and optimizing complex queries against large datasets.
• Strong Python development experience, including extensive use of the Pandas library for data transformation, cleansing, and analysis.
• Experience designing and maintaining ETL/ELT pipelines and data integration workflows.
• Hands-on experience with relational databases such as SQL Server, PostgreSQL, Oracle, or MySQL.
• Experience working with cloud-based data platforms (Azure, AWS, or Google Cloud) is considered a strong asset.
• Familiarity with data warehousing concepts, dimensional modeling, and performance optimization.
• Experience with version control tools such as Git and modern software development practices.
• Strong analytical and problem-solving skills with excellent attention to detail.
• Excellent communication skills with the ability to work effectively across technical and business teams.

Nice to Have

• Experience with orchestration tools such as Apache Airflow, Azure Data Factory, or similar.
• Exposure to Spark, PySpark, or distributed data processing frameworks.
• Experience with Power BI, Tableau, or other business intelligence platforms.
• Knowledge of CI/CD pipelines and automated testing for data engineering solutions.

Note from the Hiring Manager

We're looking for a hands-on Senior Data Engineer who enjoys building reliable, scalable data solutions. If you're passionate about writing high-performance SQL, developing robust Python solutions using Pandas, and improving how organizations leverage data, we'd love to hear from you.

Why Partner with Altis

If you've never worked with a staffing agency before, we make it easy. We work with top employers across Canada who have great jobs to fill, each vetted and verified by our team. When you apply for a job with Altis, we get to know you as a candidate and learn what your strengths are. Then, if you're a solid match, we handle all the logistics, advocating for you as a candidate for the role, providing access to coaching, and connecting you directly with the hiring manager. Best of all, our services are completely free for candidates.

We appreciate the time and effort all applicants invest in their submissions. Please note that only candidates shortlisted for this role will be contacted directly. However, your profile will remain under consideration for future opportunities that align with your experience and career goals.All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. Our human recruiters review all applications and always make the final hiring decision. On occasion, we also use AI-assisted tools to help review applications.