Description
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.
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 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 team’s 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 $95,000.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