AI Data Engineer – Power Platform & Automation

Team Red Dog•Beaverton, OR

3d•Remote

About The Position

Team Red Dog is hiring an AI Data Engineer to modernize Azure hardware planning and portfolio reporting for a global technology leader. The role focuses on integrating enterprise data, developing AI-powered automation, and replacing manual reporting with dynamic Power BI dashboards. It uses Microsoft Power Platform, Azure DevOps, SharePoint, and generative AI to streamline workflows, improve data accuracy, and deliver actionable business intelligence. The engineer will assess existing workflows, identify automation opportunities, create centralized and governed data solutions, and build interactive dashboards that provide visibility into business operations. The position offers exposure to Azure hardware planning and enterprise cloud operations, with autonomy to design solutions and demonstrate measurable improvements to reporting efficiency, data quality, and decision-making across teams. The role requires collaboration with business stakeholders to turn reporting needs into scalable technical solutions. The engineer will document solutions, train users, support adoption, and report outcomes such as hours saved, reduced reporting cycle times, and improved data accuracy. Candidates must be prepared to give a live demonstration of a prior AI project that improved workflow or operational efficiency, without disclosing confidential, proprietary, or customer information. This is a remote U.S. W2 contract opportunity through June 30, 2027, with the potential to extend up to 18 months total, subject to performance, budget, and client discretion. The schedule is 40 hours per week, Monday through Friday, during Pacific Standard Time business hours. The estimated start date is immediately. Applicants must be authorized to work in the U.S. without sponsorship; employment is contingent on successful reference and background checks.

Requirements

At least 4 years of experience in data engineering, business intelligence, analytics automation, or a related discipline.
At least 2 years of hands-on experience developing production generative AI solutions using Copilot Studio, Azure OpenAI, AI Builder, Microsoft 365 Copilot, or similar technologies.
Advanced Power BI expertise, including data modeling, DAX, Power Query (M), automated refresh, deployment, and row-level security.
Strong working knowledge of Microsoft Power Platform, including Power Apps and Power Automate.
Experience with Azure DevOps queries, Analytics/OData, REST APIs, SharePoint Online, and advanced Excel.
Proficiency in SQL and Python for data manipulation, integration, and workflow automation.
Demonstrated ability to integrate and reconcile data across multiple enterprise platforms and systems.
Experience translating complex business requirements into technical solutions and executive-ready dashboards.
Strong communication, analytical thinking, troubleshooting, and stakeholder collaboration skills.
Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, or a related field, or equivalent professional experience.
Ability to work 40 hours per week, Monday through Friday, during Pacific Standard Time business hours.
Must be authorized to work in the U.S. without sponsorship.
Successful completion of reference and background checks is required.

Nice To Haves

Experience with Azure hardware, supply chain, product roadmaps, or portfolio management data.
Familiarity with Microsoft Fabric, Dataverse, KQL, Power Platform application lifecycle management (ALM), or Git.
Microsoft certifications in Power BI, Fabric, Power Platform, or Azure AI.
Previous experience working within Microsoft's enterprise technology environment.

Responsibilities

Evaluate business workflows, identify manual processes, and prioritize opportunities for AI-driven automation and operational improvement.
Design and implement AI-powered solutions for data aggregation, reconciliation, reporting, and workflow management.
Integrate SharePoint, Azure DevOps, Excel, and cross-organizational database data into a governed, centralized source of truth.
Build, enhance, and maintain interactive Power BI dashboards to replace manual spreadsheet and presentation-based reporting.
Develop automated data refresh processes, validation checks, and data-quality monitoring.
Implement generative AI use cases, including automated change summaries, natural-language data queries, data reconciliation, and reporting automation.
Maintain and troubleshoot Power BI dashboards, improving performance, usability, and data accessibility.
Collaborate with business stakeholders to translate reporting requirements and operational challenges into scalable technical solutions.
Document technical solutions, provide user training, and support adoption of AI and automation capabilities.
Measure and communicate improvements, including hours saved, reduced reporting cycle times, and increased data accuracy.
Demonstrate a prior AI project that optimized a workflow or improved operational efficiency, excluding confidential, proprietary, or customer-related information.