As a Data Engineer within the solutions delivery team, you will contribute to the modernization of mission-critical government systems. In collaboration with multidisciplinary stakeholders, you will design secure integrations among the portal, Microsoft Power Platform, Azure services, existing systems, SQL Server, and approved file-transfer services. This role supports health-screening data collection, workflow automation, notifications, results delivery, reporting, and analytics while preserving the authoritative system of record. All solutions must comply with approved GCC cloud environments, FISMA Moderate security requirements, federal privacy controls, Agile delivery practices, and Enterprise Performance Life Cycle requirements.
Our delivery teams value innovation, collaboration, feedback, and continuous improvement. We use Agile and automate-first DevSecOps practices, modern technology stacks, and iterative delivery. Successful team members work independently, collaborate effectively, and bring strong coding and problem-solving skills to complex customer challenges.
Role and Responsibilities:
- Design, build, test, deploy, and maintain secure ETL/ELT processes for structured and unstructured public health data.
- Develop scalable batch, scheduled, event-driven, and near-real-time pipelines for portal intake, validation, workflows, reporting, analytics, and bidirectional MHS exchange.
- Integrate Power Pages, Power Apps, Dataverse, Power Automate, Azure services, APIs, SQL Server, systems, and approved file-transfer platforms.
- Develop secure MHS SQL Server integrations using approved APIs, stored procedures, connectors, gateways, hybrid connections, or VPN interfaces; prohibit direct public database access.
Required Skills
- Five or more years of experience in data engineering, systems integration, data warehousing, analytics engineering, or database development.
- Hands-on experience constructing and maintaining production ETL and ELT pipelines using SQL and Python.
- Strong SQL Server development skills, including queries, views, stored procedures, data modeling, performance optimization, and controlled database interfaces.
Skills Required
- Five or more years of experience in data engineering, systems integration, data warehousing, analytics engineering, or database development.
- Hands-on experience constructing and maintaining production ETL and ELT pipelines using SQL and Python.
- Strong SQL Server development skills, including queries, views, stored procedures, data modeling, performance optimization, and controlled database interfaces.
What We Do
Established in 2004, TrueTandem is a consulting services organization focused on the rapid deployment and adoption of Microsoft technologies and solutions. The company offers a full array of services from infrastructure to application development. Current job offerings can be found here: https://jobs.lever.co/truetandem TrueTandem's mission is to help customers quickly realize and leverage the value of their technology investments, become more efficient and self-sufficient. TrueTandem's management team has over 50 years of collective work experience as former Microsoft employees. The team understands the technology and culture to get the most out of client's relationships with and investments in Microsoft. TrueTandem knows how to navigate a large organization while offering the agility of a small company. A Certified Small Business and Gold-Certified Managed Microsoft Partner, TrueTandem's reputation for outstanding work in the public and the private sectors has earned them the respect of government entities, fortune 500 companies, associations and software partners around the world. Large and small organizations trust TrueTandem with their mission-critical deployments and solutions. TrueTandem thrives on delivering quality projects for our customers with their core statement, "we just get it done!"
.png)
