Employment Type:

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 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.
• Develop and deliver robust data solutions by leveraging data warehouses, advanced data analytics, and Azure platform best practices
• Structure data aligned with the Medallion Architecture in Azure Synapse and Microsoft Fabric
• Maintain rigorous data validation processes to guarantee the accuracy and reliability of data across all systems and reports
• Leverage automation and orchestration tools to streamline the implementation processes
• Refine data with notebooks, dataflows, and data factory within Microsoft Synapse and Fabric
• pay grade 15 range 96,319.82-144,479.7275
   

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.
• Hands-on experience working with Azure Synapse or Microsoft Fabric
• Advanced knowledge of T-SQL
• Experience with Azure data services, including Azure Data Lake, SQL, and Data Factory
• Experience with parquet files formats and delta lakes
• Experience with practical applications of Python for data transformations and notebooks
• Experience with Microsoft Purview or similar data governance platform
• Familiarity with Medallion Architecture concepts like bronze, silver, and gold layers
• Knowledge of DevOps processes and version control fundamentals

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.