Shamrock Foods Company is seeking an AI Solutions Architect to shape the strategic use of data and AI across the organization, driving scalable, governed, and transformative insight-driven decisions.
Requirements
- Hands-on experience with dimensional modeling, star and snowflake schema design, and semantic layer development
- Proficiency with Databricks, Microsoft Azure services (Synapse, Data Factory, Data Lake, Fabric) and Power BI
- Experience with GenAI/LLMs, Agentic AI tools, methods and concepts
- Understanding of MLOps (e.g., MLflow, Azure AutoML) and integrating ML models into BI/Reporting layers and/or applications
- Azure, Databricks or GCP Certification (Data Engineer, AI Engineer, or Solution Architect) preferred
- Experience collaborating closely with business users to ensure usability and success
- Strong communication skills and ability to engage both technical and non-technical stakeholders
Responsibilities
- Architect AI/ML and advanced analytics solutions: from use-case identification to data ingestion and transformation to model development, deployment, and monitoring.
- Design dimensional data models (star-schema) and semantic layers that enable performant, self-service analytics and AI-ready data structures.
- Collaborate with data engineers and data teams to build scalable data pipelines and design semantic models and datasets in tools like Databricks and Power BI.
- Lead the integration of ML models into data platforms, ensuring business users can consume predictions via reports, dashboards, and APIs.
- Define and promote AI-ready and analytics-ready architecture standards including practices for data governance, lineage, observability and cataloging.
- Partner with business and IT stakeholders to translate business goals into AI/ML solutions and dimensional models that meet reporting, analytics, and automation needs.
- Mentor junior engineers and analysts on advanced analytics concepts, data modeling and engineering best practices.
Other
- Bachelor’s or Master’s degree: Computer Science, Data Science, Engineering, or related field
- 5–8 years of experience delivering AI/ML, advanced analytics, or enterprise data platform solutions
- Strong communication skills and ability to engage both technical and non-technical stakeholders
- Consulting or professional services experience preferred
- Must come on-site to our home office located in Phoenix, Arizona at least 2-3x a week