Database Engineer

TrueTandem is a trusted information technology solutions provider specializing in Microsoft-based solutions for federal and commercial clients. They are seeking a Data Engineer to support modernization initiatives by executing data migration, improving data quality, and preparing analytics-ready data for applications hosted in Microsoft Azure Government Cloud.

Responsibilities:

• Conduct discovery and assessment of customer’s legacy data sources to document data structures, dependencies, and data quality issues
• Perform data profiling to identify incomplete, duplicate, or inconsistent records prior to migration
• Design and execute data extraction, transformation, and load (ETL/ELT) processes to migrate legacy data into Azure‑based environments
• Cleanse, normalize, and standardize datasets to ensure consistency, accuracy, and usability across modernized systems
• Coordinate data migration timing with application teams to ensure data availability aligns with production deployments and go‑live activities
• Validate migrated data through reconciliation checks and stakeholder review to confirm completeness and accuracy
• Implement data quality checks, validation rules, and exception handling to support long‑term data integrity
• Support establishment of basic data governance artifacts, including documentation of data definitions, standards, and transformation logic
• Prepare curated datasets to support analytics and reporting use cases, including Power BI dashboards
• Support data integration efforts by assisting with data synchronization and API‑based data flows where required
• Develop and maintain technical documentation related to data models, migration approaches, and data quality controls
• Contribute to monthly progress reporting and other contract deliverables as required

Requirements:

• US Citizen with Public Trust clearance
• 5+ years of experience in data engineering, data migration, or ETL development
• SQL skills and experience working with relational data structures
• Experience cleansing, normalizing, and validating data
• Experience supporting data migrations from legacy applications or databases
• Ability to work independently and collaborate with application and analytics teams
• Hands-on experience with Microsoft Azure data services, preferably in Azure Government Cloud (MAG)
• Experience working with Microsoft Dataverse — tables, relationships, and data modeling
• Experience with Azure Data Factory and/or Synapse for ETL/ELT pipelines
• Experience implementing API-based data sharing and integration patterns between systems
• Experience supporting analytics or reporting initiatives (e.g., Power BI)
• Familiarity with data governance concepts in regulated or government environments
• Experience migrating data from Mendix or other low-code/legacy platforms