ETL Developer

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.

Responsible for all back-end development, providing an overall information architecture design across multiple platform types (operational, analytical, reporting) balancing the need for access against security, analytics and performance requirements. Work with IT and business teams to design and maintain the enterprise data model. Support enterprise data strategy. 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. Design and develop ETL solutions and deliver large scale enterprise environment solutions. Work with other ETL, Universe, and Metadata architects or developers to support full delivery life cycle of EDW solutions and design/develop Universe/Metadata and reports as needed. Perform other duties as needed.

Bachelor’s degree or equivalent in Computer Science, Data Science, Engineering or a related field. Four (4) years of software development or related experience, developing Data Warehousing and Business Intelligence solutions for large applications spanning across multiple business functions; and working with SQL Query and Data Modeling. Three (3) years of Business Intelligence experience in a healthcare setting. Experience, skills or ability: performing SQL development and dimensional modeling applying Star Schema and BI Methodology; using one (1) or more of the following ETL data integration tools: SSIS, Pentaho, Informatica, Data Services, Data Virtualization, etc.; and performing dimensional data profiling and applying clinical or financial terminology in SQL with Healthcare data modeling and analyzing 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, PowerPoint). 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.