Junior Data Engineer

In 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.

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)
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 team

Subject Matter Expertise

Developing expertise

• You 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 teams capability accordingly.

Applying expertise

• You 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 Development

• Systems thinking
• You 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 quality

• You 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 Communication

Simplifying complexity

• You 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 stakeholders

• You are adaptive across a range of situations effectively tailoring your delivery methods based on your knowledge of stakeholders to have maximum impact and influence.
  

Compensation and Benefits

Base salary range and benefits information for this position are being included in accordance with requirements of various state/local pay transparency legislation. Please note that salaries may vary for different individuals in the same role based on several factors including but not limited to location of the role individual competencies education/professional certifications qualifications/experience performance in the role and potential for revenue generation (Producer roles only).

Compensation

The base salary compensation range being offered for this role is $95000.00 - $100 000.00 CAD annually.

This role is also eligible for an annual short-term incentive bonus.

Employment-based non-immigrant visa sponsorship and/or assistance is not offered for this specific job opportunity.

This position will remain posted for a minimum of three business days from the date posted or until a sufficient/appropriate candidate slate has been identified

Company Benefits

WTW provides a competitive benefit package which includes the following (eligibility requirements apply):

• 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.

At WTW we trust you to know your work and the people tools and environment you need to be successful. The majority of our colleagues work in a hybrid style with a mix of remote in-person and in-office interactions dependent on the needs of the team role and clients. Our flexibility is rooted in trust and hybrid is not a one-size-fits-all solution.

We understand flexibility is key to supporting an inclusive and diverse workforce and so we encourage requests for all types of flexible working as well as location-based arrangements. Please speak to your recruiter to discuss more.

EOE including disability/vets