Data Warehouse Implementation Associate Manager

WTW•San Francisco, CA

5h•Hybrid

About The Position

The Data Warehouse Implementation Associate Manager is responsible for overseeing and managing all phases of client onboarding and data implementation for WTW’s Analytic Solutions Core offering (ACT Core solution). Acting as the central coordinator, this role facilitates communication and collaboration between WTW Client Service Teams (CSTs), clients, Cedar Gate/Data Warehouse Vendor (DWV), and carriers/data sources. Ensures the accurate and timely completion of intake steps, contracting documents, data requests, and validation activities. This individual must possess strong project management skills, a comprehensive understanding of employer healthcare plans, and fluency in data structures and account hierarchies to effectively guide clients from eligibility confirmation through ACT platform go-live. Success in this position is measured by the quality and timeliness of implementations, which directly impact analytics delivery and client satisfaction. Key requirements include expertise in employer health plans, spanning eligibility, medical and pharmacy claims, and healthcare plan management components—as well as experience working with account structures, hierarchies, and levels of aggregation. This role is open to candidates across the United States

Requirements

Strong understanding of employer health plans, including eligibility, medical and pharmacy claims, and healthcare plan management components.
Experience working with account structures, hierarchies, and levels of aggregation.
Comfortable interpreting data files, data quality reports, and validation outputs.
Ability to manage and oversee negotiations of legal agreement requirements [Non-Disclosure Agreements (NDA), PHI forms, Data releases] with clients, carriers, and vendor partners.
Familiarity with data warehousing concepts or healthcare analytics platforms (Cedar Gate experience is a strong plus).
3–7+ years of experience managing complex implementations, ideally in health & benefits, data analytics, or vendor onboarding, ideally gained in a benefit consulting/brokerage firm, commercial data warehouse company or reporting function of an insurance company
Ability to coordinate across multiple teams, clients, WTW, Client Service teams, carriers, and technical vendors.
Excellent organizational skills, with a strong ability to track parallel workflows and dependencies.
Skilled in managing deadlines, anticipating risks, and driving issues to resolution.
Clear written and verbal communication skills with both technical and non‑technical stakeholders.
Ability to guide clients and internal partners through detailed processes and requirements.
Strong relationship‑building skills, with a service‑oriented mindset.
Strong attention to detail and high accountability for accuracy in documentation and data‑related processes.
Ability to work independently while also serving as a cross‑functional integrator.
Excellent Microsoft Office skills, particularly in Excel, Outlook, PowerPoint, and Power BI
Bachelor’s degree required, preferably with significant quantitative coursework
State Life and Health license required within 90 days of joining

Nice To Haves

Cedar Gate experience is a strong plus

Responsibilities

Overseeing and managing all phases of client onboarding and data implementation for WTW’s Analytic Solutions Core offering (ACT Core solution).
Facilitating communication and collaboration between WTW Client Service Teams (CSTs), clients, Cedar Gate/Data Warehouse Vendor (DWV), and carriers/data sources.
Ensuring the accurate and timely completion of intake steps, contracting documents, data requests, and validation activities.
Guiding clients from eligibility confirmation through ACT platform go-live.
Leading and coordinating all phases of client onboarding and data implementation for WTW’s Analytic Solutions Core offering.
Ensuring all intake steps, contracting documents, data requests, and validation activities are completed accurately and on schedule.
Managing and overseeing negotiations of legal agreement requirements [Non-Disclosure Agreements (NDA), PHI forms, Data releases] with clients, carriers, and vendor partners.
Coordinating across multiple teams, clients, WTW, Client Service teams, carriers, and technical vendors.
Managing deadlines, anticipating risks, and driving issues to resolution.
Guiding clients and internal partners through detailed processes and requirements.
Serving as a cross-functional integrator.

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
Work/Life Resources (including Employee Assistance Program)
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)
Qualified contributory pension plan (if eligible)
401(k) plan with annual nonelective company contribution.
Non-qualified retirement plans available to senior level colleagues who satisfy the plans’ eligibility requirements.