About City of Hope
City of Hope is an independent biomedical research and treatment organization for cancer, diabetes and other life-threatening diseases.
Founded in 1913, City of Hope is a leader in bone marrow transplantation and immunotherapy such as CAR T cell therapy. City of Hope’s translational research and personalized treatment protocols advance care throughout the world. Human synthetic insulin, monoclonal antibodies and numerous breakthrough cancer drugs are based on technology developed at the institution.  AccessHope™, a subsidiary launched in 2019 serves employers and their health care partners by providing access to City of Hope’s specialized cancer expertise.
A National Cancer Institute-designated comprehensive cancer center and a founding member of the National Comprehensive Cancer Network, City of Hope is ranked among the nation’s “Best Hospitals” in cancer by U.S. News & World Report and received Magnet Recognition from the American Nurses Credentialing Center. Its main campus is located near Los Angeles, with additional locations throughout Southern California and in Arizona.

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
This position designs, organizes, and enables delivery of standard health data generated from the clinical, research, and business/finance information systems from all available City of Hope enterprise applications and database systems.  The Enterprise Data Architect will understand City of Hope’s strategic goals and objectives and will enhance City of Hope’s ability to use data to achieve these goals. This position will work closely with clinicians, researchers, and business leaders across the City of Hope enterprise to understand their data needs. This position will ensure that the design of data systems, including the Enterprise Data Warehouse, represents these needs and is optimal in order to achieve Clinical, Business and Research goals and outcomes. This position will be responsible for the design of data architectures information systems through designing data models, standard terminologies, metadata and clinical decision support elements. This role will use enterprise development, testing and analysis tools including SQL, ETL (Enterprise-Transform-Load), DVO (Informatica PowerCenter Data Validation Option), MDM (Master Data Management), Business Glossary, Meta-data, Data Lineage, Data Masking, Quality, CDC (Change Data Capture), and enterprise modeling tools.  In addition, this role will be responsible for integration of City of Hope data with standard terminology sets such as CPT, SNOMED, ICD9/10, and RxNorm.  This role will use data integration, transformation, analysis, and query tools to help members of City of Hope with clinical, research and business analysis of data. Through an understanding of this data, this position will design architectures, and federate data from large enterprise systems and make that data available for informed decision making, reporting, analysis, and data mining.

Key Responsibilities include:

• Data integration using enterprise development toolsets (e.g. ETL, MDM, Quality, CDC, Data Masking, Quality)
• Develop and maintain the overall City of Hope data architecture model
• Responsible for data integration architecture, development, testing, data quality, and on-going auditing.
• Conducts detailed requirements gathering and analyzes information obtained to translate customers’ objectives into a detailed technical implementation plan.
• Designs and supports multi-dimensional models, including the construction of data views, dimensions, measures, filters, hierarchies and cubes while adhering to standard development methodologies.
• Serve as an expert resource and consultant for all areas of data warehousing and integration with regard to data collection, standards, management, governance, retrieval and use as well as design and use of data elements and tools.
• Provides data modeling and architecture expertise for complex projects.
• Collaborates with data architects, database administrators and other team members to understand dimensional requirements and translate into functional specifications.
• Designs data marts and develops 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.
• Accurately scopes, defines and estimates work effort and resource plan for assigned projects.
• Determine testing needed to assure the accuracy of information being delivered by creating test plans and evaluate testing results.
• Identify data quality issues and support the data governance initiative by participating in necessary activities including data profiling.
• Forecast and analyze data and trends to create reports that highlight areas needing improvement.
• Participates in On Call after hours support (24/7) coverage as required.
• Other Duties as Assigned
   

Basic education, experience and skills required for consideration:

• Bachelor’s Degree in a Health Science, Computer Science, Information Systems or related discipline
• Experience may substitute for minimum education requirements
• 5 years of demonstrated expert knowledge developing SQL, stored procedures, views, MDM (Master Data Management), and ETL (Extract Transform, Load).
• 5 years of experience with data aspects of information system design, modeling, and implementation
• 5 years of experience relational and dimensional data modeling - including constructing database normalization; utilizing data modeling tools to record, update, reverse engineer and generate DDL; creating logical and physical data models for current and proposed states
• 5 years demonstrated experience and expert knowledge supporting statistical and predictive analytic modeling with large datasets.
• 3 or more years of data or information architecture experience in an enterprise environment (prefer healthcare and clinical research).

Additional Information:

• 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