About City of Hope
City of Hope's mission is to deliver the cures of tomorrow to the people who need them today. Founded in 1913, City of Hope has grown into one of the largest cancer research and treatment organizations in the U.S. and one of the leading research centers for diabetes and other life-threatening illnesses. City of Hope research has been the basis for numerous breakthrough cancer medicines, as well as human synthetic insulin and monoclonal antibodies. With an independent, National Cancer Institute-designated comprehensive cancer center at its core, City of Hope brings a uniquely integrated model to patients spanning cancer care, research and development, academics and training, and innovation initiatives. City of Hope’s growing national system includes its Los Angeles campus, a network of clinical care locations across Southern California, a new cancer center in Orange County, California, and treatment facilities in Atlanta, Chicago and Phoenix. City of Hope’s affiliated family of organizations includes Translational Genomics Research Institute and AccessHopeTM. For more information about City of Hope, follow us on Facebook, Twitter, YouTube, Instagram and LinkedIn.

City of Hope’s commitment to Diversity, Equity and Inclusion
We believe diversity, equity and inclusion is key in serving our mission to provide compassionate patient care, drive innovative discovery, and advance vital education focused on eliminating cancer and diabetes in all of our communities. Our commitment to Diversity, Equity and Inclusion ensures we bring the full range of skills, perspectives, cultural backgrounds and experiences to our work -- and that our teams align with the people we serve in order to build trust and understanding. We are dedicated to fostering a community that embraces diversity - in ideas, backgrounds and perspectives; this is reflected in our work and represented in our people.

** This is a Fully Remote Opportunity. You may sit at any of the 48 States **

Position Summary
Responsible for leading the design and support of Data warehouse & Business Intelligence architecture, programming reports, dashboards using SQL server Integration tools, IBM Cognos BI tool, software Requirement gathering, analysis and coordination with technical team. Works with senior management to understand and prioritize data and information requirements. Expert technical role. Provides technical expertise and direction for the development of complex business intelligence and decision support systems solutions.

Key Responsibilities include:

• Utilizes understanding of dimensional data modeling techniques, data warehousing, design and concepts to produce balanced scorecard design, and design of dashboards and KPI’s (Key Performance Indicators).
• Develops data marts, scheduled and ad-hoc parameterized queries, and reports from a variety of data sources and provides on-going analytical support for these requests. Converts existing reporting tools to a standardized reporting infrastructure.
• Design, develop, and implement data warehouse and business intelligence applications and dashboards utilizing industry standard tools
• Develop and implement business logic and the ETL (extract, transform, and load) mechanism to populate the EDW (Enterprise Data Warehouse) and Programming ETL tool with business rules to be applied to data from source input to target data repository, automating data extraction/load programs to run on regular schedule.
• Responsible for creating & maintaining significant enhancements and customizations to major applications using both custom application vendor delivered and/or generic programming tools.
• Design, create, test and maintain a portfolio of reports, scorecards and dashboards.
• Stay informed about Business Intelligence industry trends, technologies and best practices that can be applied to achieve business goals
• Forecast and analyze data and trends to create reports that highlight areas needing improvement.
• Participates in On Call afterhours support (24/7) coverage as required
• Other duties as Assigned
  

Basic education, experience and skills required for consideration:

• Bachelor’s Degree (Experience may substitute for minimum education requirements)
• Five years or more in a SQL programming & IBM Cognos Reporting analyst position working with large multi-user systems
• Required experience in data warehouse and business intelligence applications including data design, database architecture, metadata and repository creation. Assists in the development, maintenance, and support of an enterprise data warehouse system and corresponding data marts. Troubleshoots and tunes existing data warehouse applications. Assists in creating new or enhanced components of the data warehouse.

Preferred education experience and skills:

• EPIC Clarity Database Knowledge a Plus
• Experience with database technologies such as Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server. Experience developing or managing ETL packages, across platforms such as SQL Server, DTS or SSIS. Proficiency in SQL. Experience with BI Technologies mainly IBM Cognos

Additional Information:
The estimated pay scale represents the typical [salary/hourly] range City of Hope reasonably expects to pay for this position, with offers determined based on several factors which may include, but not be limited to, the candidate’s experience, expertise, skills, education, job scope, training, internal equity, geography/market, etc. This pay scale is subject to change from time to time.

As a condition of employment, City of Hope requires staff to comply with all state and federal vaccination mandates.

City of Hope is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, or status as a qualified individual with disability.
#LI-CL