Posting Details
Position Information
Posting Number
NONAC3794
Job Title
ETL Developer
Position Title
ETL Developer
Position Type
Non-Faculty
Number of vacancies
1
Salary
Commensurate with experience
Department
Information Technology
Position Summary
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.
Minimum Qualifications
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.
Experience:
• 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.
Preferred Qualifications
Workday implementation and/or Integration experience preferred
Closing Date
Open Until Filled
Yes
Special Instructions to Applicants
Employment in this role may be contingent upon extramural funding and successful performance and may be terminated or reduced in percentage of appointment if such funding is not secured or ceases to be available.
Quick Link
https://careers.msm.edu/postings/24569
Job Duties
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.
