Dominic Chiari
Portland,Oregon
Summary
Senior Data Analyst with experience building financial forecasts, Snowflake data models, Power BI reporting, and Python automation. Uses SQL, statistical modeling, data reconciliation, and stakeholder collaboration to improve reporting accuracy and reduce manual work.
Overview
5
5
years of professional experience
Work History
Senior Data Analyst
Lithia Motors, Inc
Portland, OR
08.2025 - Current
- Designed and deployed a daily net profit forecasting engine using rolling 36-month regression and dealership posting patterns; historical replay reduced mean absolute error from $12.64M to $4.51M.
- Reworked monthly pacing for approximately 360 dealerships using three years of transaction history, day-of-week, holiday, and month-end factors; reduced average day-15 error from 6.7% to 3.0%.
- Built Python tools that automate 3,000+ month-end packet file operations per close cycle and generate table-of-contents pages for 28 leadership packets.
- Rebuilt the AOP Advisor access review pipeline with Python and Snowflake, expanding coverage from 2,862 unvalidated rows to 6,445 audited, role-mapped records.
- Built and delivered a Snowflake-based AOP seasonality model that distributes annual plan values across dealership price-group and account cohorts, reducing average model error from 7.6% to 0.35% on high-volume validation data.
Product Manager
Lithia Motors, Inc
Portland, OR
04.2024 - 08.2025
- Owned Power BI reporting solutions covering dealership sales performance, operational trends, and financial results.
- Worked with business stakeholders to translate reporting needs into changes for dashboards and data products.
- Led UAT with 50+ finance and operations stakeholders, checking reporting accuracy and usability.
- Supported 25+ dealership acquisitions, coordinating financial, sales, and operational data integration within a 14-day SLA.
- Partnered with data engineering teams on data ingestion and reporting pipeline improvements.
Technical Data Analyst
Lithia Motors, Inc
Medford, OR
04.2022 - 04.2024
- Developed SQL queries and Snowflake views for recurring dealership sales, finance, inventory, and operational reporting.
- Built and maintained Power BI reports to track vehicle purchases, sales, and dealership performance.
- Created dashboards analyzing dealership inventory performance and reinvestment impact.
- Automated tax and finance reporting processes, saving 15+ hours per month.
- Provided technical support for BI reports and investigated data issues to help maintain reporting accuracy.
Education
Bachelor of Science - Business Information Systems
Oregon State University
Corvallis, OR06-2021
Skills
- Snowflake SQL
- Snowflake Cortex
- Python
- Financial and market data analysis
- Statistical forecasting
- Transaction-level data
- Data pipelines,
- Anomaly investigation & reconciliation
- Power BI
- Excel
- Power Query (M)
- Microsoft Fabric
- Git
Timeline
Senior Data Analyst
Lithia Motors, Inc
08.2025 - Current
Product Manager
Lithia Motors, Inc
04.2024 - 08.2025
Technical Data Analyst
Lithia Motors, Inc
04.2022 - 04.2024
Bachelor of Science - Business Information Systems
Oregon State University