Business Information Developer Consultant Senior

Elevance Health (Anthem); Richmond (VA); Hybrid; USD 121,000 - 181,000; Full time

Benefits offered by this job

Benefits package

Incentive programs

Equity stock purchase & 401k

Job summary

Elevance Health, based in Richmond, VA, is seeking a Senior Business Information Developer Consultant to lead the development and execution of advanced data mining analyses within a Data Warehouse framework.

The role emphasizes building and maintaining complex ETL workflows, data models, and reporting applications, while mentoring staff and ensuring data integrity. A BS/BA and 6+ years of experience are preferred, with strong SQL and ETL tool expertise.

Qualifications

• Requires a BS/BA degree; minimum of 6 years' experience; or any combination of education and experience, which would provide an equivalent background.
• Strong experience in Data Engineering, ETL development, and enterprise data integration highly preferred.
• Hands‑on experience with Informatica PowerCenter for designing, developing, and maintaining ETL workflows highly preferred.
• Strong proficiency in MS SQL Server with advanced T‑SQL/SQL programming, including stored procedures, functions, views, query optimization, and performance tuning highly preferred.
• Experience writing SQL/PL/SQL scripts for data extraction, transformation, and validation highly preferred.
• Strong understanding of Data Modeling concepts, including logical, physical, and dimensional data models highly preferred.
• Experience working with enterprise Data Warehouse (EDW) environments and large‑scale data integration solutions highly preferred.
• Hands‑on experience with one or more enterprise databases, including: MS SQL Server, Snowflake, Oracle, Teradata, Sybase highly preferred.
• Experience developing and maintaining Shell Scripts to support ETL processes and data operations highly preferred.
• Experience with Control‑M for job scheduling, workflow automation, and batch process monitoring highly preferred.
• Experience using GitHub or other version control systems for source code management and collaborative development highly preferred.
• Strong analytical, troubleshooting, and performance tuning skills for ETL processes and database workloads highly preferred.
• Experience with Snowflake data warehouse design, optimization, and cloud data migration highly preferred.
• Knowledge of data warehousing concepts, including Star and Snowflake schema design highly preferred.
• Strong data analysis and data validation skills highly preferred.
• Experience working in Agile/Scrum development environments highly preferred.
• Excellent problem‑solving, communication, and collaboration skills highly preferred.

Responsibilities

• Undertakes complex assignments requiring additional specialized technical knowledge.
• Develops very complex and varied strategic report applications from a Data Warehouse.
• Establishes and communicates common goal and direction for team.
• Establishes and maintains advanced knowledge of data warehouse database design, data definitions, system capabilities, and data integrity issues.
• Acts as a source of direction, training, and guidance for less experienced staff.
• Monitors project schedules and costs for own and other projects.
• Develops and supports very complex Data Warehouse-related applications for business areas requiring design and implementation of database tables.
• Conducts training on use of applications developed.
• Spends time thinking about programming and how it would be used to design solutions.

Skills

Data engineering

ETL development

Data integration

SQL programming

Data modeling

Agile/Scrum

Problem solving

Education

BS/BA degree

Tools

Informatica PowerCenter

MS SQL Server

Snowflake

Oracle

Teradata

Shell scripting

Control-M

GitHub

Job description

Anticipated End Date: 2026-10-02

Position Title: Business Information Developer Consultant Senior

Location: This role requires associates to be in-office 1 - 2 days per week, fostering collaboration and connectivity, while providing flexibility to support productivity and work-life balance. This approach combines structured office engagement with the autonomy of virtual work, promoting a dynamic and adaptable workplace. Ideal candidates will be able to report to our Pulse Point location in Richmond, VA. Alternate locations may be considered if candidates reside within a commuting distance from an office.

Please note that per our policy on hybrid/virtual work, candidates not within a reasonable commuting distance from the posting location(s) will not be considered for employment, unless an accommodation is granted as required by law.

The Business Information Developer Consultant Senior is viewed as an expert in the development and execution of data mining analyses.

How you will make an impact:

• Undertakes complex assignments requiring additional specialized technical knowledge.
• Develops very complex and varied strategic report applications from a Data Warehouse.
• Establishes and communicates common goal and direction for team.
• Establishes and maintains advanced knowledge of data warehouse database design, data definitions, system capabilities, and data integrity issues.
• Acts as a source of direction, training, and guidance for less experienced staff.
• Monitors project schedules and costs for own and other projects.
• Develops and supports very complex Data Warehouse-related applications for business areas requiring design and implementation of database tables.
• Conducts training on use of applications developed.
• Spends time thinking about programming and how it would be used to design solutions.

Minimum Requirements:

• Requires a BS/BA degree; minimum of 6 years' experience; or any combination of education and experience, which would provide an equivalent background.

Preferred Skills, Capabilities and Experience:

• Strong experience in Data Engineering, ETL development, and enterprise data integration highly preferred.
• Hands‑on experience with Informatica PowerCenter for designing, developing, and maintaining ETL workflows highly preferred.
• Strong proficiency in MS SQL Server with advanced T‑SQL/SQL programming, including stored procedures, functions, views, query optimization, and performance tuning highly preferred.
• Experience writing SQL/PL/SQL scripts for data extraction, transformation, and validation highly preferred.
• Strong understanding of Data Modeling concepts, including logical, physical, and dimensional data models highly preferred.
• Experience working with enterprise Data Warehouse (EDW) environments and large‑scale data integration solutions highly preferred.
• Hands‑on experience with one or more enterprise databases, including: MS SQL Server, Snowflake, Oracle, Teradata, Sybase highly preferred.
• Experience developing and maintaining Shell Scripts to support ETL processes and data operations highly preferred.
• Experience with Control‑M for job scheduling, workflow automation, and batch process monitoring highly preferred.
• Experience using GitHub or other version control systems for source code management and collaborative development highly preferred.
• Strong analytical, troubleshooting, and performance tuning skills for ETL processes and database workloads highly preferred.
• Experience with Snowflake data warehouse design, optimization, and cloud data migration highly preferred.
• Knowledge of data warehousing concepts, including Star and Snowflake schema design highly preferred.
• Strong data analysis and data validation skills highly preferred.
• Experience working in Agile/Scrum development environments highly preferred.
• Excellent problem‑solving, communication, and collaboration skills highly preferred.

Location: Richmond, VA

For candidates working in person or virtually in the below location(s), the salary* range for this specific position is $120,720 to $181,080

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