"Alerted.org

Data Warehouse Consultant Senior

**Location** : This role enables associates to work virtually full-time, with the exception of required in-person training sessions, providing maximum flexibility and autonomy. This approach promotes productivity, supports work-life integration, and ensures essential face-to-face onboarding and skill development.

CareBridge Health is a proud member of the Elevance Health family of companies, within our Carelon business. CareBridge Health exists to enable individuals in home and community-based settings to maximize their health, independence, and quality of life through home-care and community based services.

The **Data Warehouse Consultant Senior** will be an integral part of the Data Team in leading complex data projects, building and scaling processing capabilities, conducting data analysis and expanding reporting. This role will center around mining complex claims, diagnosis, eligibility and patient data for valuable insights and then translating those findings into high quality, data driven decisions to improve processing capabilities and expand the use of client data for the business.

The ideal candidate has experience in healthcare data, is an excellent communicator, curious, detailed oriented and has a knack for identifying patterns and data quality issues within sprawling, variable data sets. The candidate should possess strong SQL skills and be very comfortable navigating databases, reviewing and updating database objects and working closely with data engineers and client facing team members.

How you will make an impact:

+ Serving as a subject-matter-expert on claims, eligibility, authorization and assessment datasets.

+ Tackling wide-reaching ambiguous data issues and pushing to resolution

+ Identifying data gaps, communicating impacts on downstream users and leading the work to close the gaps.

+ Writing complex and performant SQL queries and conducting in-depth analysis on giant datasets.

+ Validating completeness and accuracy of client data and reporting out data requirement gaps.

+ Providing transparency into data for the business through expanding reporting capabilities.

+ Collaborating with data engineers to improve and scale data processing capabilities.

+ Instructs, directs 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 on the creation and maintenance of the content of the data warehouse, establishes and maintains advanced knowledge of data warehouse data structure design, definitions, capabilities, SQL, and data integrity issues, 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, SAS, Business Objects, and OLAP preferred.

+ Excellent analytical, communication, problem-solving, and planning and organizational skills and demonstrated ability to lead and plan complex, large-scale projects strongly preferred

Please be advised that Elevance Health only accepts resumes for compensation from agencies that have a signed agreement with Elevance Health. Any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of Elevance Health.

Who We Are

Elevance Health is a health company dedicated to improving lives and communities – and making healthcare simpler. We are a Fortune 25 company with a longstanding history in the healthcare industry, looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve.

How We Work

At Elevance Health, we are creating a culture that is designed to advance our strategy but will also lead to personal and professional growth for our associates. Our values and behaviors are the root of our culture. They are how we achieve our strategy, power our business outcomes and drive our shared success - for our consumers, our associates, our communities and our business.

We offer a range of market-competitive total rewards that include merit increases, paid holidays, Paid Time Off, and incentive bonus programs (unless covered by a collective bargaining agreement), medical, dental, vision, short and long term disability benefits, 401(k) +match, stock purchase plan, life insurance, wellness programs and financial education resources, to name a few.

Elevance Health operates in a Hybrid Workforce Strategy. Unless specified as primarily virtual by the hiring manager, associates are required to work at an Elevance Health location at least once per week, and potentially several times per week. Specific requirements and expectations for time onsite will be discussed as part of the hiring process.

The health of our associates and communities is a top priority for Elevance Health. We require all new candidates in certain patient/member-facing roles to become vaccinated against COVID-19 and Influenza. If you are not vaccinated, your offer will be rescinded unless you provide an acceptable explanation. Elevance Health will also follow all relevant federal, state and local laws.

Elevance Health is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to age, citizenship status, color, creed, disability, ethnicity, genetic information, gender (including gender identity and gender expression), marital status, national origin, race, religion, sex, sexual orientation, veteran status or any other status or condition protected by applicable federal, state, or local laws. Applicants who require accommodation to participate in the job application process may contact [email protected] for assistance.

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state, and local laws, including, but not limited to, the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act.