Data Architect

Ranked one of Tennessee’s top places to work, MHC is a rare and special place where outstanding company culture is intentional. Where clients and associates are treated the same, as equals. Mental Health Cooperative, Inc. (MHC) was formed in 1993 to serve individuals with severe and persistent mental illness. Since then, we have expanded our services to children and adolescents with severe emotional disorders across Middle and East Tennessee. Our sole purpose is to support and treat those challenged with serious mental illness and poverty. Although based out of Nashville, we serve several communities across middle and East Tennessee with satellite offices in Antioch, Gallatin, Dickson, Columbia, Cleveland, Murfreesboro, Clarksville, Cookeville, Chattanooga, and Memphis. If you are interested in joining a team that is caring, collaborative, innovative and energizing this might be a great place for you! Job Title: Data Architect (Nashville, TN) Schedule: Monday - Friday 8:00am - 4:30pm Position Location: Nashville, TN 10% onsite work 90% remote Key Responsibilities Data Architecture & Integration: Design and maintain data models, transformations, and system integrations across internal and external data sources, ensuring adherence to data standards and best practices Data Warehouse & Reporting: Develop and support data warehouse structures, ETL processes, and reporting solutions (e.g., Power BI, SSRS) with a focus on performance, accuracy, and alignment with business definitions Data Governance & Documentation: Maintain documentation for data models, ETL processes, and reporting logic; support standardized definitions, data lineage, and consistent reporting practices Operational Support: Monitor and troubleshoot ETL jobs, reporting processes, and database performance; resolve data issues and support critical operational and compliance reporting Integrations & Interoperability: Support internal and external data exchanges, including APIs and industry standards (e.g., HL7, FHIR), and assist with implementation and validation of new data interfaces Business Collaboration: Partner with stakeholders to translate business needs into technical solutions and support clinical, financial, and operational reporting initiatives Compliance & Data Quality: Ensure adherence to HIPAA, data security standards, and regulatory requirements while supporting data validation and accuracy across deliverables Process Improvement: Identify and implement improvements to data quality, ETL performance, and reporting efficiency, including automation and standardization initiatives Qualifications & Expectations Strong proficiency in SQL, data modeling, and ETL development Working knowledge of healthcare data domains (clinical, billing, financial) Understanding of enterprise data architecture and governance principles Ability to manage priorities across development, production support, and project work Essential Requirements Bachelor's Degree Acceptable Criminal Background Investigation Benefits Medical Insurance/Prescription Drug Coverage Health Savings Account Dental Insurance Vision Insurance Basic Life and AD&D Insurance Short- & Long-Term Disability Supplemental Life Insurance Cancer Insurance Accident Insurance Critical Illness Insurance 403b - Retirement Plan Calm App for medication and mental health Gym membership discounts Mental Health Cooperative embraces inclusion, diversity and equal opportunity. We're committed to building a team that represents a variety of backgrounds, perspectives, and skills. Mental Health Cooperative is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status.\ MHC was founded in Nashville, Tennessee, in response to the need for assertive community-based treatment for individuals who have required frequent inpatient psychiatric hospitalization. Since 1993, MHC has been passionately helping adults with severe mental illness to live quality lives in the community with our state-of-the-art treatment and support. In 1999, MHC recognized the need to support the whole family and expanded services to include children and youth. We established our non-profit agency by merging three community organizations: Urban Case Management of Meharry Community Health Center, Continuous Treatment Team of Council of Community Services, and Mobile Crisis Team of the Crisis Intervention Center. This fusion resulted in an innovative, comprehensive, and multidisciplinary approach that addresses the specialized needs of individuals living with severe behavioral health conditions and challenges related to poverty. MHC remains the only organization in the state focused solely on this population. To learn more, visit our website: #J-18808-Ljbffr