Senior Data Engineer

We are seeking a highly skilled Data Engineer to join our team. In this role, you will be instrumental in modeling, designing, and developing robust data pipelines, analytics-ready datasets and comprehensive business intelligence solutions. You will work within established design and development methodologies to ensure high-quality documentation and enterprise-standard data architecture.

Pay Rate: $57.46- $67.04/Hr

Advantages
- Work with a modern Azure-based cloud environment and industry-leading tools like Databricks and Synapse.

- Shape enterprise-scale data products and influence data-driven decision-making.

- Engage in a professional environment focused on knowledge sharing and continuous technical improvement.

- Move beyond execution into architectural modeling and technical solutioning.

Responsibilities
- Design, develop, and document integration packages using Azure Data Factory (ADF) and SSIS to consolidate data from multiple complex systems.

- Develop and maintain Databricks notebooks and jobs using Python (PySpark) and SQL for both batch and streaming workloads.

- Design and implement complex T-SQL, stored procedures, views, triggers, and indexes to optimize data flow and storage.

- Build curated datasets following layered patterns (Bronze/Silver/Gold) and implement Delta Lake best practices.

- Assist in the data modeling of warehouse and data lake solutions while performing advanced data analysis to provide meaningful, data-driven insights.

- Design and implement rigorous data quality, cleansing, and stewardship processes.

- Convert business requirements into technical specifications and work closely with Business Analysts and project teams to ensure alignment.

- Research and propose technical solutions, perform knowledge transfer sessions, and recommend improvements for automation and workflow efficiency.

- Provide accurate time estimates for technical tasks and ensure all developments meet enterprise documentation standards.

Qualifications
- University degree in Computer Science or a related business/computer discipline (or equivalent experience).

- 5+ years of proven experience in database development or data engineering for enterprise-level solutions.

- Hands-on expertise with Microsoft Azure Synapse, SQL Data Warehouse, and Azure Data Factory.

- Advanced experience with Azure Databricks and SQL Server (2016 or later).

- Strong proficiency in SQL and Python.

- Experience with CI/CD pipelines via Azure DevOps.

- Skilled in developing Microsoft Power BI reports or similar data visualization tools.

- Expert understanding of Data Warehouse (DW), Business Intelligence (BI) implementations, and Data Lake design.

- Strong analytical and problem-solving abilities, with well-developed interpersonal and communication skills to explain complex data solutions to the team.

Summary
If you're interested in the Data Engineer role based in Toronto, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.