Business Intelligence Engineer

EverCommerce (Nasdaq: EVCM) is a leading service commerce platform, providing vertically-tailored, integrated SaaS solutions that help more than 690,000 global service-based businesses accelerate growth, streamline operations, and increase retention. Its modern digital and mobile applications create predictable, informed, and convenient experiences between customers and their service professionals. With its EverPro, EverHealth, and EverWell brands specializing in Home, Health, and Wellness service industries, EverCommerce provides end-to-end business management software, embedded payment acceptance, marketing technology, and customer experience applications. Learn more at EverCommerce.com.

EverCommerce is seeking to fill the role BI Engineer II. The Business Intelligence (BI) Engineer II is responsible for developing and managing the organization's BI infrastructure, including the creation and maintenance of data pipelines, reporting systems, and analytics tools. This role involves collaborating with various departments to gather requirements, design data solutions, and deliver actionable insights that support strategic decision-making. The BI Engineer II will leverage a deep understanding of data warehousing, visualization, and analytical techniques to enhance business performance and drive data-informed strategies.

Key Responsibilities

• Data Integration and Management: Design, build, and maintain ETL (Extract, Transform, Load) processes and data pipelines to ensure the accuracy, timeliness, and reliability of data.
• Data Modeling: Design and implement data models to support BI solutions, ensuring that data structures are optimized for query performance and reporting needs.
• Collaboration: Work closely with stakeholders and cross-functional teams to understand business requirements, and translate them into technical solutions.
• Optimization: Continuously monitor and optimize BI processes and tools for performance, efficiency, and scalability.
• Documentation: Maintain thorough documentation of BI systems, processes, and data models to ensure consistency and facilitate knowledge transfer.
• Troubleshooting and Support: Provide technical support and troubleshoot issues related to BI systems and data integration.

Skills and Experience Required

• Technical Expertise: Proficiency in SQL, data warehousing concepts, and BI tools (e.g., Tableau, Power BI, Looker). Experience with ETL tools (e.g., Airflow, Talend) is a plus.
• Software Experience: experience with dbt, airflow, and databricks are strongly encouraged.
• Data Modeling Skills: Strong skills in data modeling, including experience with dimensional modeling, star schemas, and normalized data structures.
• Programming Skills: Experience with scripting languages such as Python or R for data manipulation and analysis.
• Experience: 2+ years of experience in a BI engineering or data analysis role, with a proven track record of delivering BI solutions.
• Communication: Excellent verbal and written communication skills with the ability to present technical information to non-technical stakeholders.
• Problem-Solving: Strong problem-solving skills and the ability to work independently and as part of a team.
• Education: Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field. Advanced degree or relevant certifications (e.g., Microsoft Certified: Data Analyst Associate) is a plus.

Key Performance Metrics

• Data Accuracy: Accuracy of data within BI reports and dashboards, measured by error rates and feedback from users.
• Timeliness: Adherence to project timelines for the development and deployment of BI solutions.
• User Satisfaction: Stakeholder satisfaction with BI tools and reports, assessed through surveys and feedback.
• System Performance: Performance metrics of BI systems, including data processing times, query performance, and system uptime.
• Innovation: Contribution to the improvement and optimization of BI processes and tools, including the implementation of new features or techniques.

This position requires a blend of technical acumen, analytical capability, and collaborative spirit to drive the organization's data strategy forward. The BI Engineer II will play a critical role in transforming data into actionable insights that support business growth and efficiency.

Where: This is a fully remote, US based position with minimal to no travel required. You may be asked to travel up to 4 times per year for quarterly planning. The EverCommerce team is distributed globally, with teams in the U.S., Canada, the U.K., Jorda