: Data Engineer, Business Intelligence & Analytics

Rapid7 is a leading provider of security data and analytics solutions that enable organizations to implement an active, analytics-driven approach to cyber security. We combine our extensive experience in security data and analytics and deep insight into attacker behaviors and techniques to make sense of the wealth of data available to organizations about their IT environments and users. Our solutions empower organizations to prevent attacks by providing visibility into vulnerabilities and to rapidly detect compromises, respond to breaches, and correct the underlying causes of attacks. Rapid7 is trusted by more than 9000 organizations across 125 countries, including 52% of the Fortune 100. To learn more about Rapid7 or get involved in our threat research, visit www.rapid7.com.

The opportunity

Rapid7 is looking for a Data Engineer to design and implement data models, own the ETL process & influence data warehousing strategy. Youll work with modern data warehousing technologies such as Snowflake, Airflow, Docker and more. In this role youll be working in tandem with BI & Analytics analysts and managers to assure that we have the right data at the right time to support our business needs. All of this in support of our single source of truth and continuing our progression up the analytics maturity curve towards pervasive predictive and prescriptive analytics.

If you have hands-on experience preparing ELT solutions and data warehouses, plus demonstrated examples of translating business objectives and requirements into the data needed to support key analyses, then we're looking for you. At Rapid7 youll collaborate with a creative, analytical and data-driven team to bring a single source of truth and self-service analytics to over 1600 employees in a culture that values innovation and teamwork.

In this role you will

  • Create and maintain optimal data pipeline architecture, and implement structures and process to assure efficiency, repeatability and standardization in the use of data within the BI team and Rapid7 as a whole

  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Python, and other languages.

  • Collaborate with the IT and Infrastructure teams on integration efforts between systems that impact data & Analytics

  • Assemble complex data sets that meet reporting and analytics requirements from business stakeholders

  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

  • Self-starter orientation, able to handle the prioritization of multiple project and tasks under time-bound deadlines

  • Develop processes to improve data management and promote data standards, data quality & data security

In return you will bring

  • BS or MS in Computer Science, Analytics, Statistics, Informatics, Information Systems or another quantitative field. or equivalent experience and certifications will be considered

  • More than 1 year of experience with modern data warehouse (Snowflake, Redshift, Azure, etcl)

  • More than 3 years experience building data pipelines

  • Extremely Proficient in SQL

  • Proficiency in Python, R, or other scripting language

  • Extensive experience in data integration (ETL) tools such as Informatica, SSIS, Talend, and Fivetran, Amazon Glue

  • Understanding of a version control system such as Git

  • Working knowledge and solid understanding of data architecture, data warehousing, and metadata management

  • Track record of managing and improving complex processes and very strong organizational and problem-solving skills


Employee Testimonials

James Green
Senior Director, Software Engineering

"My favorite memory of being a 'Moose' is our first ever company-wide hackathon in Cambridge. After a fun–filled week for the company kick-off, we still managed to deliver, through the night, on some amazing ideas."

Brett Garofalo
Manager, Mid-Market Sales

"I am not a natural–born salesperson or leader. Rapid7 gave me the mentorship opportunities and leeway to develop those skillsets. Having the support of my management allowed me to take risks and learn from mistakes instead of being tentative and afraid to put myself out there."

Aniket Menon Rapid7
Aniket Menon
Director, Product Management

"I love the infectious energy and fast–paced nature of the job. Unrelenting progress towards becoming the #1 company in Cyber Security. The sheer number of Products and Services we have launched in the last two years is a staggering achievement."

Dennis Nahas Rapid7
Dennis Nahas
Manager of Engineering, IT Devops

"The most fulfilling moments are seeing our products name dropped in the security press, knowing we all contributed to that."

Chris Wallace Rapid7
Chris Wallace
Director, People Strategy

"It's pretty cool to look around the room and know that I played a part in making all of that happen, and that I hopefully helped those people move into a role that they find really rewarding and exciting. Especially in a company where they in turn can have a big impact and take their careers to the next level. The fact that they are all good people, and that we all manage to have a bit of fun in the process, helps too."

Roy Hodgman Rapid7
Roy Hodgman
Manager, Data Scientist

"I feel that [our core value for] continuous learning best represents me because it's been essential to my career here. There are no shortage of tools and techniques that can be applied to the projects I work on, and despite what I think I might know about the problem at hand, more often than not there are new and novel ways to approach it."