Data Warehouse Consultant Sr

Location: Altamonte, FL, Atlanta, GA, St. Louis. This position will work a hybrid model (remote and office). The Ideal candidate will live within 50 miles of one of our Elevance Health PulsePoint locations.

BioPlus Specialty Pharmacy is now part of CarelonRx (formerly lngenioRx), and a proud member of the Elevance Health family of companies. Together, CarelonRx and BioPlus offer consumers and providers an unparalleled level of service that's easy and focused on whole health. Through our distinct clinical expertise, digital capabilities, and broad access to specialty medications across a wide range of conditions, we deliver an elevated experience, affordability, and personalized support throughout the consumer's treatment journey.

The Data Warehouse Consultant Sr will be a top-level contributor responsible for partnering with internal and external business clients and IT to fulfill information needs and support business decisions.

How you will make an impact:

• Instructs and reviews the work of less experienced data warehouse analysts.

• Acts as team leader for large-scale, complex projects and sets and communicates common goals and directions for team.

• Maintains information policies and procedures to support current and future data information needs and ensures proper data definitions, ownership, use and integrity of data.

• Analyzes highly complex business user needs, documents information requirements, facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed.

• Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules and data sources.

• Completes metadata assessment and reviews feedback to determine changes, ensures that data definitions are clear and current, and communicates changes to data definitions to all users.

• Demonstrates in-depth knowledge of all major subject areas (i.e., claims, coverage, provider, income, capitation, etc.)

• Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule.

Minimum Requirements:

• Requires a Bachelor's degree and more than 8 years' experience in data analysis, data modeling, and working with automated data warehouse systems experience or any combination of education and experience, which would provide an equivalent background.

Preferred Skills, Capabilities, and Experiences:

• Experience in SQL, GQL, BI tools, and OLAP preferred