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/REQUIREMENTSCharacter/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 and Statement of Faith; upholds Focus on the Family's ministry in prayerPrays personally for Focus on the Family’s staff and constituents and may occasionally lead in a public prayerEngages in Christian ministryDemonstrates behaviors aligned with FOF core 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. 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 CoverageLegal Shield/ID Shield CoverageAFLAC403B Retirement PlanVacation Time & Vacation PayoutSick TimeHolidaysService AwardsCommunity Service DaysBookstore DiscountFitness CenterEmployees scheduled for 30 hours or more per week are eligible for all the above and:Medical PlanDental PlanVision PlanLife InsuranceDisability InsuranceFlexible Spending AccountsEAP (Employee Assistance Program)Tuition ReimbursementWarehouse Membership ReimbursementNote: 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 CenterBookstore DiscountSick Time