Data Architect, ISD

The Data Architect will play a pivotal role in the evolution of CHOC’s data architecture and system automation. This role will work to define and build a modern enterprise data architecture that supports the organization’s business strategy. This role will architect, design and lead implementation of data models, data flows as well as API driven data services in alignment with Enterprise Architecture standards and guiding principles. This role will have deep, hands-on expertise in data architecture, design and implementation of Data Warehouse, Business Intelligence, MDM, Meta Data management and Web APIs/ Interfaces., * Required: Data architecture development, ETL, data extracts, data modeling, database design and management. Extensive data integration, warehousing and analytics solutions experience. Expert SQL (Microsoft SQL and/or Oracle) experience. Highly skilled data modeling in both operational transactional and data warehouse dimension design. Experience with data visualization tools such as QlikView. ETL, data transformation , and masking tools experience (Microsoft SSIS, Informatica, etc.). Extensive experience designing and developing RESTful APIs with broad knowledge of web standards to APIs (REST, JSON, SOAP, HTTP, OAuth, SSL, PGP, SAML, etc.). Experience in developing interfaces using middleware such as Oracle SOA, WSO2, MuleSoft, Tibco, Azure Data Factory. Understanding of Cloud-based architectures (AWS, Azure, etc.).

Licensure

• Required: None required.

Work Environments - Functional Demand: Sedentary - Very light energy level Lift 10 lbs. box overhead. Lift and carry 15 lbs. Push/pull 20 lbs. cart.

Physical Activity Requirements:

Bending, Carry Objects, Climbing, Keyboard use/repetitive motion, Pinching/fine motor activities, Push/Pull, Reaching forward, Reaching overhead, Sitting, Squat/kneel/crawl (Squad & Knee), Standing, Talk or hear, Taste or smell, Twisting, Walking, Wrist position deviation

Physical Activity Lifting Lifting (Floor to waist level) - Occasional 0-35%, Lifting (Waist level and above) - Occasional 0-35%

Sensory Requirements: Color Discrimination, Depth Perception, Far Vision, Hearing, Near Vision

Environment Requirements: Airborn Communicable Disease, Bloodborne Pathogens, Chemical, Dust Particular Matter, Extreme Noise Levels, Extreme Temperatures, Radiation, Uneven Surfaces or Elevations

• Required: Minimum five (5) years of experience in IT, with at least three (3) years in data modeling, ETL, API integration and data warehouse design and implementation.

• Preferred: Eight (8) or more years of experience in IT, with at least five (5) years in data modeling, ETL, API integration and date warehouse design and implementation., * Required: Bachelor’s degree in Computer Science, Information Technology or related field or equivalent industry experience.

Minimum $121,347 Midpoint $160,826 Maximum $200,283

Rate of pay is determined by various factors, including but not limited to knowledge, skills, competencies, experience, education, as well as position requirements.

At CHOC, we strive to be the leading destination of children’s health by providing exceptional and innovative care. We are responsible for the overall health of our community’s pediatric population in our hospitals, clinics, and practices. And because of our breadth of care, your career at CHOC can be as diverse and fulfilling as you determine. CHOC’s compensation structure, benefits offerings, and career development programs are geared to helping you achieve your professional and personal goals. Apply now to see where your career at CHOC can take you.