Designs, builds, tests, deploys, and maintains secure ETL/ELT pipelines for public health data. Integrates Power Platform, Azure services, APIs, SQL Server, CDC/NIOSH systems, and approved file-transfer platforms. Develops batch, event-driven, and near-real-time data workflows supporting intake, validation, reporting, analytics, notifications, and results delivery while meeting FISMA Moderate, federal privacy, Agile, and DevSecOps requirements.
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.
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.
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 • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
Build and operate production data pipelines and dimensional models using Spark, SparkSQL, and cloud lakehouse technologies. Own pipelines from requirements through deployment, monitoring, and iteration; improve data quality, lineage, reliability, and cost efficiency. Partner with data scientists, analysts, product managers, and engineers to support datamarts, KPIs, reporting, and analysis. Participate in business-hours on-call rotations and improve runbooks and alerting.
Top Skills:
AirflowC++DatabricksJavaKafkaKinesisMonte CarloPythonScalaSparkSparksqlSQLStructured Streaming
Financial Services
Develop and maintain secure, scalable data pipelines and production code using AWS, PySpark, Python, and ETL technologies. Extract and transform data, implement quality checks, optimize data processing workflows, support cloud data modernization, and ensure reliable data availability. Collaborate with cross-functional teams, troubleshoot technical issues, automate recurring remediation, and communicate with technical and non-technical stakeholders. The role also involves software testing, operational stability, continuous delivery, and potentially mentoring other engineers.
Top Skills:
Ab InitioAirflowAWSCi/CdData LakesDatabricksETLInformaticaJavaPysparkPythonSnowflakeSQL
AdTech • Automotive • Big Data • Consumer Web
Administer and enhance Edmunds’ Databricks data platform and AWS infrastructure. Build and maintain ETL pipelines, infrastructure-as-code tooling using Terraform or CDK, and operational dashboards, alerts, and reports. Collaborate with business, engineering, analytics, security, and infrastructure teams to support data platform users and AI solutions. Evaluate new technologies, troubleshoot platform issues, and improve operational, cost, and security visibility.
Top Skills:
SparkAWSAws CdkDatabricksInfrastructure As Code (Iac)PythonScalaSQLTerraform
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
