Database Engineer V

eSimplicity•Columbia, MD

20h•Remote

About The Position

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: The Database Engineer V designs, develops, and maintains data processing systems and tools. It involves analyzing customer needs, determining system requirements, designing data structures, ensuring compatibility across platforms, and documenting technical specifications. This position also evaluates new technologies and recommends improvements to enhance data handling and system performance.

Requirements

Bachelor of Science in related field or equivalent years of experience
10+ years related experience
Minimum of 7 years of systems analysis experience in a data warehouse environment using MS tools (MS Word, Excel, PowerPoint, and Project)
Minimum of 3 years of recent hands-on architecting data warehouse solutions.
Must possess effective organizational, interpersonal, oral and written skills
Strong analytical and problem-solving capabilities and close attention to detail.
Must be a team player able to multi-task in a dynamic environment
Extensive working knowledge of the SDLC and the associated processes and documentation.
This position requires access to information subject to U.S. government regulations. Only U.S. citizens or lawful permanent residents may be considered due to government contract requirements

Nice To Haves

Experience implementing solutions in AWS Glue, MicroStrategy (2019 or higher), Oracle (10g or higher), and Redshift environment with a strong background in SQL commands/ functions/ Procedures and database data modeling tools similar to Erwin, source to target mapping tools similar to Erwin Mapping Manager.

Responsibilities

Gather information from existing systems and define program requirements.
Provide technical guidance on complex program and system challenges.
Develop detailed specifications and design solutions to meet complex business needs.
Conduct technical analysis and assist project teams in resolving system issues.
Write DDL scripts and update database structures for Oracle and Redshift
Tune database performance.
Evaluate multi-data-mart integrations and recommend solutions and testing approaches.
Perform gap/impact analyses on source changes and requirements.
Write complex SQL queries for large, multi-format datasets.
Analyze data warehouse scenarios, including AWS Glue ETL flows
Lead data analysis and design logical/physical data models (relational and dimensional).
Document source-to-target logic, mappings, BI objects, and data quality rules.
Manage metadata across ERwin, Oracle, Redshift, AWS Glue, and MicroStrategy.
Develop and maintain data architecture standards and documentation.