Associate Director – Analytics and Data Products

Advocates for Human Potential, Inc.

. Own the build of curated datasets, transformation pipelines, semantic models, and reporting layers for enterprise reporting and client-facing data products .

Posted 10/13/2026full-timeRemote • United StatesSenior💰 $125,000 - $145,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and managing data transformation pipelines, semantic models, and reporting layers for enterprise analytics. Proficient in SQL, data visualization tools like Power BI or Domo, and cloud platforms such as Redshift and Databricks.

Highest-signal resume keywords

Advanced Degree In Quantitative FieldStrong SQLProduction Data Transformations (dbt)Power BI Or DomoExperience With Cloud Warehouse Platforms

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData TransformationsPower BIDomoRedshiftDatabricksRPythonStataSAS

Soft Skills

Client-Facing CredibilityLeadership

Tools & Technologies

Cloud WarehouseLakehouse PlatformsData OfficeAI Work

Industry Keywords

Behavioral HealthFederal Contract DataState Contract Data

Tech Stack

Tools & technologies

Amazon RedshiftCloudPythonSQL

About the role

Key responsibilities & impact

Own the build of curated datasets, transformation pipelines, semantic models, and reporting layers for enterprise reporting and client-facing data products
Deliver scoped engagements end to end
Define the decision a product has to support with the project director or executive sponsor
Manage build plans and keep delivery visible against them
Implement the enterprise reporting standard with one definition per metric, traceable from dashboard to source and validated in the pipeline
Set reporting standards with the Methods & Standards Lead
Run production refresh cycles, access, version control, and documentation
Transition consultant-built and legacy reports into maintained products
Build reusable dashboard and reporting templates and custom products where templates are insufficient
Coordinate data engineering work with Digital Solutions and analyst and BI resources assigned to Data Office work
Carry the Data Office’s build contributions to AI work led by Digital Solutions
Ensure AI-related requests move through the standard intake process

Requirements

What you’ll need

Advanced degree in a quantitative or technical field, or equivalent experience building and running analytics delivery
Strong SQL
Production data transformations (dbt or comparable)
Power BI or Domo at the semantic model and dataset level
Experience with cloud warehouse or lakehouse platforms, for example Redshift and Databricks
Track record delivering analytics that leaders and clients act on, under deadline and across stakeholders with different priorities
Analytic and methods fluency to implement a definition correctly and recognize an analysis that does not hold
At least one of R, Python, Stata, or SAS
Ability to lead technical work and set standards for staff who do not report to you
Client-facing credibility
Behavioral health, health, or federal and state contract data experience is a plus
Must be currently authorized to work in the United States on a full-time basis
Must reside in and carry out job responsibilities from a location within the U.S. or a U.S. territory for the duration of employment
Access to a reliable and secure internet connection that supports remote work responsibilities

Benefits

Comp & perks

Comprehensive medical, dental, and vision insurance for you and your family
Retirement plan with a 3% match
Student loan repayment assistance
Employer-paid life and disability insurance
Generous paid time off
Annual bonuses
Short- and long-term incentives
Program-specific awards
Remote work responsibilities supported by reliable and secure internet access
Reasonable accommodations for individuals with disabilities
Work-life balance, self-care, and mental and emotional health support