Operations Data Analyst

Provides support to the Financial Planning & Analysis (FP&A) area by collecting, analyzing and interpreting data. This position executes and supports data management, reporting and analysis needs for various end users including, but not limited to: management, project teams, clients and peers. In addition, this position is focused on identifying metadata and quality issues, as well as potential solutions through data analysis and reporting.

This position is remote, with the exception of initial onboarding (hybrid), and so the selected individual will need to be available to work within our River Park Plaza St. Paul, MN based location. The selected candidate must reside in MN or WI. Relocation to MN or WI will be required for out-of-state candidates.

Compensation & Benefits

The annual salary range for this opportunity is $79,892to $119,766, with a median salary of $99,829/annually. Pay is dependent on several factors including relevant work experience and internal equity. Salary is just one component of the compensation package for employees. Gillette supports career progression and offers a competitive benefits package, including a retirement saving match, tuition and certification reimbursement, paid time off, and health and wellness benefits.

Major Challenges

• Developing and advising management of necessary internal controls and procedures that ensure accurate and reconcilable data flowing from diverse databases.
• Ensuring all data is accurate in reporting
• Providing timely and consistent customer service
• Maintaining professional courtesy when faced with business pressures
• Working objectively towards solving problems

Primary Job Responsibilities

• Develop analytic/quantitative models in support of key internal and client decision making processes
• Partner with internal teams to evaluate existing reporting/dashboards and provide additional analytics to serve existing and prospective clients.
• Support presentations on program analytics for existing and prospective clients.
• Proactively manage and prioritize assigned tasks, ensuring deadlines are achieved, communicating progression or road-blocks
• Produce ad-hoc analyses to support client requests
• Present findings and provide subject matter expertise on program data to clients and internal partners
• Collects, validates, analyzes, interprets, and organizes various types of data into meaningful reports and/or summaries for various uses including, but not limited to: management decision making, process improvements, client specific requirements or requests, etc.
• Designs, develops, tests and deploys standard and custom reports to internal and/or external end users for strategic and operational analysis.
• Uses statistical analysis and other data analysis methods to identify quality issues and possible solutions or process improvements.
• Defines department specific report requirements. Works with users and project teams to define new capabilities and reports requirements using standard requirements definition tools.
• Works with business analysts, and data stewards to drive requirements gathering for metadata and data quality criteria, thresholds and reporting for enterprise and departmental projects.
• Works in conjunction with a variety of stakeholders to capture, assesses, analyze, and remediate metadata and data quality issues.
• Works with project managers for incorporating metadata and data quality principles, standards and processes in project life cycles and all new business integration activities.

Qualifications

Required:

• Bachelor's degree or equivalent experience
• 4 + years' experience in data management, data analysis, report development and/or related field
• Highly proficient in Excel (e.g. macros, pivot tables, advanced charts/graphs, conditional formatting, data tables, basic programming)
• Solid knowledge of PowerBI, PowerQuery, Python, SQL
• Excellent verbal and written communication skills
• Ability to function under pressure, conflicting priorities and deadlines
• Strong analytical skills with attention to detail
• Ability to work independently with minimal direction

Preferred:

• Experience within healthcare industry
• Experience with medical claims, reimbursement, and/or healthcare industry data
• Experience in metadata and/or data quality monitoring
• Experience using analytic tools or systems (ex. web based, custom, proprietary, etc.)
• Experience using MHA / WHA data
• Experience documenting requirements, creating training materials and working directly with end users
• Quality Assurance experience

Gillette requires all staff to be fully vaccinated for COVID-19 unless there is a Gillette-approved medical or religious exemption. New hires will be required to have at least one dose of the COVID-19 vaccine prior to starting employment and submit proof of 1st dose of COVID-19 vaccine prior to 1st day. Gillette also requires all employees to receive the influenza vaccine or wear an approved face mask during influenza season. The flu vaccine can be done at the time of the health clearance appointment.

Gillette Children's is committed to recruiting and retaining a diverse team, as we know that the diverse experiences of our employees make Gillette a stronger and better organization. We are committed to creating an equitable and inclusive environment where all patients, families and staff are welcomed and valued. We believe diverse perspectives and identities foster excellence, improve patient care and are essential for Gillette to fulfill its mission. Our team members collaborate to help patients of all backgrounds and abilities reach their full potential.

Gillette Children's is an equal opportunity employer and will not discriminate against any employee or applicant for employment because of an individual's race, color, creed, sex, religion, national origin, age, disability, marital status, familial status, genetic information, status with regard to public assistance, sexual orientation or gender identity, military status or any other class protected by federal, state or local laws.

Gillette Children's is a global beacon of care for patients with brain, bone and movement conditions that start in childhood. Our research, treatment and supportive technologies enable every child to lead a full life defined by their dreams, not their diagnoses.

To learn more about working at Gillette Children's, please visit https://www.gillettechildrens.org/careers.

Gillette Children's participates in the U.S. Department of Homeland Security (DHS) E-Verify program which is an internet-based employment eligibility verification system operated by the U.S. Citizenship and Immigration Services. If E-Verify cannot confirm that you are authorized to work, Gillette will give you written instructions and an opportunity to contact DHS or the Social Security Administration (SSA) to resolve the issue before Gillette takes any further action. Please visit https://www.e-verify.gov/ for further details regarding e-verify.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)