Dynatrace: Senior Snowflake Developer

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

Why you will love being a Dynatracer

DOE, salary $140K - $160K, plus Health, Dental, Life, STD, LTD, 401K, PTO. Total compensation may vary depending on candidate experience/education and location.

Discover more

About Dynatrace

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.

More information

#LI-HC1
#LI-Remote

All your information will be kept confidential according to EEO guidelines.

We offer competitive compensation, company-sponsored premium benefits, medical, dental, vacation/holidays, company matching 401(k) Plan, etc. Dynatrace is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, sex, color, gender identity, religion, national origin, ancestry, citizenship, physical abilities, age, sexual orientation, creed, disability status, veteran status, pregnancy, genetic status, or any other characteristic protected by law. If your disability makes it difficult for you to use this site, please contact recruiting@dynatrace.com. Dynatrace participates in E-Verify, participant information in English and Spanish. Right to work information in English and Spanish. EEO is the Law/EEO is the Law Supplement. To be considered for this position, please upload your resume/CV.

Note to Recruiters and Placement Agencies: Dynatrace LLC (Dynatrace) does not accept unsolicited agency resumes. Please do not forward unsolicited agency resumes to our website or to any Dynatrace employee. Dynatrace will not pay fees to any third party agency or firm and will not be responsible for any agency fees associated with unsolicited resumes. Unsolicited resumes received will be considered property of Dynatrace.