Julia McKinnon
Brooklyn,NY
Summary
Detail-oriented Data Analyst with experience maintaining large administrative datasets, building dashboards and reports, and performing high-accuracy data entry and quality assurance audits. Comfortable working independently, managing multiple priorities, and following through with minimal supervision. Strong proficiency with Google Workspace, SQL, Excel, Power BI, and Tableau, with hands-on experience supporting CRM data integrity and cross-team reporting.
Overview
1
1
Certification
7
7
years of professional experience
Work History
Business Data Analyst
Mona
05.2023 - Current
- Analyze large datasets to identify trends, support forecasting, and inform administrative and strategic decision-making.
- Build and maintain dashboards and reports (Excel, SQL, Power BI, Tableau) that are accessible to non-technical colleagues.
- Perform ongoing data validation, quality assurance audits, and error correction across CRM and internal systems.
- Automate weekly and monthly reporting workflows to improve timeliness and accuracy.
- Oversee data migration and integrity during CRM platform integrations, maintaining strict confidentiality of sensitive records.
- Act as a go-to resource for both technical and non-technical team members, resolving data questions independently.
Junior Data Analyst
Aetna Healthcare
01.2021 - 04.2023
- Collected, cleaned, and analyzed large volumes of claims and administrative data to support operational efficiency.
- Built dashboards and reports to track KPIs and visualize trends for internal and regulatory reporting.
- Identified and resolved data discrepancies through detailed quality assurance review, improving accuracy and compliance.
- Conducted root-cause analysis on data trends to support process improvements across departments.
Billing Analyst
SimpliSafe
06.2020 - 12.2020
- Investigated and resolved data and billing discrepancies, maintaining accurate records across systems.
- Automated reconciliation and reporting processes to improve accuracy and reduce manual review time.
- Led data audits and supported data migration during a new billing system implementation.
Claims Adjuster - USAA Account
Teleperformance
07.2019 - 06.2020
- Maintained and updated customer records across multiple database systems with a high standard of accuracy.
- Managed high-volume documentation and data entry across Auto, Health, and Banking claim types.
- USAA Contract
Education
Data Analysis and Machine Learning -
University of Richmond
02-2025
Biology - undefined
Virginia Commonwealth University
High school or equivalent - undefined
Highland Springs High School
Skills
- Data Entry
- Quality Assurance Audits
- Data Cleaning
- Data Validation
- Data Organization
- Dashboard Development
- Report Development
- Power BI
- Tableau
- Excel
- Google Workspace
- CRM Management
- Database Management
- SQL
- Database Querying
- Workflow Automation
- Confidential Data Handling
- Independent Project Management
Certification
University of Richmond — Data Analysis and Machine Learning
Timeline
Business Data Analyst
Mona
05.2023 - Current
Junior Data Analyst
Aetna Healthcare
01.2021 - 04.2023
Billing Analyst
SimpliSafe
06.2020 - 12.2020
Claims Adjuster - USAA Account
Teleperformance
07.2019 - 06.2020
High school or equivalent - undefined
Highland Springs High School
Biology - undefined
Virginia Commonwealth University
Data Analysis and Machine Learning -
University of Richmond
Personal Information
Title: Data Analyst