Lead Analytics Engineer - Data Engineering



Data Science
Prague, Czechia
Posted on Thursday, October 5, 2023

Analytics Engineers sit at the intersection of business teams, Data Analytics and Data Engineering and are responsible for bringing robust, efficient, and integrated data models and products to life. Analytics Engineers speak the language of business teams and technical teams, able to translate data insights and analysis needs into models powered by the Enterprise Data Cloud - Snowflake. The successful Analytics Engineer is able to blend business acumen with technical expertise and transition between business strategy and data development.

About the Team
The Data Platform team is responsible for providing Rapid7 stakeholders with timely, credible, democratized and integrated data solutions to gain insights and scale the business. Our team also enables Rapid7 stakeholders with the tools and training they need to explore the data themselves.

About the Role

As a key leader responsible for helping to bridge the gap between business and technology, in-service of data-driven business growth and operation the Analytics Engineer role requires equal amounts of business acumen and technical acumen. The lead analytics engineer will serve as a SME for our Data Platform team. You will provide high-quality accessible data to our Rapid7 stakeholders using the Modern Data Stack (Snowflake, DBT, Tableau) and help enable other Rapid7 developers to do the same.

In this role, you will:

  • Collaborate with team members and business partners to collect business requirements, define successful analytics outcomes, and design data models.

  • Build trust in all interactions, working backwards from a business impacting outcome, utilizing Agile data-product development.

  • Serve as the Directly Responsible Individual for major sections of the Enterprise Dimensional Model.

  • Design, develop, and extend dbt code repository to extend the Enterprise Dimensional Model (Co-owned by Data-engineering, BI and Go-To-Market Analytics).

  • Create and maintain architecture and systems documentation in the “Data Team” Handbook.

  • Maintain the Rapid7 Data Catalog, a scalable resource to support Self-Service and Single-source-of-truth analytics for business partners.

  • Document plans and results in user-stories, issues, Confluence pages - following the tradition of documentation first!

  • Craft code that meets our internal standards for style, maintainability, and best practices (such as the SQL Style Guide) for a high-scale database environment. Maintain and advocate for these standards through code review.

  • Approve data model changes as a Data Team Reviewer and code owner for specific database and data model schemas.

  • Provide data modeling expertise to all Rapid7 teams through code reviews, pairing, and training to help deliver optimal, DRY, and scalable database designs and queries in Snowflake and in Tableau.

  • Play a vital role in building the infrastructure for identifying strategic data opportunities for the business by highlighting / investigating areas of opportunity for all data consumers within Rapid7.

  • Assist with onboarding users and other administration tasks in DBT and Tableau

  • Assist with DBT and Tableau office hours to support developers across Rapid7

The skills you’ll bring include:

  • Ability to thrive in a hybrid organization.

  • “Be an advocate” for data-driven decision making in our cross-functional teams (Data Engineering, BI-Finance, Product Analytics).

  • Positive and solution-oriented mindset.

  • Comfort working in an agile, iterative environment.

  • Self-motivated and self-managing, with a high level of organizational skills.

  • Great communication: Regularly achieve consensus amongst technical and business teams.

  • Demonstrated capacity to clearly and concisely communicate complex business activities, technical requirements, and recommendations.

  • Demonstrated experience providing technical leadership & data design.

  • Have a solid understanding of data warehouses, business intelligence tools, and the Modern Data Stack.

  • Proficiency in engineering best practices (sprints, code reviews, etc.)

  • GitHub experience preferred

  • Python experience preferred (For use with DBT & airflow)

  • 1+ year(s) in dbt. This means you consider yourself well-versed in dbt modeling and understand how to build modular, performant models.

  • 6+ years in the Data space as an analyst, data-scientist, data-engineer, or equivalent.

  • 2+ years experience designing, implementing, operating, and extending enterprise dimensional data models.

  • 2+ years experience building reports and dashboards in a data visualization tool.

About Rapid7

At Rapid7, we are on a mission to create a secure digital world for our customers, our industry, and our communities. We do this by embracing tenacity, passion, and collaboration to challenge what’s possible and drive extraordinary impact.

Here, we’re building a dynamic workplace where everyone can have the career experience of a lifetime. We challenge ourselves to grow to our full potential. We learn from our missteps and celebrate our victories. We come to work every day to push boundaries in cybersecurity and keep our 10,000 global customers ahead of whatever’s next.

Join us and bring your unique experiences and perspectives to tackle some of the world’s biggest security challenges.