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
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/
