Note: The job is a remote job and is open to candidates in USA. 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
Skills
- 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
Company Overview