Sr Data Architect

Goldfish Swim School; Troy (MI); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Health insurance

Paid time off

Vision insurance

401(k)

401(k) matching

Dental insurance

Job summary

Goldfish Swim School is seeking a Sr Data Architect to lead the hands-on ownership of systems, data flows, and vendor relationships. You will execute the data roadmap day-to-day and connect operations, marketing, and finance with executive leadership and a fractional CTO.

You will maintain reporting across Salesforce, iClassPro, and BigQuery/dbt, govern data dictionaries, and own integrations while ensuring data quality and security. Flexible work-from-home options are available.

Qualifications

• Six to ten years in business systems, marketing or analytics.
• Experience owning SaaS integrations.
• SQL skills in data warehouse environments (BigQuery/dbt preferred).
• Hands-on CRM experience, Salesforce preferred.
• Ability to create and review reports.
• Strong vendor-management and cross-functional communication.
• Security-conscious with customer data.

Responsibilities

• Maintain and expand reporting across Salesforce, iClassPro, and BigQuery/dbt.
• Maintain data dictionaries, logic, documentation, and data lineage; validate KPIs.
• Own day-to-day health and data flow of integrations (Salesforce, iClassPro, marketing data warehouse, GA4, call tracking).
• Coordinate with technology vendors; define data and integration requirements and report progress to leadership.
• Translate requirements into system updates, reports, or vendor tasks across teams.
• Protect customer and company data and support compliance requirements.

Skills

SQL knowledge

BigQuery/dbt

Salesforce CRM

Data reporting

Vendor management

Tools

Salesforce

GA4

GTM

Job description

Benefits:

• Health insurance
• Paid time off
• Vision insurance
• 401(k)
• 401(k) matching
• Dental insurance

Job Title:

Sr Data Architect

Reports To:

Chief Operating Officer

Job Summary:

The Sr Data Architect serves as the primary hands-on owner across systems, data flows, and technology vendors. Responsible for executing the business systems and data roadmap day-to-day, this role serves as the connective tissue among operations, marketing, and finance, working alongside executive leadership and a fractional CTO.

Duties and Responsibilities:

• Data, Reporting & Analytics: Maintain and expand reporting across Salesforce, iClassPro, and BigQuery/dbt. Support campaign attribution, lead quality, and key business metrics.
• Governance & Quality: Maintain data dictionaries, business logic, system documentation, and data lineage maps. Validate KPIs across source systems and manage cross-system changes safely.
• Systems Integration & Ownership: Own the day-to-day health and data flow of integrations connecting Salesforce, iClassPro, marketing data warehouse, GA4, and call tracking. Catch breaks early and resolve issues to prevent data quality degradation.
• Vendor Partnership: Act as the primary contact for technology vendors. Clearly define data and integration requirements, keep projects on track, and communicate progress to leadership.
• Cross-Functional Support: Translate operational, marketing, and financial requirements into system updates, reports, or vendor tasks. Partner across teams on attribution, franchisee-facing systems, and financial metrics.
• Security & Documentation: Maintain standard operating procedures, system inventories, and access records while protecting customer and operational data. Support regulatory consent and compliance requirements.

Requirements:

• Six to ten years of experience in business systems, marketing or revenue operations, data, or analytics.
• Experience owning integrations between SaaS platforms.
• Working SQL knowledge and comfort operating in a data warehouse environment. BigQuery and dbt experience is strongly preferred.
• Hands-on experience with a CRM, with Salesforce strongly preferred.
• Ability to build, review, and validate reports.
• Strong vendor-management and coordination instincts.
• Ability to communicate effectively with both technical and non-technical stakeholders across operations, marketing, and finance.
• Strong documentation discipline.
• A security-conscious mindset when working with customer and company data.

Desired Skills and Abilities:

• Experience in a franchise, multi-unit, or multi-location business.
• Familiarity with marketing analytics platforms such as GA4 and GTM.
• Experience with call tracking and marketing automation platforms, including Act-On or similar tools.
• Experience working alongside a fractional or part-time technical leader.

Desired Skills and Abilities:

• Experience in a franchise, multi-unit, or multi-location business.
• Familiarity with marketing analytics platforms such as GA4 and GTM.
• Experience with call tracking and marketing automation platforms, including Act-On or similar tools.
• Experience working alongside a fractional or part-time technical leader.

Flexible work from home options available.