Colin "Mitch" Mitchell
Somersworth,NH
Summary
Enthusiastic data professional. Adept at leveraging data methodologies to accomplish project milestones according to specific timeframes. Experienced in multiple data tools with a passion for mastering new technical skills as needed. Strong communicator and presenter deft in connecting the dots with data. Highly organized and detail-oriented with 5+ years of progressive experience in the field.
Overview
7
7
years of professional experience
Work History
Senior Financial Analyst
Whitecap
01.2023 - Current
- Partner with data services and data science team to leverage data pipeline in support of Power BI dashboard development.
- Design and implement actionable dashboards visible to high level leadership. Translate business requirements from partners into complex DAX.
- Support data validation process during new data lake stand-up. Author Python automation scripts validating hundreds of individual tests for new data lake.
- Train and mentor junior team members in all data practices.
Senior Insight Analyst
Polly (formerly DealerPolicy)
12.2021 - 12.2022
- Supported new product roll-out through A/B testing analysis and post-deployment effect research.
- Authored and maintained over forty operational reports with Power BI and DAX.
- Troubleshot data integrity hurdles and peer reviewed complex SQL queries.
- Constructed ad hoc Python tools to overcome uniquely challenging analytics obstacles.
- Mentored new hires in full suite of office tools and software.
Quality Associate - Data Management
JP Morgan Chase & Co.
06.2017 - 12.2021
- Designed and implement quality analysis data model.
- Parsed, restructured, and normalized data sources for cross-platform migration.
- Developed, documented, and maintained data input procedures.
- Automate complex data validation and reporting across multiple lines of business
- Liaise between neighboring teams in support of broader company data initiatives
- Streamline partner data processes through tool construction.
Education
Master of Science - Applied Mathematics
Northeastern Illinois University
5500 St Louis Ave, Chicago, IL 6062512.2016
Bachelor of Science - Applied Mathematics
Northeastern Illinois University
5500 St Louis Ave, Chicago, IL 6062505.2015
Skills
- Power BI (DAX)
- Excel (VBA)
- SQL
- Python
- Stat Package R
- Data Visualization
- Tasking & Reporting Automation
- Applied Regression Analysis
- Statistical Modeling
- Data Normalization & Structuring
Timeline
Senior Financial Analyst
Whitecap
01.2023 - Current
Senior Insight Analyst
Polly (formerly DealerPolicy)
12.2021 - 12.2022
Quality Associate - Data Management
JP Morgan Chase & Co.
06.2017 - 12.2021
Master of Science - Applied Mathematics
Northeastern Illinois University
Bachelor of Science - Applied Mathematics
Northeastern Illinois University
Similar Profiles
Kunal ShahKunal Shah
Senior Business Analyst at WhitecapSenior Business Analyst at Whitecap
Rogelio RamosRogelio Ramos
Branch Manager at WhitecapBranch Manager at Whitecap
Nicole CorsoNicole Corso
Senior Credit Analyst at WhitecapSenior Credit Analyst at Whitecap