Business Intelligence Analyst
Role details
Job location
Tech stack
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