Development Systems Business Intelligence Analyst for Children's Hospital Colorado Foundation

Frank Dean

Children's Hospital Colorado Foundation, based in Aurora, Colorado on the Anschutz Medical Campus, is seeking a Business Intelligence Analyst to work on the conversion of the Foundation's systems from Raiser's Edge and Sphere to Blackbaud CRM and Luminate. 

GENERAL PURPOSE OF JOB



The Business Intelligence Analyst will work with Foundation staff to gather requirements for business processes and reports, map current and desired future processes, document procedures and develop reports and other outputs to facilitate access to information. Train staff as needed on new processes and reports. Other duties as assigned.



EXPERIENCE REQUIRED



Experience documenting and designing business process and working with business intelligence solutions required. Extensive knowledge of programming technologies including VB .Net 2008, XML, SQL, ASP web service calls and usage required. Knowledge of Microsoft SQL Server, T-SQL stored procedures and function scripting, SQL Server Reporting Services (SSRS) and Excel desired. Solution being implemented includes a vendor provided data warehouse; familiarity with data warehouse design desired but not required.



Experience in a non-profit environment is a plus. Preference will be given to candidates with Raiser's Edge, Blackbaud CRM or other CRM software experience.



Ability to communicate effectively, through presentations and in writing, with both technical and non-technical personnel. Ability to interact positively with other departments and co-workers using tact, diplomacy and teamwork. Ability to learn quickly and retain information.  



Excellent administrative skills, high motivation, and a proven ability to produce results in a highly deadline-oriented environment. Attentiveness to detail. Strong interpersonal skills, particularly regarding the judgment, discretion, confidentiality, patience, and understanding necessary for dealing effectively with a diverse body of professional colleagues and staff. Reliability, accuracy, and expedience in addressing his or her duties. The ability to handle pressure, to meet deadlines, and to do so with a minimum of supervision or instruction. Strong team orientation.



EDUCATIONAL REQUIREMENTS



Bachelor's degree required.



ESSENTIAL FUNCTIONS



Report Design<?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" />

• Gather requirements for business intelligence from Foundation staff
• Design, develop, document, test and deploy custom reports, ad-hoc queries and data exports
• Build and implement business intelligence solutions to display information (reports, dashboards, queries, etc.)
• Assure quality of solutions
• Business Process Analysis

Analyze current business processes, procedures and protocols

• Gather and document requirements
• Draft future processes with the aim of improving efficiency, eliminating redundancy and maximizing the use of Foundation information systems
• Simulate new processes and changes to processes as needed

Documentation

• Document processes, procedures and protocols
• Organize the repository of documentation with the goal of making information on processes easy for Foundation staff to find

System Configuration, Information Architecture and Data Maintenance

• Participate in the configuration of the CRM and Luminate systems
• Contribute to the design of the CRM data warehouse
• Identify data cleanup opportunities
• Transform data to improve data quality

Communicate and Train

• Communicate the needs for process changes to affected parties
• Train Foundation staff as needed on new and changed processes and how to access information

Other duties as assigned

• Assist with other projects as needed

Apply at

http://www.childrenscoloradofoundation.org/site/c.jfILKSOBJsG/b.4497043/k.BEC0/Jobs.htm