Senior Data Warehouse Engineer

Road Scholar

Boston (MA)

Remote

USD 110,000 - 130,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, Dental and Vision Insurance
403(b) Retirement Plan with 5% match
PTO and paid time off during holidays
Professional development opportunities

Job summary

Road Scholar is seeking an experienced data warehouse developer to design, build, and manage load and transformation processes for the Data Warehouse, collaborating across IT and business partners. You will ensure data quality, performance, and adherence to standards while supporting production operations.

The role offers a remote-friendly environment with a focus on complex data pipelines, API data ingestion, and Linux-based tasks. Competitive salary and benefits are provided.

Qualifications

  • 7+ years of IT and business/industry work experience in a development role.
  • Bachelor's or Master’s Degree in Computer Science, Information Systems, or related field (or equivalent work experience).
  • Knowledge of Data Integration design, SQL, ETL-Tools, and data warehouse design (star schema).
  • Hands-on experience with Oracle Autonomous Database (ADB).
  • Experience with Boomi or similar integration/ETL platform.
  • Experience with ingesting data from API-based data sources and SQL Server.
  • Strong troubleshooting skills in complex data pipelines.

Responsibilities

  • Design, build, and manage Data Warehouse Load and Transformation solutions, including documentation and adherence to technical standards.
  • Supports data modelling and collaborates on warehouse and reporting design.
  • Translates business processes into technical design concepts for stakeholders.
  • Ensure quality of deliverables through design review, testing, and performance optimization.
  • Provide production support and troubleshoot Data Warehouse systems to minimize business impact.

Skills

SQL
Data integration
ETL design
Problem solving
Communication

Education

Bachelor's or Master’s Degree in Computer Science or related field

Tools

Oracle Autonomous Database (ADB)
Boomi
SQL Server
Linux

Job description

When it comes to creating educational travel adventures that enrich the lives and fulfill the dreams of more than 100,000 people every year, there's no organization better than Road Scholar. What's our secret? Dedicated and talented staff who believe in our mission.

At Road Scholar, we are committed to fostering a culture of inclusivity and belonging. We believe that by valuing a wide range of perspectives and experiences, we create a stronger, more innovative organization that reflects the communities we serve.

In addition, we are dedicated to being an environmentally sustainable organization. From the way we design our programs to how we operate as a team, we are striving to reduce our environmental impact and create a positive legacy for future generations.

About the role...

We are seeking an experienced, innovative and motivated developer to support our Business Analytics initiative. The role will collaborate closely with other IT staff as well as with business partners reporting to the Senior Director of Business Analytics. Responsible for Data Load and Transformation processes that populate the Data Warehouse, and systems related to the Data Warehouse. Will design, build and manage Data Warehouse Load and Transformation solutions of varying complexity, and will ensure completeness and efficiency of solutions and adherence to technical standards. The position will also play a critical role partnering with other development teams, testing and quality, and production support, to meet implementation dates and allow smooth transition throughout the development life-cycle. We're looking for someone with strong troubleshooting instincts who is energized by digging into complex data issues, and whose natural curiosity drives them to understand not just what broke, but why — curiosity is a key competency for success in this role.

Road Scholar offers a remote work environment. The compensation range for this exempt level salaried position is $110,000 - $130,000 based on experience.

In this role, you will...
  • Design, build, and manage Data Warehouse Load and Transformation solutions, including documentation and adherence to technical standards
  • Supports data modelling and actively collaborates with team members on warehouse and reporting design
  • Partners with business teams to understand business processes, and effectively translates and articulates technical design and implementation concepts to business partners
  • Ensures exceptional quality of deliverables through rigorous design review, testing, and compliance, and is accountable for the performance and efficiency of solutions
  • Provides production support and troubleshooting for Data Warehouse systems, quickly diagnosing and resolving data and pipeline issues to minimize business impact
  • Escalates issues and provides feedback on program specifications
