DeveloperJobs.io
← Back to all jobs

Job Description

AcuityMD is hiring a Data Engineer to design and improve data pipelines and transformation systems. This role partners with product managers and stakeholders to validate data outputs, establish statistical benchmarks, and model analytics-ready datasets for downstream use.

Location and Work Arrangement

  • Location: Boston, MA (hybrid)
  • Remote work: Full-time telecommuting permitted from anywhere within the U.S.
  • Travel: Quarterly travel to the Boston headquarters
  • Schedule: 40 hours per week, M-F, 9:00 a.m. to 5:00 p.m.

Compensation

  • Salary range: USD 112,861 - 159,000 per year

Responsibilities

  • Communicate business context, technical requirements, recommendations, and code clearly and concisely.
  • Build data transformation workflows and pipelines in any capacity.
  • Explore, transform, and analyze data in relational databases.
  • Model new data and improve existing data products using quantitative rigor to ensure correctness and interpretability while addressing customer needs.
  • Transform and integrate raw data from multiple sources into usable, documented, high-quality data and intelligence products using data modeling and statistical techniques.
  • Collaborate with product managers and cross-functional stakeholders to design solution approaches, validation frameworks, and statistical benchmarks.

Requirements

  • Master’s degree (or foreign equivalent) in Computer Science, Computer Engineering, or a closely related field, plus 1 year of experience in the job offered or a related occupation.
  • Employer will accept a Bachelor’s degree (or foreign equivalent) in Computer Science, Computer Engineering, or a closely related field plus 2 years of progressively responsible experience in the job offered or a related occupation.
  • Experience transforming raw data files into well-structured, documented, and modeled data assets in a database or warehouse, including schema design and sensible modeling for reliable, reusable tables (1 year).
  • Experience writing analytic SQL across multiple dialects (e.g., PostgreSQL, Snowflake, BigQuery, Spark SQL), including fluency with window functions, CTEs, and complex joins and aggregations (1 year).
  • Experience applying foundational machine learning algorithms (e.g., random forest classifiers, logistic regression) to derive insights, including algorithm selection, performance evaluation, and clear interpretation of model outputs (1 year).
  • Experience forecasting from time-series data using Python libraries such as Prophet (or comparable tools like statsmodels), accounting for trend and seasonality and validating forecast accuracy against held-out data (1 year).
  • Familiarity with large datasets (hundreds of gigabytes up to terabyte scale), including SQL performance optimization (partitioning, indexing, and reading query plans) to keep queries fast and cost-aware (1 year).
  • Experience using data visualization tools such as Tableau or Hex to communicate non-obvious query plans in a fast and cost-aware manner (1 year).
  • Working familiarity with directing autonomous agentic development systems (e.g., Claude Code) to build tools (1 year).
  • Experience profiling data and building automated checks for data quality issues (nulls, duplicates, schema drift, out-of-range values) before data reaches downstream consumers (1 year).
  • Exposure to healthcare data standards and structures (e.g., FHIR, HL7, OMOP, claims/HER data), including de-identification and responsible PHI handling under HIPAA (1 year).
  • Must be legally authorized to work in the U.S. without sponsorship.

Required Technologies

  • PostgreSQL
  • Snowflake
  • BigQuery
  • Spark SQL
  • Python
  • Prophet
  • statsmodels
  • Tableau
  • Hex
  • Claude Code
  • FHIR
  • HL7
  • OMOP

Special Skill Requirements

  • Data modeling and ingestion: Transform raw data files into structured, documented, modeled data assets with schema design and modeling that produce reliable, reusable tables (1 year).
  • Analytic SQL: Write analytic SQL across multiple dialects (e.g., PostgreSQL, Snowflake, BigQuery, Spark SQL) with window functions, CTEs, and complex joins and aggregations (1 year).
  • Applied machine learning: Use foundational ML algorithms (e.g., random forest classifiers, logistic regression) to derive insights, evaluate performance, and interpret model outputs in clear, non-black-box terms (1 year).
  • Time-series forecasting: Forecast from time-series data using Prophet or comparable tools such as statsmodels, accounting for trend and seasonality and validating against held-out data (1 year).
  • Computational performance at scale: Optimize SQL performance for datasets ranging from hundreds of gigabytes to terabyte scale, including partitioning, indexing, and query-plan review (1 year).
  • Visualization and communication: Use Tableau or Hex to communicate non-obvious query plans in a fast and cost-aware manner (1 year).
  • Directing agentic development: Direct autonomous agentic development systems (e.g., Claude Code) to build tools (1 year).
  • Data quality, testing, and validation: Profile data and build automated checks for quality issues (nulls, duplicates, schema drift, out-of-range values) (1 year).
  • Healthcare data domain awareness: Work with FHIR, HL7, OMOP, claims/HER data, including de-identification and responsible PHI handling under HIPAA (1 year).

Equal Opportunity Statement

EOE, including disability and veterans.

Similar Jobs