John Spicer

John Spicer Email and Phone Number

Data Management Leader | Expert in Data Strategy, ETL Processes, & SQL | Mentorship & Team Development | Driving Efficiency through Cloud Migration & Automation | HIPAA-Compliant Solutions @ PwC
John Spicer's Location
Columbia, South Carolina, United States, United States
About John Spicer

I’m an analytical and solutions-oriented professional with a solid background in data strategy, process optimization, and team development within both healthcare and business operations. My expertise lies in overseeing end-to-end data management processes, ensuring compliance with HIPAA and other regulatory standards.I specialize in translating complex business needs into actionable, data-driven solutions. Using tools like SQL, Alteryx, Power BI, and Azure, I enhance data integrity, accessibility, and reporting accuracy. I’m particularly skilled at fostering team growth and designing training programs that drive technical proficiency in data analysis.Throughout my career, I’ve transformed operational workflows through automation and ETL processes, significantly improving data handling efficiency. I’ve also mentored data analysts and implemented robust data governance policies, all while ensuring client satisfaction with precise, insightful data solutions.

John Spicer's Current Company Details
PwC

Pwc

View
Data Management Leader | Expert in Data Strategy, ETL Processes, & SQL | Mentorship & Team Development | Driving Efficiency through Cloud Migration & Automation | HIPAA-Compliant Solutions
John Spicer Work Experience Details
  • Pwc
    Data Team Manager
    Pwc Nov 2022 - Present
    Gb
    I manage seamless data collection, processing, and analysis efforts, ensuring high quality and integrity across all initiatives. Leading a team of 16, including 3 Senior Data Analysts, 8 Data Analyst IIs, and 5 Data Analysts, I formulate data strategies aligned with organizational goals, transforming business requirements into effective, data-driven solutions. I oversee project lifecycles from conception to delivery, ensuring alignment with timelines and objectives. Additionally, I establish and enforce data governance policies to maintain compliance with privacy standards such as HIPAA, ensuring secure and ethical data handling.I enhance team technical proficiency through comprehensive training programs, leveraging tools like SQL, Alteryx, and ETL methodologies. I maintain professional and cooperative interactions with clients, management, and colleagues, fostering a collaborative and team-oriented approach. Key accomplishments include migrating database management systems from SSMS to Azure Cloud to optimize data storage and accessibility, leading the implementation of ETL processes and automation to improve data handling efficiency, and directing daily operations of the data team while providing mentorship and development support.
  • Virtual Business Office Associates
    Senior Data Analyst
    Virtual Business Office Associates Aug 2021 - Nov 2022
    Columbia, Sc, Us
    I ensured the quality and timeliness of all reporting, both internal and client-focused while collaborating with the operations team to facilitate new client integrations and maintain ongoing client accounts. I provided advanced SQL Server database management, including updating databases and creating tables, views, and stored procedures. Additionally, I mentored junior Data Analysts, supporting their growth and assisting the Data Analyst Manager with supervisory tasks. I managed multiple projects simultaneously, always maintaining the confidentiality and security of protected health information (PHI) in compliance with HIPAA regulations.Key accomplishments include developing and implementing software automation tools to boost productivity, designing and executing comprehensive test scenarios and scripts to contribute to robust software solutions, and consulting with users to assess hardware, software, and system requirements to ensure client satisfaction. I also spearheaded the creation of a Power BI reporting framework, which streamlined data visualization and analysis processes, and managed change requests to maintain project momentum and meet critical deadlines.
  • Virtual Business Office Associates
    Data Analyst Ii
    Virtual Business Office Associates Apr 2019 - Aug 2021
    Columbia, Sc, Us
    I developed comprehensive accounts receivable (A/R) analyses, full reports, flash reports, invoices, and ad hoc deliverables using tools like Power BI, SSRS, Excel, and PowerPoint, ensuring accuracy and timeliness to support both client and internal decision-making processes. My expertise in SQL Server allowed me to maintain database integrity, creating and updating tables, views, and procedures with precision. I also facilitated client data integration by managing data loads, import summary reports, and new client setups, ensuring seamless onboarding of new accounts. Additionally, I analyzed pre-project revenue potential, providing key insights to support business development opportunities.Key accomplishments include improving SQL code efficiency, which significantly reduced processing errors and enhanced data quality and introducing error-catching mechanisms and detailed logging processes to elevate the robustness of data handling procedures. I collaborated closely with the operations team to identify data trends, enabling proactive adjustments to client strategies. I also participated in ongoing educational programs to stay current with industry trends and advancements in technology, ensuring continuous improvement in my technical proficiency.
  • Virtual Business Office Associates
    Data Analyst I
    Virtual Business Office Associates Oct 2018 - Apr 2019
    Columbia, Sc, Us
    I executed the loading and scrubbing of client data for database integration, ensuring both accuracy and security, particularly in handling protected health information (PHI). With expertise in SQL Server, I developed and maintained databases, including creating tables, views, and procedures using T-SQL scripting. I streamlined data processing workflows to facilitate the production of critical financial reports, such as the Placement Summary and Weekly Cash Report.Key contributions include organizing and transforming large data sets to successfully import and manage client information within tight deadlines. I also supported the Data Analyst II role by delivering accurate and timely client and internal reports, such as A/R analyses and biweekly updates. Additionally, I produced vital financial reports like the Transaction Recon Summary and Takebacks/Dups Report, which played a crucial role in ensuring transparency and accurate reconciliation of accounts receivable.
  • Virtual Business Office Associates
    Associate Trainer
    Virtual Business Office Associates Oct 2016 - Oct 2018
    Columbia, Sc, Us
    I conducted comprehensive training programs for both new and existing employees, focusing on account follow-up processes and client engagement preparedness within healthcare revenue cycle management. I developed instructional materials tailored to key areas such as claims handling, transaction reviews, and patient account resolution. By mentoring staff and addressing performance gaps, I cultivated a learning environment that facilitated continuous technical skill development. I worked closely with the Learning and Education Team to assess training needs and implement effective educational strategies, ensuring staff proficiency and enhanced client service.Key accomplishments include improving staff quality of work by 85% through targeted mentoring, achieving an 80% retention rate by training and developing 100 new staff members annually, and boosting daily production by 50%. Additionally, I played a pivotal role in the creation of job aids and instructional materials, which streamlined onboarding and contributed to ongoing education efforts.
  • Virtual Business Office Associates
    Patient Accounting Associate Ii
    Virtual Business Office Associates Sep 2016 - Oct 2016
    Columbia, Sc, Us
    Worked accounts to full resolution – i.e., through payment, adjustment, identification of patient responsibility, and/or client-specified point of return. Resolved accounts and/or performed a secondary review of specific account actions to validate accuracy, completeness and appropriateness of actions taken to resolve accounts in adherence to client, organization, regulatory policies, and procedures. Duties: Possessed a thorough understanding of the hospital revenue cycle with specialization in hospital billing, follow-up, and the account resolution process to include, but not limited to; claims submission, acceptance, and adjudication, transaction reviews, adjustment posting, identification of patient responsibility, etc. Utilized and applied industry knowledge to resolve aged accounts receivable by working various account types. Leveraged available resources and systems (both internal and external) to analyze patient accounting information and took appropriate action for payment resolution. Documented all activity in accordance with organization and client policies Assisted in mentoring of new hires including, but not limited, to shadowing and answering general collection questions.
  • Virtual Business Office Associates
    Patient Accounting Associate I
    Virtual Business Office Associates Mar 2016 - Aug 2016
    Columbia, Sc, Us
    Analyzed the disposition of aged accounts receivable. Identified necessary actions to resolve the outstanding balance, and took identified resolution steps in adherence to client, organization, regulatory policies, and procedures.

John Spicer Education Details

  • South University
    South University
    General
  • Strayer University
    Strayer University
    General
  • Strayer University
    Strayer University
    General

Frequently Asked Questions about John Spicer

What company does John Spicer work for?

John Spicer works for Pwc

What is John Spicer's role at the current company?

John Spicer's current role is Data Management Leader | Expert in Data Strategy, ETL Processes, & SQL | Mentorship & Team Development | Driving Efficiency through Cloud Migration & Automation | HIPAA-Compliant Solutions.

What schools did John Spicer attend?

John Spicer attended South University, Strayer University, Strayer University.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.