Ochsner Health
IS Data Integration Developer
Ochsner Health, New Orleans, Louisiana, United States, 70123
We've made a lot of progress since opening the doors in 1942, but one thing has never changed - our commitment to serve, heal, lead, educate, and innovate. We believe that every award earned, every record broken and every patient helped is because of the dedicated employees who fill our hallways.
At Ochsner, whether you work with patients every day or support those who do, you are making a difference and that matters. Come make a difference at Ochsner Health and discover your future today!
This job supports, develops, and maintains Extract, Transform and Load (ETL) solutions in a data warehouse environment that includes ancillary data stores. Develops extracts, dashboards, reports, and data solutions, and uses tools like Informatica. Creates workflows, sessions, and mappings in accordance with standards and best practices. Analyzes data, validates data quality, gathers requirements, conducts data modeling and data warehouse design and contributes to the creation of supporting documentation. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential duties.
This job description is a summary of the primary duties and responsibilities of the job and position. It is not intended to be a comprehensive or all-inclusive listing of duties and responsibilities. Contents are subject to change at the company's discretion.
Education
Required - High school diploma or equivalent.
Preferred - Master's degree in computer science or related field.
Work Experience
Required - 4 years of experience with development, data extraction, ETL using an Enterprise tool, SQL programming language, data analysis, data profiling or related,
OR
1 year of experience with SQL programming language, data analysis and data profiling, 2 years of experience with data extraction or ETL using an Enterprise tool, and 1 year of experience in development with bachelor's degree in computer science or related field.
Preferred - 1 year of experience with a formal development methodology like Scrum Agile developing on a Massively Parallel Processing (MPP) database working with a project or task tracking tool and ETL tool like Informatica PowerCenter 9.x,10.x, DataStage, or SQL server Integration Services (SSIS).
Knowledge Skills and Abilities (KSAs) Proficiency in using computers, software, and web-based applications, and willingness to learn new technologies. Proficient in PL/SQL database/programming languages for creating and maintaining Data Definition Language (DDL) and Data Manipulation Language (DML) code. Strong knowledge of ETL and ETL tools and ability to create, maintain and execute test plans for ETL streams. Analytical, design, and development skills and ability to modify or expand information systems. Effective verbal and written communication, interpersonal, and customer service skills and the ability to collaborate with the team, internal business and technology departments as well as external vendors. Problem solving skills and ability to be self-motivated, work independently, and pay close attention to detail, accuracy of facts and documentation. Excellent organizational and time management skills and ability to follow through on tasks in a timely manner and effectively manage multiple priorities. Job Duties
Contributes to the development of data architecture and data modeling, including developing extracts, dashboards, reports, and data solutions, and uses tools like Informatica. Creates workflows and sessions and develops ETL mapping solutions within the data warehouse environment following current processes. Maintains and develops documentation to identify and define processes, monitors production systems for issues and escalates or resolves issues. Analyzes data, validates data quality, gathers requirements, conducts data modeling and data warehouse design; and contributes to the creation of supporting documentation in accordance with best practices. Supports and monitors ETL systems and data integration server. Manages and completes projects as needed. Performs other related duties as required.
The above statements describe the general nature and level of work only. They are not an exhaustive list of all required responsibilities, duties, and skills. Other duties may be added, or this description amended at any time.
Remains knowledgeable on current federal, state and local laws, accreditation standards or regulatory agency requirements that apply to the assigned area of responsibility and ensures compliance with all such laws, regulations and standards.
This employer maintains and complies with its Compliance & Privacy Program and Standards of Conduct, including the immediate reporting of any known or suspected unethical or questionable behaviors or conduct; patient/employee safety, patient privacy, and/or other compliance-related concerns.
The employer is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.
Physical and Environmental Demands
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.
Sedentary Work - Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently (Frequently: activity or condition exists from 1/3 to 2/3 of the time) to lift, carry, push, pull, or otherwise move objects. Sedentary work involves sitting most of the time but may involve walking or standing for brief periods of time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
Normal routine involves no exposure to blood, body fluid or tissue and as part of their employment, incumbents are not called upon to perform or assist in emergency care or first aid.
The incumbent has no occupational risk for exposure to communicable diseases.
Because the incumbent works within a healthcare setting, there may be occupational risk for exposure to hazardous medications or hazardous waste within the environment through receipt, transport, storage, preparation, dispensing, administration, cleaning and/or disposal of contaminated waste. The risk level of exposure may increase depending on the essential job duties of the role.
Are you ready to make a difference? Apply Today!
Ochsner Health does not consider an individual an applicant until they have formally applied to the open position on this careers website.
Individuals who reside in and will work from the following areas are not eligible for remote work position: Colorado, California, Hawaii, Maryland, New York, Washington, and Washington D.C.
Ochsner Health endeavors to make our site accessible to all users. If you would like to contact us regarding the accessibility of our website, or if you need an accommodation to complete the application process, please contact our HR Employee Solution Center at 504-842-4748 (select option 1) or
careers@ochsner.org
. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.
We are proud to be an Equal Employment Opportunity and Affirmative Action employer. We are committed to the principles of equal employment opportunity and providing a workplace that is free from discrimination based on race, color, creed, religion, pregnancy status, pregnancy-related conditions, national origin, ancestry, mental or physical disability, medical condition, age, veteran status, military status, citizenship status, marital status, familial status, sexual orientation, gender, gender identity or expression, genetic information, political affiliation, unemployment status, or any other characteristic protected under applicable federal, state or local law. These protections extend to applicants and all employment related decisions. View the
EEO is the Law poster
and its
supplement , as well as the
pay transparency policy
for more information.
Affirmative Action Policy Statement
At Ochsner, whether you work with patients every day or support those who do, you are making a difference and that matters. Come make a difference at Ochsner Health and discover your future today!
This job supports, develops, and maintains Extract, Transform and Load (ETL) solutions in a data warehouse environment that includes ancillary data stores. Develops extracts, dashboards, reports, and data solutions, and uses tools like Informatica. Creates workflows, sessions, and mappings in accordance with standards and best practices. Analyzes data, validates data quality, gathers requirements, conducts data modeling and data warehouse design and contributes to the creation of supporting documentation. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential duties.
This job description is a summary of the primary duties and responsibilities of the job and position. It is not intended to be a comprehensive or all-inclusive listing of duties and responsibilities. Contents are subject to change at the company's discretion.
Education
Required - High school diploma or equivalent.
Preferred - Master's degree in computer science or related field.
Work Experience
Required - 4 years of experience with development, data extraction, ETL using an Enterprise tool, SQL programming language, data analysis, data profiling or related,
OR
1 year of experience with SQL programming language, data analysis and data profiling, 2 years of experience with data extraction or ETL using an Enterprise tool, and 1 year of experience in development with bachelor's degree in computer science or related field.
Preferred - 1 year of experience with a formal development methodology like Scrum Agile developing on a Massively Parallel Processing (MPP) database working with a project or task tracking tool and ETL tool like Informatica PowerCenter 9.x,10.x, DataStage, or SQL server Integration Services (SSIS).
Knowledge Skills and Abilities (KSAs) Proficiency in using computers, software, and web-based applications, and willingness to learn new technologies. Proficient in PL/SQL database/programming languages for creating and maintaining Data Definition Language (DDL) and Data Manipulation Language (DML) code. Strong knowledge of ETL and ETL tools and ability to create, maintain and execute test plans for ETL streams. Analytical, design, and development skills and ability to modify or expand information systems. Effective verbal and written communication, interpersonal, and customer service skills and the ability to collaborate with the team, internal business and technology departments as well as external vendors. Problem solving skills and ability to be self-motivated, work independently, and pay close attention to detail, accuracy of facts and documentation. Excellent organizational and time management skills and ability to follow through on tasks in a timely manner and effectively manage multiple priorities. Job Duties
Contributes to the development of data architecture and data modeling, including developing extracts, dashboards, reports, and data solutions, and uses tools like Informatica. Creates workflows and sessions and develops ETL mapping solutions within the data warehouse environment following current processes. Maintains and develops documentation to identify and define processes, monitors production systems for issues and escalates or resolves issues. Analyzes data, validates data quality, gathers requirements, conducts data modeling and data warehouse design; and contributes to the creation of supporting documentation in accordance with best practices. Supports and monitors ETL systems and data integration server. Manages and completes projects as needed. Performs other related duties as required.
The above statements describe the general nature and level of work only. They are not an exhaustive list of all required responsibilities, duties, and skills. Other duties may be added, or this description amended at any time.
Remains knowledgeable on current federal, state and local laws, accreditation standards or regulatory agency requirements that apply to the assigned area of responsibility and ensures compliance with all such laws, regulations and standards.
This employer maintains and complies with its Compliance & Privacy Program and Standards of Conduct, including the immediate reporting of any known or suspected unethical or questionable behaviors or conduct; patient/employee safety, patient privacy, and/or other compliance-related concerns.
The employer is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.
Physical and Environmental Demands
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.
Sedentary Work - Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently (Frequently: activity or condition exists from 1/3 to 2/3 of the time) to lift, carry, push, pull, or otherwise move objects. Sedentary work involves sitting most of the time but may involve walking or standing for brief periods of time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
Normal routine involves no exposure to blood, body fluid or tissue and as part of their employment, incumbents are not called upon to perform or assist in emergency care or first aid.
The incumbent has no occupational risk for exposure to communicable diseases.
Because the incumbent works within a healthcare setting, there may be occupational risk for exposure to hazardous medications or hazardous waste within the environment through receipt, transport, storage, preparation, dispensing, administration, cleaning and/or disposal of contaminated waste. The risk level of exposure may increase depending on the essential job duties of the role.
Are you ready to make a difference? Apply Today!
Ochsner Health does not consider an individual an applicant until they have formally applied to the open position on this careers website.
Individuals who reside in and will work from the following areas are not eligible for remote work position: Colorado, California, Hawaii, Maryland, New York, Washington, and Washington D.C.
Ochsner Health endeavors to make our site accessible to all users. If you would like to contact us regarding the accessibility of our website, or if you need an accommodation to complete the application process, please contact our HR Employee Solution Center at 504-842-4748 (select option 1) or
careers@ochsner.org
. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.
We are proud to be an Equal Employment Opportunity and Affirmative Action employer. We are committed to the principles of equal employment opportunity and providing a workplace that is free from discrimination based on race, color, creed, religion, pregnancy status, pregnancy-related conditions, national origin, ancestry, mental or physical disability, medical condition, age, veteran status, military status, citizenship status, marital status, familial status, sexual orientation, gender, gender identity or expression, genetic information, political affiliation, unemployment status, or any other characteristic protected under applicable federal, state or local law. These protections extend to applicants and all employment related decisions. View the
EEO is the Law poster
and its
supplement , as well as the
pay transparency policy
for more information.
Affirmative Action Policy Statement