Job Information
Focus on the Family Sr Business Intelligence SQL Developer 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 Sr. Business Intelligence SQL Developer position exists to provide technical development of detailed reporting of ministry key performance indicators. This position will develop, test, and implement new and enhanced reports, define new data aggregation views, working with other ministry departments to develop and enhance the quality and presentation of operational metrics, trend analyses, and statistical models.
Essential Duties/Responsibilities:
Compiles and analyzes operational information from all components of the ministry and develops integrated analyses and reports using complex database applications and data sets
Develops reporting solutions using Microsoft SQL, Snowflake 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 (5-10) ministry departments
Automates existing reports by enhancing the report with stored procedures, views, and functions for publication to an existing web reporting catalog
Participates in and coordinates the design and implementation of data collection, cleansing and analysis
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 develop reporting applications to other team members for ongoing support and maintenance
Maintains a positive relationship with customer areas and the IT department, ensuring that customer needs are met and that IT policies are followed through mutually beneficial collaboration
Creates and supports windows and web-based .NET applications as supplements to report inputs or as stand-alone process improvement applications
Salesforce data object and SOQL experience a plus
Other Duties/Responsibilities:
Performs other duties as assigned
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
5 - 7 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 2005 and 2008
5 + years of experience with enterprise reporting applications (such as Cognos, CoreMetrics, SAS, etc.)
5+ 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 2008 and SQL Reporting Services, SSAS, SSIS experience a plus
Knowledge of web data presentation using data visualization tools required
Knowledge of Microsoft C#, SQL 2008 R2, and .NET 3.5 or greater preferred
Skills, Abilities, and Special Talents/Gifts:
Strong software development 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 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: $89,440 to $102,960/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:
Sick Time
Bookstore Discount
Fitness Center
Tentative Search Timeline:
Priority will be given to applications submitted by August 1st, 2024. However, this posting will remain open until filled.
The potential employee start date is August 5th, 2024.
Posting date: July 1st, 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