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., 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 EEO Statement Summary Morehouse School of Medicine is an equal opportunity/equal access/affirmative action employer fully committed to achieving a diverse workforce and complies with all Federal and Georgia State laws, regulations, and executive orders regarding non-discrimination and affirmative action. Morehouse School of Medicine does not discriminate on the basis of race, age, color, religion, national origin or ancestry, sex, gender, disability, veteran status, genetic information, sexual orientation, or gender identity or expression. 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. 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. Posting Specific Questions Required fields are indicated with an asterisk (*).

• • What is your highest level of completed education?
• High School/GED
• Associate’s Degree
• Bachelor’s Degree
• Master’s Degree
• EdD, MD, PhD, DrPH, JD
• • Are you comfortable working on-site? (Open Ended Question)
• • 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”). (Open Ended Question)
• • What is your date of availability? (Open Ended Question)
• • Please provide your salary requirement. Do Not Enter Negotiable, a specified salary range is required. Not providing a salary requirement will result in your application being incomplete and will not be considered. (Open Ended Question) Applicant Documents Required Documents
• Cover Letter

• Curriculum Vitae or Resume Optional Documents

• Other Document

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

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 ! Posting Number NONAC3794