Data Warehouse Consultant

Location: This role requires associates to be in‑office 1 day per week, fostering collaboration and connectivity, while providing flexibility to support productivity and work‑life balance. The hybrid workplace approach combines structured office engagement with the autonomy of virtual work. Ideal candidates will be able to report to one of our Pulse Point locations in Lake Mary, FL; St. Louis, MO; Richmond, VA; Plano, TX; New York, NY; Wilmington, DE; or Atlanta, GA. Per our policy on hybrid/virtual work, candidates not within a reasonable commuting distance from these locations will not be considered for employment unless an accommodation is granted as required by law. Data Warehouse Consultant is responsible for serving as an expert in data analysis, reporting, and formulating recommendations and providing guidance to other data analysts. How You Will Make An Impact Creates and maintains databases to track business performance. Analyzes data and summarizes performance using summary statistical procedures. Develops and analyzes business performance reports (e.g. claims data, provider data, utilization data) and provides notations of performance deviations and anomalies. Serves as a subject matter expert in data analysis and reporting, formulating actionable recommendations and providing guidance to other data analysts. Creates and publishes periodic reports, and develops ad hoc reports to address emerging business questions and priorities. Translates complex business issues into diagnostic and/or tracking data solutions that convert business requirements into actionable decision support tools. Identifies trends, patterns, and outliers in large and complex datasets to inform strategic and operational decisions. Provides analytic consultation to business partners, leadership, and external customers to support performance improvement initiatives. Makes data‑driven recommendations based on analysis and clearly communicates findings to technical and non‑technical stakeholders. Ensures data integrity, consistency, and accuracy across reporting solutions and analytic outputs. Supports a higher level of complexity in data analysis and reporting, requiring advanced problem‑solving, critical thinking, and independent judgment. Ensures proper data definitions, ownership, use and integrity of data. Analyzes more 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 excellent knowledge of data warehouse data structure design, definitions, capabilities, programming languages, and data integrity issues. Completes metadata assessment and reviews feedback to determine changes needed. Ensures that data definitions are clear and current and communicates changes to data definitions to all users. 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 BA/BS degree in a related field and a minimum of 6 years’ experience in data analysis, data modeling, and working with automated data warehouse systems; or any combination of education and experience that would provide an equivalent background. Preferred Skills, Capabilities, And Experiences Experience presenting technical subject matters to non‑technical audiences highly preferred. Experience in navigating new data models (both documented and undocumented) highly preferred. Ability to manipulate large sets of data highly preferred. Ability to learn new subject matter and document effectively for broader team knowledge/use highly preferred. Professionalism, positivity, and being solution‑oriented in communications and collaborations inside and outside of the team highly preferred. Experience with relational databases and knowledge of query tools and statistical software highly preferred. Ability to train and mentor junior team members in advanced SQL query‑writing and team standard operating procedures preferred. Strong analytical, organizational, presentation, and problem‑solving skills strongly preferred. Familiarity with Amazon RedShift, Snowflake, Postgres, Microsoft SQL Server, Oracle, or equivalent database software preferred. Familiarity with ETL coding via Python, or ETL software such as Microsoft SSIS, Informatica, or Talend preferred. For candidates working in person or virtually in the below location(s), the salary* range for this specific position is $120,480 to $180,720. Locations: New York, NY. In addition to your salary, company offers benefits such as a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). The salary range is the range Elevance Health in good faith believes is the range of possible compensation for this role at the time of this posting. This range may be modified in the future and actual compensation may vary from posting based on geographic location, work experience, education and/or skill level. Even within the range, the actual compensation will vary depending on the above factors as well as market/business considerations. No amount is considered to be wages or compensation until such amount is earned, vested, and determinable under the terms and conditions of the applicable policies and plans. The amount and availability of any bonus, commission, benefits, or any other form of compensation and benefits that are allocable to a particular employee remains in the Company’s sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law. 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, and local laws. Applicants who require accommodation to participate in the job application process may contact 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. Prospective employees required to be screened under Florida law should review the education and awareness resources at HB531 | Florida Agency for Health Care Administration. #J-18808-Ljbffr