ETL Developer

Knowledge, Skills and Abilities (KSA)

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.

Education and Experience

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.

Licensure(s) and Certification(s)

None.

Age Specific Criteria

Age specific criteria pertinent to this position are contained and described within the department's Performance Standards. Additional criteria may be listed in separate documents by the department.

Exposure to Hazards

Hazardous materials pertinent to this position are described in the department's Safety Data Sheets (SDS) information outlined on One Portal.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. ACTIVITIES: Occasionally requires squatting, climbing, kneeling, crawling, reaching above waist, reaching at shoulder level, reaching above shoulder level. Frequently requires walking, standing, bending waists, twisting waist, balancing, bending neck, turning neck and reaching below waist. HAND FUNCTIONS: Frequently requires pinching, simple grasping, firm grasping and fine manipulation. ENVIRONMENTAL DEMANDS: Occasionally exposed to outdoor weather conditions, heights, dust, gas, excessive noise, hostility and working on uneven ground. VISION REQUIREMENTS: Specific vision abilities may be required including close vision, distance vision, peripheral vision, depth perception and ability to adjust focus. DRIVING: Drives a car or truck up to 4 hours per day. LIFTING AND CARRYING: Frequently lifts up to 25 lbs, occasionally lifts up to 50 lbs and occasionally lifts over 50 lbs. Frequently carries up to 25 lbs, occasional carries up to 50 lbs and occasionally carries over 50 lbs. The type of objects lifted or carried are as follows: computer, laptops, technical and office equipment, boxes and supplies. PUSH AND PULL (PATIENT CARE AND NON-PATIENT CARE ACTIVITIES): Continuously uses maximum force when performing non-patient care activities. The types of objects that are pushed or pulled are as follows: equipment and carts, large devices on casters.

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.