| Loma Linda University Health|
United States, California, Loma Linda
|June 21, 2022|
Shared Services: MC: Enterprise Data Warehouse (Full-time, Day Shift) -
Our mission is to continue the teaching and healing ministry of Jesus Christ. Our core values are compassion, excellence, humility, integrity, justice, teamwork and wholeness.
The ETL Developer is responsible for all back-end developing, providing an overall information architecture design across multiple platform types (operational, analytical, reporting) balancing the need for access against security, analytics and performance requirements. Works with IT and business teams to design and maintain the enterprise data model; supporting enterprise data strategy; will design, implement and execute changes to existing data models; create new data models that are congruent to Enterprise Data Warehouse (EDW) data model and architecture strategies. Designs and develops ETL solutions and delivers large scale enterprise environment solutions. Works with other ETL, Universe, and Metadata architects or developers to support full delivery life cycle of EDW solutions and will design/develops Universe/Metadata and reports as needed. Performs other duties as needed.
Bachelor's Degree in Computer Science, Data Science or Engineering required. Minimum three years of Business Intelligence in a healthcare setting required. Minimum four years of experience in Data Warehousing and Business Intelligence solutions for large applications spanning across multiple business functions required. Minimum four years of experience in SQL Query and Data Modeling required. Experience may be considered in lieu of Degree. Valid Driver's License required at time of hire.
Strong SQL Development Experience and Strong Dimensional Modeling applying Star Schema and BI methodology. Experience with one or more ETL data integration tools (SSIS, Pentaho, Informatica, Data Services, Data Virtualization, etc.). Able to perform dimensional data profiling as needed and must expert in SQL with Healthcare data modeling applying clinical or financial terminology, with ability to analyze technical information and requirements to design and develop robust data interactive solutions.: Able to perform dimensional data profiling as needed and must expert in SQL with Healthcare applying clinical for financial terminology, with ability to analyze technical information and requirements to design and develop robust data interaction solutions. Able to read; write legibly; speak in English with professional quality; use computer, printer, and software programs necessary to the position (e.g., Word, Excel, Outlook, Power Point). Strong knowledge of project management software such as MS Project, Access, and other project management tools for task tracking and team collaboration efforts. Able to communicate basic concepts in concise, eloquent form to peers and leadership verbally, in writing and through pictures or diagrams when appropriate. Able to relate and communicate positively, effectively, and professionally with others; work calmly and respond courteously when under pressure; lead, supervise, teach, and collaborate; accept direction. Ability to deal effectively with people and elicit support from other department areas, vendors, and customers. Excellent analytic, communication, and documentation skills. Able to organize technical work; demonstrate excellent planning, problem solving, analysis, documentation, presentation and organization skills; analyze and interpret data, processes and needs based on limited information; organize work and resources; define problems and solutions, prioritize work load; make recommendations; manage time effectively and plan and implement objectives effective. Able to communicate effectively in English in person, in writing, and on the telephone; think critically; work independently; perform basic math and statistical functions; manage multiple assignments; compose written material; work well under pressure; recall information with accuracy; pay close attention to detail. Able to distinguish colors as necessary; hear sufficiently for general conversation in person and on the telephone, and identify and distinguish various sounds associated with the workplace; see adequately to read computer screens, and written documents necessary to the position.