Data Warehouse Business Analyst
Cancer care is all we do
Hope in healing
Cancer Treatment Centers of America® (CTCA), part of City of Hope, takes a unique and integrative approach to cancer care. Our patient-centered care model is founded on a commitment to personalized medicine, tailoring a combination of treatments to the needs of each individual patient. At the same time, we support patients’ quality of life by offering therapies designed to help them manage the side effects of treatment, addressing their physical, spiritual and emotional needs, so they are better able to stay on their treatment regimens and get back to life. At the core of our whole-person approach is what we call the Mother Standard® of care, so named because it requires that we treat our patients, and one another, like we would want our loved ones to be treated. This innovative approach has earned our hospitals a Best Place to Work distinction and numerous accreditations. Each of us has a stake in the successful outcomes of every patient we treat.
The Data Warehouse Business Analyst reviews, analyzes, and evaluates user needs and the related systems. The role is responsible for assisting in the design of systems to parallel overall business strategies. He/she acts as an internal expert in terms of system capabilities and is also responsible for knowing what changes have been made to the base system. Additional responsibilities include assisting with documenting functional and technical requirements, mapping process flows, documenting test plans, conducting system testing, documenting user manuals, and administering training.
30% Works with customers to understand their data requirements. Assists with mapping data models, documenting/designing technical solutions to satisfy requirements, and completing formal system testing.
10% Works with vendors to be current on product features and to support the alignment of the CTCA implementation strategy with the product’s roadmap. Using this information, he/she assists in educating the CTCA end-users on available functionality.
30% Assists in monitoring CTCA data assets and reports anomalies, errors, inaccuracies, or inefficiencies. Makes recommendations as needed.
5% Assists in the programming and configuration of changes to the application, interfaces, and database to ensure that the systems operate according to the end-user’s needs.
20% Collaborates closely with the user community and IT leadership to provide support for systems, projects and initiatives. Assists with the training, education, and instruction of users on features, operation, and usage of data assets.
5% Assists in the development of policies and procedures for the usage of information systems.
Education/ Experience Level
An Associates Degree in Computer Technology or related field is required; Bachelor’s Degree in Computer Science or Information Systems is preferred.
3-5 years on a data-focused team inclusive of data warehousing, application development, reporting, and/or analytics
1+ year working in a healthcare or health insurance setting is required
Has led 5-10 small to medium size technical initiatives or projects
Knowledge & Skills
Advanced capabilities in the acquisition and drafting of business and/or technical requirements as an individual contributor and within a team environment
Intermediate to advanced knowledge of relational database concepts and can apply these to data warehousing and/or application constructs
Intermediate to advanced experience with TSQL in the writing of complex queries to review data and data structures. This skill should be sufficient to perform data analysis in the review and troubleshooting of issues in stored procedures or other SQL-related processes
Experience with two or more in the following applications - MS SQL Server (SSMS; SSAS; or SSRS); Tableau; Qlikview; Business Objects; RedGate; Embarcadero; Visual Studio; Informatica Data Quality
Strong organizational skills and have leveraged one or more project management methodologies/tools in order to implement a technical solution
Strong interpersonal, written, and oral communication skills.
Each CTCA employee is a Stakeholder, driven to make a true difference and help win the fight against cancer. Each day is a challenge, but this unique experience comes with rewards that you may never have thought possible. To ensure each team member brings his or her best self, we offer exceptional support and immersive training to encourage your personal and professional growth. If you’re ready to be part of something bigger and work with a passionate, dynamic group of care professionals, we invite you to join us. Visit: Jobs.cancercenter.com to begin your journey.
We win together
Each CTCA employee is a Stakeholder, driven to make a true difference and help win the fight against cancer. Each day is a challenge, but this unique experience comes with rewards that you may never have thought possible. To ensure each team member brings his or her best self, we offer exceptional support and immersive training to encourage your personal and professional growth. If you’re ready to be part of something bigger and work with a passionate, dynamic group of care professionals, we invite you to join us.
Visit: Jobs.cancercenter.com to begin your journey.
Job Status: Full Time
Job Reference #: JR-07659