This job is with WTW, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.DescriptionIn this role, we are seeking a Junior Data Engineer who will work within our H&B Canada Operations team. You will be responsible for developing, maintaining and optimizing our data sources including pipelines and data products. This role will support multiple stakeholders across the business. The ideal candidate should possess strong technical abilities to solve complex problems with data, a willingness to learn new technologies and tools if necessary and be comfortable supporting the data needs of multiple teams, stakeholders and products.The Role- Design, build and maintain batch and/or real-time data pipelines- Maintain and optimize data infrastructure for accurate extraction, transformation and loading (ETL) of data assets from various sources- Develop ETL processes to help extract and manipulate data from multiple sources- Automate data workflows such as data ingestion, aggregation and ETL processing- Prepare raw data into a consumable dataset for both technical and non-technical stakeholders- Build, maintain and deploy data products for analytics and data science teams on Azure Cloud- Ensure data accuracy, integrity, privacy, security and compliance through quality control measures- Monitor data systems performance and implement optimization strategies- Leverage data controls to maintain data privacy, security, compliance and quality for all data products- Collaborate with global colleagues to ensure data availability and integrity- Ensure that every data product is scalable,



repeatable and governed.Qualifications- University or college degree in Computer Science, Information Systems, Mathematics, Engineering, Statistics, or related field of study.- Proficiency in a modern data technology stack (e.G. Azure: Synapse, Fabric, ADF AWS: Redshift, Glue, Athena, etc.)- Strong understanding in Apache Spark or other big data frameworks; distributed computing experience a plus- Advanced SQL skills and experience with relational databases and database design- Intermediate to Advanced level in Python; working knowledgewithin PySpark a plus- Robust proficiency in data pipeline and workflow management tools (e.G. Airflow, ADF)- Experience in data ingestion tools such as Matillion, FiveTran, Airbyte, etc. a plus- Experience with Microsoft Power Platform (e.G. Power BI, Power Automate, etc.)- Strong analytical skills and experience with data modeling- Strong project management and organizational skills- Proven ability to work independently and with a teamSubject Matter ExpertiseDeveloping expertiseYou strengthen your depth and/or breadth of subject matter knowledge and skills across multiple areas.You define the expertise required in your area based on emerging technologies, industry practices.



You build the team’s capability accordingly.Applying expertiseYou apply subject matter knowledge and skills across multiple areas to assess the impact of complex issues and implement long-term solutions. You foster innovation using subject matter knowledge to enhance tools, practices, and processes for the team.Solution DevelopmentSystems thinkingYou lead and foster collaboration across H&B technology to develop solutions to complex issues.You apply a whole systems approach to evaluating impact, and take ownership for ensuring links between structure, people and processes are made.Focusing on qualityYou instill a quality mindset to the team and ensure the appropriate methods, processes and standards are in place for teams to deliver quality solutions. You create and deliver improvement initiatives.Technical CommunicationSimplifying complexityYou develop and/or enhance tools, aids and/or original content to support the delivery and/or understanding of complex information. You guide others on best practice.Influencing stakeholdersYou are adaptive across a range of situations, effectively tailoring your delivery methods based on your knowledge of stakeholders to have maximum impact and influence.CompensationThe base salary compensation range being offered for this role is $95,000 to $100,000 CAD per yearThis role is also eligible an annual short-term incentive bonus, and performance-based recognition awards.Artificial Intelligence (AI) tools may be used in the process to screen, assess, or select applicants for a position but all final decisions and determinations are made exclusively by authorized human personnel.This job posting is an advertisement for an existing vacancy.Equal Opportunity Employer]]>

📌 Junior Data Engineer - C$95,000 - C$100,000 A Year (Toronto)
🏢 WTW
📍 Toronto