Senior Data Warehouse Developer
---Who We Are---
Defyned Brands is a premier developer, marketer, distributor and multi-channel retailer of best-in-class vitamins, supplements and apparel. Originally founded as a specialty retailer with one location, the company has grown to own and operate 50 5 Star Nutrition specialty supplement stores, five nationally recognized vitamin and supplement brands and over 200 employees all driven by the same mission: To deliver outstanding results for our customers. We are dedicated to the ultimate customer service experience & company culture is the centerpiece of our company which has been the fuel on the fire for our tremendous success & growth.
---A Day in the Life---
Defyned Brands is seeking a highly motivated and experienced Senior Data Warehouse Developer to drive data-centric organization through continued development and ownership of our recently implemented data stack and help the organization solve its biggest data challenges. Reporting to the Director of Finance and Operations, this individual will continue build-out of our Snowflake data warehouse, integrate with source systems via ETL such as Stitch and other integration pathways, model data utilizing dbt, and ensure information within data warehouse is accurate and reliable. Responsibilities will include conducting full development lifecycle – requirements gathering, specification development, coding, testing, production deployment and documentation while managing daily data warehouse related processes. Individual will also work collaboratively with cross-functional partners to identify and design data requirements and use roadmap to support and drive organizational strategies and objectives.
+Own existing and future data warehouse infrastructure (i.e. Snowflake, Stitch, dbt, etc.) to drive business intelligence strategies and initiatives +Further develop Snowflake data warehouse by defining and developing pipeline solutions – architect end-to-end design, mappings and hands-on development to collect, cleanse, transform and model data from disparate sources into reconcilable and usable data sets +Architect database structures and objects, fine tune SQL queries for performance, create queries and data transfer processes to ensure optimal performance of ETL and data models; while debugging, troubleshooting and fixing data and system related issues as they arise +Establish, maintain and promote consistent methodology for analytics deployment +Support front-end analysis in development of Looker visualization tool and data analysis practices +Continually analyze existing data stack and share new data product recommendations to improve data consolidation, management, analysis and interpretation
+Expert in SQL and ability to write complete, optimized development queries across large and complex data sets; experience with R, Python, etc. a plus +Technically skilled in modern big data principles and technologies; existing data stack experience ideal – Snowflake, Stitch, dbt, Looker +Ability to scale and document processes, systems and controls surrounding data +Passionate, high energy, highly motivated and self-starter who enjoys working in a fast-paced, high-growth and dynamic environment +Exceptional attention to detail and accuracy +Ability to manage and prioritize requests through strong project and time management skills
---Qualifications and Experience---
+Bachelor’s degree in quantitative/technical field (i.e. computer science, information systems, engineering, math, statistics, etc.) +5+ years of hands-on experience implementing and managing data warehousing solutions +Exceptional technology knowledge and experience in data warehouse methodologies including data management, data integration, ETL and analytics system architecture +Experience managing data from numerous source systems including ERP’s (i.e. NetSuite), commerce platforms (i.e. Shopify), marketing analytics (i.e. Google Analytics), etc. +Previous experience with dbt a plus +Experience working in fast-paced start-up environment with systems/processes/procedures requiring development
Defyned Brands offers a very competitive compensation & benefit package that includes: quarterly bonus potential, company sponsored health, dental & vision insurance; life and long-term disability insurance, unlimited snacks & drinks, generous product employee discounts, team social events, onsite gym & a casual high energy working environment.
Defyned Brands is an Equal Opportunity Employer. This description represents the job in general terms and is not designed to contain or to be interpreted as a comprehensive listing of all the duties, responsibilities, and qualifications required of the employee performing this job.