Senior Integration Analyst

BEHAVIORAL HEALTH PRACTICE SERVICES LLC.; United States; Remote; USD 120,000 - 147,000; Full time

Benefits offered by this job

Medical

Dental

Vision

AD&D

Disability insurance

Life insurance

401k match

Parental leave

PTO

Holiday pay

EAP

Job summary

LifeStance Health is seeking a Senior Data Integration Analyst to lead enterprise data integration and governance across the Enterprise Data Platform. You will drive source-to-target mappings, data transformations, and data quality initiatives, ensuring trusted, scalable data products.

Ideal candidates have 8+ years in data analysis, healthcare data experience, and strong SQL skills, with HIPAA knowledge and US work authorization.

Qualifications

• Bachelor's degree in CIS / MIS / CS / Data Analytics or related field.
• 8+ years of data analysis experience, 3 years in healthcare data.
• Working knowledge of healthcare data structures and workflows.
• Proficient SQL; ability to query Snowflake for data issues.
• Experience with HIPAA privacy and security requirements.
• Authorized to work legally in the United States.

Responsibilities

• Lead enterprise data analysis initiatives across multiple source systems.
• Define source-to-target mappings and transformation requirements.
• Govern data quality standards and data lineage for the Silver Medallion layer.
• Own metadata and governance assets in Snowflake Horizon Catalog.
• Collaborate with Data Engineering and DataOps for remediation.

Skills

SQL

Data analysis

Data governance

Healthcare data

Snowflake

Stakeholder communication

Education

Bachelor's degree in Computer Information Systems / MIS / CS / Data Analytics

Tools

Snowflake Horizon Catalog

Salesforce

Workday

AthenaOne

Job description

At LifeStance Health, we strive to help individuals, families, and communities with their mental health needs. Everywhere. Every day. It’s a lofty goal; we know. But we make it happen with the best team in mental healthcare. Thank you for taking the time to explore a career with us. As the fastest growing mental health practice group in the country, now is the perfect time to join our team! LifeStance Health Values Belonging: We cultivate a space where everyone can show up as their authentic self. Empathy: We seek out diverse perspectives and listen to learn without judgment. Courage: We are all accountable for doing the right thing - even when it's hard - because we know it's worth it. One Team: We realize our full potential when we work together towards our shared purpose.

Benefits

• medical
• dental
• vision
• AD&D
• short and long-term disability
• life insurance
• 401k retirement savings with employer match
• paid parental leave
• paid time off
• holiday pay
• Employee Assistance Program

Role Overview

The Sr. Data Integration Analyst serves as the authoritative leader for data integration and standardization across the Enterprise Data Platform, driving enterprise-wide consistency, governance, and adoption of data integration best practices. This role independently leads data integration analysis initiatives by defining source-to-target mapping strategies, establishing complex data transformation requirements, and providing architectural direction for the implementation of Silver Medallion layer design principles. Acting as a trusted advisor to both business and technical stakeholders, the analyst ensures the delivery of trusted, scalable, and business-ready data products aligned with enterprise objectives. The role also maintains ownership of business glossary terms for all data domains in Silver Medallion layer, data quality standards, data lineage context, stewardship processes, and associated governance artifacts within Snowflake Horizon Catalog, ensuring sustained data transparency, accountability, and operational excellence.

Compensation

Compensation: $120,000 - $147,000/annually in addition to a competitive bonus plan

Key Responsibilities

Identity Resolution & Match Stewardship (approximately 60%)

• Lead enterprise data analysis initiatives across multiple source systems to proactively identify data quality risks, establish integration standards, and define source-to-target mapping strategies that enable trusted, standardized data domain assets across the Enterprise Data Platform.
• Provide independent leadership in the analysis and resolution of complex cross-system data relationships and grain challenges by documenting lineage, defining transformation requirements, conducting root cause assessments, and recommending strategic remediation approaches for Data Engineering implementation.
• Own the design, governance, and ongoing evolution of source-to-target mappings for Silver Medallion layer data domains, including NPI, taxonomy, licensure, credentialing status, payer enrollment, practice affiliation, and employment attributes across EHR/PM, Salesforce, Workday, and other approved enterprise source systems.
• Serve as the accountable steward for metadata and governance assets within Snowflake Horizon Catalog, establishing and maintaining business definitions, data lineage, source-to-target mappings, data quality standards, ownership assignments, and critical data element documentation to promote enterprise transparency, regulatory compliance, data discoverability, and trusted business-ready data products.

