Position Name – Senior Data Engineer
Type of hiring – Fulltime/Subcon
Location – Markham, ON (need to visit 3 days a week in office mandatorily)
Vacancy Status: We are looking to hire a Senior Data Engineer immediately who has experience in Snowflake, DBT and AWS – Glue.
Job Description:
As a Senior Data Engineer, you will play a pivotal role in driving the design, development, and delivery of scalable data solutions across the enterprise.
You will:
- Advocate for engineering standards and process efficiencies to ensure high-quality, timely delivery.
- Lead the development of complex, high-performance data pipelines using tools like dbt Core/Cloud.
- Help design, and review data models (conceptual, logical, physical) that meet business and technical requirements.
- Own and maintain robust, reusable code in SQL, Python, Shell, and Terraform scripts.
- Develop detailed low-level engineering solution design documents to guide implementation and ensure alignment with technical standards.
- Create and review data test plans to ensure alignment with solution requirements.
- Advocate importance of data catalogs, data governance and data quality practices.
- Conduct root cause analysis and implement effective solutions for technical data issues.
- Lead scrum ceremonies and foster an agile mindset across the team.
- Mentor and support Data Engineers and Associate Data Engineers, elevating engineering standards and practices.
- Collaborate cross-functionally to deliver high-quality data products with strong customer-centric focus.
- Drive technical presentations and provide constructive feedback on data designs and processes.
- Plan and execute data release activities to ensure smooth and high-performance delivery.
- Support talent acquisition by designing interview challenges, conducting interviews, and contributing to hiring decisions.
What you'll bring
- 8+ Years of professional experience in data engineering, with a proven track record of delivering 3+ high-impact data projects from inception to warranty.
- Deep expertise in relational databases (Snowflake, PostgreSQL, Amazon Aurora), big data platforms (Hadoop), and NoSQL databases (MongoDB).
- Advanced proficiency in data visualization tools such as Snow sight, Streamlit, Qlik, and SAP Business Objects.
- Expert level coding skills in SQL, Python, Glue, DBT, Shell, and Terraform, with a focus on maintainability and performance.
- Experience with data orchestration and pipeline tools, including Zena and AWS Managed Airflow.
- High resilience and adaptability in ambiguous or high-pressure environments.
- A customer-first mindset, using data-driven insights to deliver impactful solutions.
- Strong collaboration and communication skills, with the ability to lead teams and influence stakeholders.
- Insurance knowledge is an asset -Ability to foundationally understand complex business processes driving technical systems.
- Prior experience in AI/ML model operationalization is an asset.
Any or all of the following certifications will be nice to have:
- SnowPro Core
- SnowPro Advanced: Data Engineer (DEA-C01 or DEA-C02)
- dbt Developer
- AWS Cloud Practitioner
