Senior Business Intelligence Analyst - Foundation

$96,595 - $161,325/Yr

City of Hope

Full-time - Mid Level

Hospitals

About the position

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. As a Senior Business Intelligence Analyst, you will play a crucial role in our growing national system, which includes our Los Angeles campus, a network of clinical care locations across Southern California, and treatment facilities in Atlanta, Chicago, and Phoenix. This position is designed for an experienced professional who is passionate about preparing and presenting information in a visually appealing and easily understood manner, making it relevant and actionable for key stakeholders. In this role, you will be responsible for collecting and synthesizing complex data from multiple sources, providing intellectual rigor to analysis and interpretation processes, and deriving meaningful insights that support the achievement of strategic and operational goals. You will work closely with multiple internal stakeholders to analyze business needs and deliver relevant information in appropriate formats. Your ability to analyze large datasets to discover trends, patterns, and actionable insights will be essential in driving organizational performance improvement. As a team lead, you will oversee the day-to-day functions of the BI Analysts and train entry-level employees to elevate their skills to match the team's capabilities. You will design, create, test, and maintain a portfolio of reports, scorecards, and dashboards, while also participating in enterprise-level metadata, master data management, and data governance initiatives. Staying informed about Business Intelligence industry trends, technologies, and best practices will be key to achieving our business goals. Your expertise in dimensional data modeling techniques, data warehousing, and the design of dashboards and KPIs will be critical in producing balanced scorecards and ensuring data quality through participation in data profiling activities. This position reports to the Director of Analytics and is a full-time role with a focus on day shifts.

Responsibilities

• Program ETL on SQL server and Snowflake.
• Oversee the day-to-day functions of the BI Analysts and train entry-level employees.
• 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.
• Develop and implement business logic and the ETL mechanism to populate the EDW and Programming ETL tool with business rules.
• 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.

Requirements

• 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.
• Experience in a health care, biomedical research, and/or academic medical setting is preferred.