Matthew McDermott

Cloud Data Engineering Manager

• Designed and implemented a Fabric-native orchestration framework supporting notebooks, Power BI refreshes, API ingestion, dependency resolution, retries, timeout handling, and parallel execution.

• Built unified marketing pipelines integrating Google Ads, Meta, Klaviyo, LS Direct, and budgeting data into a standardized reporting model powering executive dashboards.

• Led Dayforce migration data architecture and developed workforce history tracking using Fabric bronze, silver, and gold data models.

• Built enterprise product data pipelines and standardized product dimensions supporting reporting, AI solutions, and digital experiences.

• Designed the data architecture, Fabric Data Agents, Dataverse integrations, and automation framework powering AI-driven product knowledge assistants.

• Developed a Model Context Protocol server exposing Fabric administration, SQL execution, workspace discovery, and orchestration tooling for AI-assisted development.

• Rebuilt legacy procedures and execution patterns, improving SQL Server reliability by more than 80% while reducing crashes and operational support incidents.

• Established onboarding standards, sprint processes, project intake procedures, and technical documentation practices while mentoring Data Engineers and AI/ML Engineers.

Business Intelligence Engineer

• Identified that Hero content engagement was only 1.2% through in-depth Homepage analytics, prompting an A/B test of a redesigned layout. The new experience now drives 9.4% engagement (+82k bps) and is launching globally in Q2 2025.

• Engineered 15+ global data pipelines supporting Homepage analytics across 22 marketplaces, enabling real-time decision-making for hundreds of internal teams and improving data accessibility by 50%.

• Built a Homepage attribution model quantifying ~$3.7B in quarterly incremental revenue, driving ROI-based content optimization and becoming a P0 metric in executive quarterly reviews.

• Developed a custom RAG-based AI chatbot on AWS to enhance customer self-service, enabling natural language Text-2-SQL generation, automated data retrieval, team doc search, and experimental business decision overrides.

• Established slot-level logging across 10+ Homepage widgets, revealing underperforming content and enabling optimizations that lifted engagement by +500 bps over baseline.

• Led team-wide adoption of CI/CD pipelines and peer review standards, reducing release cycle time by 75% and boosting code quality and deployment confidence.

Sr. Business Analysis Manager

• Led the Sprint-T-Mobile data integration, aligning logging and warehouse analytics, enabling unified customer reporting across the entire base.

• Designed and implemented a custom CRM call-tracking system, boosting campaign effectiveness by 200% and reducing manual tracking errors by 80%.

• Built and maintained 20+ Power BI dashboards and 10+ Power Apps, driving over 3M logins and increasing engagement by 500%.

• Performed geospatial analysis to identify 400+ new retail opportunities, leading to a 60% market share increase.

• Extracted Power BI metadata using XMLA, DML, and DAX, enabling dynamic refreshes and detailed usage analytics.

Business Analysis Manager

• Automated generation and maintenance of 50–100 page analytical PowerPoint decks for weekly regional and market-level business reviews, reducing manual reporting time by 80% and standardizing executive insights across business units.

• Developed daily COVID-19 business continuity reports using Excel VBA and automated email distribution, delivering timely operational insights to senior leadership and supporting real-time crisis response during peak uncertainty.

• Led SQL Server enterprise-wide data governance initiatives, establishing access controls, data quality standards, and audit processes that improved data reliability, compliance, and security across 10+ integrated systems.

• Designed and deployed dynamic Power BI dashboards integrating data from SQL Server, Excel, and SharePoint, enabling real-time tracking of customer behavior, sales trends, and campaign performance — increasing stakeholder engagement and reducing ad-hoc report requests by 60%.

Sr Analyst, Business Analysis

• Developed Azure Data Factory pipelines to automate data ingestion and transformation workflows, reducing manual reporting time by 70%.

• Designed and deployed Power BI dashboards combining data from multiple sources (SQL Server, Excel, and SharePoint), offering real-time insights into customer behavior and sales trends.

• Enabled executive reporting through dynamic, refreshable dashboards using DAX, Power Query, and row-level security, enhancing visibility and decision-making.

• Partnered with cross-functional teams to standardize KPIs across departments, driving consistent business performance evaluation.

• Optimized labor management by designing a relational database schema to track staffing metrics, enabling the creation of advanced KPIs such as hourly efficiency, labor-to-sales ratio, and schedule alignment — improving workforce planning and operational agility.

Sales Analyst

• Constructed a multi-metric weighted ranking system aggregating key sales KPIs across the Northeast region, enabling standardized performance benchmarking and driving data-informed coaching and recognition across 100+ retail locations.

• Built and automated a KPI-driven dataset powering weekly market-level business reviews, streamlining the creation of performance presentations and reducing preparation time by 75% through Power BI, SQL, and Excel automation.

Retail Store Manager

• Fostered a high-performing, data-driven sales culture, consistently ranking among the top-performing stores nationwide by leveraging KPIs to drive accountability, coaching, and performance optimization.

• Hired, onboarded, and developed high-potential talent, promoting multiple team members into leadership roles.

• Mentored and coached a team of 10+ sales associates, using individual performance data and behavioral insights to tailor development plans and boost team engagement.

• Managed performance metrics and reporting dashboards, serving as a subject matter expert and peer trainer for strategic initiatives across the district.

• Oversaw inventory management and shrink control processes, maintaining >99% inventory accuracy through disciplined audits and proactive stock management.

• Led store scheduling and labor optimization, aligning staffing models to peak traffic patterns and increasing labor efficiency while improving customer and employee satisfaction.

• Acted as a district-level ambassador for new initiatives, piloting rollout strategies and providing feedback that influenced national training programs and sales tools.

Retail Sales Manager

Retail Sales Representative

Retail Sales Representative