Job Location: Livonia, MI
Employment Type
Full time
Shift
Day Shift
Description
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 are required 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. Participates in the data transformation solution life-cycle, transformation standards, best practices and procedures. Possesses a solid understanding of our customers and how they are using data to drive their business and achieve their goals. Serves as a mentor to lower level BI developers in helping to create a sustainable data services ecosystem.
Essential Functions
Develops ETL solutions for interfacing, data replication, and bulk load transfers and the integration of value added or data enhancement processes.
Utilizes and proficient in different data modeling methodologies including STAR, Snowflake, 3NF.
Designs, develops and supports ETL solutions for BI and Analytics applications.
Responsible for identifying and tuning poor performing SQL.
Provides production support for data transformation jobs.
Works in teams and in a self-directed work environment.
Participates in peer reviews of solution designs and related code reviews.
Designs and deploys job workflows.
Assists in training fellow Data Developers.
Works closely with the PMO to estimate level of effort for proposed projects.
Assists in developing new and complies with 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 participates in an On-Call rotation.
Creates and maintains technical documentation for data transformation procedures.
Ensures compliance of the vision and direction of the Data Warehouse and Advance Analytics 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 experience.
Minimum of five (5) years’ experience in Information Technology of which three (3) years’ experience working as Data Developer in a large data warehouse environment.
Minimum three (3) years’ experience working with Data Development technologies such as InformaticaTM, Data Stage, or MS SSIS etc.
Minimum of three (3) years’ experience writing and tuning advance SQL.
Demonstrated knowledge of healthcare nomenclature preferred.
Proficiency in different data modeling methodologies including STAR, Snowflake and 3NF.
Strong proficiency in leading technical projects, assignments and analysis.
Ability to interface with manager 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.
Demonstrated ability to interact effectively across capability group boundaries.
- Experience in working with ODI and OBIEE/OAC
- Hands on experience in development and customizations for OBIA ODI and OBIEE
- Experience in working with ODI/BI analysis for designing DWH
- Knowledge in integrating multiple data sources to load into Enterprise DWH
- OBIA, OBIEE/OAC, ODI Certifications are plus
- Preferred Qualifications: OUA, Oracle Data Integrator(ODI), Oracle BI Applications (OBIA), Oracle BI, OAS, BIP, BIAPPS, PL/SQL
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.
00369353
Submit CV To All Data Science Job Consultants Across United States For Free
