Business Intelligence Developer - Contractor

Collaborate with Health Connect America to support a company that delivers trauma-informed, family-centered

services that empower children and families to thrive.

Before partnering with Health Connect America, take some time to learn more about who we are.

At Health Connect America, all services are guided by a unified, trauma-informed approach. Across every program, we are committed to providing compassionate, client-centered care that fosters healing and growth.

Health Connect America and its family of brands provide behavioral health and therapeutic foster care services to children and families. We collaborate with independent professionals who share our commitment to helping individuals and families reach their full potential.

Our services are delivered in homes, communities, and office settings — always centered on dignity, trust, and empowerment. We are honored to partner with the families we serve as they work toward self-improvement and more fulfilling lives.

This Business Intellegence Developer contract opportunitywill design, develop, and maintain business intelligence and reporting solutions that support operational, financial, and executive decision-making, with a primary focus on converting Excel-based reporting into scalable Power BI dashboards and reports. Services will also include data modeling, ETL and SQL development, as well as the development and maintenance of custom SQL-based reports for the organization’s EHR and client databases, including CareLogic.

• Design and develop interactive Power BI dashboards, reports, datasets, semantic models, KPIs, and visualizations to support executive, operational, financial, and program-level decision-making.

• Transform and integrate data from multiple sources using Alteryx, Power Query, DAX, and other ETL processes while maintaining scalable data models and data quality standards.

• Develop and maintain custom SQL-based reports and data extracts from the organization’s EHR and client databases to support operational and clinical reporting needs.

• Translate business requirements into effective reporting solutions, troubleshoot data and performance issues, and ensure accuracy, consistency, usability, and governance across reporting platforms.

• Identify opportunities to improve reporting processes and automation while supporting testing, deployment, documentation, training, and ongoing reporting enhancements.

• Two or more years of experience developing reports and dashboards in Power BI.
• Strong knowledge of Power Query, DAX, data modeling, and visualization best practices.
• Experience writing SQL queries and working with relational databases.

• Hands-on experience with Alteryx Designer.
• Experience reporting from electronic health record (EHR) or client database systems; familiarity with CareLogic is preferred.
• Experience developing healthcare, behavioral health, or clinical reporting solutions.
• Knowledge of data warehousing concepts and dimensional data modeling.
• Experience working with large datasets and enterprise reporting environments.
• Bachelor's degree in Information Systems, Data Analytics, Computer Science, Business Analytics, or a related field, or equivalent practical experience.