Analytics Developer

The Harris Center for Mental Health and IDD is hiring an Analytics Developer to join our IT team. The Analytics Developer designs, builds, and maintains the data solutions that power reporting and decision making across the Harris Center. This is a technical development role with primary responsibility for SQL based data interaction and pipeline work, data modeling for BI consumption, DAX development in Power BI, Microsoft Fabric Implementation support, and data visualization. The Analytics Developer applies technical knowledge to assigned analytics projects, collaborates with the data and analytics team on implementation, and contributes to the quality and accuracy of reporting solutions across the organization.

Your role in Action

• Write, optimize, and maintain T-SQL queries to extract, transform, and aggregate data from agency database solutions, including Epic Caboodle/Clarity tables, Microsoft Fabric lake houses, and SQL-based data stores. 
• Design and develop Power BI reports and dashboards, including semantic data models (star schema), DAX measures and calculated columns, row-level security (RLS) configurations, and Power Query (M)transformations.
• Support Microsoft Fabric implementation efforts including lake house data ingestion, SQL analytics endpoint validation, dataflow development, and migration of existing data assets to the Fabric environment.
• Design and maintain data models that support reporting accuracy and reuse, including documentation of table grain, column definitions, metric logic, and known data limitations.
• Engage in data wrangling over structured and semi-structured sources; investigate data quality issues, validate outputs against source systems, and document findings for resolution.
• Participate in analytics development projects across the full project lifecycle, including requirements gathering, technical implementation, testing, and documentation, under the direction of the Principal Data Scientist.
• Provide technical data support to non-technical users and clinical/operational stakeholders; translate complex data questions into clear, accurate, and appropriately scoped analytical responses.
• Audit reports, data pipelines, and analytical solutions for inconsistencies, errors, and performance issues; monitor data trends in ongoing reports and escalate anomalies with documented findings.
• Comply with all Agency policies and procedures, including those governing security, HIPAA data confidentiality, and the appropriate handling of behavioral health and IDD information.

What qualifications you will need:

Education:

• Bachelor’s degree (B.A.) or equivalent.

Experience:

• At least 2 years of experience in analytics development, business intelligence, or data engineering — including hands-on work with SQL, data modeling, and BI platform development required. Experience with Power BI preferred.

About us:

The Harris Center is the state-designated Local Mental Health Authority and Local Intellectual and Developmental Disability (IDD) Authority serving Harris County, Texas.  As the largest behavioral and developmental disability care center in Texas, The Harris Center provides care to over 90,000 people and has an annual budget of over $300 million.

As part of its mission to transform the lives of people with behavioral health and IDD needs in the third largest county in the United States, The Harris Center provides a full continuum of services at 80 different sites across Harris County. In addition, services are provided in more than 40 different languages as well as sign language in order to better serve what is one of the largest communities in the nation.

By utilizing the unique expertise of its more than 2,500 employees, The Harris Center is committed to meeting the behavioral health and IDD needs of Harris County residents and giving them hope to live to their fullest potential.

What else you should know:

• This posting is associated with position number 1151.

What we have to offer:

The Harris Center not only offers a competitive salary but also a suite of excellent benefits designed to enrich your life both professionally and personally. Imagine a future with a robust retirement plan complemented by our generous company matching – a testament to our investment in your long-term financial well-being. Experience the unique advantage of our prior service credit, accelerating your journey towards a more substantial Paid Time Off accrual, empowering you to enjoy well-deserved breaks.

Enjoy Cell Phone Discounts, exclusive entertainment deals through Tickets at Work, and a free Headspace subscription for mental wellness. Additionally, our Employee Assistance Program supports your overall well-being.

Take advantage of significant financial relief through student loan forgiveness as a valued member of The Harris Center team. As a qualifying entity, our employees are eligible for various student loan forgiveness programs, designed to alleviate the financial burdens associated with higher education.

Contributes to suicide care and prevention by embracing our values and applying a trauma-informed approach rooted in safety, trust, choice, collaboration, and empowerment.