Ryan Lynch
Data Analyst | Business Intelligence
Denver,CO
Summary
Analytical and detail-oriented professional with excellent communication skills and over ten years of experience in data analytics, business intelligence, and financial modeling. Expert in transforming complex datasets into actionable insights that drive strategic decision-making by improving efficiency, uncovering growth opportunities, and supporting long-term business goals.
Overview
11
11
years of professional experience
4
4
Certifications
Work History
Business Analyst
Data Driven Consulting
Denver, CO
07.2020 - Current
- Self-employed consultant partnering with 30+ businesses across diverse industries to identify process improvements, eliminate inefficiencies, and implement data-driven solutions that enhance operations and deliver measurable results.
- Transformed complex SQL and Excel based datasets into actionable insights through advanced statistical analysis.
- Designed Excel workbooks using advanced functions, VBA macros, and PivotTables to automate operations and boost efficiency.
- Developed insightful reports using Power BI and Excel, and communicated findings clearly and concisely to stakeholders at all levels.
Data Analyst
CenturyLink (now Lumen)
Broomfield, CO
07.2016 - 07.2020
- Analyzed large datasets (50TB+) using SQL and Excel to uncover trends, optimize performance, and support high-impact decisions.
- Built and maintained advanced Excel financial models related to customer behavior, revenue performance, and market dynamics.
- Delivered executive-level insights through clear communication and impactful data visualizations using Excel and Power BI.
Investment Analyst
EverWest RE Partners (now Sagard)
Denver, CO
06.2014 - 07.2016
- Led financial analyses of 100+ commercial real estate assets across all classes, supporting acquisition, disposition, and valuation strategies.
- Evaluated $10M–$100M opportunities using scenario and sensitivity analyses to assess performance, market trends, and risk exposure.
- Presented comprehensive investment reports to executives and external investors, driving strategic portfolio decisions.
Education
Bachelor of Science - Business Administration And Management
Colorado State University
Fort Collins, CO 08.2010 - 05.2014
Skills
- Excel (VBA Macros, Advanced Functions)
- Data Analytics & Statistical Analysis
- SQL (Data Extraction & Transformation)
- Process Optimization & Automation
- R, Tableau, Python (NumPy, pandas)
- Financial Modeling & Forecasting
- Business Intelligence (Power BI)
- Data Visualization & Reporting
Certification
Data Analyst Career Certification (365DataScience)
Microsoft Office Specialist (MOS) Certification for Excel (Microsoft)
Timeline
Business Analyst
Data Driven Consulting
07.2020 - Current
Data Analyst
CenturyLink (now Lumen)
07.2016 - 07.2020
Investment Analyst
EverWest RE Partners (now Sagard)
06.2014 - 07.2016
Bachelor of Science - Business Administration And Management
Colorado State University
08.2010 - 05.2014
Similar Profiles
Ryan LynchRyan Lynch
Business Analyst at Data Driven ConsultingBusiness Analyst at Data Driven Consulting
Feimen AosaiFeimen Aosai
Currency Trader at Data-Driven Forex Trading StudyCurrency Trader at Data-Driven Forex Trading Study
Niranjan KumarNiranjan Kumar
Research Project at Data Driven MarketingResearch Project at Data Driven Marketing
MONICA STOCKBRIDGEMONICA STOCKBRIDGE
Content Writer at AquentContent Writer at Aquent
Joseph Aemile St. CyrJoseph Aemile St. Cyr
Substitute Teacher at ESS WestSubstitute Teacher at ESS West