Perform hands-on data engineering to assess legacy sources, profile and cleanse data, design and run ETL/ELT migrations into Azure Government environments, validate and reconcile migrated data, implement data quality checks and basic governance, and prepare curated datasets for analytics (Power BI) while coordinating with application teams and producing contract deliverables.
Company Description
TrueTandem's mission is to be a trusted information technology solutions provider, committed to the success of our customers, communities and employees. To enable this mission, we listen to our customers’ needs, empower our dedicated and talented employees, envision success together, and deliver innovative cost-effective solutions. For our customers, we aim to deliver more power to meet their business outcomes through technology implementation, integration, optimization and customization. We enable some of the most well-known companies, nonprofits and federal agencies in the United States to intelligently plan and develop their applications, modernize their infrastructure and manage their data.
TrueTandem, LLC is seeking an experienced, driven, and growth-oriented Data Engineer to support our modernization engagement. TrueTandem is a 17-year Certified Small Business and a Microsoft AI Cloud Solutions Partner specializing in delivering innovative Microsoft-based solutions across Federal and commercial clients. We help organizations modernize applications, transform infrastructure, and unlock the value of their data through rapid adoption of Microsoft technologies.
The Data Engineer will support our customers modernization initiatives by executing data migration, data quality improvement, and analytics‑ready data preparation activities in support of modernized applications hosted in Microsoft Azure Government Cloud. This role is responsible for hands‑on execution of data engineering tasks required to migrate, validate, govern, and prepare the customer’s data assets for operational use and reporting.
This work will be remote and full-time.
Responsibilities Include:
- 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.
Required Qualifications:
- US Citizen with Public Trust clearance
- 1+ 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.
- Preferred: Experience implementing API-based data sharing and integration patterns between systems.
- Preferred: Active CDC suitability or Public Trust clearance
- Preferred: Experience supporting analytics or reporting initiatives (e.g., Power BI).
- Preferred: Familiarity with data governance concepts in regulated or government environments.
- Preferred: Experience migrating data from Mendix or other low-code/legacy platforms.
Additional Information
TrueTandem is an equal opportunity employer, committed to diversity and inclusion in the workplace and affords equal opportunity to all qualified applicants for all positions without regard to protected veteran status, qualified individuals with disabilities and all individuals without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age or any other status protected under local, state or federal laws.
Equal Opportunity Employer - Minorities/Females/Disabled/Veterans
Similar Jobs
Hardware • Security • Manufacturing
Design, support, and optimize PostgreSQL-based data systems for USGS; write efficient SQL, manage large datasets, automate workflows with Python, implement CI/CD using GitLab/GitHub, and deploy/scale databases on AWS (EC2, S3, RDS) to ensure data integrity, performance, and operational reliability.
Top Skills:
Aws Ec2Aws RdsAws S3Ci/CdGitGitlabPostgresPythonSQL
Information Technology • Consulting
Lead development, maintenance, and optimization of an MS Access front-end for a cloud-hosted MariaDB/MySQL financial management backend. Build queries, stored procedures, ODBC connectivity, Excel/Pivot reporting, bulk data loads, role-based access, SharePoint distribution, documentation, performance tuning, and translate stakeholder requirements for federal financial workflows.
Top Skills:
AgmaxAWSMacrosMariadbMicrosoft AccessExcelMySQLOdbcOffice 365 (64-Bit)Oracle Mysql Odbc DriverPivot TablesSharepointSQLStored ProceduresVBA
Information Technology • Software
Design, operate, and optimize high-scale PostgreSQL/Aurora databases for payments. Implement partitioning, advanced indexing, query tuning, and reliability practices. Work with analytics stacks (ClickHouse/Tinybird), search (OpenSearch), and data pipelines to support transactional and analytical use cases, migrations, and incident response.
Top Skills:
AWSAws AuroraClickhouseOpensearchPostgresTinybird
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
