Data and Analytics Engineer

Gravity IT Resources; Salt Lake City (UT); On-site; USD 110,000 - 150,000; Full time

Job summary

Gravity IT Resources in Salt Lake City is seeking a Data and Analytics Engineer to design and maintain end-to-end data pipelines using Snowflake, Airflow, dbt, Python, and Power BI. This engineering-first role emphasizes ownership of modeling, performance tuning, and semantic layers with AI-assisted workflows.

You will own the full pipeline lifecycle, collaborate on source models and CI checks, and work autonomously on vague goals to deliver scalable data solutions that empower stakeholders.

Qualifications

• Hands-on experience with Snowflake and Airflow in a real work environment.
• Proficiency in Python and SQL for production pipelines
• Experience with dbt, including writing tests, documentation, and structuring models
• Familiarity with Git/GitHub pull request workflows, branching, and reviews
• Knowledge of AI-first workflows using Claude, Copilot, Cursor, and VS Code
• Strong problem-solving skills, curiosity, and a gritty mindset
• Ability to work autonomously on vague goals and define deliverables independently

Responsibilities

• Build and optimize data pipelines leveraging Snowflake and Airflow
• Develop and maintain Snowflake data models and ensure performance tuning
• Create and manage production data workflows using Airflow, including monitoring, retries, and dependency management
• Develop data models and transformations with dbt, including tests and documentation
• Collaborate on source models, exposure documentation, and CI checks
• Build semantic models in Power BI, including DAX measures, refresh, and stakeholder engagement
• Use AI tools such as Claude, Copilot, Cursor, and VS Code to generate, review, test, and refine code, ensuring guardrails are followed
• Own the full pipeline lifecycle and deliver end-to-end solutions

Skills

SQL

Python

Snowflake experience

Airflow experience

dbt experience

Git workflows

AI-first workflows

Autonomy

Problem solving

Tools

Snowflake

Airflow

dbt

Power BI

Claude

Copilot

Cursor

VS Code

Job description

Job Title: Data and Analytics Engineer

Location Requirements: Onsite

Job Type: Direct Hire

Role Overview:
You will take charge of designing and maintaining end-to-end data pipelines using a set stack that includes Snowflake, Airflow, dbt, Python, and Power BI. This engineering-first role emphasizes ownership of modeling, performance tuning, and semantic layers, with heavy AI-assisted workflows. The culture values low bureaucracy, high autonomy, and problem solvers who are humble and scrappy.

Responsibilities:

• Build and optimize data pipelines leveraging Snowflake and Airflow
• Develop and maintain Snowflake data models and ensure performance tuning
• Create and manage production data workflows using Airflow, including monitoring, retries, and dependency management
• Develop data models and transformations with dbt, including tests and documentation
• Collaborate on source models, exposure documentation, and CI checks
• Build semantic models in Power BI, including DAX measures, refresh, and stakeholder engagement
• Use AI tools such as Claude, Copilot, Cursor, and VS Code to generate, review, test, and refine code, ensuring guardrails are followed
• Own the full pipeline lifecycle and deliver end-to-end solutions

Required Qualifications:

• Hands-on experience with Snowflake and Airflow in a real work environment
• Proficiency in Python and SQL for production pipelines
• Experience with dbt, including writing tests, documentation, and structuring models
• Familiarity with Git/GitHub pull request workflows, branching, and reviews
• Knowledge of AI-first workflows using Claude, Copilot, Cursor, and VS Code
• Strong problem-solving skills, curiosity, and a gritty mindset
• Ability to work autonomously on vague goals and define deliverables independently

Equal Employment Opportunity Statement
Gravity IT Resources is an Equal Opportunity Employer. We are committed to creating an inclusive environment for all employees and applicants. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other legally protected characteristic. All employment decisions are based on qualifications, merit, and business needs.