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
Engineer
ETL
Google Cloud Bigquery
Healthcare Data Engineer
Informatica
Information Technology (IT)
Reporting and Analytics
Software Development
SQL
Tableau
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.