Data Engineer, Business Intelligence & Analytics at Rapid7

| Greater Boston Area
Sorry, this job was removed at 2:24 p.m. (EST) on Thursday, September 3, 2020
Find out who's hiring in Boston.
See all Data + Analytics jobs in Boston
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

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

The opportunity

Rapid7 is looking for a Data Engineer to design and implement data models, own the ETL process & influence data warehousing strategy. You’ll work with modern data warehousing technologies such as Snowflake, Airflow, Docker and more. In this role you’ll 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 you’ll 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

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.


Rapid7 is conveniently located between the North End and West End of Boston, with plenty of restaurants, bars and public transport close by.

An Insider's view of Rapid7

What does your typical day look like?

For the majority of the day it’s a mix of weekly check-ins with various teams, project updates, and the occasional brainstorm.

When I’m not in meetings I’ve got headphones in while planning, writing, or designing — at my desk or perched somewhere around the office.


Senior Brand Storyteller

What are Rapid7 Perks + Benefits

Volunteer in local community
Once a year, Rapid7 offices across the globe close for the day so employees can volunteer.
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Onsite Gym
Retirement & Stock Options Benefits
401(K) Matching
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Our game room includes Ping Pong.
Stocked Kitchen
Rapid7 has a fully stocked kitchen including unlimited snacks, coffee, tea and all of the flavored sparkling water you can handle.
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Promote from within
Time allotted for learning
Online course subscriptions available
Paid industry certifications
More Jobs at Rapid726 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Rapid7's full profileSee more Rapid7 jobs