Megan Nicholson
Seattle,WA
Summary
Detail-oriented, organized, and ambitious data scientist specializing in healthcare industry data. Proficient in analyzing healthcare claims data to identify patterns, trends, and draw conclusions. Skilled in data validation, cleaning, manipulation and visualization using SQL, Python, and Power BI.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Senior Data Scientist
Milliman MedInsight
01.2024 - Current
- Collaborate in a closely knit team to expand assets as part of the Data Products platform
- Developed and continually expand an analytics toolkit that leverages parameterized SQL approaches to streamline common analytical processes
- Built and utilize toolkit functions to map disparate claims sources to a common schema which improves coding efficiency by shifting hundreds of lines of SQL to behind-the-scenes processes now accessible by 1 line of Python code
- Collaborate with colleagues to provide analysis for a study on how the inclusion of SDOH factors impacts risk score modeling
- Perform prospective risk score modeling using the CDPS risk score methodology recalibrated with multiple linear regression techniques
- Present ongoing projects at company wide conferences
- Subject matter expert in claims analytics with knowledge from a variety of commercial and Medicare claims sources
- Perform common analytical procedures including but not limited to data cleaning and manipulation, aggregation, and predictive modeling in a various Databricks environments
- Leverage generative AI capabilities and concepts to bring efficiency to workflow
Healthcare Data Analyst
Milliman MedInsight
03.2022 - 01.2024
- Contributed to a variety of big data projects including the summarization of claims data to provide valuable insights at the provider, provider group, and various geographical dimensions
- Assumed VRDC seat in January of 2023 to facilitate and develop analytical methodology using Medicare, Medicaid, and other data supplied by CMS
- Developed Medicare FFS and MA enrollment analysis
- Developed ETL process to move data projects developed from Unity Catalog sources to SQL server hosted databases
- Translated SAS code into Python code to assign episodes to individuals' claims. The script saw 2 days of efficiency gains by moving from SAS to Databricks
Power Apps Developer
Bridge Partners
07.2021 - 02.2022
- Designed, programmed, and deployed a Power App for Microsoft's M&O organization's internal use
- Worked closely with clients to gather requirements and translate them into technical specifications for implementation.
- The app served to provide the user with an effortless experience to view relevant data without searching through a complex data file as well as centralizing a fragmented form intake process and data cleaning/input exercises
- Created Power Automate Flows to email data exports to users directly based on permission status, to write MS Form submissions to a dataset, and to send email notifications when new submissions needed review
- Properly tested and tracked features to mitigate risk of bugs and ensure desired functionality
- Supplied documentation regarding troubleshooting and how to alter features in the back-end
- Functionality included but was not limited to, optimized search results, permission groups, exports, data entry, external website launch.
Data Analytics Project Manager
Bridge Partners
07.2021 - 02.2022
- Managed account transitions processes, resource assignments, ad hoc reporting and dashboard creation for Customer Success Account Mangers and the leadership teams in Microsoft's GAMD organization
- Established effective communication among team members for enhanced collaboration and successful project completion to maintain data integrity which allowed leadership to make crucial decisions regarding workload distribution and headcount
- Implemented sustainable reporting practices in Power BI which increased accuracy in reporting and insights into metrics by replacing a static ,manual entry Excel file with an auto refreshed query connected to data cubes
- Streamlined account reconciliation process to reduce time managers spend on exercise by 50% which improved accuracy in account assignments that directly impacted employee compensation
- Improved Power Automate Flow with query optimization - improved run time from 15 minutes to seconds
- Automated redundant business process by creating Power Automate Flow to write form submissions to SharePoint list that generates Power BI report
Project Manager/Sales Support Specialist
Microsoft
02.2021 - 07.2021
- Successfully developed and implemented Agile pilot project to provide project management and sales support for Microsoft’s Strategic Partnerships team to procure multimillion-dollar partnership agreements with Fortune 500 companies
- Individual support was provided to 4 strategic partnership leads assigned to over 14 account teams specializing in healthcare, retail, and consumer goods
- Accomplished stakeholder satisfaction measured by completion of deliverables which accelerated sales processes to generate $800 million dollars in revenue
- Built unique relationships with each client to gain trust and expand support by providing insight into presentation themes, data visualizations, and pursuit content
- Developed Excel documentation and PowerPoint presentations to drive key workstreams that influenced and accelerated procurements of strategic partnerships
- Lead meetings to align various stakeholders while utilizing planner and Power BI to organize and report
Education
Master of Science - Data Science
The University of Montana
Missoula, Montana05.2020
Bachelor of Arts - Mathematics
The University of Montana
Missoula, Montana12.2018
Skills
- Python
- SQL
- Databricks (Azure & AWS)
- Statistical Analysis
- Machine Learning
- Big Data Analytics
- Neural Networks
- Healthcare Industry Knowledge
- Healthcare Quality Measures
- Healthcare Benchmarking
Certification
Databricks Certified Data Analyst Associate, July 2023 - July 2025
Timeline
Senior Data Scientist
Milliman MedInsight
01.2024 - Current
Healthcare Data Analyst
Milliman MedInsight
03.2022 - 01.2024
Power Apps Developer
Bridge Partners
07.2021 - 02.2022
Data Analytics Project Manager
Bridge Partners
07.2021 - 02.2022
Project Manager/Sales Support Specialist
Microsoft
02.2021 - 07.2021
Master of Science - Data Science
The University of Montana
Bachelor of Arts - Mathematics
The University of Montana