Skip to main content
Tallo logoTallo logo

Find Jobs

Find Jobs Near You – Available Work in Your Location

Rainbow bridge illustration

Find your next move.

Your current job is just the starting point. See where workers like you actually went next.

Powered by real career transition data in the U.S. labor market over the past 20 years. How it works

Requires a free account

Skip to job details

Back to Results

Apply for this opportunity

To apply for this job, you'll continue to an external website or email application.

Pantheon

Data Analytics Engineer

Job Description

Key Responsibilities Design, develop, and lead implementation of complex star-schema data models, including fact, dimension, bridge, and aggregate tables. Build, optimize, and govern DBT frameworks, models, testing strategies, and reusable development patterns. Architect, optimize, and troubleshoot large-scale Snowflake data structures, pipelines, and SQL workloads. Define and enforce enterprise data modeling standards, best practices, and design patterns. Lead architectural decisions related to dimensional modeling, normalization, denormalization, and analytical data structures. Partner with Data Engineers, BI Developers, Product Owners, Architects, and business stakeholders to deliver scalable analytical solutions. Mentor team members, conduct design reviews, and provide technical leadership across analytics engineering initiatives. Drive data quality, performance, governance, documentation, and continuous improvement of the analytics platform. Required Qualifications Expert-level hands-on experience with DBT development, testing, and deployment practices. Expert-level experience with Snowflake architecture, performance tuning, and SQL optimization. Proven experience designing and implementing enterprise-scale dimensional data models. Deep understanding of data warehousing, analytical modeling, and modern analytics engineering principles. Experience leading technical design decisions and influencing data architecture strategy. Strong communication and stakeholder management skills with the ability to translate complex technical concepts into business value.

Review key factors to help you decide if the role fits your goals.
Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
80
out of 100
Average of individual scores