Snowflake Data Engineer - W2
Pantheon
Dice Job Match Score™
🛠️ Calibrating flux capacitors...
Job Details
Skills
- Snowflake
- DBT
- data modeling
- ADF
Summary
We are looking for a hands-on Data Analytics Engineer with strong experience in DBT, Snowflake, and dimensional data modeling to help build and maintain the analytical foundation that supports enterprise reporting and analytics.
Ideal Candidate:
A collaborative analytics engineer who enjoys working with teammates and stakeholders to transform complex source data into well-designed star-schema models using DBT and Snowflake, while contributing to a strong engineering culture and data modeling best practices
Key Responsibilities:
- Design, develop, and maintain star-schema data models, including fact and dimension tables.
- Build and support DBT models and testing frameworks to deliver trusted, analytics-ready datasets.
- Develop, optimize, and troubleshoot data structures and SQL workloads in Snowflake.
- Apply data modeling best practices and make informed decisions around dimensional design, normalization, and denormalization.
- Partner closely with Data Engineers, BI Developers, Product Owners, and business stakeholders to translate requirements into scalable analytical solutions.
- Participate in design discussions, knowledge sharing, and peer reviews to promote consistent modeling standards across the team.
- Support data delivery from ingestion through transformation and into the semantic layer for reporting and analytics.
- Document modeling decisions and collaborate with team members to continuously improve data architecture and engineering practices.
Required Qualifications:
- Strong hands-on experience with DBT development and testing.
- Strong experience with Snowflake and SQL optimization.
- Proven experience designing and implementing star-schema dimensional models.
- Deep understanding of fact and dimension modeling and analytical data warehouse concepts.
- Ability to work effectively in a collaborative, cross-functional team environment and communicate technical concepts to both technical and non-technical stakeholders.
Preferred Qualifications:
- Azure Data Factory (ADF)
- Power BI Semantic Models
- Python or Power Query
- DP-203 or SnowPro certifications
.
- Dice Id: 10110117
- Position Id: 9054204
- Posted 5 hours ago
Company Info
Pantheon Inc. was founded in 1997 as a full service software engineering company, engaged in: Software product development, Software development support and consulting services, and Turnkey software development.
Pantheon was founded by technology and business experts who are pioneers in the field of software engineering, both in the commercial space and academia.
Our flagship product Odyssey is used by many Fortune 500 multi-national companies around the world. Odyssey is actively used in 13 countries spanning many continents.
Pantheon puts science to work by creating innovative products and solutions that have proved to be increasingly critical to business success. This is accomplished by helping organizations manage change, manage lifecycle of information assets, and meet compliance and audit challenges. Our aim is to help our customers meet their goals through expertise, efficiency and sound decision-making in everything we do. We have the ability to innovate in response to market needs, drawing on our experience and top quality technical talents.
What do we look for?
We look for talented and creative professionals who are capable of being adaptive and responsive to the needs of our customers. The environment is challenging and dynamic, providing many opportunities for displaying one's drive, commitment and energy, all of which are necessary to keep us moving forward. If you think you possess these qualities and strive for challenges, then go ahead and apply to be part of the team at Pantheon.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs