Jeremiah W

Cloud and Data Solutions Architect

Microsoft • Full-time

Jan 2023 - Jun 2025 • 2 yrs 5 mos

Via Allyis • Architected end-to-end Azure data platform powering personalized email communications for 300,000+ Microsoft employees worldwide, including executive leadership audiences, requiring enterprise-grade reliability, security, and governance. • Led strategic migration roadmap from Salesforce Marketing Cloud to Dynamics 365 Customer Insights, modernizing global marketing infrastructure and reducing platform dependency. • Established CI/CD workflows in Microsoft Fabric leveraging Git integration and deployment pipelines to automate build, validation, and promotion of Dataflows and Power BI semantic models across dev/test/prod environments. • Designed a multi-agent auto-remediation system in Azure AI Foundry where triage and remediation agents trigger on ADF pipeline failures, query a unified knowledge base, and propose fixes via ADO pull request with root cause analysis and structured diff. • Built a natural-language support agent in Copilot Studio deployed to a Teams channel, enabling support staff to submit freeform issue descriptions. Agent queries D365 CIJ send records, Dataverse tables, and Fabric SQL to trace root cause across the stack and returns a resolution summary with recommended fix and ticketed action. • Architected a real-time operational intelligence dashboard using Microsoft Fabric (EventStream, Eventhouse, KQL) ingesting live Dataverse events from Dynamics 365 Customer Insights Journeys, enabling sub-minute visibility into email throughput, processing latency and journey failures. • Owned Azure subscription governance, including resource provisioning, RBAC, security policies, and environment lifecycle management. • Recognized with company-wide award for AI innovation for delivering scalable internal AI solutions.

Senior Azure Data Engineer

Kroger • Full-time

Apr 2021 - Dec 2021 • 8 mos

Executed a full migration of pharmacy data from on-premises Oracle/SQL Server to Azure cloud. Built incremental refresh pipelines in Azure Data Factory and integrated Databricks to transform raw data into Delta tables. Developed Power BI Log Analytics dashboards for pipeline error reporting and operational visibility across hundreds of locations.

Senior Social Data Analyst

Microsoft

Jan 2017 - Mar 2021 • 4 yrs 2 mos

Via DesignIt • Partnered with Microsoft Cloud & Enterprise Marketing stakeholders to define measurement strategy, data requirements, and reporting frameworks for global social media campaigns, aligning analytics with revenue and pipeline goals. • Architected and maintained a centralized Azure-based data platform (Azure SQL, ETL pipelines, SSAS Tabular) integrating Adobe Analytics, Sprinklr (multi-channel social APIs), Marketo, and Dynamics CRM to create a unified, end-to-end view of the marketing funnel. • Built a full-funnel attribution model connecting social engagement → website behavior → marketing automation stages (MQL, SQL) → CRM outcomes (leads, opportunities, revenue), enabling direct measurement of campaign impact on pipeline and closed deals. • Developed scalable Power BI dashboards and data models to surface actionable insights for Marketing and Finance teams, translating campaign performance into ROI, conversion rates, and budget efficiency metrics. • Designed and implemented a custom link tracking system to capture post-click user behavior, significantly improving visibility into conversion paths across webinars, content downloads, and event registrations. • Delivered executive-level reporting (monthly 85+ slide decks) summarizing performance across 75+ global social channels, highlighting growth trends, attribution insights, and strategic recommendations. • Built and maintained Brandwatch social listening dashboards to analyze sentiment, campaign resonance, and audience behavior around key launches and events, feeding insights back into campaign optimization.