Remote Data Analyst Sql Excel Jobs in Center Line, MI

Purpose

Responsible for the data capture, analysis & reporting of data information to assist the Trinity Health leadership team achieve operational efficiency. Responsible for auditing department information, producing reports & suggesting improvements to processes. Provides knowledge & expertise in the program, services & applications.

Note: "patients" refers to patients, clients, residents, participants, customers, members

Essential Functions

Our Trinity Health Culture: Knows, understands, incorporates & demonstrates our Trinity Health Mission, Values, Vision, Actions & Promise in behaviors, practices & decisions.

Work Focus:

Research, collects & analyzes information. Identifies opportunities, develops solutions, & leads through resolution.

Collaborates on performance improvement activities as indicated by outcomes in program efficiency & patient experience.

Responsible for distribution of analytical reports.

Process Focus:

Utilizes multiple system applications to perform analysis, create reports & develop educational materials.

Incorporates basic knowledge of Trinity Health policies, practices & processes to ensure quality, confidentiality & safety are prioritized.

Demonstrates knowledge of departmental processes & procedures & ability to readily acquire new knowledge.

Data Management & Analysis:

Research & compiles information to support ad-hoc operational projects & initiatives.

Synthesizes & analyzes data & provides detailed summaries including graphical data presentations illustrating trends & recommending practical options or solutions while considering the impact on business strategy & supporting leadership decision making.

Leverages program & operational data & measurements to define & demonstrate progress, ROI & impacts.

Maintains a Working Knowledge of applicable federal, state & local laws / regulations, Trinity Health Integrity & Compliance Program & Code of Conduct, as well as other policies, procedures & guidelines in order to ensure adherence in a manner that reflects honest, ethical & professional behavior & safe work practices.

Functional Role (not inclusive of titles or advancement career progression)

The Strategic Sourcing Analyst plays a key role in the day-to-day operations within the Strategic Sourcing division of Supply Chain Management. This role provides strategic support to the Sourcing Managers via a variety of essential activities with focus on supporting the division in obtaining annual financial goals. The responsibilities of the Analyst are complex and varied but include functions ranging from handling the competitive bidding process for low to low-medium risk (but high volume) projects involving direct & indirect commodities and/or services; drafting contracts, contract amendments, and RFP/RFQ information. Works independently and receives general direction and guidance from sourcing manager.

• Maintains knowledge of the Group Purchasing Organization's (GPO) and Trinity's contract portfolio to leverage and utilize appropriate agreements. Coordinates and maintains system compliance by optimizing these agreements. Has a thorough understanding of the review and analysis process to ensure a timely turn around on agreement approvals.

• Works closely with the legal department and sourcing manager in the drafting and analyzing of communications between the organization and contracted partners. Communications may include a variety of items such as routine correspondence, contract amendments, and business agreements. Responsible for ensuring correct distribution, tracking, and understanding of said communications. Handles or assists in handling contract compliance issues based on complexity.
• In conjunction with Sourcing Managers, supports competitive bidding process on direct and indirect supplies/services/equipment; pre-qualifies suppliers, supports RFP/RFI creation, accumulates responses, reviews product/service information to determine applicability and any outliers.
• Drafts and completes execution of amendments to extend contract terms, participation of facilities, addition of products/or services, or other amendment requirements, as determined by contract requirements or as directed by Sourcing management leadership.
• Responsible to complete contract lifecycle management system contract request, tier reporting, SIPs and Eloc.
• Collects, cleans, and validates large datasets from multiple sources to ensure accuracy and integrity. Analyzes data to identify trends, patterns, and anomalies that inform business strategies. Develops and maintains dashboards, reports, and visualizations using tools such as Power BI, Tableau, Excel or similar platforms. Performs ad-hoc analysis and provides actionable recommendations to stakeholders.
• Conducts category assessments including spend analysis, demand forecasting, supply market intelligence, and risk evaluation to identify value creation opportunities.
• Readily speaks to the year over year spend differences and challenges within assigned portfolio.
• Independently pursues contract optimization opportunities and brings opportunity assessments forward to the Sourcing Leadership team.
• Analyzes markets to determine vendor sources and product/service/equipment/ITavailability. Supports development of fact bases for major purchasing categories, including detailed understanding of descriptions of the product/service/equipment/IT offerings and price points; recommended suppliers; understanding capabilities of current suppliers.
• Using working knowledge of contract construction, reviews, red lines and drafts language for discussion. Close working relationships with legal for contract issues requiring legal input.
• Ensures effective handoff of executed contracts to business owner, Supply Chain verticals, and other stakeholder departments as applicable. This includes accurate PO placement, broad understanding of contract value and milestones, and implementation expectations.
• Lends support for sourcing and contract management system(s). May include duties such as supervising audits on database information, producing reports from contract management system, reviewing information input by Sourcing Manager, suggesting processes to increase efficiency and effectiveness of contract systems and overall general support of processes surrounding contract management.
• Works with other Supply Chain verticals to support processes and procedures that optimize the value of the Trinity Health-Supplier relationship.
• Serves as a contact for RHM management team members as it relates to purchasing/sourcing issues. Provides guidance and investigates issues raised by ministries related to contracts.
• Supports and contributes to process improvement that provides cost savings, increased efficiency and enhanced customer service.
• Performs other duties as assigned.

