Sr. Data Reporting and Data Development Analyst

Overview

Create and manage master data sets from raw sources to deploy Operational Metrics and develop customized analytical tools. Identify data trends and perform root cause analysis to make data driven decisions towards Operational Excellence and meeting service targets & commercial needs, identify data connectivity improvements.

Responsibilities

• Serve as the owner and subject matter for regional value stream data structures and sourcing.
• Ensure data integrity for business decisions, senior management reviews, operational analysis, and day to day improvement.
• Facilitate alignment around Operational Metric definitions, defects, and opportunities.
• Collaborate with regional directors and corporate function management on developing reporting solutions.
• Develop automated data solutions in partnership with corporate IT and National Lab Ops & Enterprise Automation teams.
• Leverage developed solutions to create customized and accurate reporting, scorecards, and management tools for regional Operations teams.
• Design and maintain data submission templates for master data sets.
• Able to collect data from different systems, clean, sort and creates different graph levels.
• Collaborate with key stakeholders to design and adopt mechanisms for managing critical data locally in a structured format.
• Query and collate metrics from automated and non-standard data sources.
• Collect data across standard and non-standard sites, portals, vendor sharedrives, etc, adhering to agreed operational definitions.
• Educating front line team members and leaders on operational interpretations and best practices on data dashboard or tool utilization. Leading the way in advocating for digital competency and capability.
• Perform checks and audits of all data sources to ensure metrics are accurate and complete.
• Support a culture of continuous improvement by supporting, facilitating, or leading rapid improvement events/kaizens by articulating drivers of gaps towards performance across the value stream.

Examples of Operational Metrics:

• Specimen Management and testing Productivity (Throughput, Efficiency, Total Labor)
• Reliability (Instrument Uptime, Instrument failures, Instrument Cycles & Capacity, Preventative Maintenance Compliance, Mean time between failures)
• Market Volume Insights (Req Complexity, Weekly Volume Trends, Volume Characteristics)

Qualifications

Required Work Experience:

• Minimum of 5 years of experience in a role requiring analytics or reporting.
• Database application design and development experience
• Strong technical skills in Python, Linux, AIIDA, SFDC, SQL, SQL Developer, SAS or similar tools
• Experience with business intelligence tools such as PowerBI and Tableau
• Fluency with analyzing and manipulating large complex datasets
• Deploying technology, process and methods  to analyze data

Physical and Mental Requirements:

• Ability to sit for prolonged periods.

Knowledge:

• Expertise in creating, managing, and analyzing large master data sets.
• Working understanding and experience with relevant Order to Cash processes.
• Systems knowledge: QLS, QBS, QDSS, Cognos, AIIDA.

Skills:

• Proficiency with the Microsoft Power Platform (Power Apps, Power BI, Power Automate).
• Experience with data science tools and programming languages, including Python and packages such as Pandas, NumPy, Scikit-learn, and PySpark.
• Advanced SQL skills, including Common Table Expressions (CTEs) and User Defined Functions (UDFs).
• Program Management projects with logical steps to step definitions.
• Complex analytical mindset to problem resolution.
• Understanding of data pipeline management, including underlying scripts, edge cases, scalability, future-proofing, and API configurations.
• Advanced proficiency in Excel, including Regular Expressions, Pivot Tables, Chart Designs, Dashboard Creation, VBA/Macros, and various lookup functions (XLOOKUP, HLOOKUP, VLOOKUP, INDEX/MATCH).
• Expertise in rational database query and creation (Access & SQL).
• Direct experience influencing operational leaders.
• Proven track record in analyzing data and drawing actionable conclusions.
• Strong communication skills, with the ability to hunt down data, transform it, and clearly express opportunities.
• Strong presentation skills.

Software / Programming Requirements:

• MS Excel: data mining, modeling, and tool origination/refinement.
• MS Power Platform: Microsoft PowerBI, Power Apps, Power Automate
• Minitab: statistical analysis of historical data.
• Python: data extraction/building methods
• MS Access: database queries and creation.
• SharePoint / Tableau: distribution of metrics and data sets.
• Bonus: MS Visio

Attributes:

• Results-oriented.
• Collaborative.
• Analytical.
• Problem-solving.
• Customer-focused.
• Negotiating skills.
• Functional/technical skills.
• Organizational skills.

Education:

• Bachelor’s Degree.

Certifications:

• Green Belt Certification.

EEO

Equal Opportunity Employer: Race/Color/Sex/Sexual Orientation/Gender Identity/Religion/National Origin/Disability/Vets or any other legally protected status.