Data Architect, Research

Data ArchitectThe 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. 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 deviation 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.