Senior Data Warehouse Engineer & Consultant

elevancehealth; Richmond (VA); On-site; USD 121,000 - 181,000; Full time

Benefits offered by this job

Comprehensive benefits

Equity stock purchase

401k match

Job summary

Elevance Health in Richmond, VA is seeking a Business Information Developer Consultant Senior to advance data warehouse solutions and complex reporting from a centralized data warehouse. The role blends in-office collaboration 1–2 days a week with flexible remote work to support productivity and balance.

The candidate should have a BS/BA and 6+ years of experience with strong data engineering, ETL, and SQL skills.

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 preferred.
• Hands-on experience with Informatica PowerCenter for designing, developing, and maintaining ETL workflows 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.
• 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

Enterprise Data Integration

SQL

T-SQL

Data Modeling

Snowflake

ETL Workflows

Agile/Scrum

Shell Scripting

GitHub

Data Warehouse

Education

BS/BA degree

Tools

Informatica PowerCenter

MS SQL Server

Snowflake

Oracle

Teradata

Sybase

Control-M

GitHub

Shell Scripting

Job description

Elevance Health in Richmond, VA is seeking a Business Information Developer Consultant Senior to advance data warehouse solutions and complex reporting from a centralized data warehouse. The role blends in-office collaboration 1–2 days a week with flexible remote work to support productivity and balance.

The candidate should have a BS/BA and 6+ years of experience with strong data engineering, ETL, and SQL skills.