IT-Analytics Engineer

Cretex • Brooklyn Park, MN

11d • $90,000 - $140,000

About The Position

Analytics Engineer is responsible for designing, building, and optimizing a modern manufacturing data platform that transforms complex operational data into trusted, analytics-ready solutions. The position combines hands-on data engineering with technical leadership, leveraging Snowflake, DBT, Matillion, and CI/CD best practices to develop scalable, high-performing data pipelines and models. Working closely with business stakeholders and product owners, the individual will ensure data quality, governance, and observability while building semantic data layers that support reporting, self-service analytics, and future AI-driven capabilities. The ideal candidate brings deep expertise in modern data architecture, strong communication skills, and experience delivering scalable data products that enable business insights and operational excellence. Stack: Snowflake, Snowflake AI/Cortex, DBT, Matillion, Dimensional Modeling, Data Vault 2.0, GitHub/CI-CD, Power BI

Requirements

• Bachelor’s degree in Computer Science, Engineering, or a related field
• 6 years of data engineering and/or analytics engineering experience with demonstrated expertise in Snowflake and DBT.
• Experience querying and consuming data from Microsoft SQL Server (MSSQL) and REST APIs.
• Understanding of data connectivity methods, including ODBC, ADO, and JDBC.
• Expert experience using Git-based source control workflows and building automated CI/CD deployment pipelines for data platforms.
• Proven experience designing and implementing Medallion/Lakehouse data architectures and dimensional data models.
• Demonstrated ability to communicate effectively with stakeholders at all levels of the organization and collaborate successfully across cross-functional teams.
• Proven ability to gather requirements, translate business needs into technical solutions, and work effectively with diverse team members and stakeholders.

Nice To Haves

• Experience with PostgreSQL, MySQL, or MariaDB is a plus.
• Working knowledge and experience with Data Vault 2.0 architecture is preferred.
• Experience working with manufacturing data domains, including Bills of Materials (BOMs), Inventory, Sales and Work Orders, Supply Chain, Quality (NCRs/CAPA), Labor and Scrap Reporting, Machine Usage, and Efficiency Metrics.
• Familiarity with machine interfaces and streaming data ingestion technologies.
• Hands-on experience with Snowflake performance tuning, governance, role-based access controls, and platform capabilities that support scalable analytics and AI-ready data products.
• Familiarity with Snowflake AI capabilities, including Cortex AI (CoCo), Cortex Analyst, Cortex Search, Snowflake CoWork, Snowpark, Agents, or related features that support governed AI/ML use cases within the data platform.
• Experience preparing governed, well-modeled data products for AI/ML and agentic use cases, including metadata management, semantic descriptions, access controls, and business-friendly data definitions.
• Experience with analytics visualization tools, such as Power BI, and an understanding of how downstream consumers interact with data products.
• Ability to write custom Python scripts to support integrations when out-of-the-box tools do not meet business or technical requirements.

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.

Benefits

• 401k retirement savings plan with a company match contribution
• onsite health clinics
• discretionary holiday bonus program (based on years of service)
• Cretex University
• 24/7 employee assistance program with access to five confidential visits with a licensed counselor at no cost
• wellness program with incentives
• employee death benefit
• employee sick and safe leave
• comprehensive medical insurance with access to virtual providers
• dental insurance (Little Partners Dental benefit covers services 100 percent for children 12 and younger when seen by a Health Partners in network provider)
• vision insurance
• a pre-tax health savings account
• healthcare and dependent care pre-tax reimbursement accounts
• paid holidays
• paid time off
• discretionary profit sharing program
• Parental Leave
• accident and critical illness benefits
• optional employee, spouse, and child life
• short and long term disability
• company provided life insurance
• tuition assistance programs

What This Job Offers

• Job Type: Full-time
• Career Level: Senior