Principal Power BI Architect and Analytics Engineer

Oleg Wing

Principal Power BI Architect / Analytics Engineer

207-***-**** ️ *******@*****.*** LinkedIn GitHub

PROFESSIONAL SUMMARY

Principal-level Power BI Architect with 10+ years of experience designing and delivering enterprise-grade business intelligence platforms. Deep expertise in Power BI architecture, semantic modeling, DAX optimization, governance, and cloud data platforms including Microsoft Fabric, Azure Synapse, and Delta Lake. Proven record of building scalable, high-performance BI ecosystems, implementing CI/CD for semantic models, and enabling secure self-service analytics across organizations. Strong technical leader with hands-on delivery experience and a background in mentoring teams and establishing best practices.

PROFESSIONAL EXPERIENCE

Analytics Consultant / Power BI Architect

Collectiv – Chicago, IL

June 2022 – Present

Led the architecture and development of enterprise Power BI solutions, including semantic models, PBI reports, and paginated reports supporting executive, operational, marketing, sales, and financial analytics.

Designed scalable semantic models featuring star schemas, composite models, and dynamic Row-Level Security (RLS).

Authored complex DAX, including features such as calculation groups, time intelligence, and dynamic formatting, to create KPIs for a variety of business units.

Used Power Query, including custom M code and functions, to clean data in a repeatable and secure way.

Optimized datasets and models, in several cases reducing model size by up to 90%, resulting in significantly improved query and refresh performance.

Developed and enforced Power BI governance standards, including workspace strategy, naming conventions, deployment rules, and security models.

Configured Power BI data gateways, managed tenant settings, and advised on licensing and capacity considerations.

Integrated data from multiple sources including REST APIs, SOAP APIs, SQL Servers, flat files, Synapse, and Databricks into actionable Power BI reports.

Used advanced SQL including aggregations, joins, CTEs, subqueries, and window functions to implement data warehouses in Microsoft Fabric and Synapse and write ad-hoc queries.

Built and maintained metadata-driven bronze/silver/gold transformation frameworks using Fabric Data Factory and PySpark, reducing solution delivery timelines by up to 50%.

Partnered with stakeholders across Senior Leadership, Finance, Sales, Marketing, and Operations to translate business requirements into analytical solutions.

Mentored consultants and analysts on Power BI design patterns, modeling best practices, and DAX optimization techniques.

Authored architectural documentation, data model references, and deployment standards to ensure long-term maintainability.

Senior Business Analyst / BI Lead

Emery Jensen Distribution – Oak Brook, IL

December 2020 – June 2022

Served as the lead BI resource partnering with Sales, Marketing, Pricing, Merchandising, and Finance leadership.

Led the enterprise migration from Excel-based reporting to Power BI, converting 20+ reports into governed, automated dashboards.

Designed data models and ETL processes to support operating expense analysis, rebate programs, and profitability reporting.

Developed advanced profitability and pricing analytics that directly contributed to identifying and closing unprofitable accounts, driving a $3M margin improvement in a single year.

Automated complex rebate and incentive calculations, reducing processing time from one week to one hour.

Delivered executive-level insights through dashboards and presentations, routinely supporting senior leadership decision-making.

Pricing Analyst

Emery Jensen Distribution – Oak Brook, IL

October 2018 – November 2020

Built forecasting and pricing models to support margin planning and merchandising strategy.

Designed automated backend reporting for pricing and margin analysis, eliminating manual spreadsheet workflows.

Discovered intercompany pricing discrepancies through analytics, resulting in $10M+ in annual margin savings.

TECHNICAL SKILLS

Languages:

Python, SQL, DAX, Power Query (M), VBA, C#

BI & Analytics:

Power BI (Semantic Models, Paginated Reports, Embedded, Power BI Reports), Tabular Editor, DAX Studio

Cloud & Data Platforms:

Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Azure SQL, Delta Lake

Other Tools:

Excel, CI/CD Pipelines, Metadata-Driven Frameworks

CERTIFICATIONS

PL-300 – Power BI Data Analyst Associate

DP-600 – Fabric Analytics Engineer Associate

DP-700 – Fabric Data Engineer Associate

EDUCATION

Bachelor of Arts in Mathematics

University of Maine – Orono, ME

Minor: Economics

4.0 GPA, Phi Beta Kappa

Contact this candidate