📁
Information Technology
📅
10004170 Requisition #
Thanks for your interest in the Data Warehouse Architect position. Unfortunately this position has been closed but you can search our 0 open jobs by clicking here.
Basic education, experience and skills required for consideration:

  • Bachelor’s Degree in a Health Science, Computer Science, Information Systems or related discipline

    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).

 

Preferred education experience and skills:

  • Demonstrated expert knowledge developing SQL, stored procedures, views, MDM (Master Data Management), and ETL (Extract Transform, Load).
  • Expert demonstrated knowledge writing / understanding SQL queries and stored procedures; MS SQL/ Oracle experience preferred
  • Knowledge of Data Governance and Data Stewardship principles and processes.
  • Knowledge and experience with Data Quality concepts and tools.
  • Proficient at performance tuning techniques – both Informatica and database level
  • Knowledge of OS command line and scripting techniques
  • Experience with non-relational data sources (flat file, XML, CACHE, unstructured, etc)
  • Experience with data mining and analysis
  • Implementation of decision support elements in information systems including rules and alerts.
  • Experience in enterprise data management processes
  • Strong understanding of relational, dimensional and object-oriented data structures, theories, principles, and practices. 
  • Strong familiarity with master data and metadata management and associated processes. 
  • Hands-on knowledge of enterprise repository tools, data modeling tools, data mapping tools, data profiling tools, and data and information system life cycle methodologies. 
  • Experience with Microsoft SQL Server Integration Services (SSIS). 
  • Understanding of Healthcare Data Interoperability standards (HL7, RIM)
  • Understanding of metadata standards (Dublin Core, SKOS) preferred
  • Excellent communication skills including ability to understand user requirements and to facilitate user understanding of enterprise data.
  • A working understanding of data privacy standards and regulations. (e.g. PHI and HIPAA).

 

Preferred Software experience:

 

  • Informatica PowerCenter 9.x
  • Informatica PowerExchange 9.x
  • Informatica Data Quality (IDQ) 9.x - Developer/Data Analyst /Business Glossary 
  • Informatica Master Data Management 9.x - Hub and Data Director (IDD) Informatica DVO (Data Validation Option)
  • SQL client tool(s) such as SSMS (SQL Server Management Studio), Toad, SQL Developer, Erwin
  • Relational databases and SQL Query/SSIS (SQL Server Integration Services)
  • Crystal skills preferred
  • Windows / Microsoft Office
  • Project Management Software
  • Eclipsys/Allscripts, i2b2
  • Programming skills and experience in Visual Studio.NET and other object oriented environments is a plus.

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.

 

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions