Junior Data Engineer

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.ResponsibilitiesDesign, build and maintain batch and/or real-time data pipelinesMaintain and optimize data infrastructure for accurate extraction, transformation and loading (ETL) of data assets from various sourcesDevelop ETL processes to help extract and manipulate data from multiple sourcesAutomate data workflows such as data ingestion, aggregation and ETL processingPrepare raw data into a consumable dataset for both technical and non-technical stakeholdersBuild, maintain and deploy data products for analytics and data science teams on Azure CloudEnsure data accuracy, integrity, privacy, security and compliance through quality control measuresMonitor data systems performance and implement optimization strategiesLeverage data controls to maintain data privacy, security, compliance and quality for all data productsCollaborate with global colleagues to ensure data availability and integrityEnsure that every data product is scalable, repeatable and governedSkillsUniversity or college degree in Computer Science, Information Systems, Mathematics, Engineering, Statistics, or related field of studyProficiency 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 plusAdvanced SQL skills and experience with relational databases and database designIntermediate to Advanced level in Python; working knowledge within PySpark a plusStrong proficiency in data pipeline and workflow management tools (e.g. Airflow, ADF)Strong analytical skills and experience with data modelingStrong project management and organizational skillsProven ability to work independently and with a teamExperience in data ingestion tools such as Matillion, FiveTran, Airbyte, etc. a plusExperience with Microsoft Power Platform (e.g. Power BI, Power Automate, etc.)BenefitsHealth 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 OverviewWTW is a global advisory and solutions company that helps clients around the world turn risk into a path for growth. It was founded in 1828, and is headquartered in London, England, GBR, with a workforce of 10001+ employees. Its website is https://www.willistowerswatson.com.



Apply To This Job