Data Quality, Issue Management & Silver Layer Validation (approximately 40%)

• Participate in establishment and governing business acceptance criteria for enterprise data products, ensuring alignment with data quality standards, governance policies, operational requirements, and strategic business objectives prior to production release.
• Lead the validation and certification of critical business identifiers and key data elements across Silver layer datasets, directing complex data analysis efforts, identifying integration risks and defects, and driving remediation strategies in partnership with Data Engineering and DataOps teams.
• Own the end-to-end governance process for Silver Medallion layer data domains, and reference data integration issues, providing intake leadership, prioritization oversight, impact assessment, remediation guidance, and resolution validation to ensure timely and effective issue management across the enterprise.
• Conduct enterprise-level trend analysis and root cause investigations to identify systemic data quality and integration challenges across registration, scheduling, provider onboarding, credentialing, HR, and other operational workflows; define corrective action requirements and influence long-term process and technology improvements.
• Serve as the authoritative owner of source-to-target mapping specifications, business transformation logic, and end-to-end data lineage documentation for Silver Medallion layer data domains, to include reference data domains, ensuring transparency, consistency, and traceability across enterprise data assets.
• Act as the primary escalation point and strategic liaison for identity, integration, and data quality incidents affecting analytics, operational, and business stakeholders; lead impact assessments, define remediation and testing requirements, and oversee the controlled promotion of solutions through established release and governance processes.

Requirements

• Bachelor's degree in Computer Information Systems, Management Information Systems, Computer Science, Data Analytics or a related field, or equivalent relevant experience.
• 8+ years of data analysis experience, 3 years in healthcare data analysis, health information management (HIM).
• Working knowledge of healthcare patients and provider data structures and workflows.
• Experience with AthenaOne is strongly preferred; familiarity with Salesforce provider credentialing and Workday as provider data sources is a plus.
• Proficient SQL skills and the ability to independently query Snowflake to investigate identity issues, validate global ID assignments, profile defects, and verify remediation.
• Experience defining data quality rules, managing issue backlogs, performing root-cause analysis, and communicating trends and business impact to technical and non-technical stakeholders.
• Understanding of HIPAA privacy and security requirements as applied to identity data, access, auditability, and merge/unmerge operations.
• Demonstrated ability to document standards, facilitate cross-functional decisions, train operational users, and communicate data quality findings to non-technical leaders.
• Qualified candidates must be legally authorized to be employed in the United States.

LifeStance is an EEO/Affirmative Action Employer and does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability, or any other legally protected status.

Demonstrates awareness, inclusivity, sensitivity, humility, and experience in working with individuals from diverse ethnic backgrounds, socioeconomic statuses, sexual orientations, gender identities, and other various aspects of culture.

Preferred Skills and Knowledge

• Experience with Snowflake Horizon Catalog or another enterprise data catalog/governance platform, including business glossary, ownership, quality, and lineage documentation.
• Experience reading data models, interpreting automated test results, and working within medallion or layered data architectures.
• Experience in behavioral health, multi-site outpatient practice, or another complex healthcare delivery environment.
• Familiarity with referential, probabilistic, and deterministic matching methods and their operational tradeoffs.
• Experience producing stewardship scorecards and presenting data quality trends to governance or operational leadership.

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit, stand, bend, talk and hear. The employee is frequently required to walk. The employee must be able to lift and/or move objects up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and the ability to adjust focus.

LifeStance provides the compensation range and benefits that it in good faith believes it might pay and/or offer for this position. LifeStance reserves the right to ultimately pay more or less than the posted range and offer additional benefits and other compensation, depending on circumstances not related to an applicant’s sex or other status protected by local, state, or federal law.

#LI-Remote #LI-BA1

LifeStance is an equal opportunity employer. We celebrate diversity and are fully committed to creating an inclusive work environment for all our employees.

Learn more about Diversity, Equity and Inclusion at LifeStance.

LifeStance Health complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities.

If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact our Human Resources Team at [e-mail].

Please note: This contact is intended solely for accommodation requests. Inquiries regarding applications, resumes and applicant status should not be sent to this email address as they will not be reviewed or responded to.

At LifeStance Health, we know that mental health care jobs are more than careers, they are missions. When people choose careers in mental health, they do it because they care about their impact on the world. So do we. That’s why we’re assembling the very best team for both telehealth and in-person care.