BI Engineering, Manager

EverCommerce

12d•Remote

About The Position

EverCommerce Solutions Inc. is seeking a BI Engineering Manager to lead and optimize their Business Intelligence (BI) engineering team. This fully remote position involves overseeing the design, development, and implementation of BI systems and solutions, establishing Service-Level Agreements (SLAs) for data, and producing data visualizations. The role requires working with data engineering teams to integrate external data sources, build data pipelines, and design complex data models using SQL and dbt. Automation of dbt/SQL models through ETL orchestration tools like Apache Airflow and ensuring smooth code deployment using CI/CD tools are key responsibilities. The manager will also lead, mentor, and collaborate with cross-functional teams and stakeholders, contribute to data strategy, establish governance standards, manage projects using Agile methodologies, and perform advanced analyses in large-scale data warehouse environments. While the position is fully remote, it requires quarterly travel to the EverCommerce headquarters in Denver, Colorado.

Requirements

Bachelor’s degree in Management Information Systems, Computer Science, Data Science, or a closely related field.
Five (5) years of experience as a Marketing Analyst, Marketing Analytics Manager, Data Science Program Manager, BI Engineer, or a closely related occupation.
Two (2) of the five (5) years of experience must be in a managerial or team lead position within a BI engineering/data warehousing or similar industry.
Demonstrable knowledge and prior experience in: Snowflake, AWS Redshift, or Databricks.
Demonstrable knowledge and prior experience in: Power BI, Looker, or Tableau.
Demonstrable knowledge and prior experience in: Confluence, Notion, or Google Docs/Drive.
Demonstrable knowledge and prior experience in: Apache Airflow, MWAA, or dbt Jobs.
Demonstrable knowledge and prior experience in: Designing and implementing complex data models using SQL query in dbt to support dashboards and ad hoc analysis and to transform raw source data into usable derived tables for BI/analytics tool consumption and visualization.
Demonstrable knowledge and prior experience in: Designing, building, and maintaining DAGs for the new ETL pipelines in Apache Airflow.
Demonstrable knowledge and prior experience in: Leading, mentoring, and collaborating with cross-functional teams and business stakeholders to gather reporting and data requirements.
Demonstrable knowledge and prior experience in: CircleCI or GitHub Actions.
Demonstrable knowledge and prior experience in: Kanban, Agile, or Scrum methodologies.
Must have U.S. employment authorization.
Do not apply if you are in F-1 or H-1 status or otherwise require employer sponsorship for U.S. employment authorization.

Responsibilities

Lead and optimize the Business Intelligence (BI) engineering team by overseeing the design, development, and implementation of BI systems and solutions.
Establish Service-Level Agreements (SLAs) for data availability and accuracy.
Produce and maintain data visualizations in dashboards and reports using Power BI, Looker, or Tableau.
Lead and conduct discovery based on established business requirements, including reading production code and documentation, user testing the app, and meeting with engineering and system owners.
Work with data engineering team members to connect external data sources and build long-term pipelines of the data to the organization’s main data warehouse.
Design and implement complex data models using SQL query in dbt to support dashboards and ad hoc analysis and to transform raw source data into usable derived tables for BI/analytics tool consumption and visualization.
Fully automate each created dbt/SQL model by scheduling tasks in ETL orchestration tools including Apache Airflow, MWAA or dbt Jobs.
Design, build, and maintain Directed Acyclic Graph (DAGs) for the new ETL pipelines in Apache Airflow.
Ensure smooth deployment of code to production by leveraging CI/CD monitoring tools including CircleCI or Github Actions.
Provide peer code review feedback on Github Pull Requests.
Lead, mentor, and collaborate with cross-functional teams and business stakeholders to gather reporting and data requirements, ensuring accurate and effective data models, dashboards, and reports.
Contribute to long-term data strategy and roadmap development.
Establish data governance, quality control, and documentation standards.
Manage projects using Kanban, Agile, or Scrum methodologies to ensure timely delivery and alignment with business objectives.
Perform advanced analyses in large-scale data warehouse environments including Snowflake, AWS Redshift, or Databricks and document the analyses in a structured and organized manner, using knowledge management tools including Confluence, Notion, or Google Docs/Drive.