Senior Data Engineer at ONEGLOBE LLC – Washington, District of Columbia

What You'll Get to Do as a Data Engineer:

• Serve as a technical point of contact for client stakeholders, leading meetings with both internal teams and federal agency counterparts.
• Maintain version-controlled codebases in GitLab and enforce code review and CI/CD best practices across the data engineering team.
• Containerize development and deployment workflows using Docker to ensure environment consistency.
• Develop and maintain comprehensive business rules documentation in Confluence or equivalent knowledge management platforms.
• Mentor junior data engineers on SQL optimization, migration patterns, and documentation standards.
• Take responsibility for the delivery of Data Migration for multiple systems: analysis, design, implementation, testing, validation, and acceptance.
• Assembling large, complex sets of data that meet non-functional and functional business requirements.
• Communicate with key stakeholders to understand the data migration needs and requirements and troubleshoot data inconsistencies that might arise.
• Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies
• Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
• Develop data migration strategies and plans.
• Develop scripts to extract, transform and load data.
• Perform data analysis and cleansing activities to ensure data quality, as needed.
• Troubleshoot and resolve issues related to data migration.
• Participate in data migration testing including data-level validation and application-level validation.
• Document data migration processes, procedures, and outcome.

You’ll Bring These Qualifications

• Must be a US Citizen for DHS Suitability clearance.
• 5+ years of work experience with a combination of data modeling, ETL, database operations, data services, data analytics, ETL and data migration tools.
• 5+ years of work experience with coding in one of mainstream programming languages: Python, Java, Node.js etc.
• Experience with Git/GitLab workflows, including branching strategies, merge requests, and CI/CD pipeline configuration.
• Experience with Docker or containerized development environments.
• Familiarity with federal data systems and agency stakeholder dynamics (DHS/FEMA preferred).
• Experience in design and development of ETL process using AWS ETL tools like AWS DMS, Glue, Athena, AWS Aurora PostgreSQL, etc.
• Experience in designing data migration solutions, archival processes, and reconciliation.
• Experience with data quality checks, data de-duplication and data validation processes.
• Perform data migration audit, reconciliation, and exception reporting.
• Experience with a public cloud (AWS, Microsoft Azure, Google Cloud)
• Experience operating production workloads on Oracle/PostgreSQL (preferred)
• Solid understanding of data elements and their relationships between the source and target systems