Job Information
Focus on the Family Business Intelligence & Applications Manager in Colorado Springs, Colorado
Headquartered in Colorado Springs, Colorado, Focus on the Family has nearly 700 employees who work to achieve the mission of enriching the lives of families, engaging the culture, advocating for life and spreading the Gospel of Jesus Christ. The work is meaningful, the culture is rewarding, and the purpose is eternal.
The Business Intelligence & Applications Manager position exists to provide strategic leadership and oversight to executive and ministry reporting. This position oversees the development and execution of donor, ministry, operational and executive level reporting as well as predictive and prescriptive analysis. This position oversees the recommendation and implementation of reporting solutions in close partnership and collaboration with Data Warehouse and core system functions. In addition, this position must possess an understanding of financial systems and capabilities.
Essential Duties/Responsibilities:
Supervises, encourages, and motivates the Ministry Reporting Team toward excellence, timeliness, and accuracy
Directs day-to-day activities of work groups within areas of responsibility; establishes priorities and makes work assignments
Interfaces with mid-level, senior, and executive management to understand their strategic, ministry, business, and operational reporting needs; oversees the development of ministry and business reporting based on reporting needs
Interfaces with Data Warehouse Manager and Data Management Director to ensure that data requirements are delivered and that the on-prem and cloud data warehouses are updated with all data required for reporting solutions
Compiles and analyzes operational information from all components of the ministry and develops integrated analyses and reports using complex database, reporting and analytics applications
Develops reporting solutions using various reporting tools and database development techniques to join key data for integrated analyses and reporting of ministry data to all levels of the organizational leadership
Leads SQL report design, development, standardization, and implementation efforts as a reporting representative for multiple ministry departments
Automates existing reports by enhancing the reports with stored procedures for publication to existing web reporting catalogs and in-application reporting and analytics functionality such as Salesforce reporting and CRM Analytics
Participates in and coordinates the design and implementation of data collection, cleansing and analysis in partnership with the Director of Data Management and Business Intelligence
Develops and maintains automated reporting solutions that present the key business statistics and performance indicators of the ministry via a customer-intuitive and visually appealing web-based graphical user interface supported by SQL data sources
Develops frequent customized (ad hoc) analysis and reporting solutions as required by leadership; Evaluates which ad hoc reports would be good candidates for automation, and develops automated solutions
Ensures that analysis and reporting solutions meet client (business owner) and departmental design requirements
Monitors significant changes to key business statistics and performance indicators to demonstrate possible business trends
Performs data analysis functions across large data sets, encompassing multiple key measures and long-term trend analysis
Oversees handoff of newly developed reporting applications to other team members for ongoing support and maintenance
Maintains a positive relationship with customer areas and the greater Technology department, ensuring that customer needs are met and that technology policies are followed through mutually beneficial collaboration
Has a high understanding of CRM, ERP, Web, and Social Media data
Communicates with and trains other team members on data issues discovered as well as best department practices
Other Duties/Responsibilities:
Perform other duties as assigned
Managerial Breadth/Scope of Job:
Manages professional staff of employees at various levels
Is responsible for the performance and development of their staff along with hiring and review
Working Environment/Physical Requirements:
Office environment
Must be able to work at a computer workstation for multiple hours with infrequent interruption
JOB QUALIFICATIONS/REQUIREMENTS:
Character/Spiritual:
Exemplifies Ephesians 5:1-2, “Therefore be imitators of God as dear children and walk in love, as Christ also has loved us and given Himself for us...”
Pursues the Great Commission given by Jesus Christ in Matthew 28:19-20, “Go therefore and make disciples of all the nations, baptizing them in the name of the Father and of the Son and of the Holy Spirit, teaching them to observe all things that I have commanded you; and lo, I am with you always, even to the end of the age.”
Is a consistent witness for Jesus Christ; maintains a courteous, Christ-like attitude in dealing with people within and outside of Focus; adheres to the Standard of Moral Conduct (http://media.focusonthefamily.com/fotf/pdf/about-us/human-resources/moral-policy.pdf) and Statement of Faith (http://www.focusonthefamily.com/about/foundational-values#values) ; upholds Focus on the Family's ministry in prayer
Prays personally for Focus on the Family’s staff and constituents and may occasionally lead in a public prayer
Engages in Christian ministry
Demonstrates behaviors aligned with FOF core values (http://www.focusonthefamily.com/about/foundational-values#values)
Personal Characteristics:
Creative thinker, effective problem-solver
Self-Motivated; requires little direct supervision
Analytical, organized mindset
Team player; trustworthy; reliable
Dedicated to superior individual performance and team effectiveness
Coachable, able to redirect work priorities and assignments as requested
Knowledge/Experience:
Bachelor’s degree in computer science or information systems
7-10 years of prior work experience involving use of SQL programming, creation of stored procedures, data extraction, transformation, and presentation including hands-on work with SQL Server
7-10 years of experience with enterprise reporting applications
7-10 years of experience with relational database modeling, data warehouse building, and standardized information retrieval
Demonstrated experience in report development to meet customer information and business needs
Demonstrated mastery of SQL Server 2012+ and SQL Reporting Services, SSAS, SSIS experience a plus
Knowledge of web data presentation using data visualization tools required
Knowledge of Microsoft C#, SQL 2012+. Salesforce. Snowflake, and .NET 4.0 or greater preferred
Skills, Abilities, and Special Talents/Gifts:
Strong statistical background
Demonstrated competence in data management and design of multiple large projects
Demonstrated experience designing and developing solutions to meet client business/reporting needs
Attention to detail and accuracy
Excellent interpersonal and presentation skills
Customer-service mindset and professional demeanor
Proven ability to work effectively and productively with professional staff in other divisions
Expertise to handle multiple projects and adhere to strict deadlines and budgets
Exceptional analytical ability and logical thought process to deal with complex problems
Ability to meet short-term and long-term deadlines
Proficiency with SQL and/or SQL interface tools, cloud platforms and multiple reporting software applications
Ability to work independently and in a team setting
Demonstrated ability to work independently on technical and highly complex analytical studies
Salary Range: $97,760 to $114,920/Yr.
Application Materials Required: Cover Letter, Resume/CV
Application Materials Instructions:
Please identify the job specific minimum qualifications you possess in your cover letter and be sure your resume includes any and all relevant experience to be accurately assessed against the qualifications listed in the posting. To apply, please submit the following application materials to this posting. 1. A current resume. Must include date ranges to include month and year (mm/yyyy) and whether the position was full time or part time. 2. A cover letter that specifically addresses the job requirements and outlines qualifications.
Focus on the Family puts a high value on our team members and offers a unique benefit package.
Employees scheduled for 20 hours or more per week are eligible for:
Norton LifeLock ID Theft Coverage
Legal Shield/ID Shield Coverage
AFLAC
403B Retirement Plan
Vacation Time & Vacation Payout
Sick Time
Holidays
Service Awards
Community Service Days
Bookstore Discount
Fitness Center
Employees scheduled for 30 hours or more per week are eligible for all the above and:
Medical Plan
Dental Plan
Vision Plan
Life Insurance
Disability Insurance
Flexible Spending Accounts
EAP (Employee Assistance Program)
Tuition Reimbursement
Warehouse Membership Reimbursement
Note: This is a summary and should not be construed as future promises to continue to provide benefits as outlined above. For complete and definitive language, refer to the governing plan documents.
*Temporary employees are not eligible for benefits, except for:
Fitness Center
Bookstore Discount
Sick Time
Tentative Search Timeline:
Priority will be given to applications submitted by March 20th, 2024. However, this posting will remain open until filled.
The potential employee start date is April 1st, 2024.
Posting date: November 30th, 2024
Unposting date: Ongoing until filled
Posting contact email: job@fotf.org
Helping Families Thrive in Christ! Focus on the Family is a 501c3 Christian Non-Profit Ministry.
Job Details
Pay Type Salary