Analytics Engineer: Data Pipelines & Models

Constant Contact; Waltham (MA); On-site; USD 84,800 - 101,760; Full time

Benefits offered by this job

Health benefits

Generous paid time off

Job summary

Constant Contact is seeking an Analytics Engineer in Waltham, MA to bridge data analysis and data engineering. You will transform raw data into clean, reliable datasets, build robust data models, and empower analysts and stakeholders with actionable insights that drive decisions across the organization.

You will design scalable data pipelines, enforce data governance, and collaborate with data teams to deliver high-quality data solutions.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, Mathematics or related field; Master’s preferred.
• 1-3 years of experience as Analytics Engineer, Data Engineer, or similar role.
• Strong SQL proficiency and data modeling (star/snowflake).
• Experience with ELT tools and data pipelines (Airflow, dbt, Fivetran).
• Python or R programming experience.
• Familiarity with Snowflake/BigQuery/Redshift.
• Knowledge of data visualization tools (Tableau/Looker/Power BI).
• Good problem-solving and collaboration skills.

Responsibilities

• Design, build, and optimize analytical and operational data models.
• Develop and maintain scalable ELT pipelines to transform raw data.
• Collaborate with analysts, scientists, and engineers to meet data needs.
• Ensure data quality and governance with testing, validation, and documentation.
• Maintain data infrastructure and tools to support analytics workflows.
• Monitor pipelines and reports for timely data delivery and reliability.
• Enforce data governance and security standards.
• Provide reliable models to support critical business decisions.
• Finance domain analytics experience is a plus.

Skills

SQL

Data modeling

Python

R

Cloud data warehousing

Data visualization

Communication

Agile

Analytical thinking

Education

Bachelor's degree in CS/Engineering/Math

Master's degree a plus

Tools

Airflow

dbt

Fivetran

Job description

Constant Contact is seeking an Analytics Engineer in Waltham, MA to bridge data analysis and data engineering. You will transform raw data into clean, reliable datasets, build robust data models, and empower analysts and stakeholders with actionable insights that drive decisions across the organization.

You will design scalable data pipelines, enforce data governance, and collaborate with data teams to deliver high-quality data solutions.