Employment Type:

Full time

Shift:

Day Shift

Description:

Responsible primarily for production support and optimization efforts while participating in new development with Product Engineering team.

Responsible for the production support, as well as 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. 

POSITION PURPOSE

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. 

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.
• 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.
• Performs other duties as assigned.

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 working with data development technologies such as Informatica, Data Stage or MS SSIS.
• Minimum of five (5) years' experience writing and tuning advance SQL.
• 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 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.