Snowflake Analytics Platform Engineer

IRIS Consulting LLC

Elk River (MN)

On-site

USD 110,000 - 160,000

Full time

9 days ago

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

IRIS Consulting LLC is seeking an Analytics Engineer to design, build, and optimize a modern manufacturing data platform. You will work closely with stakeholders to transform operational data into analytics-ready solutions, leveraging Snowflake, DBT, Matillion, and governance best practices to enable self-service analytics and future AI-driven capabilities.

The role requires deep data architecture expertise, strong communication skills, and experience delivering scalable data products that drive

Qualifications

Bachelor's degree in Computer Science, Engineering, or a related field.
6 years of data engineering and/or analytics engineering experience with Snowflake and DBT.
Experience querying MSSQL and REST APIs.
Experience with Git-based CI/CD deployment pipelines for data platforms.
Data Vault 2.0 architecture experience preferred.

Responsibilities

Design, develop, and maintain scalable data ingestion and orchestration processes using Matillion or similar enterprise ETL/ELT tools to integrate data from complex manufacturing systems into Snowflake.
Build, deploy, and support end-to-end data transformation pipelines using DBT and Snowflake, moving data through Bronze (raw), Silver (integrated), and Gold (analytics-ready) layers.
Develop and maintain Data Vault 2.0 models and related data architecture standards to ensure data is auditable, scalable, and adaptable to evolving business systems and ERP environments.
Create and optimize dimensional models, star schemas, and semantic data layers that support self-service analytics and high-performance reporting in Power BI and other analytical tools.
Design, implement, and manage CI/CD processes, source control standards, and automated deployment pipelines using GitHub Actions, Azure DevOps, or similar technologies to ensure reliable and repeatable releases.
Establish and maintain monitoring, logging, alerting, and observability capabilities to proactively identify, troubleshoot, and resolve data pipeline and platform issues.
Implement and maintain automated data quality controls, validation testing, and observability frameworks to ensure the accuracy, completeness, and reliability of enterprise data assets.
Partner with Data Product Owners, business stakeholders, and cross-functional teams to evaluate technical requirements, assess solution feasibility, and translate business needs into actionable technical deliverables.
Provide technical leadership and guidance on data platform architecture, development standards, best practices, and documentation to ensure scalable and maintainable solutions.
Define and promote architectural patterns that support future AI, machine learning, and advanced analytics capabilities within the Snowflake ecosystem, including semantic layers, secure data access, search, and agent-based workflows.
Analyze and optimize Snowflake compute utilization, data processing performance, and SQL query execution to improve platform efficiency, scalability, and end-user experience.
Collaborate effectively across technical and business teams, communicating complex concepts clearly and contributing to the successful delivery of enterprise data and analytics initiatives.