Children's Hospital Los Angeles

Purpose Statement/Position Summary: The CRM Support Services team is responsible for the overall technical and developer support of CHLA's fundraising application, Blackbaud CRM. While ensuring the functionality and tools within CRM are available, the CRM Support Services team provides direct customer service to the Foundation department by leveraging the application's functionality and providing strategic business intelligence to best support the hospital's fundraising goals.. Develop reports and customizations using ad-hoc queries, SQL Server, SSIS, SSRS, Report Builder, Visual Studio and the Blackbaud CRM SDK. Gather and clarify requirements, develop, test, and validate deliverables such as reports, data lists, applications, and system upgrades, ensuring timely and accurate results.. 2 years of experience in a Healthcare Information Services support and/or philanthropy/fundraising development environment.. Fluency in SQL, specifically MS SQL Server and associated BI Tools such SSIS, SSRS and Power BI. An understanding of relational databases, data warehousing, data modeling concepts and tools.. Children's Hospital Los Angeles (CHLA) is a leader in pediatric and adolescent health both here and across the globe.

business intelligence developer

NATIONAL LEADERS IN PEDIATRIC CARE Ranked among the top 10 pediatric hospitals in the nation, Children’s Hospital Los Angeles (CHLA) provides the best care for kids in California. Here world-class experts in medicine, education and research work together to deliver family-centered care half a million times each year. From primary to complex critical care, more than 350 programs and services are offered, each one specially designed for children. The CHLA of the future is brighter than can be imagined. Investments in technology, research and innovation will create care that is personal, convenient and empowering. Our scientists will work with clinical experts to take laboratory discoveries and create treatments that are a perfect match for every patient. And together, CHLA team members will turn health care into health transformation. Join a hospital where the work you do will matter—to you, to your colleagues, and above all, to our patients and families. The work will be challenging, but always rewarding. It’s Work That Matters. Overview **This is a Remote position. Candidates must reside in California.** Schedule: Monday-Friday Purpose Statement/Position Summary: The CRM Support Services team is responsible for the overall technical and developer support of CHLA's fundraising application, Blackbaud CRM. While ensuring the functionality and tools within CRM are available, the CRM Support Services team provides direct customer service to the Foundation department by leveraging the application's functionality and providing strategic business intelligence to best support the hospital's fundraising goals. The Business Intelligence Developer is an expert in supporting enterprise Business Intelligence solutions and is responsible for running, designing and developing business intelligence solutions, including reports, dashboards, and other data artifacts, to meet the needs of internal line-of-business customers. The Developer will develop and code reports and other data artifacts in the appropriate business intelligence tools, and provide update status of work being done, assure compliance with CHLA’s software development policies, and will communicate activities to project resources, team leads and management. Strong SQL skills for data retrieval and manipulation, querying, creating and modifying database objects are a must. Develop reports and customizations using ad-hoc queries, SQL Server, SSIS, SSRS, Report Builder, Visual Studio and the Blackbaud CRM SDK. Gather and clarify requirements, develop, test, and validate deliverables such as reports, data lists, applications, and system upgrades, ensuring timely and accurate results. Create user-friendly, data intensive and visually appealing dashboards and reports using Power BI/Tableau. Minimum Qualifications/Work Experience: 2-5 years providing production level support and/or development in business intelligence/enterprise data warehouse environment, demonstrated design and development experience in software programming. 2-5 years of successful business intelligence application support and troubleshooting experience within the healthcare delivery environment or fundraising/philanthropy operations.(Client/Server, Web Server, various/multiple Database environments, etc.) 2 years of Oracle or SQL Server administration, development, and/or application experience. Experience in creating and modifying analytical applications using Business Intelligence tools and best practice visualization techniques. 2 years of experience working with (developing, troubleshooting, maintaining, etc.) various databases (Oracle, SQL Server, etc.) 2 years of experience in a Healthcare Information Services support and/or philanthropy/fundraising development environment. 2-5 years of experience developing detailed design specifications, policies/procedures. Fluency in SQL, specifically MS SQL Server and associated BI Tools such SSIS, SSRS and Power BI. An understanding of relational databases, data warehousing, data modeling concepts and tools. Full life cycle experience in developing complex reports in Tableau/BI/SSRS. Strong communication skills, ability to collaborate and solve complex problems. Understanding of industry (healthcare fundraising and philanthropy) and business processes highly preferred. Education/Licensure/Certification: Bachelor’s degree from an accredited university in a related field. Pay Scale Information $84,656.00-$152,506.00 CHLA values the contribution each Team Member brings to our organization. Final determination of a successful candidate’s starting pay will vary based on a number of factors, including, but not limited to education and experience within the job or the industry. The pay scale listed for this position is generally for candidates that meet the specified qualifications and requirements listed on this specific job description. Additional pay may be determined for those candidates that exceed these specified qualifications and requirements. We provide a competitive compensation package that recognizes your experience, credentials, and education alongside a robust benefits program to meet your needs. CHLA looks forward to introducing you to our world-class organization where we create hope and build healthier futures. Children's Hospital Los Angeles (CHLA) is a leader in pediatric and adolescent health both here and across the globe. As a premier Magnet teaching hospital, you’ll find an environment that’s alive with learning, rooted in care and compassion, and home to thought leadership and unwavering support. CHLA is dedicated to creating hope and building healthier futures – for our patients, as well as for you and your career! CHLA has been affiliated with the Keck School of Medicine of the University of Southern California since 1932. At Children’s Hospital Los Angeles, our work matters. And so do each and every one of our valued team members. CHLA is an Equal Employment Opportunity employer. We consider qualified applicants for all positions without regard to race, color, religion, creed, national origin, sex, gender identity, age, physical or mental disability, sexual orientation, marital status, veteran or military status, genetic information or any other legally protected basis under federal, state or local laws, regulations or ordinances. We will also consider for employment qualified applicants with criminal history, in a manner consistent with the requirements of state and local laws, including the LA City Fair Chance Ordinance and SF Fair Chance Ordinance. Qualified Applicants with disabilities are entitled to reasonable accommodation under the California Fair Employment and Housing Act and the Americans with Disabilities Act. Please contact CHLA Human Resources if you need assistance completing the application process. Diversity inspires innovation. Our experiences, perspectives and backgrounds allow us to better serve our patients and create a strong community at CHLA. IS - CRM Support Services #J-18808-Ljbffr

START NEW SEARCH