AI Data Engineer 1
About The Position
This team is seeking an AI Data Engineer to modernize the management and reporting of roadmap and portfolio data. The contractor will use AI and automation to streamline workflows across SharePoint, Azure DevOps (ADO), Excel, and cross-organization databases, replacing manual, slide- and spreadsheet-based reporting with live Power BI dashboards. The role includes assessing current workflows, establishing a baseline for manual effort, and prioritizing automation opportunities. The engineer will integrate data from multiple sources into a governed single source of truth with automated refresh and data-quality checks, and build and maintain Power BI dashboards and AI use cases for change summaries, data reconciliation, natural-language Q&A, and report automation. The contractor will document solutions, train users, and report outcomes such as hours saved, cycle-time reduction, and data quality. A typical day may include assessing workflows, prioritizing AI-based automation opportunities, and maintaining or troubleshooting existing Power BI dashboards. Contractor performance will be measured by quality of work.
Requirements
- Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, or a related field, or equivalent experience.
- 4+ years in data engineering, business intelligence, or analytics automation.
- 2+ years building production generative-AI solutions, such as with Copilot Studio, Azure OpenAI, AI Builder, or Microsoft 365 Copilot.
- Expertise in Power BI, including data modeling, DAX, Power Query (M), refresh, deployment, and row-level security.
- Experience with Azure DevOps queries, Analytics/OData, and REST APIs; Power Automate; SharePoint Online; advanced Excel; SQL; and Python.
- Clear communication skills and ability to translate business needs into technical solutions and executive-ready visuals.
- Sufficient knowledge and experience with company Power Platform tools, including Power Apps and Power BI, as well as Azure DevOps and SharePoint.
- Proven track record implementing AI use cases to optimize workflows and data aggregation.
- Ability to provide a live walkthrough at interviews without confidential employer or client data.
Nice To Haves
- Experience with hardware, supply-chain, or product roadmap and portfolio data.
- Experience with Microsoft Fabric, Dataverse, or KQL.
- Experience with Power Platform ALM and Git.
- Microsoft certifications in Power BI, Fabric, Power Platform, or Azure AI.
- Experience optimizing AI workloads in an enterprise environment, building Power BI dashboards, aggregating data across multiple platforms or systems, and using AI to improve workflows or operational efficiency.
Responsibilities
- Assess current workflows and baseline manual effort.
- Prioritize automation opportunities by impact, including opportunities to use AI.
- Integrate data from SharePoint, Azure DevOps, Excel, and cross-organization databases into a governed single source of truth.
- Set up automated data refresh and data-quality checks.
- Build, maintain, and troubleshoot Power BI dashboards.
- Build AI use cases for change summaries, data reconciliation, natural-language Q&A, and report automation.
- Document solutions and train users.
- Report the impact of solutions, including hours saved, cycle-time reduction, and data quality.
- Provide a live walkthrough of relevant work at interviews without using confidential employer or client data.
