Skip to main content

Data Engineer-Data Warehouse Consultant


  • IL, Chicago
  • CA, Glendale
  • IL, Deerfield



The Data Engineer-Data Warehouse Consultant position is viewed as an experienced resource in the development and execution of data warehouse related activities. Primary duties may include but are not limited to:

  • Undertakes complex assignments requiring additional specialized technical knowledge.

  • Establishes and maintains knowledge of data warehouse database design, data definitions, system capabilities, and data integrity issues.

  • Ability to communicate effectively with multiple levels within the organization is strongly preferred.

  • Instructs, directs and reviews work of less experience data warehouse analysts.

  • Maintains information policies and procedures to support current and future data information needs.

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

Department Specific Responsibilities Include:

  • Participate and/or take lead on all architecture, development and deployment in different Data warehouse implementations

  • Maintains information policies and procedures to support current and future data information needs.

  • Perform tests and validate all data flows and prepare all Datawarehouse processes according to business requirements and incorporate all business requirements into all design specifications.

  • Documents all technical and system specifications documents for all Datawarehouse processes and perform unit tests on all processes and prepare required programs and scripts.

  • Documents and maintains business definitions, data dictionary and metadata

  • Solving complex technical data engineering problems by providing code changes and patch releases.

  • Identify opportunities to automate and improve development processes.

  • Owns the change request process and coordinate with other teams as necessary

  • Maintains active relationships with business and cross team to determine business requirements and leads requirements gathering meetings.

  • Performs technical design reviews and code reviews.

  • Leads multiple or large projects and facilitates large group JAD sessions for requirements, modeling in several disciplines. 

Minimum Qualifications

  • Requires BA/BS in related field

  • Minimum of 6 years’ experience in data analysis, data modeling, and working with automated data warehouse systems; or any combination of education and experience which would provide an equivalent background.

Preferred Skills, Capabilities and Experience

  • Understanding of CI/CD tools, data governance and Agile project management skills.

  • Experience in production support from Level 1 to Level 3.

  • Experience in Health Care Domain preferred

  • Minimum of 1 year’s hands-on experience with Cloud Technologies like AWS, GCP or Azure preferred.

  • Minimum of 5 years hands-on experience with ETL Tool: DataStage, SSIS or similar technologies. 

  • Strong SQL and analytical skills. Experience developing APIs will be a plus.

  • Hands-on experience in designing and implementing data pipelines in cloud platforms; in-depth knowledge of various core AWS services such as IAM, Cloud Formation, EC2, S3, ECS, EMR/Spark, SQS, SNS, Glue suite-ETL job, Data Catalog, Crawler, Data sync, Cloud Health, CloudWatch, Lambda, Athena, Quicksight, DMS and Redshift.

  • Experience working with relational databases including Oracle, SQL Server, T-SQL scripts and stored procedures.

  • Experience working in event driven architecture; hands-on experience working with JSON and tool - RabbitMQ

  • Experience working with Sybase and MongoDB a plus.

For candidates working in person or remotely in the below locations, the salary* range for this specific position is $102,580 - $128,225

Location:  California

In addition to your salary, Elevance Health 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 offered for this specific position is based on a number of legitimate, non-discriminatory factors set by the company.  The company is fully committed to ensuring equal pay opportunities for equal work regardless of gender, race, or any other category protected by federal, state, and local pay equity laws .

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

Please be advised that Elevance Health only accepts resumes from agencies that have a signed agreement with Elevance Health. Accordingly, Elevance Health is not obligated to pay referral fees to any agency that is not a party to an agreement with Elevance Health. Thus, any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of Elevance Health.

Be part of an Extraordinary Team

Elevance Health is a health company dedicated to improving lives and communities – and making healthcare simpler. Previously known as Anthem, Inc., we have evolved into a company focused on whole health and updated our name to better reflect the direction the company is heading.

We are looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve. You will thrive in a complex and collaborative environment where you take action and ownership to solve problems and lead change. Do you want to be part of a larger purpose and an evolving, high-performance culture that empowers you to make an impact?

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.

The health of our associates and communities is a top priority for Elevance Health. We require all new candidates to become vaccinated against COVID-19. If you are not vaccinated, your offer will be rescinded unless you provide – and Elevance Health approves – a valid religious or medical explanation as to why you are not able to get vaccinated that Elevance Health is able to reasonably accommodate. Elevance Health will also follow all relevant federal, state and local laws.

Elevance Health has been named as a Fortune Great Place To Work in 2021, is ranked as one of the 2021 World’s Most Admired Companies among health insurers by Fortune magazine, and a Top 20 Fortune 500 Companies on Diversity and Inclusion. To learn more about our company and apply, please visit us at 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 for assistance.

Apply Now