Business Intelligence Analyst

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.

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.

• 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., Git Hub 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.