Palo Alto, California
Palo Alto, California
Durham, North Carolina
Hinsdale, Illinois
Cincinnati, Ohio
Washington, D.C.
Posted: 23-Jun-22
Location: Altamonte Springs, Florida
Salary: Open
Categories:
Internal Number: 22013857
Description
All the benefits and perks you need for you and your family:
- Benefits from Day One
- Paid Days Off from Day One
- Student Loan Repayment Program
- Career Development
- Whole Person Wellbeing Resources
- Mental Health Resources and Support
Our promise to you:
Joining AdventHealth is about being part of something bigger. It’s about belonging to a community that believes in the wholeness of each person, and serves to uplift others in body, mind and spirit. AdventHealth is a place where you can thrive professionally, and grow spiritually, by Extending the Healing Ministry of Christ. Where you will be valued for who you are and the unique experiences you bring to our purpose-minded team. All while understanding that together we are even better.
Schedule: Full Time
The role you’ll contribute:
The primary responsibility of this position includes evaluating requirements, designing, developing, validating, and implementing ETLs (data integration processes) primarily using Oracle Data Integrator (ODI) and SQL.
The value you’ll bring to the team:
- Responsible for the development of ETLs for current and future applications and data needs
- Establish a deep understanding of existing data models, and data and reporting needs
- Develop solutions that utilize the highest standards of analytical rigor and data integrity.
- Own the design, development, and maintenance of ETLs that produce the data used for reporting.
- Recognize and adopt best practices in the ETL development life cycle: data integrity, test design, analysis, validation, and documentation.
- Monitor and tune the performance of the ODI environment
- Monitor, respond and resolve tickets and issues submitted by users
- Train and mentor team members on data integration development as necessary
The expertise and experiences you’ll need to succeed:
KNOWLEDGE AND SKILLS REQUIRED:
- At least three years of experience developing ETL processes using ODI
- Expert knowledge of ETL / data integration standards
- Experience using databases in a business environment with large-scale, complex datasets
- Previous success in designing and developing ETLs
- Mastery of stored procedures, SQL coding, queries
- ETL performance tuning
- Ability to clearly articulate ideas, technical concepts, and obstacles with technical and non-technical team members
- Must maintain a global perspective while being detail-oriented
- Organized and have experience in multi-tasking
- Customer-service driven attitude
- Candidate should be familiar with the systems development life cycle (SDLC) standards
- Flexible in the face of changing requirements and priorities
- 5 - 8 years of experience with relational data structures, theories, principles, and practices.
- Comprehensive understanding of Data Warehouse design principles
- Strong communication skills
- Ability to assimilate information rapidly
- Ability to work under time constraints
- Capacity to develop a clear understanding of the business needs and incorporate these needs into technical solutions
- Strong problem solving and analytical skills
- Advanced SQL query techniques
- Mastery of stored procedures, SQL coding, queries
- ETL performance tuning
- Ability to proactively identify, troubleshoot and resolve complex data integrity issues
KNOWLEDGE AND SKILLS PREFERRED:
- BI development experience utilizing BI platforms tools such as OBIEE, QlikView, or Power BI
- Experience working in an OBIA environments is a plus
- Peoplesoft systems experience
- Knowledge of other Hyperion tools (HFM, Essbase) is a plus
- Healthcare industry experience
EDUCATION AND EXPERIENCE REQUIRED:
Minimum Bachelor’s degree in Management Information Systems, Computer Science, Business, similar major, or equivalent technology and business experience.
