Open to opportunities

Andrew Jalowiec

@andrewjalowiec

Message

Data analytics intern turning complex datasets into dashboards and pricing insights that drive margin and efficiency.

United States

Message

What I'm looking for

I’m looking for an analytics role where I can build reliable dashboards and KPI reporting, use SQL and Python to streamline data work, and partner with cross-functional teams to improve pricing, margin, and operational decision-making.

I’m a data analytics intern who turns messy operational data into clear, decision-ready insights. At DriveTime Family of Brands, I analyzed vehicle purchasing, reconditioning, and supply chain performance using Snowflake and Sigma, then built complex SQL queries to support KPI tracking and executive reporting.

I’ve delivered impact through dashboarding and analysis—designing interactive Sigma dashboards for profitability, sales velocity, and inventory performance. I also ran profitability analysis that identified four consistently underperforming model-years and recommended a revised buying strategy to improve long-term margin performance, presenting results to cross-functional stakeholders.

Across roles, I’ve strengthened my BI and pricing toolkit by building reporting tables and dashboards with DBeaver, SAP BusinessObjects, and Power BI, and by proposing Python-based automation to reduce manual work. I’ve also supported data integrity using InfoBurst and ServiceNow, worked in Agile environments with JIRA, and previously contributed as a web developer intern by analyzing traffic and SEO performance to guide UX improvements.

Experience

Work history, roles, and key accomplishments

Data Analytics Intern

DriveTime Family of Brands

May 2025 - Aug 2025 (3 months)

Identified four underperforming vehicle model-years and recommended a revised buying strategy to improve long-term margin performance. Built Snowflake/Sigma analytics using complex SQL queries and delivered interactive dashboards and executive-ready reporting for stakeholders.

Snowflake SQL Sigma KPI Tracking Dashboard Development data transformation Data Validation

Data Science and Pricing Analyst Intern

Assa Abloy Group

Jun 2024 - Oct 2024 (4 months)

Partnered with Supply Chain and Finance to analyze inventory usage, unit cost, and build-time data supporting forecasting and cost optimization. Built SQL-based reporting tables and Power BI dashboards, proposed Python automation to reduce manual reporting, and analyzed Oracle JDE pricing discrepancies to balance margin and customer requirements.

SQL DBeaver Power BI Python Forecasting Pricing Analytics Automation

Business Intelligence Analyst Intern

Meritage Homes

Jun 2023 - Aug 2023 (2 months)

Built and maintained Power BI and SAP Webi dashboards tracking sales velocity, construction timelines, and cost performance. Validated cross-system data integrity with InfoBurst and ServiceNow, collaborated in an Agile environment with JIRA tracking, and delivered stakeholder-facing reporting to improve operational visibility.

Power BI WEBI Reports ServiceNow Dashboard Development Data Validation KPI Tracking Agile Delivery Jira

Web Developer Intern

Excalibur Rings

Jan 2022 - May 2022 (4 months)

Analyzed website traffic and SEO performance to identify engagement trends and recommend UX improvements. Communicated data-driven insights to stakeholders to increase website visibility and customer interaction.

SEO Analysis Data Insights Reporting