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.