Employment Type:

　　Full time

　　Shift:

　　Day Shift

　　Description:

　　Responsible for the development, testing and documentation of complex data transformations and services to enable the analysis of information to support strategic initiatives and ongoing business requirements for Trinity Health. Advanced technical skills in order to design, code and test complex transformations while maintaining existing environments. Develops data transformation solutions using Informatica PowerCenter, Data Services, Shell scripts and advance SQL. Assists in database performance tuning including analyzing and tuning of complex SQL statements. Leads the data transformation solution life-cycle, transformation standards, best practices and procedures. Possess a deep understanding of our customers and how they are using data to drive their business and achieve their goals. Serve as a mentor to fellow entry Data Developers in assisting in the creation of a sustainable data warehouse ecosystem.

　　(Junior level opportunity possible.)

　　ENVIRONMENT

　　Environment: Oracle Data Integrator 12c, Oracle 11g/12c, Oracle BI Applications (OBIA), Oracle Cloud Infrastructure (OCI), SQL Developer/Toad, OBIEE/Oracle Analytics Cloud (OAC)/Data Visualizer, Control-M, Jira, Microsoft Teams, Microsoft Office.

　　PREFERRED QUALIFICATIONS

　　Experience working with Oracle Data Integrator (ODI) 12c, Oracle 11g/12c, Oracle BI Applications (OBIA), Oracle Cloud Infrastructure (OCI) a plus

　　Familiarity with Oracle Repository Middleware, OAC, Data Visualizer and Control-M scheduler a plus.

　　Prefer familiarity with OAC/OBIEE and RPD design/development

　　Experience with Microsoft Teams for video conferencing, chat, file sharing and other collaboration.

　　Demonstrated knowledge of healthcare nomenclature.

　　Familiar with Agile Methodology. Previous experience working in JIRA.

　　Experience and familiarity with PeopleSoft.

　　ESSENTIAL FUNCTIONS

　　Provides leadership on technical projects, assignments and analysis. Develops complex ETL solutions for interfacing, data replication, and bulk load transfers and or near-real-time processes and the integration of value added or data enhancement processes.

　　Utilizes and serves as an expert in different data modeling methodologies including STAR, Snowflake and 3NF.

　　Designs, develops and supports ETL solutions for BI and Analytics applications.

　　Responsible for identifying and tuning poor performing SQL.

　　Works in teams and in a self-directed work environment.

　　Provides production support for data transformation jobs.

　　Identifies and troubleshoots ETL performance issues.

　　Leads peer reviews of solution designs and related code reviews.

　　Designs and deploys job workflows.

　　Mentors and assists in training entry Data Developers.

　　Works closely with the PMO to estimate level of effort for proposed projects.

　　Complies with and monitors ETL team adherence to established standards and procedures related to development activities (e.g., coding standards, version control, change management, etc.).

　　Continues to develop data transformation skills by researching new technologies and best practices.

　　Provides daily support for ETL processes and extracts and participates in an On-Call rotation. Defines, maintains and improves standards and processes for ETL and related tools.

　　Creates and maintains technical documentation for data transformation procedures.

　　Works closely with Architecture ensuring implementation of ETL best practices and designs.

　　Reinforces the vision and direction of the Enterprise Informatics Organization.

　　Initiates opportunities to learn and grow. Handles multiple demands, shifting priorities, crises and rapid change.

　　Cultivates working relationships within the Informatics Organization and with the business units that are positive, professional and collaborative.

　　Knows, understands, incorporates and demonstrates the Trinity Health Mission, Vision and Values in leadership behaviors, practices and decisions.

　　Performs other duties as assigned.

　　Maintains a working knowledge of applicable Federal, State and local laws/regulations; the Trinity Health Integrity and Compliance Program and Code of Conduct; as well as other policies and procedures in order to ensure adherence in a manner that reflects honest, ethical and professional behavior.

　　MINIMUM QUALIFICATIONS

　　Bachelor's degree in healthcare or information technology or an equivalent combination of education and/or experience.

　　Minimum of seven (7) years' experience in Information Technology of which five (5) years' experience is working as a Data Developer in a large data warehouse and business intelligence environment.

　　Minimum of five (5) years' experience writing and tuning advance SQL.

　　Minimum of five (5) years' experience working with data development technologies.

　　Demonstrated knowledge of healthcare nomenclature, preferred.

　　Expertise in different data modeling methodologies including STAR, Snowflake and 3NF.

　　Strong proficiency in leading technical projects, assignments and analysis.

　　Interfaces with director level and staff positions.

　　Experience working with multiple healthcare business disciplines including Operations, Finance, Clinical and Administration.

　　Excellent organization, analytical, interpersonal, written and verbal communication skills.

　　A personal presence which is characterized by a sense of honesty, integrity and caring with the ability to inspire and motivate others to promote the philosophy, mission, vision, goals and values of Trinity Health.

　　PHYSICAL AND MENTAL REQUIREMENTS AND WORKING CONDITIONS

　　This position operates in a typical office environment. The area is well-lit, temperature-controlled and free from hazards.

　　Incumbent communicates frequently, in person and over the telephone, with people in a number of different locations on technical issues.

　　Manual dexterity is needed in order to operate a keyboard.

　　Hearing is needed for extensive telephone and in person communications.

　　The environment in which the incumbent will work requires the ability to concentrate, meet deadlines, work on several projects at the same period and adapt to interruptions.

　　The incumbent must be capable of traveling in the course of completing project assignments.

　　Ability to meet established deadlines.

　　The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of duties so assigned.

　　Our Commitment to Diversity and Inclusion

　　Trinity Health is one of the largest not-for-profit, Catholic healthcare systems in the nation. Built on the foundation of our Mission and Core Values, we integrate diversity, equity, and inclusion in all that we do. Our colleagues have different lived experiences, customs, abilities, and talents. Together, we become our best selves. A diverse and inclusive workforce provides the most accessible and equitable care for those we serve. Trinity Health 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, disability, status as a protected veteran, or any other status protected by law.

　　Our Commitment to Diversity and Inclusion

　　Trinity Health is a family of 115,000 colleagues and nearly 26,000 physicians and clinicians across 25 states. Because we serve diverse populations, our colleagues are trained to recognize the cultural beliefs, values, traditions, language preferences, and health practices of the communities that we serve and to apply that knowledge to produce positive health outcomes. We also recognize that each of us has a different way of thinking and perceiving our world and that these differences often lead to innovative solutions.

　　Our dedication to diversity includes a unified workforce (through training and education, recruitment, retention, and development), commitment and accountability, communication, community partnerships, and supplier diversity.

　　EOE including disability/veteran