EverCommerce - Business Intelligence Engineer

About the position 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. 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.

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.

Requirements

• 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.
• 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.

Nice-to-haves

• Software Experience: experience with dbt, airflow, and databricks are strongly encouraged.
• 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.
• 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.

Benefits

• Flexibility to work where/how you want within your country of employment – in-office, remote, or hybrid
• Continued investment in your professional development
• Day 1 access to a robust health and wellness benefits package, including an annual wellness stipend.
• 401k with up to a 4% match and immediate vesting
• Flexible and generous (FTO) time-off
• Employee Stock Purchase Program

Apply tot his job Apply To this Job