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
