Full-Stack Data Engineer: Snowflake & AI-Driven Analytics

Pure Magic; Alcoa (TN); On-site; USD 110,000 - 150,000; Full time

Job summary

Pure Magic is seeking a Full Stack Data Engineer to join the Data & Analytics team. You will design and tune SQL and Snowflake models, build pipelines across AWS, and integrate applications, warehouse, and reporting layers into a reliable data flow.

You will turn operational data from various source systems into trustworthy numbers, create Power BI dashboards, and apply AI tooling to modernize the platform. About three years of experience is expected.

Qualifications

• Bachelor’s degree in CS, Engineering, Information Systems, Mathematics, or related field, or equivalent practical experience.
• Approximately three years of professional data/analytics engineering or similar role.
• Deep SQL skills with optimization, relational design, and performance tuning.
• Hands-on Snowflake experience and dbt models development.
• Experience with AWS data services and integrating data pipelines.
• Strong analytics with Power BI data models and dashboards.

Responsibilities

• Design, build, and maintain ELT pipelines into Snowflake.
• Develop well-structured dbt models and performant SQL across the warehouse.
• Own end-to-end pipeline orchestration, scheduling, and monitoring.
• Integrate data across source apps, APIs, Snowflake, and downstream consumers.
• Deliver Power BI dashboards and semantic models for stakeholders.
• Apply AI tooling to automate data tasks and prototype services.
• Collaborate with engineers, analysts, and business partners.

Skills

SQL

Snowflake

dbt

AWS

Power BI

AI tools

Git

Data modeling

Analytics

Problem solving

Education

Bachelor’s degree in CS/Engineering/IS/Math or related

Tools

Airflow

Dagster

dbt Cloud

Docker

Terraform

AWS S3

Job description

Pure Magic is seeking a Full Stack Data Engineer to join the Data & Analytics team. You will design and tune SQL and Snowflake models, build pipelines across AWS, and integrate applications, warehouse, and reporting layers into a reliable data flow.

You will turn operational data from various source systems into trustworthy numbers, create Power BI dashboards, and apply AI tooling to modernize the platform. About three years of experience is expected.