Business Intelligence & Applications Manager

Colorado Springs, CO, United States

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: [email protected]

Helping Families Thrive in Christ! Focus on the Family is a 501c3 Christian Non-Profit Ministry.

Job Details

Pay Type Salary