Skip to main content
Back to Top

Data Engineer-Data Warehouse Consultant

Location: Schaumburg, IL
JobFamily: Reporting & Data Analysis
Req #: PS72993
Date Posted: May 10, 2022

Share Job:



SHIFT: Day Job

SCHEDULE: Full-time

AIM Specialty Health.  Our mission is making healthcare services appropriate, safe and affordable.  To make this possible, we need talent like yours to help us support innovation and speed to market with our solutions, providing no barriers from technology.  AIM Specialty Health is a proud member of the Anthem family of companies and we are looking for technology professionals who are looking to grow their talent and career while helping make a real difference in people’s lives.

Data Engineer-Data Warehouse Consultant

The preferred locations are Chicago, Deerfield, Schaumburg and Westchester, Illinois

as well as Glendale, CA

The Data Engineer-Data Warehouse Consultant position is viewed as an experience 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.



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 Anthem. 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 Anthem approves – a valid religious or medical explanation as to why you are not able to get vaccinated that Anthem is able to reasonably accommodate. Anthem will also follow all relevant federal, state and local laws.

Anthem, Inc. 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 Anthem 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.

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