Snowflake Engineer

Key Responsibilities Deliver the first Snowflake project within the first 3 months, working with Snowflake Architect: bring in an initial set of data from file stores and file transfer systems. Client bringing all of its data onto Snowflake and AWS and needs a senior Data Engineer to eventually lead the work.

Senior Data Engineer, Snowflake (Direct Hire)
Location: Minneapolis–St. Paul area, onsite 4 days per week in Maple Grove
Interviews: Schedule with Manager and then technical panel interview.

Overview
Client bringing all of its data onto Snowflake and AWS and needs a senior Data Engineer to eventually lead the work. The first project is small, but it's a chance to set the foundations, frameworks and best practices correctly from the start. Over time, this person will guide data platform modernization. The role mixes architecture, strategy and hands-on delivery.

Key Responsibilities

• Deliver the first Snowflake project within the first 3 months, working with Snowflake Architect: bring in an initial set of data from file stores and file transfer systems.
• Build the foundations and frameworks for bringing in more data sources, including PostgreSQL later on.
• Guide leadership on modern data architecture, including lakehouse vs. traditional EDW and medallion architecture.
• Work with parent company and Apex's data practice to carry shared standards into implementation.
• Advise on semantic layer design for analytics and future AI use cases.
• Apply engineering best practices: CI/CD, deployments and version control.

Must-Have

• Strong Snowflake experience, including setting up the foundational architecture and best practices.
• Strong AWS experience on modern data platforms.
• Strong hands-on SQL.
• PostgreSQL experience, ideally pg_lake. Other relational databases such as SQL Server or Oracle are acceptable.
• Data warehousing fundamentals: Kimball, dimensional modeling, star/snowflake schemas, OLAP vs. OLTP.
• Experience bringing in data from many different sources, including file-based sources.
• CI/CD, deployment and version control experience.
• A general understanding of SSO (Okta) and security best practices.
• Proven ability to guide stakeholders through a modernization effort.

Nice-to-Have

• Python, including AI-assisted development.
• GoAnywhere or similar file transfer and ingestion tools.
• Semantic layer and context layer design.
• Infrastructure as Code.