In collaboration with the BI team, design and engage engineering best practices (code review processes, git workflows, CI/CD)
Collaborate with the BI team to follow and keep up to date “Definition of Done” agreements
Collaborating with the BI team to architect and design modern, scalable warehouse architecture (Snowflake: dimensional models for reporting)
Evaluating and recommending data transformation methodologies, frameworks and tools
Collaborate with the Director of Engineering on Build vs. Buy decisions for tools and infrastructure
Collaborate with the BI Team to architect and design processes and standards for table design include primary and foreign keys, and audit columns
Optimize warehouse performance via partitioning, clustering, query design and other processes to balance fast execution versus spend
Collaborate with the BI Team to build repeatable transformation patterns and establish the standard use of frameworks
Collaborate with the BI Team to create automated data quality monitoring, including: quarantine tables, alerts, and error handling
Conduct in-depth data analysis to uncover trends, patterns, and correlations that drive business decisions
Architect and design operational dashboards that track pipeline health: data freshness, volume anomalies, schema drift, changes in error rates, etc.
Design and develop data warehouse structures to support Tableau explorer-users finding the linked data they need
Establish version control practices for analytics code and database objects
Perform complex statistical analyses and hypothesis testing to support strategic initiatives
Design and implement data processes and automation to enhance efficiency and accuracy
Confidently provide detailed insights and recommendations based on data analysis to influence business strategies
Provide support on data use and analysis to BI Developers, including SQL, structuring views, creating stored procedures and database analysis tasks
Ensure compliance with data integrity, security, and company policies in all analytical tasks
Stay current with industry trends, tools, and best practices in data analysis and visualization
Initiate, manage, and deliver multiple projects simultaneously, prioritizing tasks and meeting deadlines while coordinating the BI Team closely
Continuously enhance technical skills and knowledge in data analysis and visualization
Regularly exercise independent judgment and discretion while performing complex work and collaborating with the Director of Engineering regularly
Other duties as assigned.
Requirements
Bachelor’s degree in Computer Science, Mathematics, Economics, Information Management, Statistics, or a related field, or equivalent experience level, required
4-6 years of progressive professional experience in data work
Proven track record in conducting complex statistical analyses, executing projects, and generating actionable insights from large data sets
Advanced time management and organizational skills
Strong verbal and written communication skills
Fundamental orientation to collaborative work styles
Ability to handle a high volume of work and function in a fast-paced environment, on deadline
Self-motivated and directed, with keen attention to detail
Proficient using a computer, office software, video conferencing, and other computer programs including Google Workplace (Docs, Sheets, Calendar, Gmail, etc.)
Extensive experience in database management, database development, data querying with SQL
Proficiency in at least one coding language for the use of data analytics (e.g. Python, R, etc.)
Experience using data visualization tools like Tableau
Experience with ETL (extract, transform, load) best practices and tools
Advanced Proficiency in managing and developing data warehouse structures like materialized views and calculated fields to support fast analyses
Proficiency in developing and working with OLAP/data summary structures in a data warehouse setting
3-5 Years of working experience with Snowflake
Tech Stack
ETL
Python
SQL
Tableau
Benefits
Comprehensive health coverage including medical, dental, and vision
Generous time-off to support work-life balance including PTO, volunteer time, sick time, and paid holidays
401(k) plan with company match to support your financial future
Company culture rooted in shared values and community
Education tuition reimbursement program
Employee Assistance Program (EAP) and legal assistance benefit
Company-paid annual donation to a non-profit or charity of your choice
Employee recognition program with gifts and awards