Analytics Engineer

Constant Contact•Waltham, MA

7d•$80,000 - $96,000•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! We have an opening for an Analytics Engineer who 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. This role elevates you from a backend support function to a strategic partner who will directly influence organizational decision-making. You will have the autonomy to design and optimize a modern data stack using dbt and Snowflake, moving beyond legacy maintenance to build scalable infrastructure that empowers small businesses. This is a high-visibility opportunity to combine deep technical execution with clear business impact in an environment that prioritizes innovation and professional growth. This is a flexible, hybrid role requiring in-office presence in our Waltham, MA office twice a week

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.

Nice To Haves

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, 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.
Experience with the Finance domain/analytics is a plus.

Benefits

We celebrate one another’s differences. We are proud of our culture of diversity and inclusion, and we're always working hard to strengthen and improve this culture. We have programs in place that bring us together on important issues and provide educational opportunities for all employees.
Join the experts. If you're passionate about supporting businesses and organizations, you won’t find a better spot to share your talent. We’re dedicated to improving the quality of our product from a customer standpoint and have a true desire to enable the success of businesses, non-profit organizations, and community groups.
You’ll have opportunities to grow your career. We encourage and support our team members to learn different aspects of the business, take on stretch assignments, seek coaching opportunities and professional development opportunities.
A generous paid time off policy and a competitive benefits package that supports the health and well-being of you and your family
At Constant Contact, we’re all about work flexibility and are proud to serve our customers as a hybrid workforce. Our hybrid work model combines the convenience of remote work with access to our great office locations to collaborate in-person, participate in live trainings, and socialize with colleagues.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume