BI Engineering Manager

Employer: EverCommerce Solutions Inc.

Headquarters Address: 3601 Walnut Street, Suite 400, Denver, CO 80205

Worksite Address: This is a fully remote position. Work from home benefit provided. Worksites are unanticipated.

Job Title: BI Engineering, Manager Salary: $224,058.00/year

Job Duties:

• 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.
• This is a fully remote position. Work from home benefit provided. Worksites are unanticipated.
• This position requires travel to the EverCommerce headquarters in Denver, Colorado, for five (5) business days per quarter.

Degree Requirement: Bachelor’s degree in Management Information Systems, Computer Science, Data Science, or a closely related field.

Experience required: Five (5) years of experience as a Marketing Analyst, Marketing Analytics Manager, Data Science Program Manager, BI Engineer, or a closely related occupation.

Special Requirements: 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:

• Any of the following data warehouses: Snowflake, AWS Redshift, or Databricks.
• Any of the following BI tools: Power BI, Looker, or Tableau.
• Any of the following knowledge management tools: Confluence, Notion, or Google Docs/Drive.
• Any of the following ETL orchestration tools: 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.
• Designing, building, and maintaining DAGs for the new ETL pipelines in Apache Airflow.
• Leading, mentoring, and collaborating with cross-functional teams and business stakeholders to gather reporting and data requirements.
• Either CircleCI or GitHub Actions.
• Either Kanban, Agile, or Scrum methodologies.

Travel Requirements: This position requires travel to the EverCommerce headquarters in Denver, Colorado, for five (5) business days per quarter.

To Apply: Please apply through https://www.evercommerce.com/about-us/careers/. Only qualified applicants should apply. 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.

Benefits Information: https://www.evercommerce.com/about-us/careers/