Business Analyst

Title: Workflow Automation & BI Analyst (Power Automate / Power BI) Location: Remote (US-based) Job Type: Contract (3 Months) Compensation: $41.35 - $48.87 per hour - W2 Only Industry: Retail Key Skills Microsoft Power Platform tools (Power Automate, Excel, SharePoint, Outlook, Power BI), reporting in Domo/Tableau/Power BI About The Role We are partnering with a leading Fortune 50 retailer known for its innovative approach to digital commerce, media, and data-driven marketing. This organization operates a cutting-edge in-house media and advertising platform that supports programmatic campaigns across a vast retail ecosystem. We are seeking a highly technical BWorkflow Automation & BI Analyst to support a short-term automation initiative focused on optimizing operational workflows and improving team efficiency during a critical transition period. This role will work closely with cross-functional stakeholders to design and implement scalable automation solutions that reduce manual effort and enable teams to focus on strategic, revenue-generating activities. Job Description As a Workflow Automation & BI Analyst, you will evaluate current operational workflows, identify inefficiencies, and lead the development of automation solutions across the Microsoft ecosystem. This role requires strong technical expertise, process improvement capabilities, and the ability to work independently in a fast-paced, evolving environment. Key Responsibilities Include • 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 Qualifications Required Qualifications: • 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 Preferred Qualifications: • 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 Benefits Dahl Consulting is proud to offer a comprehensive benefits package to eligible employees that will allow you to choose the best coverage to meet your family’s needs. For details, please review the DAHL Benefits Summary: https://www.dahlconsulting.com/benefits-w2fta/. How To Apply Take the first step on your new career path! To submit yourself for consideration for this role, simply click the apply button and complete our mobile-friendly online application. Once we’ve reviewed your application details, a recruiter will reach out to you with next steps! Equal Opportunity Statement As an equal opportunity employer, Dahl Consulting welcomes candidates of all backgrounds and experiences to apply. If this position sounds like the right opportunity for you, we encourage you to take the next step and connect with us. We look forward to meeting you! #ZR #IT.Indeed