City of Hope - Duarte, CA
posted 5 months ago
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 the Director of Analytics and is designed for 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. The position 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 be responsible for programming ETL on SQL server and Snowflake, overseeing the day-to-day functions of the BI Analysts, and training entry-level employees to elevate their skills. You will analyze large datasets to discover trends, patterns, and actionable insights, applying research and evaluation standards, descriptive statistics, and data management principles to translate complex data into meaningful content. Presenting findings using verbal, written, and graphic communication techniques will be essential, as will offering recommendations to support organizational performance improvement. You will work closely with multiple internal stakeholders to analyze business needs and deliver relevant information in appropriate formats. Your responsibilities will also include designing, creating, testing, and maintaining a portfolio of reports, scorecards, and dashboards, as well as participating in enterprise-level metadata, master data management, and data governance initiatives. Staying informed about Business Intelligence industry trends, technologies, and best practices that can be applied to achieve business goals will be crucial. Additionally, you will develop and implement business logic and the ETL mechanism to populate the EDW and Programming ETL tool with business rules, automating data extraction/load programs to run on a regular schedule. Utilizing your understanding of dimensional data modeling techniques, data warehousing design, and concepts will help you produce balanced scorecard designs and dashboards with Key Performance Indicators (KPIs). Gathering and analyzing business requirements to perform data modeling and mapping across multiple platforms for enterprise-wide BI initiatives will also be part of your role, along with identifying data quality issues and supporting the data governance initiative by participating in necessary activities including data profiling.