Data Engineer
Backend Developer
Analytics
Big Data
Bigdata
Business Analytics
Business Intelligence
Cloud
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Data Warehousing
Database
Databases
Digital Marketing
ETL
Google Cloud Bigquery
Healthcare Data Engineer
Informatica
Information Technology (IT)
Reporting and Analytics
Software Development
SQL
Tableau
Job Description
AcuityMD is seeking a Data Engineer to build and transform data pipelines and transformation systems. Based in Boston, MA (hybrid), the role focuses on relational database modeling and analysis, and includes collaboration with product managers and stakeholders on validation approaches and statistical benchmarks.
Location and Work Arrangement
Boston, MA (hybrid).
- Telecommuting: Full-time telecommuting permitted from anywhere within the U.S.
- Travel: Quarterly travel to the Boston headquarters.
Compensation and Schedule
- Salary: USD 112,861 - 159,000 per year.
- Schedule: 40 hours per week, M-F, 9:00 a.m. to 5:00 p.m.
Responsibilities
- Communicate business concepts, technical requirements, recommendations, and code clearly and concisely.
- Build data transformation systems and pipelines.
- Explore, transform, and analyze data in relational databases.
- Model new data and improve existing data products using quantitative rigor to address customer problems while ensuring correctness and interpretability.
- Transform and integrate raw data from multiple sources into usable, documented, high-quality data and intelligence products using data modeling and statistical techniques.
- Partner 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.
- Alternatively, the 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, modeled data assets within a database or warehouse, including schema design and applying sensible models for reliable, reusable tables (1 year).
- Experience writing analytic SQL across multiple dialects (e.g., PostgreSQL, Snowflake, BigQuery, Spark SQL), with fluency in window functions, CTEs, and complex joins and aggregations (1 year).
- Experience applying foundational ML algorithms (e.g., random forest classifiers, logistic regression) to derive insights, including selecting algorithms, evaluating performance, and interpreting model outputs in clear, non-black-box terms (1 year).
- Experience forecasting from time-series data using Python libraries such as Prophet (or comparable tools like statsmodels), including accounting for trend and seasonality and validating accuracy against held-out data (1 year).
- Familiarity with large datasets (hundreds of gigabytes up to terabyte scale) and optimizing SQL performance at that scale, including partitioning, indexing, and query plan review (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 creating automated checks to detect quality issues (nulls, duplicates, schema drift, out-of-range values) before downstream consumption (1 year).
- Exposure to common healthcare data standards and structures (e.g., FHIR, HL7, OMOP, claims/HER data), including de-identification and responsible handling of PHI under HIPAA (1 year).
- Must be legally authorized to work in the U.S. without sponsorship.
Technology Stack
- PostgreSQL
- Snowflake
- BigQuery
- Spark SQL
- Python
- Prophet
- statsmodels
- Tableau
- Hex
- Claude Code
- FHIR
- HL7
- OMOP
Special Skill Requirements
- Data modeling and ingestion: Transforming raw data files into well-structured, documented, modeled data assets, including schema design and creating reliable, reusable tables (1 year).
- Analytic SQL: Writing SQL across multiple dialects with window functions, CTEs, and complex joins and aggregations (1 year).
- Applied machine learning: Using foundational ML algorithms with model evaluation and interpretation in clear, non-black-box terms (1 year).
- Time-series forecasting: Forecasting with Prophet (or statsmodels), accounting for trend and seasonality, and validating against held-out data (1 year).
- Computational performance at scale: Optimizing SQL for datasets ranging from hundreds of gigabytes to terabyte scale, including partitioning, indexing, and reading query plans (1 year).
- Visualization and communication: Using Tableau or Hex to communicate non-obvious query plans in a fast and cost-aware manner (1 year).
- Directing agentic development: Directing autonomous agentic development systems (e.g., Claude Code) to build tools (1 year).
- Data quality, testing, and validation: Profiling data and building automated checks for nulls, duplicates, schema drift, and out-of-range values (1 year).
- Healthcare domain awareness: Working with FHIR, HL7, OMOP, and claims/HER data, including de-identification and PHI handling under HIPAA (1 year).
Equal Opportunity Employer
AcuityMD is an Equal Opportunity Employer, including disability and protected veteran status.