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 is responsible for the design, connection, scheduling and deployment of data integration components, including workflows, sessions, and mappings, in accordance with standards and best practices. Assists in developing and setting the standards and best practices for the organization. Provides data analysis and validation, and will engage in gathering of requirements for Extract, Transform, Load (ETL) solutions, collaborating with business and technology departments to understand system data and its use, and providing support around the data and how it is integrated. Monitors production systems for issues and resolves issues as needed. Provides assistance in data modeling and data warehouse design and provides assistance to define structure of targets for ETL processes. Provides mentoring and assistance to DI analysts and associates and develop a deep understanding of the data, its use, and the structure of both source and target systems.
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 Ochsner’s discretion.

EDUCATION

Required - Bachelor’s degree

WORK EXPERIENCE

Required - 3 year of SQL experience, data analysis and data profiling; relational database systems and data extraction, transformation of data and loading data
Preferred - 3 years of Oracle SQL experience, data analysis and data profiling
3 years of Oracle relational database systems
3 years of data extraction, transformation of data and loading data using Informatica

KNOWLEDGE SKILLS AND ABILITIES (KSAS)

• Must have computer skills and dexterity required for data entry and retrieval of information.
• Effective verbal and written communication skills and the ability to present information clearly and professionally.
• Must be proficient with Windows-style applications, various software packages specific to role and keyboard.
• Strong interpersonal skills.
• Familiarity with dimensional modeling (Ralph Kimball), business intelligence concepts.
• Excellent problem solving skills.
• Ability to work effectively in a rapidly changing, team-based environment.
• Ability to work flexible hours including occasional evenings, weekends, and holidays.

• Develop data architecture, data modeling and ETL mapping solutions within the data warehouse environment.
• Maintain and develop documentation to identify and define processes or procedures.
• Manages data by following best practices.
• Supports and monitors ETL systems.
• Administration of Data Integration server and/or processes.
  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.
  Complies with the Ochsner Health System 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.
  Ochsner 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.