ETL Developer
Loma Linda University Health | |
$47.81 - $69.25 / Hourly | |
United States, California, Loma Linda | |
Nov 25, 2024 | |
Medical Center: Operational Excellence (Full Time, Day Shift, Onsite/Non Remote) - 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 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 expert in SQL with Healthcare applying clinical for financial terminology; 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, PowerPoint). Strong knowledge of project management software such as MS Project, Access, and other project management tools. Relate and communicate positively and effectively with others; work calmly and respond courteously when under pressure; lead, supervise, teach, and collaborate; accept direction. Deal effectively with people and elicit support from other department areas, vendors, and customers. Excellent analytic and documentation skills. Organize technical work; demonstrate excellent planning, problem solving, analysis, and presentation skills; analyze and interpret data, processes and needs based on limited information; make recommendations; manage time effectively and plan and implement objectives effectively. Think critically and work independently; perform basic math and statistical functions; compose written material; 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. 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. |