WTW is seeking a Junior Data Engineer to join their H&B Canada Operations team. The role involves developing, maintaining, and optimizing data sources, including pipelines and data products, while supporting multiple stakeholders across the business.
Responsibilities
- 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
Skills
- 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 knowledge within PySpark a plus
- Strong proficiency in data pipeline and workflow management tools (e.g. Airflow, ADF)
- Strong analytical skills and experience with data modeling
- Strong project management and organizational skills
- Proven ability to work independently and with a team
- 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.)
Benefits
- Health and Welfare Benefits: Medical (including prescription coverage), Dental, Vision, Health Savings Account, Commuter Account, Health Care and Dependent Care Flexible Spending Accounts, Group Accident, Group Critical Illness, Life Insurance, AD&D, Group Legal, Identify Theft Protection, Wellbeing Program and Work/Life Resources (including Employee Assistance Program)
- Leave Benefits: Paid Holidays, Annual Paid Time Off (includes state/local paid leave where required), Short-Term Disability, Long-Term Disability, Other Leaves (e.g., Bereavement, FMLA, ADA, Jury Duty, Military Leave, and Parental and Adoption Leave), Paid Time Off (only included for Washington roles)
- Retirement Benefits: Qualified contributory pension plan (if eligible) and 401(k) plan with annual nonelective company contribution. Non-qualified retirement plans available to senior level colleagues who satisfy the plans’ eligibility requirements.
Company Overview
Apply Now