Minimum Qualifications

• Bachelor's degree with major course work in business, supply chain management, or data science and at least 3 (three) years of sourcing experience or an equivalent combination of education and work experience.
• Comprehensive knowledge and skills in advanced data analytics and procurement practices including intermediate to advanced excel skills, knowledge of Power BI, Tableau, or similar applications.
• Strong analytical skills, attention to detail, and the ability to communicate complex findings in a clear and concise manner. The ideal candidate is highly proficient in data visualization, statistical analysis, and business intelligence tools.
• Knowledge of methods used in the access and use of information, the preparation of specifications, and the analysis of bids and contracts. Ability to set standards for and create and maintain accurate records and reports.
• Ability to identify problems, utilize originality and ingenuity to make recommendations and decisions, and implement solutions. Demonstrated ability to identify, investigate, analyze, and resolve complex issues.
• Excellent verbal and written communication skills.
• Strong problem-solving skills with the ability to research problems and present findings with attention to detail and a high degree of accuracy.
• Solid customer service qualities along with excellent interpersonal skills. Must be comfortable operating in a collaborative, shared leadership environment. Must have the ability to work effectively in a large, multi-level, geographically dispersed organization.
• Ability to establish and maintain productive and positive working relationships with all stakeholders and external suppliers. Ability to work independently and in collaboration with others.
• Proven prioritization, multi-tasking, and coordination skills within a fast-paced environment. Strong organizational skills and high level of initiative.
• Personal presence 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.

.

Additional Qualifications (nice to have)

• Healthcare industry experience is preferred.

Physical & Mental Requirements & Working Conditions (General Summary)

Direct Healthcare Services / Indirect Healthcare / Support Services:

• Exposure to conditions which may be considered unpleasant to sight, touch, sound & / or smell. Occasional
• Exposure to fumes, odors, dusts, mists & gases, biohazards / hazards (mechanical, electrical, burns, chemicals, radiation, sharp objects, etc.). Occasional
• Exposure to or subject to noise, infectious waste, diseases & conditions. Occasional
• Exposure to interruptions, shifting priorities & stressful situations. Frequent
• Ability to follow tasks through to completion, understand & relate to complex ideas / concepts, remember multiple tasks & regimens over long periods of time & work on concurrent tasks / projects. Continuous
• Ability to read small print, hear sounds & voice / speech patterns, give / receive instructions & other verbal communications (in-person & / or over the phone / computer / device / equipment assigned) with some background noise. Continuous
• Perform manual dexterity activities & / or grasping / handling. Occasional
• Ability to climb, kneel, crouch & / or operate foot controls. Occasional
• Use a computer / other technology. Continuous
• Sit with the ability to vary / adjust physical position or activity. Frequent
• Maintain a safe working environment & use available personal protective equipment (PPE). Occasional
• Comply with applicable Code of Conduct, policies, procedures & guidelines. Continuous
• Ability to provide assistance in the event of an emergency. Occasional

Direct Healthcare Services:

• Perform activities that require standing / walking with the ability to vary / adjust physical position or activity. Occasional
• Lift a maximum of 30 pounds unassisted. Occasional
• Use upper & lower extremities, engage in bending / stooping / reaching & pushing / pulling. Occasional
• Work indoors (subject to travel requirements) under temperature-controlled & well-lit conditions. Continuous
• Encounter worksites (e.g., patient homes) or travel to worksites that may have variable internal & external environmental conditions. Occasional
• Perform work that involves physical efforts (e.g., transporting, moving, positioning & / or ambulating patients). Occasional

Indirect Healthcare / Support Services:

• Perform activities that require standing / walking with the ability to vary / adjust physical position or activity. Occasional
• Lift a maximum of 30 pounds unassisted. Occasional
• Experience of long periods of walking / standing / stooping / bending / pulling & / or pushing. Occasional
• Encounter a clinical / patient facing / hands on interactive work environment. Occasional
• Work indoors (subject to travel requirements) under temperature-controlled & well-lit conditions. Continuous
• Work outdoors with variable external environmental conditions. Occasional

Average Workday Activity: Occasional - O (1% - 33%), Frequent - F (34% - 66%), Continuous - C (67% - 100%)

Our Commitment

Rooted in our Mission and Core Values, we honor the dignity of every person and recognize the unique perspectives, experiences, and talents each colleague brings. By finding common ground and embracing our differences, we grow stronger together and deliver more compassionate, person-centered care. We are 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, veteran status, or any other status protected by federal, state, or local law.