Constant contact

Enterprise Data Architect

Hybrid from Waltham, MA or Boston, MA or Remote,US Full Time

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 Enterprise Data Architect to help lead the design, implementation, and evolution of our global data platform. As a SaaS company providing digital marketing solutions to small businesses worldwide, we are scaling our platform to support AI, machine learning, in-app analytics, and real-time data products.

This role is both strategic and hands-on: you will define the standards, blueprints, and governance models for our enterprise data architecture while also contributing directly to development, schema design, and infrastructure optimization. You will play a key role in data architecture implementation across domains and will partner with engineering, product, data science, and AI teams to ensure our data platform enables innovation, compliance, and scalability. This role ensures that all data-related systems, initiatives, and assets are integrated and aligned with the company's business goals, regulatory requirements, and long-term vision. 

The Enterprise Data Architect will report to the Senior Director of Enterprise Data Platform and work closely with data engineers, ML engineers, software engineers, and data governance leads.

What You'll Do:

Architect & Implement Data Mesh or Medallion Architecture

  • Define and roll out domain-driven data product architecture across the enterprise.
  • Establish standards for data contracts, schemas, SLAs, lineage, and discoverability (with DataHub).
  • Records detailed logical and physical data models in the information repository and coordinates the publication and maintenance of these models.

Strategic Data Platform Design

  • Define the overall vision, strategy, and roadmap for the organization's data architecture, aligning it with enterprise business objectives.
  • Develop and maintain the enterprise data architecture roadmap across AWS, Snowflake, and hybrid systems.
  • Design scalable solutions for real-time analytics, in-app data products, and AI/ML pipelines.
  • Design and maintain the blueprint for the entire data ecosystem, which includes conceptual, logical, and physical data models for various systems and domains.
  • Assess and recommend the data technologies, platforms, and tools—including cloud solutions (AWS, Azure, GCP), databases (SQL and NoSQL), and analytics platforms—that best meet the organization's needs. 

Hands-On Engineering

  • Write and optimize scripts, build scalable data pipelines, and design schemas in Snowflake and Iceberg/S3.
  • Optimize data infrastructure performance and cost (Athena, Trino, DuckDB, Cube.dev, Superset, Tableau)

Data Governance, Compliance & Security

  • Collaboration with data governance leads to enforcing policies on PII, GDPR, CCPA, and international data residency.
  • Implement standards for encryption, row/column masking, lineage tracking, and auditability.
  • Ensure compliance is embedded into architectural patterns (AWS Lake Formation, IAM, Glue Catalog, etc.).

Blueprints & Standards

  • Create reusable architecture patterns and design templates for ingestion, transformation, serving, and quality.
  • Work with engineering teams to enforce consistency in tools, pipelines, and naming conventions.

Collaboration & Influence

  • Partner with domain teams (Marketing, Finance, Product, Deliverability, etc.) to ensure domain ownership of data products.
  • Work closely with ML/AI teams to enable model training, feature store integration, and real-time inference pipelines.
  • Provide architectural leadership across global teams and mentor engineers on best practices.

Who You Are:

  • Experience: 12+ years in data architecture, data engineering, or related fields; with at least 5+ years in an architect-level role.
  • Tech Expertise:
    • Strong hands-on SQL, Python, or other data centric programming language.
    • Deep experience with AWS data stack (S3, Glue, Athena, Lake Formation, Kinesis/MSK, EMR/Trino, IAM).
    • Experience with Snowflake, with an understanding of migration paths to AWS-native.
    • Knowledge of open table formats (Iceberg preferred, Delta Lake/Hudi).
    • Familiarity with semantic layers (Cube.dev, dbt metrics, LookML, Superset).
  • Architecture & Governance:
    • Strong understanding of data mesh principles and domain-driven data ownership.
    • Data governance, compliance, and security knowledge (GDPR, CCPA, SOX).
  • Tools & Platforms: Experience with DataHub (catalog/lineage), dbt, Tableau; Superset a plus.
  • Mindset: Strategic thinker who can also roll up sleeves to write SQL, debug pipelines, and build POCs.
  • Collaboration: Proven track record working across engineering, product, and data science teams in a global environment.

Preferred Qualifications:

  • Experience with machine learning data pipelines (feature stores, model serving).
  • Knowledge of real-time streaming architectures (Kafka/MSK, Kinesis, Flink).
  • Prior experience in SaaS or marketing technology industries.
  • Hands-on experience with data observability frameworks (Great Expectations, Monte Carlo, OpenLineage).
  • Cloud certifications (AWS Solutions Architect, AWS Data Analytics Specialty) a plus.

Success in This Role Looks Like:

  • Within 3 months: Establish a clear data architecture blueprint and start onboarding first domain data products.
  • Within 6 months: Build and document enterprise-wide standards for ingestion, transformation, governance, and serving.
  • Within 12 months: Deliver consistent semantic metrics (via Cube.dev or similar), enable AI/ML data pipelines, and scale the platform to support global growth.

#LI-HK1 #LI-Remote

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
$155,000$194,000 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 talentacquisition@constantcontact.com.

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.

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.