We're seeking...
  • 7+ years of proven IT and business/industry work experience in a development role
  • Bachelor's or Master’s Degree in Computer Science, Information Systems, or other related field (or equivalent work experience)
  • Knowledge of and experience with Data Integration design, SQL, ETL-Tools, and data warehouse design (star schema, etc.)
  • Hands-on experience with Oracle is a must, including experience with Oracle Autonomous Database (ADB)
  • Experience with Boomi or a similar integration/ETL platform
  • Experience with ingesting data from API-based data sources and SQL Server
  • Comfortable working in Linux environments, including file manipulation, and experience automating file transfers via SFTP
  • Strong troubleshooting skills, with a proven ability to diagnose and resolve production issues in complex data pipelines
  • Self-starter with a great curiosity and ability to learn new skills and technology quickly — curiosity and a drive to understand the “why” are key competencies for this role
  • Ability to prioritize multiple deliverables, and respond under pressure with competing priorities
  • Ability to display creative thought leadership, drive results, innovation and change
  • Must possess strong written, verbal, analytical, problem solving, and communication skills
Why join the Road Scholar Team...

We offer a competitive compensation and benefits package!

  • Medical, Dental and Vision Insurance (with a substantial employee subsidy!)
  • 403(b) Retirement Plan with a company match of 5% after 1 year of employment!
  • Up to 20 days of PTO annually, accrued every payroll cycle
  • Enjoy a paid week off, in addition to your PTO, at the end of December to enjoy the holiday season!
  • A generous employee discounts on our programs
  • As a Road Scholar employee, you can opt-in to receive an IATA membership
  • We take professional development seriously which is why we provide LinkedIn Learning access to all employees amongst other professional development opportunities
  • That’s right, we’re fully remote!
  • To learn moreabout our benefits offerings, check us out at https://www.roadscholar.org/careers/
Equal Opportunity Employer

Road Scholar supports diversity in our staff, participants, and programs. An Equal Opportunity Employer Road Scholar values and supports individual differences and strives to create an environment that contributes to the success of both the individual and the organization. As an Equal Opportunity Employer, we consider applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, pregnancy, illness, marital or veteran status or disability or any other status protected by applicable law.

Cybersecurity

At Road Scholar, we are committed to cybersecurity and to providing a safe experience for job seekers. All official communication regarding employment opportunities will come exclusively via email from the official Road Scholar domain or from our applicant tracking system URL recruiting.ultipro.com. We never conduct interviews through texting applications or instant messaging platforms. If you receive an employment offer or other correspondence from an individual at Road Scholar you have not met, or from a non-Road Scholar email domain, it may be a phishing attempt.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote Senior Data Warehouse Engineer
Remote Senior Data Warehouse Engineer

Road Scholar • Boston (MA)

Remote
USD 110,000 - 130,000
Medical, Dental and Vision Insurance
403(b) Retirement Plan with 5% match
PTO and paid time off during holidays
+1
Sr Data Warehouse Developer
Sr Data Warehouse Developer

University of Rochester • City of Rochester (NY)

On-site
USD 86,482 - 129,723
Senior Data Warehouse Architect & ETL Lead
Senior Data Warehouse Architect & ETL Lead

University of Rochester • City of Rochester (NY)

On-site
USD 86,482 - 129,723
Senior Data Engineer
Senior Data Engineer

Arcadia • United States

Remote
USD 131,000 - 235,000
Remote first
Flexible PTO
12 company-wide holidays
+3
Senior Data Pipeline Engineer
Senior Data Pipeline Engineer

Jobgether • United States

Remote
USD 100,000 - 130,000
Fully remote
35‑hour workweek
Health insurance
+6
Staff Engineer
Staff Engineer

Arcadia • United States

Remote
USD 146,000 - 262,000
Remote-first culture
Flexible PTO
12 company holidays
+6
Senior Software Engineer, Assessment Delivery
Senior Software Engineer, Assessment Delivery

Renaissance Learning • United States

Remote
USD 110,000 - 151,000
Health benefits
401(k) match
Paid time off
+1
RD&D Process and Operations Lead (Hybrid)
RD&D Process and Operations Lead (Hybrid)

Lakeshore Learning Materials • Carson (CA)

Hybrid
USD 118,000 - 140,000
Bonus eligible
Paid parental leave
Medical, dental, and vision coverage
+6
Senior Cybersecurity Data Engineer - Data Platform & Lakehouse SME
Senior Cybersecurity Data Engineer - Data Platform & Lakehouse SME

Workday, Inc. (old) • Boulder (CO)

Hybrid
USD 160,000 - 258,000
Senior Data Engineer
Senior Data Engineer

EAB • Washington

On-site
USD 86,000 - 110,000
Remote work within continental US
Parental leave
401(k) retirement plan
+2