Data & AI Solutions Developer

Cerro Wire LLC is hiring a Data & AI Solutions Developer to build and support governed data products, Power BI solutions, and applied AI tools. The role owns user-facing data and AI solutions from design through production support, with a focus on Microsoft Fabric, Azure AI Foundry, security, and adoption.

Responsibilities

• Build and maintain gold-layer data products, semantic models and standardized business metrics in Microsoft Fabric, partnering with the Senior Data Engineer on upstream pipelines
• Develop Power BI reports and Copilot-enabled experiences that let users securely interact with governed datasets
• Implement usage telemetry and adoption dashboards for BI, automation and AI tools, and recommend improvements based on usage patterns
• Design, build and deploy AI agents, retrieval-augmented generation (RAG) solutions and agentic workflows using Azure AI Foundry, Microsoft Copilot and other approved enterprise AI platforms
• Build and maintain embeddings, vector stores and grounding strategies that connect AI solutions to governed data
• Evaluate AI solutions for retrieval quality, groundedness, reliability, latency and usability, and build in monitoring, logging, error handling and human-in-the-loop review
• Automate business processes with Power Automate and Power Apps where they are the right fit
• Apply data classification, PII handling and access controls, including row-level security and Entra ID, to every BI and AI solution
• Design AI solutions to resist prompt injection and limit agent permissions to the minimum required
• Serve as a technical resource in Data & AI governance and use-case reviews
• Own technical delivery once requirements are approved: design, development, testing, deployment, documentation and production support
• Follow SDLC practices, including Git version control, Fabric deployment pipelines, testing, release management and documentation of designs, data definitions, lineage and runbooks
• Build reusable components, templates and prompt patterns that speed future development
• Run proofs of concept and make evidence-based technology recommendations covering fit, security, scalability and cost, including Fabric capacity and AI consumption
• Work with analysts, the Senior Data Engineer, plant and business stakeholders, and vendors on design, implementation and knowledge transfer
• Mentor peers through design and code reviews, and lead demos and office hours that build practical adoption of data and AI

Preferred

• Microsoft Certified: Fabric Analytics Engineer Associate
• Production experience with AI agents, RAG, embeddings or vector databases, including Azure AI Foundry
• Experience with Microsoft Power Platform (Power Automate, Power Apps)
• Experience with row-level security, Entra ID or Microsoft Purview
• Experience in manufacturing, or with Sage X3 or Salesforce data
• Microsoft Certified Fabric Analytics Engineer Associate
• AI Agent Production Experience
• Embeddings
• Vector Databases
• Azure AI Foundry
• Microsoft Power Platform
• Power Automate
• Power Apps
• Row-Level Security
• Microsoft Entra ID
• Microsoft Purview
• Manufacturing Experience
• Sage X3
• Salesforce Data

Benefits

• Health Benefits effective day one (Life, Health, Dental, Vision)
• Holiday pay effective day one
• Vacation and Personal Time Off (prorated & accrued)
• Tuition Reimbursement
• Employee Discount Program
• Six Sigma & Lean Training
• Learning & Development Training
• 401k with company matching
• Remote work in the United States

Company

• Global manufacturer of commercial foodservice equipment and supplies
• Carol Stream, Illinois, USA
• https://marmonfoodservice.com/
• Founded in 1953
• 1001-5000 employees

Qualifications

• Candidates must be legally authorized to work in the United States on a permanent basis
• The company is unable to provide employment visa sponsorship now or in the future
• Bachelor's degree in Computer Science, Information Systems, Data Science, Software Engineering or a related field, or an equivalent combination of education and experience
• 3–5 years of experience in business intelligence, analytics engineering, data engineering or software development
• Hands-on experience with Microsoft Fabric or a comparable cloud data platform
• Strong SQL, including developing and troubleshooting complex queries and data structures
• Working proficiency in Python, including notebook-based or PySpark data work
• Power BI experience, including semantic modeling, DAX and report development
• Hands-on development of at least one generative AI solution, such as a RAG application, agent or LLM-integrated workflow
• Experience with Git-based version control
• Microsoft Certified: Fabric Analytics Engineer Associate
• Production experience with AI agents, RAG, embeddings or vector databases, including Azure AI Foundry
• Experience with Microsoft Power Platform (Power Automate, Power Apps)
• Experience with row-level security, Entra ID or Microsoft Purview
• Experience in manufacturing, or with Sage X3 or Salesforce data
• 3–5 years of experience in business intelligence, analytics engineering, data engineering or software development.

Required skills

• Azure AI Foundry, DAX, Generative AI, Git, Microsoft Certified Fabric Analytics Engineer Associate, Microsoft Fabric, Power BI, PySpark, Python, Retrieval-Augmented Generation (RAG), SQL, Semantic Modeling

Preferred skills

• Microsoft Certified: Fabric Analytics Engineer Associate

Experience

• 3-5 years