Your role at Dynatrace
The primary focus of the Snowflake developer will be collaborating on the design and development of a modern data platform in Snowflake on AWS.
The Snowflake developer will take end-to-end ownership of their code in support of Power BI dashboards and visualizations.
The Snowflake developer will effectively translate business requirements into ELT pipelines using data replication tools (such as Fivetran) and data transformation tools (such as DBT) or advanced SQL scripting (views, Snowflake Store Procedure, UDF).
The Snowflake developer will champion development, deployment, code reviews, and production support.
Candidate should also be able to maintain and implement best practices for Snowflake infrastructure
What will help you succeed
Must have 10+ yrs. in IT, 4+ years working as a Snowflake Developer, and 7+ years in Data warehouse, ETL, and BI projects.
Must have experience in at least one complex implementation of a Snowflake Data Warehouse.
Expertise in Snowflake data modeling, ELT using Snowflake SQL or Modern Data Replication tools (i.e., Fivetran), Snowflake Store Procedures / UDF / advanced SQL scripting, and standard Data Lake / Data Warehouse concepts.
Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, and time travel.
Expertise in deploying Snowflake features such as data sharing, events, and lake-house patterns.
Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe and Big Data model techniques.
Experience in Data Migration from Redshift to Snowflake cloud data warehouse.
Deep understanding of relational data stores, methods, and approaches (star and snowflake, dimensional modeling).
Hands-on experience with DBT Core or DBT Cloud, including dev and prod deployment using CI/CD (BitBucket) is a plus.
Should be able to develop and maintain documentation of the data architecture, data flow, and data models of the data warehouse.
Certified on Snowflake with the SnowPro Core certification is a plus.
Good communication skills
Python and API experience is a plus
We support your career development and personal growth journey with knowhow, resources and dedicated time.
We believe in providing a flexible, fulfilling and trusting work environment that fits your current life situation.
Dynatrace exists to make the world’s software work perfectly. Our unified software intelligence platform combines broad and deep observability and continuous runtime application security with the most advanced AIOps to provide answers and intelligent automation from data at an enormous scale. This enables innovators to modernize and automate cloud operations, deliver software faster and more securely, and ensure flawless digital experiences. That is why the world’s largest organizations trust Dynatrace® to accelerate digital transformation.
We're an equal opportunity employer and embrace all applicants. Dynatrace wants YOU—your diverse background, talents, values, ideas, and expertise. These qualities are what make our global team stronger and more seasoned. We're fueled by the diversity of our talented employees.