Business Intelligence Engineer II
About The Position
This role involves designing, developing, implementing, testing, documenting, and operating large-scale, high-volume, high-performance data aggregate tables and reports/dashboards/BI solutions for analytics and deep business insights. The position requires implementing data ingestion routines for both real-time and batch processing using best practices in data modeling and ETL/ELT processes. Responsibilities include providing on-line reporting and analysis using business intelligence tools and a logical abstraction layer against large, multi-dimensional datasets and multiple sources. The engineer will gather business and functional requirements and translate them into robust, scalable, and operable solutions within the overall data architecture. Key tasks include producing comprehensive data set documentation, metadata, BI reports, and dashboards. The role also involves examining customer traffic, browsing, and purchase behaviors to develop a deep understanding of business metrics, conducting deep dive analysis on customer pathing and other website and mobile app interactions to optimize site experience, and using tools like Snowflake, Python, Google Analytics, and Tableau to construct, maintain, distribute, and enhance dashboards and reporting. Ensuring analytics implementation provides clear visibility into the impact and value of new features and functionality, and building insights and recommendations through clear written and verbal communication are also crucial aspects of this position.
Requirements
- Bachelor’s degree in Computer Science, Business Analytics, Engineering, Mathematics, Data Analytics, Modeling, Data Modeling, or related field of study and 3 years of experience required as a Business Intelligence Analysts or related position/occupation.
- Master’s degree in Computer Science, Business Analytics, Engineering, Mathematics, Data Analytics, Modeling, Data Modeling, or related field of study and 1 year of experience required as a Business Intelligence Analysts or related position/occupation.
- Advanced knowledge of SQL and data modeling.
- Building automated data warehousing environments for production reports or tables.
- Experience with Redshift, Snowflake DWH’s and S3 or similar data lakes.
- Experience with Python/ R or similar coding languages.
Responsibilities
- Design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data aggregate tables and reports/dashboards/BI solutions for analytics and deep business insights.
- Implement data ingestion routines both for real time and batch using best practices in data modeling, ETL/ELT processes.
- Provide on-line reporting and analysis using business intelligence tools and a logical abstraction layer against large, multi-dimensional datasets and multiple sources.
- Gather business and functional requirements and translate these requirements into robust, scalable, operable solutions that work well within the overall data architecture.
- Produce comprehensive, usable data set documentation, metadata, BI reports, and Dashboards.
- Examine customer traffic, browsing and purchase behaviors by developing the deepest understanding of business metrics.
- Conduct deep dive analysis on customer pathing and other website and mobile app interactions to optimize site experience.
- Use available tools and data (Snowflake, Python, Google Analytics, Tableau, etc.) to construct, maintain, distribute and enhance dashboards and reporting.
- Ensure analytics implementation provides crystal-clear visibility into the impact and the value of new features and functionality.
- Build insights and create recommendations via written and verbal communications that can be understood by a broad audience.
Benefits
- 401k
- new hire and annual equity grant
- annual bonus (for C08+ positions)
- medical/Rx insurance
- vision insurance
- dental insurance
- life insurance
- disability insurance
- hospital indemnity insurance
- critical illness insurance
- accident insurance
- parental leave
- family services benefits
- backup dependent care
- flexible spending accounts
- telemedicine
- pet adoption reimbursement
- employee assistance program
- 10% off pet insurance
- 20% off at Chewy.com
- unlimited PTO (for exempt salary team members, subject to manager approval)
- six paid holidays per year
- paid sick and family leave (in compliance with applicable state and local regulations)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
