Data Architect, ISD

Work Location

Orange, California

Work Shift

Day – 08hrs (United States of America)

Why CHOC?

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.

Environmental Sustainability Statement

Driven by the connection between children's health and a healthy environment, we commit to creating a healthcare model that incorporates environmental sustainability aligned with our mission to protect children's health and patient safety.

Job Summary

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.

Pay Range

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.

Experience

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

Education

• Required: Bachelor's degree in Computer Science, Information Technology or related field or equivalent industry experience.

Training

• Required: None required.

Specialized Skills

• 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

Non-Discrimination Statement:

CHOC does not discriminate on the basis of age, race, color, religion, national origin, ancestry, marital status, genetic information, disability, sex, gender (including pregnancy, breastfeeding, childbirth, lactation or related medical conditions), gender identity or expression, medical condition, sexual orientation, veteran status, military or uniformed service member status, or other protected characteristics in accordance with state and federal laws.

We encourage individuals from all backgrounds to apply for positions at CHOC, even if your experience doesn’t align perfectly with the listed qualifications for a particular role, as your unique experience may be a great addition to our culture for another one of our opportunities.

If you desire support or accommodations throughout the Talent Acquisition process, please inform your Talent Acquisition Partner.