Senior Data Analyst, People Analytics and Reporting

JOSEPH DEMAIO

Bethlehem Township, PA

610-***-**** • ***.*******@*****.***

LinkedIn: linkedin.com/in/joedemaio

SUMMARY

Senior Data Analyst People Analytics Reporting & Process Automation Data-driven analyst with extensive experience supporting operational, HR-adjacent, and enterprise reporting through structured analysis, workflow optimization, and high-accuracy data validation. Skilled at transforming complex datasets into actionable insights, improving data quality, and building scalable reporting solutions that support leadership decision-making. Known for clear documentation, disciplined follow-through, and strong cross-functional communication across HR, operations, IT, and business teams. Experienced with Power BI, SQL, process automation, and multi-system data governance. CORE COMPETENCIES

• HR & People Analytics Reporting

• Data Validation & Quality Assurance

• Workflow Mapping & Process Optimization

• Requirements Gathering & Documentation

• Power BI Dashboards & KPI Development

• Process Automation (Power Automate, UiPath RPA)

• Cross-Functional Collaboration

• Root-Cause Analysis & Issue Resolution

• Standardized Procedures & Data Governance

• Tools: Excel (advanced), SQL Server, Power BI, CRM platforms, Oracle/PL-SQL PROFESSIONAL EXPERIENCE

Business Analyst – Patient Access & Capacity Management St. Luke’s University Health Network — Jan 2025 to Feb 2026

• Supported operational and HR-adjacent reporting by validating data, identifying inconsistencies, and documenting corrected logic for leadership and cross-functional teams.

• Mapped multi-step workflows to clarify requirements and support system enhancements affecting staffing, scheduling, and capacity management.

• Produced structured documentation of business rules, lifecycle logic, and process flows used by IT, HR partners, and operational leaders.

• Collaborated with cross-functional teams to resolve workflow barriers and improve efficiency in scheduling, provider processes, and workforce-related operations.

• Prepared recurring analytical summaries highlighting trends, performance indicators, and areas of opportunity for leadership review.

Database Documentation Specialist (Contract)

Trinity Life Sciences — Jan 2024 to Jun 2024

• Documented complex system logic, data flows, and transformation rules to support compliance, training, and long-term maintainability.

• Partnered with cross-functional teams to clarify requirements, ensure alignment, and resolve inconsistencies in multi-system workflows.

• Created standardized process documentation, data dictionaries, and lineage summaries used across business and technical teams.

• Identified process gaps and recommended improvements to enhance accuracy, efficiency, and data integrity.

Performance Data Analyst

Lehigh Valley Health Network — Jan 2023 to Oct 2023

• Mapped operational workflows and created documentation to support consistent reporting and process execution across HR-adjacent and operational domains.

• Identified discrepancies across clinical and operational systems and coordinated with stakeholders to resolve root causes.

• Automated recurring reporting processes, improving efficiency and reducing manual workload.

• Produced structured summaries and process maps used by leadership and operational teams. Business Analyst – Service Operations

Dräger Medical — May 2019 to Nov 2022

• Analyzed and documented multi-step service and contract workflows to support process improvements and system enhancements.

• Conducted root-cause analysis of discrepancies and missing elements across operational and HR-related processes.

• Created audit-ready documentation packets, technical specifications, and process flows for cross-functional teams.

• Supported UAT cycles, tracked issues, and ensured completeness of documentation and process alignment.

• Completed UiPath RPA Associate certification (credential tied to corporate account; no longer accessible). Applied RPA concepts to workflow automation and process efficiency initiatives. Database Developer / Analyst (Consulting Roles)

Merck, Johnson & Johnson, Guardian Life, PPL EnergyPlus, FedChem — 2012 to 2019

• Mapped data workflows, created source-to-target documentation, and supported process standardization across enterprise systems.

• Identified and resolved inconsistencies in multi-system environments, improving data quality and operational reliability.

• Developed structured documentation and transformation rules to support long-term maintainability and training.

• Collaborated with business and technical teams to clarify requirements and ensure accurate process execution.

EDUCATION

B.S. Chemistry (Mathematics Minor) — Moravian University Vocational Diploma in Computer Programming — The Chubb Institute STRENGTHS

• Clear, structured communicator

• Strong analytical and problem-solving skills

• High accuracy and attention to detail

• Ability to simplify complex workflows

• Consistent follow-through on multi-step initiatives

Contact this candidate