Business Analyst

Dahl Consulting is partnering with a leading Fortune 50 retailer known for its innovative approach to digital commerce and data-driven marketing. They are seeking a highly technical Workflow Automation & BI Analyst to support a short-term automation initiative focused on optimizing operational workflows and improving team efficiency during a critical transition period.

Responsibilities:

• Audit existing operational workflows and identify opportunities for automation and optimization
• Build and implement scalable automation solutions using Microsoft Power Automate and related tools
• Streamline recurring reporting processes, including revenue tracking, pacing analysis, and distribution
• Automate manual campaign support and operational workflows where feasible
• Develop standardized templates, trackers, and workflow documentation
• Integrate and optimize data flows between Excel, SharePoint, Outlook, Salesforce exports, and internal systems
• Partner with stakeholders to prioritize high-impact automation initiatives
• Document workflows and provide transition materials to support long-term sustainability

Requirements:

• 3+ years of experience building workflow automations using Microsoft Power Platform tools
• Proficiency in: Microsoft Power Automate, Microsoft Excel (advanced formulas and/or macros preferred), Microsoft SharePoint, Outlook workflows, Power BI, Tableau, DOMO
• Experience documenting technical workflows and processes
• Strong process improvement and operational workflow expertise
• Proven ability to manage projects and communicate effectively with stakeholders
• Ability to work independently and execute in ambiguous, fast-paced environments
• Basic understanding of APIs and workflow integrations
• Experience supporting advertising, media, ad tech, retail media, or programmatic operations teams
• Familiarity with DSPs, SSPs, campaign trafficking workflows, or digital media reporting
• Experience working with Salesforce data exports and reporting workflows