CRB Data Lake Support - Junior

As part of Corporate Risk and Broking (CRB) the Data, Acquisition, Validation, and Enrichment team focuses on ingesting data from various sources, enriching the data, storing the data, and serving the data to our various systems and stakeholders. We work heavily with other technical teams in CRB to ensure that what is collected is fit for use. The CRB Data Lake is a culmination of data sources with our CRB Data Ecosystem and plays a vital role in the collection, transformation, governance, and availability of data.

As a CRB Data Lake Support Associate, you will work beside some of the companies’ top teams within CRB to facilitate the culmination of the strategic data in consumable packages and managing the distribution channels through pipelines and monitoring, while you progress toward becoming an experienced member of the team and CRB Technical community through your interactions with the data and teams.

You will have immediate exposure to real client data and technical teams which will draw on your imagination and creativity as well as your ability to analyze data, manage the data flows related to distribution to draw conclusions and present results of capacity, usage, availability. These experiences will help build your technical knowledge and overall industry expertise. You will be trained in how to plan, manage, prioritize, and communicate effective resolutions of the pipelines to ensure continued data flows

The Role

• Approve Deployment pipelines relate to code releases from various technical teams in CRB


• Setup monitoring schedules for pipelines deployed based on geographic areas of consumer usage


• Restart failed pipelines within the processes or guidelines, and suggesting solutions to resolve for future


• Review Synapse notebooks when errors occur and provide details on issues to development teams


• Review Synapse notebooks when errors occur and fix through development DevOps process – future growth of position as experience is gained


• Provide onboarding assistance and configuration for new ingestion data sources in conjunction with established processes and guidelines, and suggest improvements


• Provide DevOps support for deployments to core data lake repositories and monitoring


• Assist Senior Support team members with application of security access governance processes


• Prepare Access Review reports quarterly and ensure appropriate acceptance or removal is required


• Troubleshoot pipeline failures and report status on returned functionality


• Working with existing data models, data assets, within a data quality framework to suggest improvements for pipelines and data extraction/ingestion from sources – future growth of position as experience gained


• Utilizing ways to visualize and distribute the data for business outcomes based on the pipeline and data processed functions

The Requirements

• Basic understanding Azure Synapse, Azure Key Vault, Azure Data Lake Storage v2, and Azure DevOps
• Knowledge of Python and creating/edit pySpark notebooks
• Knowledge of designing, implementing and evolving data solutions within the Azure Cloud tools
• Experience in working with large data sets and co-mingling the data for business/system consumption as it relates to the Azure Cloud Modern Data Warehouse or similar data structures
• Experience with Azure SQL DB, Azure Synapse Analytics, or similar tools sets (e.g. AWS)
• Experience with data presentation to the user using reporting tools like Power BI for various data quality, presentations, and confidence reviews
• knowledge of Data Modeling and Management techniques, as it relates to retrieving data from systems to present for consumption.
• Dev-ops experience using GIT, developing, deploying code to production
• Able to work legally in the United States indefinitely and without Visa sponsorship
• Able to manage multiple tasks with as required to review and resolve issues
• Able to collaborate with multiple teams to meet needs on a daily basis
• Able to work with a globally distributed team
• Ability to solve problems through critical thinking techniques and decision trees
• This is a remote position; you will be working from your home

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

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

The base salary compensation range being offered for this role is $65,000-$70,000 USD per year.

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

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 paid 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 (Washington State only)
• Retirement Benefits: Contributory Pension Plan and Savings Plan (401k). All Level 38 and more senior roles may also be eligible for non-qualified Deferred Compensation and Deferred Savings Plans.

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.

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.

EOE, including disability/vets