Business Intelligence and Data Analytics Manager

View full description

Requirements:

• 7+ years of experience with SQL and data analysis
• 2+ at a fast-paced technology company
• Strong expertise in writing complex SQL queries and creating optimized views
• Experience with Python and R preferred
• Experience with business intelligence tools (e.g., Power BI, Tableau, Superset)
• Familiarity with Extract, Transform, and Load (ETL) processes
• Proven track record of translating business requirements into technical solutions
• Strong communication skills with ability to explain technical concepts to non-technical audiences
• Experience creating clear, impactful data visualizations
• Background in data modeling and database design
• Ability to manage multiple projects and priorities effectively
• DBT experience preferred
• ClickHouse experience is a plus
• Superset experience is a plus

Responsibilities:

• Design, develop, and maintain end to end data warehouse on behalf of the Operations’ team
• Manage related data molding work and optimize Extract, Transform, and Load (ETL) processes
• Some data engineering work needed to connect current data sources into the ClickHouse DWH
• Own Master Data Management across the Operations’ function, including data dictionary creation and management
• Ensure data quality, consistency, and accessibility
• Develop reusable reports and dashboards that become the “sources of truth” for respective functions, like Support, Sales, Partners
• Design and maintain the “all company” metrics’ dashboards
• Partner with central DWH team to ensure that Ops adheres to best practices, naming conventions
• Partner with central DWH team to extend AI functionality across Operations’ metrics (i.e. the DWAINE, Data Warehouse AI Natural Expert, project)
• Partner with Finance and Operations team members to ensure alignment on data definitions
• Develop and implement a set of audit reports across operational processes to validate the accuracy and efficiency of automations and integrations. This includes creating data snapshots to preserve audit history and historical reporting
• Perform ad hoc analyses as needed and create clear and concise visualizations to communicate findings
• Implement Tableau or related BI tool to ensure ease of use
• Lead enablement sessions to drive self service across stakeholder teams
• Potential expansion to support other teams, e.g., HR, Marketing, Finance
• Partner with Security team to ensure proper protocols are maintained to safeguard our data