Mercy Medical Center Clinton Data Developer Specialist in Livonia, Michigan


IS101_71527 Data Warehouse

Expected Weekly Hours:



Day Shift

Position Purpose:

The Data Developer Specialist is 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 CHE Trinity. This position requires advance technical skills to design, code and test complex transformations while maintaining existing environments. The role will develop data transformation solutions using Informatica PowerCenter, Data Services, Shell scripts and advance SQL. This position will also assist in database performance tuning including analyzing and tuning of complex SQL statements. The Data Developer Specialist will lead the data transformation solution life-cycle, transformation standards, best practices and procedures. This position will have a deep understanding of our customers and how they are using data to drive their business and achieve their goals. This role will also act as a mentor to fellow Junior Data Developers in helping to create a sustainable data warehouse ecosystem.

Job Description Details:

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.

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

Design, develops and support ETL solutions for BI and Analytics applications.

Responsible for identifying and tuning poor performing SQL.

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

Provide production support for data transformation jobs.

Identify and troubleshoots ETL performance issues.

Lead peer reviews of solution designs and related code reviews.

Design and deploy job workflows.

Mentor and help train junior Data Developers.

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

Complies with and monitors that ETL team adheres 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.

Actively 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 and regulations, Trinity Health Corporate Integrity Program, Code of Ethics, 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.

Trinity Health's Commitment to Diversity and Inclusion

Trinity Health employs about 133,000 colleagues at dozens of hospitals and hundreds of health centers in 22 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.

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

Trinity Health is one of the largest multi-institutional Catholic health care delivery systems in the nation, serving diverse communities that include more than 30 million people across 22 states. Trinity Health includes 94 hospitals, as well as 109 continuing care locations that include PACE programs, senior living facilities, and home care and hospice services. Its continuing care programs provide nearly 2.5 million visits annually.

Based in Livonia, Mich., and with annual operating revenues of $17.6 billion and assets of $24.7 billion, the organization returns $1.1 billion to its communities annually in the form of charity care and other community benefit programs. Trinity Health employs about 133,000 colleagues, including 7,800 employed physicians and clinicians.

Committed to those who are poor and underserved in its communities, Trinity Health is known for its focus on the country's aging population. As a single, unified ministry, the organization is the innovator of Senior Emergency Departments, the largest not-for-profit provider of home health care services — ranked by number of visits — in the nation, as well as the nation’s leading provider of PACE (Program of All Inclusive Care for the Elderly) based on the number of available programs. For more information, visit at . You can also follow @TrinityHealthMI on Twitter.