Shamrock Foods Company is seeking a Data Engineer to design and build modern data pipelines, dimensional models, and semantic layers to power data & AI driven analytics solutions across the enterprise.
Requirements
- Hands-on experience with Azure Databricks (Spark, Delta Lake)
- Strong SQL and Python skills for data transformation and pipeline development
- Experience building Power BI semantic models and designing star schemas
- Familiarity with Azure Data Lake, Data Factory, Synapse Analytics
- Ability to translate business requirements into scalable data solutions
- Experience using DBT
- Knowledge of Azure DevOps CI/CD pipelines
Responsibilities
- Build, optimize, and maintain data pipelines using Azure Databricks, DBT and other Azure services.
- Design and implement dimensional data models (star, snowflake schemas) that support analytics and AI use cases.
- Develop and maintain semantic models for Power BI, enabling self-service analytics and enterprise reporting.
- Collaborate with the AI Solutions Architect and data scientists to prepare data for machine learning workflows.
- Ensure data solutions meet performance, reliability, security, and governance standards.
- Document data flows, data models, and technical designs in support of architecture reviews and operational excellence.
- Troubleshoot and improve existing data pipelines and models.
Other
- This role requires someone to work out of our home office in Phoenix, Arizona 2-3 times a week.
- 2–5 years of experience in data engineering, BI development, or similar role
- Azure certifications (Azure Data Engineer Associate, Databricks Data Engineer, etc.)
- Exposure to MLOps or integrating data pipelines with ML models
- Familiarity with Google Cloud (GCP)
