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
Artificial Intelligence • Fintech • Information Technology • Logistics • Payments • Business Intelligence • Generative AI
Lead design, automation, and maintenance of cloud-based database infrastructure (primarily SQL Server and MySQL). Improve reliability with monitoring, HA/DR, automation, troubleshooting, on-call support, and mentoring of junior engineers while collaborating across teams.
Top Skills:
AuroraAWSBashFailover ClusteringMySQLNew RelicOrchestratorPmmPythonRdsRubySQL ServerVividcortex
Information Technology
Lead development and maintenance of an MS Access front-end with AWS/MariaDB backend for the Financial Management Tool. Manage forms, queries, reporting tables, automation, ODBC connectivity, version control, performance tuning, data integrity, and user access. Ensure reporting accuracy, daily refreshes, error resolution, and provide user support.
Top Skills:
AWSMariadbMs AccessMySQLOdbcSQL
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
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
