Hands-on engineering role to design, build, and maintain scalable ETL/ELT data pipelines, data warehouses and lakes, and data models. Optimize batch and near-real-time processing, implement query optimization and data quality checks, support AI data workflows, and collaborate with architects, analysts, and stakeholders.
This is a hands-on engineering role focused on designing efficient data pipelines, improving data infrastructure, and enabling teams to leverage data effectively.
Responsibilities- Design, build, and maintain scalable data pipelines and ETL/ELT workflows to ingest and transform data from multiple sources
- Develop and optimize batch and near real-time data processing pipelines for analytics and reporting
- Build and maintain data warehouse and data lake structures to support business intelligence and analytics use cases
- Implement and maintain data models that support efficient querying and reporting
- Improve performance and scalability of data systems through query optimization, indexing, and partitioning strategies
- Implement data quality checks, monitoring, and logging to ensure reliability of data pipelines
- Exposure to AI initiatives and experience building data pipelines supporting AI workflows
- Work with data architects and engineering teams to implement scalable data platform designs
- Collaborate with analysts, BI developers, and business stakeholders to deliver data solutions that support business needs
- Maintain documentation for data pipelines, data models, and data workflows
Bachelor's/Master's in Engineering 5-8 years
Similar Jobs
Big Data • Fitness • Healthtech • Information Technology • Software • Analytics
Own SQL and dbt-based data modeling and data quality for clinical and claims datasets. Author and refactor dbt models/tests, triage DQ alerts, design monitors, optimize SQL performance, and collaborate with Data Engineering and stakeholders to ensure trusted production datasets.
Top Skills:
AirflowAmazon RedshiftApache HudiArgo WorkflowsAws AthenaClaudeCptDbtDbt-SparkGitGitGrafanaIcd-10JIRALoincLokiNdcNpiPythonSpark SqlSQL
Information Technology • Consulting
Lead design and governance of KPIs, semantic layers, and analytics assets. Perform advanced SQL tuning across RDS/Oracle/Redshift and cost-aware Athena querying. Build reproducible Python analyses, data validation, anomaly detection, deep-dive analytics, source-to-target mapping, and drive BI dashboard UX and version-controlled analytics engineering practices.
Top Skills:
Amazon KinesisAmazon QuicksightAmazon RedshiftAmazon SnsAmazon SqsAws AthenaAws Glue Data CatalogConfluenceGithub CopilotIamJIRAOracleOrcPandasParquetPythonRdsS3Scikit-LearnSQLStatsmodelsTableau
Healthtech
Lead hands-on design, development, review, and optimization of production data pipelines and platform capabilities. Provide technical leadership, mentor engineers, drive CI/CD, observability, automation, and scalable data platform architecture to support analytics and ML workloads within an Agile environment.
Top Skills:
Apache AirflowApache HiveApache HudiApache IcebergApache KafkaSparkAvroAWSAzureAzure BoardsAzure PipelinesDelta LakeDockerFhir ApisFlinkGCPGcp DataflowGitGithub ActionsGoogle BigqueryJenkinsJIRAKubernetesOrcParquetPythonRaySharepointSQLVertex Ai
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
