Analytics Engineer: Build Trusted Data Pipelines & Models

Constant-Contact; Waltham (MA); Hybrid; USD 85,000 - 102,000; Full time

Benefits offered by this job

Health benefits

Hybrid work model

Paid time off

Job summary

Constant Contact in Waltham, MA is seeking an Analytics Engineer who bridges data analysis and data engineering. You will transform raw data into clean datasets, build data models, and enable analysts to extract insights.

This flexible hybrid role from our headquarters in Waltham includes onsite interviews and a compensation package with health benefits and paid leave. Candidates should have 2+ years in analytics or data engineering, strong SQL, experience with ELT tools, Python or R, and

Qualifications

• 2+ years of experience as an Analytics Engineer, Data Engineer, or related role.
• Strong proficiency in SQL and data modeling (star/snowflake schemas).
• Experience with ELT tools and data pipeline frameworks (Airflow, dbt, Fivetran).DBT preferred.
• Proficiency in Python or R.
• Familiarity with cloud data warehousing (Snowflake, BigQuery, Redshift).
• Knowledge of data visualization tools (Tableau, Looker, Power BI).
• Strong problem-solving and communication skills.

Responsibilities

• Design, build and optimize data models for analytical and operational use cases.
• Develop scalable data pipelines and ELT processes to transform raw data into usable formats.
• Collaborate with analysts, scientists, engineers and stakeholders to deliver reliable data solutions.
• Ensure data quality and integrity through validation, testing, and documentation.
• Maintain data infrastructure and tooling to support analytics workflows.
• Monitor and troubleshoot pipelines and reports for timely data delivery.
• Implement data governance and security measures.

Skills

SQL

Data modeling

Python/R

Data visualization

Agile

Communication

Cloud data warehousing

Data governance

Problem solving

Tools

Apache Airflow

dbt

Fivetran

Job description

Constant Contact in Waltham, MA is seeking an Analytics Engineer who bridges data analysis and data engineering. You will transform raw data into clean datasets, build data models, and enable analysts to extract insights.

This flexible hybrid role from our headquarters in Waltham includes onsite interviews and a compensation package with health benefits and paid leave. Candidates should have 2+ years in analytics or data engineering, strong SQL, experience with ELT tools, Python or R, and