Join the transformative team at City of Hope, where we're changing lives and making a real difference in the fight against cancer, diabetes, and other life-threatening illnesses. 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. Our dedicated and compassionate employees are driven by a common mission: To deliver the cures of tomorrow to the people who need them today. 

This role reports to Director of Analytics, is an experienced professional with a passion for preparing and presenting information in a visually appealing and easily understood manner, making it relevant and actionable for key stakeholders. Requires the ability to collect and synthesize complex data from multiple sources, provide intellectual rigor to analysis and interpretation processes, and derive meaningful insights that support the achievement of strategic and operational goals.

As a successful candidate, you will: 

• Able to program ETL on SQL server and Snowflake.
• Work as Team lead to oversee the day-to-day functions of the BI Analyst’s also train entry-level employees that will allow them to be on the same level as the team.
• Analyze large datasets to discover trends, patterns and actionable insights. 
• Apply research and evaluation standards, descriptive statistics and data management principles to translate complex data into meaningful content. 
• Present findings using verbal, written, and graphic communication techniques. Offer recommendations to support organizational performance improvement.
• Work closely with multiple internal stakeholders to analyze business needs and deliver relevant information in appropriate formats.
• Design, create, test and maintain a portfolio of reports, scorecards and dashboards.
• Participate in enterprise-level metadata, master data management and data governance initiatives.
• Stay informed about Business Intelligence industry trends, technologies and best practices that can be applied to achieve business goals.
• Develop and implement business logic and the ETL mechanism to populate the EDW 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.
• 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).
• Gather and analyze business requirements to perform data modeling and mapping across multiple platforms for enterprise wide BI initiatives.
• Identify data quality issues and support the data governance initiative by participating in necessary activities including data profiling.

Your qualifications should include: 

• Undergraduate degree or equivalent required.
• 5+ years of experience in business intelligence, systems analysis, informatics, or a related discipline, including requirements gathering, solution implementation, testing and validation.
• Preferably:  Experience in a health care, biomedical research and / or academic medical setting.

City of Hope is an equal opportunity employer.  To learn more about our commitment to diversity, equity, and inclusion, please click here.    To learn more about our Comprehensive Benefits, please CLICK HERE.