BI Developer (Nashville, TN)

MHC Mental Health Cooperative, Inc.; Nashville (TN); Hybrid; USD 80,000 - 110,000; Full time

Benefits offered by this job

Medical Insurance

Health Savings Account

Dental Insurance

Vision Insurance

Life Insurance

Disability Insurance

401k Retirement Plan

Calm App for mental health

Gym membership discounts

Pet Insurance

Job summary

Mental Health Cooperative, Inc. is seeking a Business Intelligence Developer in Nashville, TN. The role focuses on reporting, analytics, and solution development for operational, clinical, financial, and executive stakeholders. 90% remote with 10% on-site work.

You will build Power BI reports, SSRS reports, paginated reporting, and maintain SQL queries and data integrations across enterprise systems. A Bachelor’s degree and 3+ years of SQL-based analytics are required.

Qualifications

• Bachelor's degree or equivalent in a relevant field.
• 3+ years of experience developing SQL-based reporting and analytics solutions.
• 2+ years building reports/dashboards with Power BI and/or SSRS.
• Experience translating business needs into reporting solutions and working with stakeholders.
• Experience validating and troubleshooting data across systems.

Responsibilities

• Partner with stakeholders to document reporting requirements.
• Design and maintain enterprise reports, dashboards, KPIs, and analytics tools.
• Build Power BI reports, interactive dashboards, SSRS reports, and paginated reports.
• Develop and optimize SQL queries, views, and stored procedures.
• Support data warehouse enhancements and improve usability and performance.

Skills

Analytical thinking

Problem solving

Attention to detail

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Intelligence, Healthcare Informatics, or a related field

Tools

Microsoft SQL Server

Power BI

SSRS

Job description

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:

Business Intelligence Developer

Schedule:

Monday - Friday 8:00am - 4:30pm

Position Location:

Nashville, TN 10% onsite work 90% remote

Essential Duties and Responsibilities:

• Reporting, Analytics, and Solution Development Partner with operational, clinical, financial, and executive stakeholders to gather, clarify, and document reporting requirements.
• Design, develop, test, and maintain enterprise reports, dashboards, KPIs, and analytical tools that support business decision-making.
• Build and support Power BI reports, interactive dashboards, SSRS reports, and paginated reporting solutions.
• Develop, tune, and maintain SQL queries, views, stored procedures, and related database objects used for reporting and analytics.
• Assist with enhancements to enterprise data warehouse and reporting environments to improve usability, performance, and scalability.

Data Quality, Governance, and Documentation:

• Analyze source systems and business processes to identify data relationships, reporting needs, and opportunities for improvement.
• Support integration of reporting data from third-party applications and internal business systems.
• Perform data validation, reconciliation, and quality assurance testing to confirm accuracy, completeness, and consistency.
• Troubleshoot reporting issues and identify root causes related to source systems, ETL processes, data quality, or reporting logic.
• Maintain clear documentation, including business requirements, report specifications, data definitions, and technical notes.
• Participate in data governance initiatives and follow organizational standards for data security, quality, and management.

Stakeholder Support and Communication:

• Present reporting solutions, findings, and recommendations clearly to end users, business partners, and leadership teams.
• Coordinate user acceptance testing, gather feedback, and obtain stakeholder approval before production deployment.
• Serve as a trusted resource for business units on reporting capabilities, metric definitions, and data interpretation.
• Provide end-user support, guidance, and training for reporting and analytics platforms.

Technical Operations and Continuous Improvement:

• Follow established change management, version control, testing, and deployment procedures.
• Monitor report and dashboard performance, and recommend improvements that increase reliability, scalability, and maintainability.
• Stay current on reporting, analytics, and data platform technologies, and recommend practical opportunities for organizational improvement.
• Manage multiple concurrent projects, priorities, and support requests while meeting established deadlines.

Required Qualifications:

Education Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Intelligence, Healthcare Informatics, or a related field. Equivalent combination of education, training, and relevant experience may be considered.

Experience:

• Three or more years of experience developing SQL-based reporting and analytics solutions.
• Two or more years of experience building reports, dashboards, or paginated reports using Microsoft Power BI and/or SSRS.
• Proven ability to write, optimize, and maintain complex SQL queries, views, stored procedures, and related database objects.
• Experience gathering requirements, translating business needs into reporting solutions, and working directly with stakeholders.
• Experience validating, reconciling, and troubleshooting data across multiple systems or reporting environments.

Technical Skills Required:

• Microsoft SQL Server and T-SQL development
• Power BI report and dashboard development
• SQL Server Reporting Services (SSRS)
• Data analysis, validation, reconciliation, and troubleshooting
• Microsoft Office Suite, including Excel and related productivity tools

Preferred Technical Skills:

• Data warehousing concepts, dimensional modeling, or enterprise reporting architecture
• Power BI Report Server or on-premises Power BI reporting environments
• DAX, semantic modeling, or advanced Power BI calculations
• ETL concepts, data integration processes, or related workflow tools
• Healthcare information systems such as eClinicalWorks, Workday, or similar platforms
• Source control or work management platforms such as Git, Azure DevOps, or similar tools

Competencies:

• Analytical Thinking
• Problem Solving
• Attention to Detail
• Customer Service Orientation
• Written and Verbal Communication
• Time Management
• Collaboration and Teamwork
• Adaptability
• Accountability
• Continuous Learning

Compliance and Other Responsibilities:

• Attend all mandatory training, in-services, continuing education, and annual health requirements.
• Maintain compliance with all Corporate Compliance policies and procedures.
• Maintain compliance with HIPAA, HITECH, and organizational information security requirements.
• Adhere to OSHA and workplace safety requirements.
• Protect the confidentiality, integrity, and availability of organizational and consumer information.
• Participate in departmental and organizational initiatives and continuous improvement efforts.
• Perform other duties as assigned.

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
• Pet Insurance

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: https://www.mhc-tn.org/about-us/