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
Big Data • Cloud • Information Technology • Analytics • Business Intelligence • Consulting • Data Privacy
Designs and implements scalable data, analytics, and AI solutions for clients. Builds and optimizes data models and ETL/ELT pipelines, performs testing and validation, translates business requirements into technical solutions, documents architectures, manages workstreams, supports client training, and contributes to governance, risk tracking, and solution design.
Top Skills:
Amazon RedshiftAzure SynapseBigQueryDatabricksEltETLPythonSnowflakeSQL
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Design, develop, test, and maintain large-scale healthcare data pipelines and AWS data warehouse solutions. Build Redshift and EMR ETL processes, monitor pipeline performance, resolve data discrepancies, support deployments, conduct code reviews, and document database designs and testing. Collaborate with engineers, analysts, consultants, and cross-functional teams to improve data quality, scalability, and processing efficiency.
Top Skills:
Amazon EmrAmazon RedshiftAmazon S3Automated Testing FrameworksAWSCi/CdETLOraclePythonSQLSQL Server
Financial Services
Build and operate scalable Databricks-on-AWS data pipelines using PySpark, Delta Lake, and lakehouse patterns. Optimize performance, implement data quality, monitoring, alerting, and automated remediation, and deliver curated datasets for BI and analytics partners. Collaborate with stakeholders on architecture and design while applying secure software engineering, CI/CD, agile, and operational stability practices. The role also uses AI-assisted development tools and supports workforce data analytics.
Top Skills:
AlteryxAmazon AthenaAmazon EmrAmazon S3Apache AirflowApache IcebergSparkAutosysAWSAws CloudwatchAws GlueAws LambdaBitbucketClaudeDatabricksDatabricks WorkflowsDelta LakeDelta Live TablesGitGithub CopilotJavaJenkinsOracleParquetPysparkPythonScalaSigmaSpinnakerSQLTableau
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
