ETL Developer

In support of Morehouse School of Medicine’s Vision; “Leading the creation and advancement of health equity,” the Department of Information Technology is seeking an ETL Developer., The ETL Developer will design, code and support multiple integrations. They will be a critical component in the movement of data between the data warehouse and all other systems at Morehouse School of Medicine. The developer will be responsible for building, monitoring, and supporting all data translations and transfer protocols., Description of Job Duty

• Designing simple to complex integrations between systems
• Work with Business Systems Analysts and end users to gather requirements for needed data transfers.
• Write SQLs and scripting as needed for integrations
• Analyzing the company’s data needs
• Designing and coding the data warehousing system adjusted to the company’s specifications
• Maintaining and improving the existing ETL processes
• Controlling preliminary testing of the warehousing environment before extracting data
• Ensuring that the data system works efficiently once the data is transferred
• Working with data management teams on delivering the needed data.
• Coding integrations using multiple programming and scripting languages
• Writing SQLs to extract data from databases when needed.
• Transferring Data using multiple data transfer methods.

The above statements describe the general nature and level of work being performed by individuals assigned to this classification. This is not intended to be an exhaustive list of all responsibilities and duties required of personnel so classified.

Pre-Employment/Employment Requirements

All offers of employment are contingent upon successful completion of all pre-employment screenings. Immunization

Immunization Requirements It is MSM’s Immunization policy that all Prospective Employees are encouraged to provide proof that they are vaccinated against COVID-19 prior to commencement of employment. If employment will commence during Flu Season, MSM requires all individuals to provide proof that they are vaccinated against Seasonal Influenza for the current Flu Season, unless granted an exemption. Failure to provide proof of vaccination for any required vaccines or obtain an exemption from MSM will result in rescission of a candidate’s offer of employment or disciplinary action up to and including termination.

Education: * Bachelor’s or master’s degree in Computer Science, Math, MIS, Information Technology, Business or related field. Degree must be from a regionally accredited college or university., * 3+ years as a developer within a technology-driven organization

• 2+ years of data & analytics development or comparable experience
• 3+ years working with either Oracle or SQL Server Databases
• 2+ years of experience working with a commercial data warehousing analytical solution (Azure SQL Warehouse, COGNOS, MicroStrategy etc…)
• 3+ years of experience building interfaces using (API, FTP, SFTP) data transfer methods
• 3+ years of experience in Java or C#
• Experience using SQL Server integration tools., Workday implementation and/or Integration experience preferred, + High School/GED
• Associate’s Degree
• Bachelor’s Degree
• Master’s Degree
• EdD, MD, PhD, DrPH, JD 2. * Are you comfortable working on-site? (Open Ended Question)

1. • Please describe your experience with database management and complex data extraction for creation of inclusion cohorts and analytic files using SAS, SQL, and Oracle ODBC in an encrypted data server environment. Include the number of years of experience. (Do Not Enter “SEE RESUME”).

Morehouse School of Medicine (MSM) is a place of distinction, serving as the nation’s leading academic medical center for vulnerable populations. It’s also a place for passionate individuals looking to join a dedicated community working today to help prepare tomorrow’s leaders.

We exist to:

• Improve the health and well-being of individuals and communities;
• Increase the diversity of the health professional and scientific workforce;
• Address primary health care through programs in education, research and service; With emphasis on people of color and the under-served urban and rural populations in Georgia, the nation and the world.

At Morehouse School of Medicine, we’re leading the creation and advancement of health equity. You will find a fulfilling career at MSM!