Data Engineer Senior
General Dynamics Information Technology•USA MD Home Office (MDHOME), MD
•$102,000 - $138,000•Remote
About The Position
Own your opportunity to turn data into measurable outcomes for our customers’ most complex challenges. As a Data Engineer Senior at GDIT, you’ll power innovation to drive mission impact and grow your expertise to power your career forward. MEANINGFUL WORK AND PERSONAL IMPACT As a Data Engineer Senior, the work you’ll do at GDIT will be impactful to the mission of the Centers for Medicare & Medicaid Services (CMS) Center for Program Integrity (CPI) on the Unified Case Management (UCM) system. As a PostgreSQL database engineer, you will play a crucial role in supporting the database quality and performance that will enhance the investigative capabilities against fraud, waste, and abuse within CPI.
Requirements
- Bachelors Degree in Computer Science, Data Science, or Information Systems or related field
- 5+ years of related experience
- AWS RDS/Aurora PostgreSQL experience
- Advanced SQL
- Python for data engineering and automation development.
- Previous experience supporting CMS and Unified Case Management system
- ETL/Reporting experience
Nice To Haves
- CDC/streaming using AWS DMS, AWS Kinesis, Debezium, Amazon MSK/Apache Kafka; logical replication, WAL, replication slot management.
- Data pipeline design and operations for ingestion/transform/migrate; near real-time data movement into Snowflake, Databricks, or data lakes.
- Troubleshooting performance across databases, SQL, pipelines, and integrations; release-related database scripting/support.
- ETL/ELT tools, orchestration/workflow automation; shell scripting, Git, CI/CD; Agile/Scrum or SAFe environments.
- Familiarity with data governance, data quality, metadata/lineage, and reconciliation processes.
- Experience with regulated enterprise systems (e.g., healthcare, government, financial)
Responsibilities
- Support AWS-hosted PostgreSQL (Amazon RDS/Aurora) environments.
- Provide database/migration support for major application releases, including schema changes, data fixes, rollback planning, and deployment validation.
- Troubleshoot incidents and performance bottlenecks across databases, pipelines, and application connectivity.
- Design, build, and maintain data pipelines using Python, SQL, and AWS data services for ingestion, transformation, migration, and reconciliation.
- Support change data capture (CDC) and streaming architectures using AWS DMS, AWS Kinesis, Debezium, and Amazon MSK/Apache Kafka.
- Enable near real-time movement from PostgreSQL to downstream platforms (e.g., reporting schemas, data lakes, Snowflake, Databricks).
- Develop automation scripts for data movement, validation, reconciliation, and operational support.
- Collaborate with application, DevOps, data platform, reporting/analytics, QA, and business teams to ensure data consistency and reliability; drive root-cause analysis and remediation of data quality issues.
- Review, evaluate, design, implement and maintain environmental databases.
- Use database management concepts, storage and query/retrieval methods, statistical analyses, and programming languages to perform analyses, develop plans and recommendations, and prepare required level of documentation.
- Comply with project specifications, including format and content of input/output data and functions to be performed by computer programs.
- Prepare clear and accurate tables, data plots, maps and other graphics.
Benefits
- Comprehensive benefits and wellness packages
- 401K with company match
- Competitive pay
- Paid time off
- Full flex work week
- Variety of medical plan options, some with Health Savings Accounts
- Dental plan options
- Vision plan
- 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match.
- Variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave.
- Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees.
- Short and long-term disability benefits
- Life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
