ETL Developer

Morehouse School of Medicine

Atlanta (GA)

On-site

USD 85,000 - 120,000

Full time

5 days ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Morehouse School of Medicine in Atlanta, GA seeks an ETL Developer to design, code and support data integrations between the data warehouse and enterprise systems. You will build, monitor, and optimize ETL processes and ensure data quality across analytics platforms.

The role requires strong SQL/Java or C# skills, experience with Oracle or SQL Server, and familiarity with data warehousing tools and data transfer protocols (APIs, FTP/SFTP).

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 in a tech-forward org; 2+ years data & analytics development; 3+ years with Oracle or SQL Server; 2+ years with a data warehousing solution (Azure SQL Warehouse, Cognos, MicroStrategy); 3+ years building interfaces using API, FTP, SFTP; 3+ years Java or C#; experience using SQL Server integration tools.

Responsibilities

Design simple to complex data integrations between systems.
Work with Business Systems Analysts and end users to gather data transfer requirements.
Write SQLs and scripting as needed for integrations.
Analyze the company’s data needs.
Design and code the data warehousing system per specifications.
Maintain and improve existing ETL processes.
Test warehousing environment before data extraction.
Ensure data system works efficiently after transfer.
Collaborate with data management teams to deliver data.

Skills

ETL Development

Data Analytics

Oracle/SQL Server

Azure SQL Warehouse

APIs/FTP/SFTP

Java/C#

SQL Server Integration Tools

Education

Bachelor’s or Master’s Degree in Computer Science / Math / MIS / IT / Business

Tools

SSIS

Oracle

SQL Server

Job description

Please see Special Instructions for more details.

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.

Position Information

About MSM

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

Posting Number NONAC3794

Job Title

Job Title ETL Developer

Position Title

Position Title ETL Developer

Position Type

Position Type Non‑Faculty

Number of vacancies

Number of vacancies 1

Salary

Salary Commensurate with experience

Department

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

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

* 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)