Business Intelligence Analyst

Christian Family Care; Phoenix (AZ); On-site; USD 36,000 - 41,000; Part time

Job summary

Christian Family Care is seeking a Business Intelligence Analyst to turn data into actionable insights for a Christ-centered mission. The role focuses on building executive-ready dashboards with Power BI, optimizing SQL, and applying Python for analytics and automation.

The candidate will partner with stakeholders to define KPIs, design robust data models, and maintain ETL/ELT pipelines, while communicating complex concepts clearly to non-technical teams.

Qualifications

• Bachelor's degree in analytics, CS, IT, statistics or related field is required.
• 2+ years in BI, data analytics or data engineering, or strong portfolio with SQL/Python.
• ETL/ELT development experience preferred.

Responsibilities

• Design and build interactive dashboards for executives using Power BI or equivalent.
• Partner with leaders to define KPIs and data requirements.
• Write and optimize complex SQL queries; use Python for data transformation and automation.
• Develop and maintain ETL/ELT pipelines for dashboards and reporting.
• Serve as a data SME for CRM and operational systems; document data dictionaries and lineage.

Skills

Power BI

SQL

Python

Data visualization

Data modeling

ETL/ELT

Education

Bachelor's degree in analytics

Job description

Career Opportunities with Christian Family Care Agency

30 hours/week, non-exempt
$26.00-$30.00 per hour DOE

Turn Data into Insight. Insight into Impact . 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.

What You’ll Do

Business Intelligence & Visualization

• 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

Advanced Analytics & SQL Development

• 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

Data Governance & System Expertise

• Serve as a technical SME for CRM and operational data systems
• Document data dictionaries, data lineage, and ETL specifications

The ideal candidate brings a strong blend of technical expertise and professional communication skills, with hands-on experience in Power BI or similar visualization tools, advanced SQL development, Python for analytics and automation, and a solid foundation in data visualization, dashboarding, and data modeling. You are comfortable working with tools such as Google Analytics, Excel, and Git-based version control, and you take pride in writing clean, reliable analytics code. Just as important, you are a clear and confident communicator who can simplify complex technical concepts for non-technical stakeholders, lead productive discussions, manage projects independently, think critically, solve problems creatively, and continuously seek opportunities to learn and grow.

Minimum Qualifications

• 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)
• Experience with ETL/ELT development preferred

Note, this position post is a summary of expected job functions and qualifications. A full job description will be provided during the recruiting process. Must be able to pass a 5-panel drug screen, obtain an AZ fingerprint clearance card, DCS background check and TB test.