Remote Senior Data Warehouse Engineer

Esimplicity; Columbia (MD); On-site; USD 140,000 - 180,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

401(k) retirement benefits

Paid time off

Paid holidays

Life and disability insurance

Wellness programs

Job summary

eSimplicity seeks a seasoned Database Engineer V to support the CMS National Data Warehouse (NDW). You will design and maintain data processing systems, models, and ETL logic to ensure accurate, timely reporting and robust BI capabilities.

Responsibilities include leading data modeling efforts, tuning performance, and documenting data architecture standards. Remote position with ET hours, some travel may be required.

Qualifications

• Complex SQL queries for large datasets.
• Logical and physical data modeling (relational and dimensional).
• Database design, DDL scripting in Oracle/Redshift.
• Data warehouse architecture, source-to-target mapping.
• AWS Glue ETL flow analysis and data movement understanding.
• ERwin or comparable data modeling tools.
• MicroStrategy BI tools and reporting metadata.
• SDLC processes and technical documentation.
• Strong analytical and communication skills.

Responsibilities

• Gather requirements and analyze data warehouse needs.
• Provide guidance on complex data warehouse challenges.
• Develop specs, design logic, and documentation for ETL and reporting.
• Lead data modeling and metadata management activities.
• Analyze ETL mappings and AWS Glue data flows.
• Manage metadata across ERwin, Oracle, Redshift, and BI tools.
• Write complex SQL and tune database performance.
• Collaborate with teams to meet milestones and quality standards.

Skills

Complex SQL queries

Data modeling (logical & physical)

Oracle/Redshift DB design

Data warehouse architecture

AWS Glue ETL flow analysis

ERwin data modeling

MicroStrategy BI

DB performance tuning

SDLC & documentation

Strong communication

Education

Bachelor's degree in CS/IS/Engineering

Tools

ERwin

ERwin Mapping Manager

MicroStrategy

AWS Glue

Oracle

Amazon Redshift

Job description

eSimplicity seeks a seasoned Database Engineer V to support the CMS National Data Warehouse (NDW). You will design and maintain data processing systems, models, and ETL logic to ensure accurate, timely reporting and robust BI capabilities.

Responsibilities include leading data modeling efforts, tuning performance, and documenting data architecture standards. Remote position with ET hours, some travel may be required.