Company Description
Dynatrace exists to make software work perfectly. Our platform combines broad and deep observability and continuous runtime application security with advanced AIOps to provide answers and intelligent automation from data. This enables innovators to modernize and automate cloud operations, deliver software faster and more securely, and ensure flawless digital experiences.
Job Description
-
Design and develop data models in Snowflake with DBT for internal business partners including finance, accounting, sales, marketing and HR
-
Write advanced SQL queries for ELT/data warehousing/Business Intelligence
-
Data transformation and Data Analytics Documentation
-
Collaboration and leadership skills to drive projects
-
Promote business data models and new metrics to support Self Service Reporting.
-
Perform ad-hoc queries/reports to provide support for special initiatives and business partners
-
Follow best practices and standards around data governance, security and privacy.
-
Comfortable working in a fast-paced team environment coordinating multiple projects.
-
Effective software development life cycle management skills and experience with GitHub
-
Leverage tools like Fivetran, DBT, Snowflake, GitHub, Power BI, SQL and Python to drive ETL, data modeling and analytics.
Qualifications
Minimum Requirements:
-
10+ years of experience of coding complex SQL data models
-
10+ years of experience designing and building data models for reporting and self-service analytics
-
Bachelors degree in a related field
Preferred Requirements:
-
Advanced understanding of data modeling, data warehousing and reporting concepts
-
Advanced SQL programming skills
-
DBT and Snowflake experience
-
Experience with GitHub, Python, Fivetran, APIs and subscription analytics preferred
-
Experience with Power BI and other Reporting tools preferred
-
Knowledge of NetSuite and Salesforce preferred.
-
Excellent verbal and written communication skills
-
Demonstrated analytical ability
-
Creative problem-solving skills
-
Strong communications skills and ability to collaborate with a team
-
Able to manage multiple projects and pivot when needed
Additional Information
DOE, salary $130K – $140K, plus Health, Dental, Life, STD, LTD, 401K, PTO. Total compensation may vary depending on candidate experience/education and location.
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 . 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.
fivetran API Analytical skills ELT netsuite snowflake-cloud-data-platform Communication data-modeling Security data governance Salesforce Project management DBT Power BI Business Intelligence (BI) Verbal communication Data Analyst Problem-solving Python data-warehouse Privacy management Collaboration GitHub SQL Written communication skills Analytics ETL Leadership