Analytics Engineer

Constant Contact • Waltham, MA

4d • Hybrid

About The Position

At Constant Contact, we are seriously awesome people who take ownership and make an impact by operating with the mindset, integrity and courage of a small business owner. There’s something so profoundly rewarding about knowing that your work is empowering people everywhere to pursue their dreams . Here, we all play an integral part in helping business owners, entrepreneurs, non-profits and individuals to succeed by giving them all the help and tools they need to grow online. We’re energized by new challenges and new possibilities-and we’re just getting started! About Us: Constant Contact, an established leader in online marketing, helps small businesses, nonprofits, and individuals stay connected with their customers through email marketing, social media, event marketing, and more. Our mission is to empower small businesses and organizations to create and grow customer relationships and achieve their goals through powerful online marketing tools. We value innovation, collaboration, and a customer-first mindset in everything we do. Job Summary: As an Analytics Engineer, you will bridge the gap between data analysis and data engineering. You will be responsible for transforming raw data into clean, reliable data sets, building robust data models, and enabling data analysts and other stakeholders to extract meaningful insights. Your work will directly impact decision-making processes across the organization.

Requirements

• Bachelor's degree in Computer Science, Engineering, Mathematics, or a related field.
• 1-3 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., Apache Airflow, dbt, Fivetran).
• Proficiency in programming languages such as Python or R.
• Familiarity with cloud data warehousing solutions (e.g., Snowflake, BigQuery, Redshift).
• Strong problem-solving skills and attention to detail.
• Excellent communication and collaboration skills.

Nice To Haves

• A Master's degree is a plus.
• DBT - Preferred.
• Experience with Snowflake is desirable.
• Knowledge of data visualization tools (e.g., Tableau, Looker, Power BI) is a plus.
• Experience with the Finance domain/analytics is a plus.
• Experience with cloud databases
• Experience in Reporting tools.
• Knowledge of machine learning concepts
• Familiarity with data governance and compliance standards.
• Ability to work in an agile environment.

Responsibilities

• 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 and reports to ensure smooth operation and timely data delivery.
• Implement and enforce data governance and security measures.
• Provide reliable and trustworthy models for the Organization to make critical decisions.

Benefits

• Competitive salary and benefits package.
• Opportunity for professional growth and development.
• Collaborative and inclusive work environment.
• Flexible work arrangements.
• health and welfare benefits including paid leave.
• generous paid time off policy
• competitive benefits package that supports the health and well-being of you and your family

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level