Back to search
Work Location
Orange, California
Work Shift
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,283Rate 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.
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.)
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 deviationPhysical 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 VisionEnvironment Requirements:
Airborn Communicable Disease, Bloodborne Pathogens, Chemical, Dust Particular Matter, Extreme Noise Levels, Extreme Temperatures, Radiation, Uneven Surfaces or ElevationsNon-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.
Learn more about this Employer on their Career Site
