Senior Data Analyst (Snowflake & Enterprise Analytics)

Engagement Type: Independent Contractor (Full-Time Equivalent)

Reports To: Lead Data Scientist

About OCD Anxiety Centers

OCD Anxiety Centers is a specialized mental health organization providing evidence-based treatment for OCD, anxiety, and related disorders. Our mission is to deliver high-quality, compassionate care while continuously improving how we operate, measure outcomes, and make data-informed decisions.

As we continue to scale, we are investing in enterprise analytics and modern data infrastructure to support leadership, clinical operations, HR, and finance.

Role Overview

We are seeking a highly skilled Senior Data Analyst with deep experience in Snowflake and enterprise analytics to support system implementations, scalable reporting, and decision-making across the organization.

This role is designed for a senior individual contributor who can own analytics initiatives end-to-endfrom understanding business questions to designing data models, building dashboards, and translating data into clear insights for leadership.

Phase 1 Focus

The initial phase of this role will support the implementation of a new HR and Payroll platform (Rippling), ensuring accurate data integration, validation, and reporting within Snowflake.

Phase 2 Focus

Following implementation, the role will expand into broader enterprise and departmental analytics, supporting operations, finance, and executive leadership.

What Success Looks Like

Phase 1: Systems Implementation & Data Integration

- Lead analytics work related to integrating HR and payroll data into the Snowflake data warehouse

- Ensure data accuracy, consistency, and validation across source systems and Snowflake

- Design, build, and deliver required dashboards and reports by system go-live

- Define and document data models, metrics, and reporting logic

- Respond to analytics and reporting requests within three business days

- Create clear documentation and SOPs to support long-term scalability

Phase 2: Enterprise & Departmental Analytics

- Partner with department leaders to define meaningful business questions and success metrics

- Design, build, and maintain Snowflake-based data models supporting KPIs and decision-making

- Develop executive-ready dashboards using Power BI, Tableau, Looker Studio, or similar BI tools

- Provide insights that support strategic planning and operational improvement

- Continuously improve data reliability, usability, and reporting efficiency

Key Responsibilities

- Design, extend, and maintain scalable data models in Snowflake

- Write and optimize complex SQL queries for analytics and reporting

- Build and maintain dashboards and recurring reports for leadership and departments

- Validate data accuracy and investigate discrepancies across systems

- Translate technical data into clear, actionable insights for non-technical stakeholders

- Document analytics processes, data definitions, and reporting standards

- Collaborate closely with the Lead Data Scientist and cross-functional teams

- Support ad-hoc analytics requests while balancing long-term priorities

Qualifications & Requirements:

Required

- 5+ years of experience as a Data Analyst or Senior Data Analyst

- Strong hands-on experience with Snowflake as a data warehouse

- Advanced SQL skills and experience with data modeling

- Experience integrating data from HR, Payroll, Finance, or enterprise systems

- Experience building dashboards using Power BI, Tableau, Looker Studio, or similar tools

- Proven ability to turn data into insights for business and leadership teams

- Strong documentation and communication skills

- Ability to work independently and manage multiple priorities

Preferred

- Experience with Rippling, Paylocity, Workday, or other HRIS/Payroll platforms

- Experience supporting system implementations or data migrations

- Background in healthcare, behavioral health, or multi-location organizations

- Familiarity with analytics engineering tools (e.g., dbt, Python)

- Experience working remotely with U.S.-based teams

Work Arrangement

- Full-time equivalent (40 hours/week) independent contractor role

- Remote

- Collaboration with U.S.-based leadership and stakeholders

- Must have a reliable internet connection and professional work setup