Business Intelligence Analyst

Christian Family Care is seeking a Business Intelligence Analyst to turn organizational data into insights that support its services for children, families, and communities. The role builds dashboards and data pipelines, develops analytics and SQL solutions, and supports data governance while partnering with leaders and stakeholders.

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

Preferred

Experience with ETL/ELT development

ETL/ELT Development

Company

Arizona nonprofit providing adoption, foster care, and family counseling

Phoenix, Arizona, USA

https://cfcare.org/

Founded in 1982

51-200 employees

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)

Must be able to obtain an AZ fingerprint clearance card

Experience with ETL/ELT development

Required skills

SQL, Python, Power BI, ETL/ELT Development, Data Modeling, Data Visualization, Google Analytics, Microsoft Excel, Git

Preferred skills

Experience with ETL/ELT development, Phoenix, Arizona, USA, https://cfcare.org/, Growth Stage, Company data provided by, AI Tools, Customize Your Resume, Maximize your interview chances, Build Cover Letter, Make your application stand out, Analyze How Well You Fit, Understand your strength & weakness

Experience

2+ years