Robert Shelly
BI / Analytics Architect | Analytics Engineer | Power BI, Dataflows & Semantic Models | Enterprise Analytics | MBA
Hire this person
Send a job offer directly to this candidate
About
Business Intelligence / Analytics Architect with an MBA and 5+ years designing and building enterprise analytics solutions in the Microsoft ecosystem. Hands-on across analytics engineering, Power BI Dataflows, semantic models, Power Query (M), DAX, SQL and query integration, orchestration, and governed reusable data assets. Built cross-system transformation and conformance layers that converted fragmented operational data into trusted analytics supporting 800+ business units.
Partnered with executive leadership, IT, and business owners to automate reporting, improve data quality, standardize multinational KPIs, and deliver scalable decision-support solutions from the C-suite to frontline operations.
Experience
GFL Environmental | Business Intelligence Architect 02.2021 - 02.2026
- Designed and maintained the reporting platform as the sole BI Architect supporting Procurement and Fleet Operations.
- Designed, deployed, and maintained 30+ enterprise analytics solutions spanning 100+ production reporting and model artifacts, supporting executives, regional leadership, and frontline operations across 800+ business units.
- Built reusable analytics-engineering layers in Power BI Dataflows, including conformed/mastered dimensions, shared transformation logic, curated facts, and semantic models used across multiple reporting products.
- Developed Power Automate workflows to orchestrate dependent Dataflow and semantic-model refreshes with automated retry logic, failure monitoring, and gateway-aware scheduling.
- Built a governed business-unit master spanning 800+ BUs, combining cross-system organizational, leadership, contact, location, and operational attributes into a trusted enterprise source of truth with exception-driven validation and remediation.
- Developed effective-dated historical-state models that reconstructed asset status and context across transfers and organizational changes for point-in-time and duration-weighted analysis.
- Integrated SQL, API, ERP, and business-managed reference data across multiple source systems, using Power Query/Dataflows to standardize, blend, and serve analytics-ready datasets while optimizing source queries through query folding.
- Standardized multinational operational KPIs and externalized reusable mappings, thresholds, conversions, and business rules so definitions remained consistent across reporting products.
- Reduced manual reporting effort by approximately 15,000 hours annually through automation.
- Completed contract assignments for Robert Half clients supporting accounting and reporting functions.
- Managed operational reporting and financial-data accuracy for a four-location retail enterprise.
- Built executive reporting and financial models using advanced Excel, Power Query, and Power Pivot while reconciling POS, inventory, sales, tax, cash, and general-ledger data.
- Developed financial models and managed multi-unit tax compliance to support forecasting and business planning.
- Standardized data-entry workflows and internal controls to improve audit readiness and reporting accuracy.
Education
Master of Business Administration in MBA – East Carolina University (2018)
Bachelor of Science in Communications – East Carolina University (2009)
