Database Engineer V

About Us

eSimplicity is a modern digital services company that partners with government agencies to improve the lives and protect the well-being of all Americans, from veterans and service members to children, families, and seniors. Our engineers, designers, and strategists cut through complexity to create intuitive products and services that equip federal agencies with solutions to courageously transform today for a better tomorrow.

Purpose and Scope:

eSimplicity is seeking a Database Engineer V to support the CMS National Data Warehouse (NDW), a data warehouse foundation used for operational and management reporting, trend analysis, forecasting, metadata management, and business intelligence reporting. This role designs, develops, documents, and maintains data processing systems, data models, database structures, and source-to-target transformation logic that support timely, accurate, and consistent reporting across the program.

The Database Engineer V partners with technical teams and program stakeholders across the software and systems development lifecycle to analyze complex requirements, evaluate source-system changes, uphold data architecture standards, and recommend scalable database and data warehouse solutions.

Responsibilities:

• Gather information from existing systems and analyze program, business, and timing requirements for complex data warehouse initiatives.
• Provide technical guidance on complex database, data warehouse, and systems analysis challenges.
• Develop detailed specifications, design logic, pseudo code, and documentation that support design, development, testing, and implementation activities.
• Conduct gap and impact analyses for source-system changes, requirement updates, and data transformation logic.
• Lead data analysis and database design efforts, including logical and physical data models for relational and dimensional data structures.
• Develop and maintain source-to-target mapping documentation, transformation rules, business intelligence object definitions, and data quality rules.
• Analyze complex ETL mappings and AWS Glue data flows from source systems to the data warehouse.
• Manage and maintain metadata across ERwin, Oracle, Amazon Redshift, AWS Glue, and MicroStrategy environments, as applicable.
• Create, update, and maintain DDL scripts and database structures supporting Oracle and Amazon Redshift environments.
• Write complex SQL queries to analyze large, complex datasets across multiple formats and sources.
• Tune database performance and recommend improvements to enhance data handling, conversion, input/output, storage, and reporting effectiveness.
• Evaluate multi-data-mart integration opportunities and challenges, recommend solutions, and communicate technical tradeoffs clearly.
• Conduct quality assurance activities, including peer reviews, code reviews, design reviews, and validation of proposed testing approaches.
• Partner with technical teams to resolve issues, validate programming requirements, and support on-schedule delivery of milestones and deliverables.
• Develop, document, and maintain data architecture standards, technical specifications, operating instructions, and related SDLC documentation.
• Protect CMS, Buyer, and program information in accordance with applicable security, privacy, and confidentiality requirements.