Business Intelligence Developer

About This Role

This role involves building and maintaining dashboards for financial and ministry analysis, developing and optimizing SQL queries, and integrating data across various platforms. The position suits a developer who can clean and organize databases, collaborate with teams to define data requirements, and provide technical support for ad hoc analysis requests.

Responsibilities

• Build and maintain dashboards for financial, expense, and ministry objective analysis
• Develop and optimize SQL queries and data models
• Integrate data across multiple software platforms
• Explore and support the setup of a scalable data warehouse solution
• Assist in setting business rules, parameters, and requirements for data and BI tools
• Clean and organize databases to ensure accuracy and usability
• Collaborate with Business Intelligence team to define data requirements
• Maintain documentation of data sources, definitions, and BI tools
• Collaborate with developers in other departments to effectively execute organization-wide needs
• Configure forecasting models for financial and operational planning
• Conduct financial, expense, and ministry objective analysis and identify trends to support planning efforts
• Provide technical support for ad hoc analysis requests
• Participate in discussions around data strategy and tool enhancements
• Maintain an ongoing curriculum of learning tasks including video courses, books, online courses, and other learning tools, and review learnings with appropriate team members
• Analyze donor patterns, segmentation, and retention
• Partner with Finance on reporting structures
• Build ETL pipelines for systems integration
• Expand data engineering across all ministries

Requirements

• Bachelor’s Degree in Computer Science or related field of study with 2+ years of experience
• Ability to quickly learn various software solutions
• Proficiency in SQL, including query writing and optimization
• Advanced skills in Tableau for dashboard creation and data visualization
• Strong proficiency in Microsoft Excel, including pivot tables and advanced formulas
• Familiarity with Microsoft SQL Server and database management
• Proficiency in the Microsoft 365 Suite (Word, PowerPoint, Teams)
• An acceptance of, and commitment to Jesus Christ as Savior and Lord
• An understanding of the mission and purpose of Victory Church
• Acceptance and agreement of Victory Church’s CHECK values and staff commitments

Nice to have:

• Experience with Lava (Liquid) templating language for dynamic content generation