Business Intelligence Analyst

Christian Family Care Agency•Phoenix, AZ

3d•Onsite

About The Position

At Christian Family Care, data isn’t just numbers—it’s a powerful tool that helps us serve children, families, and communities with excellence and compassion. We’re seeking a Business Intelligence Analyst who thrives at the intersection of data engineering, analytics, and storytelling, and who is excited to use their skills to support a Christ-centered mission. If you love building elegant dashboards, optimizing complex SQL, and translating raw data into executive-level insights—and you want your work to truly matter—this role is for you.

Requirements

Bachelor’s degree in Business Analytics, Computer Science, IT, Statistics, or related field
2+ years of experience in BI, data analytics, or data engineering OR strong entry-level candidates with a solid technical portfolio (e.g., GitHub projects in SQL/Python)
Hands-on experience in Power BI or similar visualization tools
Advanced SQL development
Python for analytics and automation
Solid foundation in data visualization, dashboarding, and data modeling
Comfortable working with tools such as Google Analytics, Excel, and Git-based version control
Ability to simplify complex technical concepts for non-technical stakeholders
Ability to lead productive discussions
Ability to manage projects independently
Ability to think critically
Ability to solve problems creatively
Ability to continuously seek opportunities to learn and grow
Must be able to pass a 5-panel drug screen
Must be able to obtain an AZ fingerprint clearance card
Must be able to pass a DCS background check
Must be able to pass a TB test

Nice To Haves

Experience with ETL/ELT development preferred

Responsibilities

Design and build interactive, executive-ready dashboards using Power BI (or similar tools)
Partner closely with leaders and stakeholders to define KPIs and data requirements
Write and optimize complex SQL queries (CTEs, window functions, performance tuning)
Use Python for data transformation, analysis, and automated reporting
Perform data modeling and schema design to enable self-service analytics
Architect and maintain robust ETL/ELT pipelines supporting dashboards and reporting
Ensure reliability, scalability, and performance across SQL-based data environments
Serve as a technical SME for CRM and operational data systems
Document data dictionaries, data lineage, and ETL specifications