Data Engineer II

Remote (United States)

Compensation

Annual salary range: $82,810 - $130,319 per year

Final compensation depends on geographic location and may fall outside the estimated range.

Employment Type

Full-Time

This is a 12-month fixed-term position with the possibility of renewal based on business needs and mutual interest.

About the Role

This opportunity is for a Data Engineer II to join a Data & Analytics team responsible for building, maintaining, and evolving a modern data platform. The role supports current and future project work through hands-on data engineering, warehouse transformation, pipeline development, infrastructure support, and business intelligence enablement.

The data platform uses technologies such as Snowflake, Tableau, and AWS cloud tools. This position is well suited for someone who enjoys hands-on technical work in a small, collaborative environment and can adapt quickly across functional areas. The role also involves using AI-assisted tools responsibly to support analysis, documentation, troubleshooting, learning, debugging, and operational workflows.

This role is affiliated with an office in Cambridge, Massachusetts, but is open to remote employment within the United States.

What You’ll Do

• Contribute to the technical integrity and ongoing evolution of the data platform technology stack.
• Work closely with data engineers, technology leadership, and technical leads to improve platform reliability, scalability, and alignment with business needs.
• Design and implement core features and enhancements within the data platform.
• Contribute to technical specifications, conduct targeted technical research, and translate requirements into production-ready solutions.
• Execute and maintain DevOps workflows that support the data platform, including performance monitoring, platform upgrades, deployment frameworks, and operational improvements.
• Use guidance and mentorship from senior data engineers when needed to support platform operations and technical delivery.
• Use AI-assisted tools thoughtfully to accelerate development, debugging, documentation, and operational analysis.
• Validate AI-assisted outputs to ensure correctness, reliability, and security.
• Build and maintain reliable data extraction, loading, and transformation processes for managed and external data sources.
• Develop efficient and maintainable data pipelines using SQL and Python scripting.
• Design and develop data warehouse transformations using SQL-based methods and tools such as dbt.
• Collaborate with internal teams and external partners on enterprise data architecture design and implementation.
• Support analytics needs by conducting ad hoc analyses when required.
• Contribute to business intelligence outputs, including dashboards and visualizations using Tableau and other tools.
• Work across functional areas in a lean team environment and contribute to data systems that support real-world service delivery and decision-making.

Qualifications

• 2 to 5 years of experience in data engineering or a similar technical role.
• Proven experience designing, building, and evolving scalable data systems.
• Experience building maintainable, long-term technical solutions using software development best practices.
• Experience with version control, testing, and iterative development.
• Hands-on experience building and managing production-grade pipelines using ETL or ELT tools such as dbt, Airflow, Prefect, Fivetran, or Talend.
• Strong proficiency with cloud-based data platforms such as AWS and Snowflake.
• Experience with a broad range of data ingestion, processing, and storage technologies.
• Expert-level SQL skills for complex data engineering and analysis.
• Proficiency in Python and related data-oriented toolkits.
• Deep understanding of dimensional modeling concepts, including OLAP cubes, star schemas, Kimball architecture, and alternatives such as Inmon.
• Ability to work with technical stakeholders to clarify requirements and deliver effective end-to-end data solutions.
• Proficiency using AI-assisted tools for code generation, debugging, and optimization.
• Ability to quickly adapt to new schemas, tools, and technical environments.
• Comfort working directly in production systems to test, iterate, and optimize operational workflows.
• Eligible to work in the United States.

Bonus Experience

• Experience with enterprise data architecture, service-oriented frameworks, data integration, and data harmonization.
• Experience with data strategy, data governance, high-performing data lakes, data operations, and delivery frameworks.
• Experience with data ingestion frameworks supporting batch or real-time processing.
• Experience writing and maintaining production-ready code in a high-level programming language such as Python, Java, or C++.
• Experience with data analysis tools such as Jupyter Notebooks or R.
• Experience with data visualization tools such as Tableau, Power BI, or Superset.
• Experience with healthcare data or public health data collection methodologies and workflows.
• Experience working independently with partners on requirements gathering and solution development.
• Experience working in an agile software development environment.
• Experience using tools such as JIRA and Asana to manage work across technical and client-facing teams.

Benefits

• 100% employer-sponsored medical insurance paired with a generous Health Reimbursement Account fund.
• Access to voluntary dental and vision insurance plans.
• 401(k) plan with up to a 4% employer match.
• Employee stock option plan.
• 30 days of paid time off, inclusive of holidays.
• Unlimited sick time.
• Excellent parental leave policy.
• Flexible work schedule policy.
• Access to an Employee Assistance Program.