Senior Data Engineer

You are a service oriented individual who is excited to be a part of a fast-growing organization that enables the best to be even better. You are a proven self-motivated Senior Data Engineer at heart with leadership capabilities. You are looking for the opportunity to provide your ability to drive change within an exciting industry. You love working in a collaborative team environment but also enjoy your autonomy to conduct tasks and provide excellent service to our Support Centre team members. As an individual who is driven by excellence you are eager to contribute the success of one of Canada’s Best Managed companies.

In this role, you will be working 4 days in office Mondays to Thursdays out of Dentalcorp’s Toronto Support Centre and 1 day work from home on Fridays. Reporting to the Senior Director of Data Engineering and Architecture, the Senior Data Engineer will apply their expertise and provide industry best practices to define optimized data engineering approaches. This is an exciting opportunity to apply your current skills, as well as learn innovative technologies.

In this role, you will

Lead the design, development, and maintenance of scalable and robust reusable data pipelines.
Architect and implement data migration, data warehousing solutions and ETL/ELT projects.
Champion the transformation and consolidation of legacy ETL tools.
Ensure data quality, integrity, and security across various data systems.
Drive data-driven decision-making and innovation across high-impact projects.
Collaborate with the QA team to develop test strategies and automated test scripts.
Oversee all aspects of the data delivery life cycle from discovery, analysis, design, development, testing to release planning and implementation of data systems.
Guide and collaborate data developers and engineers to adhere to CI/CD and DevOps best practices.
Partner with the Data Quality Assurance Team to ensure the highest quality standards are applied to every process within data engineering.
Translate requirements into detailed functional and technical designs.
Provide consultation for evaluating data and software systems.
Ability to manage multiple competing projects and prioritize them effectively.
Lead and collaborate with vendors as needed.
What we’re looking for

Bachelor's Degree in a field such as Engineering, Computer Science or equivalent
Expert-level knowledge of SQL, Python, and Shell scripting.
Expert-level knowledge of Snowflake and Microsoft SQL Server
Experience with Node.js. and .Net
Expert-level knowledge of ETL and API development.
Extensive experience developing and automating CI/CD pipelines.
Expert-level knowledge of DBT for designing, developing, and maintaining data pipelines.
Expert-level knowledge in data modeling and data architecture.
Experience with Agile Scrum, Kanban, Iterative Data Development and PACE methodologies
Nice To Have:

Experience with AWS EC2, S3, ECS, Glue and Kinesis
Experience with DevOps tools such as GIT, Docker, Jenkins, and Octopus.
Knowledge of Terraform for designing and implementing infrastructure solutions.
About Dentalcorp

Dentalcorp is Canada’s largest and fastest growing network of dental practices, committed to advancing the overall well-being of Canadians by delivering the best clinical outcomes and unforgettable experiences. Dentalcorp acquires leading dental practices, uniting its network in a common goal: to be Canada’s most trusted healthcare network. Leveraging its industry-leading technology, knowledge and scale, dentalcorp offers professionals the unique opportunity to retain their clinical autonomy while unlocking their potential for future growth.

Candidates must be legally eligible to work in Canada. At Dentalcorp, we recognize that inclusivity and diversity strengthen our culture and make us better. We are committed to ensuring that the talent we hire is reflective of the diverse communities and patients we serve. To ensure equal opportunity for all candidates, we strongly encourage applicants requiring an accommodation to let their recruiter know during the recruitment/selection process. We appreciate all applicants for taking the time to apply, however, only those selected for an interview will be contacted.