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