Constant Contact Logo

Constant Contact

Analytics Engineer

Reposted 20 Days Ago
In-Office
Waltham, MA, USA
85K-102K Annually
Junior
In-Office
Waltham, MA, USA
85K-102K Annually
Junior
Design, build, and maintain scalable ELT pipelines and analytical data models. Ensure data quality, validation, and documentation. Collaborate with analysts, data scientists, and engineers to deliver reliable datasets and tooling for reporting and decision-making. Monitor, troubleshoot, and enforce data governance and security; finance domain experience is a plus.
The summary above was generated by AI

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 is a flexible hybrid role from our headquarters in Waltham, MA.  As part of the interview process, there will be an onsite interview in Waltham, MA. 

What you'll do:

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

Who you are:

  • 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., Apache Airflow, dbt, Fivetran).DBT - Preferred.
  • Proficiency in programming languages such as Python or R.
  • 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) is a plus.
  • Strong problem-solving skills and attention to detail.
  • Excellent communication and collaboration skills.

Bonus points:

  • 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.

The specific salary offered to a candidate may be influenced by a variety of factors including the candidate’s experience, their education and work location. In addition, some roles may be eligible for additional on target commission pay or bonus. The compensation package includes health and welfare benefits including paid leave.

Pay Transparency - All Full Time Employees
$84,800$101,760 USD

Why You’ll Love Us:

  • 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.

Application Deadline: 30 days. We may fill this job opening prior to the deadline if a candidate is selected by us.

Vision6 Pty Limited is an affiliate of Constant Contact, Inc. and a part of the Constant Contact group of brands.

Constant Contact is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, gender, gender identity, national origin, citizenship, age, disability, sexual orientation, genetic information, veteran status or any other status protected under applicable law. If you require accessibility assistance applying for open positions, please contact [email protected].

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

At Constant Contact, we respect personnel privacy and are committed to protecting the personal information we obtain and maintain from both current, former, and prospective employees. We maintain this Personnel Global Privacy Notice (this “Notice”) in compliance with applicable privacy laws, including the California Consumer Privacy Act (the “CCPA”) and the UK General Data Protection Regulation (collectively, the “Data Protection Laws”). Click here for a full copy of our General Personnel Privacy Notice.

Notice to Recruiters and Staffing Agencies:

Constant Contact has an internal talent acquisition department and designated career site for individuals looking to join our team. Constant Contact will not accept unsolicited resumes from any external recruiters, staffing firms, search agencies or any fee-based referrals. Any unsolicited resumes sent to directly to Constant Contact, in any capacity will be considered property of Constant Contact. Constant Contact will not pay a fee for any placement resulting from the receipt of an unsolicited resume.

HQ

Constant Contact Waltham, Massachusetts, USA Office

890 Winter Street, Suite 300, Waltham, MA, United States, 02451

Constant Contact Boston, Massachusetts, USA Office

40 Water Street, Boston, MA, United States, 02109

Similar Jobs

12 Days Ago
In-Office or Remote
United States
150K-300K Annually
Senior level
150K-300K Annually
Senior level
Healthtech • Social Impact • Telehealth
Build Sailor Health’s foundational data platform from scratch. Responsibilities include developing Snowflake and dbt pipelines integrating EHR, CRM, and communications data; creating data-powered web applications; automating clinical and billing workflows with Python; analyzing therapy transcripts and patient data using AI and machine learning; tracking clinical outcomes; and designing scalable data architectures in collaboration with clinicians, engineers, founders, and other teams.
Top Skills: DbtFhirGraphQLPythonRest ApisSnowflakeSQL
One Month Ago
In-Office
Boston, MA, USA
175K-190K Annually
Senior level
175K-190K Annually
Senior level
Artificial Intelligence
Own and govern centralized data assets; design scalable dbt/Snowflake models; model Stripe subscription and payments data; set SQL standards, testing, monitoring and documentation; lead complex BI projects in Hex; partner with product, engineering, operations and GTM to deliver durable analytics solutions.
Top Skills: DbtDialpadFivetranHeapHexHubspotPythonSalesloftSnowflakeSnowparkSQLStripeTwilio
6 Days Ago
Hybrid
Boston, MA, USA
Mid level
Mid level
Artificial Intelligence • Information Technology • Software
Build and operate the Scaled Success team’s data and automation platform. Responsibilities include scheduled data pipelines, account health scoring, real-time risk triage, campaign audience synchronization, reporting views, internal tools, and production AI workflows for classification, extraction, and drafting. The role requires validating data, deploying services, supporting automated campaigns, and operating reliable systems used by customer success teams.
Top Skills: Ai ModelsCrm SystemsCustomer Success PlatformsData WarehousesDbtMarketing Automation SystemsPythonReal-Time ServicesScheduled PipelinesSQLSupport SystemsWebhooks

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account