Constant Contact

Analytics Engineer

Constant Contact

full-time

Posted on:

Location Type: Hybrid

Location: Waltham • Massachusetts • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $80,000 - $96,000 per year

Job Level

JuniorMid-Level

Tech Stack

AirflowAmazon RedshiftApacheBigQueryCloudPythonSQLTableau

About the role

  • Design, build, and optimize data models for analytical and operational use cases.
  • Design, develop, and maintain scalable data pipelines and ELT processes to transform raw data into usable formats(as needed).
  • Collaborate with data analysts, data scientists, data engineers, and other stakeholders to understand data needs and deliver high-quality, reliable data solutions.
  • Ensure data quality and integrity by implementing best practices for data validation, testing, and documentation.
  • Develop and maintain data infrastructure and tooling to support analytics workflows.
  • Monitor and troubleshoot data pipelines/models, reports to ensure smooth operation and timely delivery of data.
  • Implement and enforce data governance and security measures.
  • Provide reliable and trustworthy models for the Organization to make critical decisions.

Requirements

  • 2+ years of experience as an Analytics Engineer, Data Engineer, or a similar role
  • Strong proficiency in SQL and experience with data modeling and schema design such as star and snowflake
  • Experience with ELT tools and data pipeline frameworks (e.g., dbt, Apache Airflow, Fivetran). DBT - Preferred.
  • Proficiency in Python programming.
  • Familiarity with cloud data warehousing solutions (e.g., Snowflake, BigQuery, Redshift). Experience with Snowflake is desirable.
  • Knowledge of data visualization tools (e.g., Tableau, Looker, Power BI).
  • Excellent communication and collaboration skills.
Benefits
  • Health and welfare benefits including paid leave
  • Opportunities to grow your career
  • Generous paid time off policy

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLdata modelingschema designELTdata pipeline frameworksPythondata visualizationdata validationdata governancedata integrity
Soft skills
communicationcollaboration