BI Engineer IV

Role Overview

• 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