Business Intelligence Analyst

Christian Family Care Agency Inc
Phoenix, United States of America
5 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 62K

Job location

Phoenix, United States of America

Tech stack

Microsoft Excel
Data analysis
Information Engineering
Data Governance
ETL
Data Visualization
Database Development
Document-Oriented Databases
Github
Google Analytics
Python
Operational Data Store
Performance Tuning
Raw Data
Power BI
Software Systems
SQL Databases
Freeform SQL
GIT
Build Management
Information Technology
Data Lineage
Software Version Control
Data Pipelines

Job description

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

Data Pipeline Architecture & ETL/ELT

  • 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

Requirements

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., * 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

About the company

Ready to use your data skills for eternal impact? Apply today and help us turn information into insight-and insight into hope. Christian Family Care is a social services agency with 40 years of serving at-risk children. We have done this by acting with empathy and compassion, embracing diversity, and exemplifying Integrity.

Apply for this position