Remote Senior Data Warehouse Engineer

Road Scholar; Boston, Northern (MA, KY); Hybrid; USD 110,000 - 130,000; Full time

Benefits offered by this job

Medical, Dental and Vision Insurance

403(b) Retirement Plan with company-mN

Up to 20 days PTO annually

Holiday week off at end of December

Employee discounts on programs

IATA membership option

LinkedIn Learning and professional dev

Job summary

Road Scholar in Boston seeks an experienced developer to support its Business Analytics initiative. You will design, build, and manage Data Warehouse Load and Transformation solutions, work with data modelling, and partner with business teams to translate requirements into technical designs.

This exempt, salaried role requires strong troubleshooting, Linux, Oracle, Boomi, API data ingestion, and a curious, proactive mindset.

Qualifications

• 7+ years IT and business/industry experience in a development role.
• Bachelor's or Master's degree in Computer Science, Information Systems, or related field.

Responsibilities

• Design, build, and manage Data Warehouse Load and Transformation solutions.
• Collaborate with team on warehouse and reporting design.
• Translate business processes into technical designs for partners.
• Ensure quality through design reviews, testing, and production support.
• Provide troubleshooting for Data Warehouse systems and pipelines.
• Escalate issues and provide feedback on program specs.

Skills

Data integration design

SQL

ETL tools

Data warehouse design

Oracle

Oracle Autonomous DB

Boomi

API data ingestion

Linux

SFTP automation

Troubleshooting

Curiosity/learning

Prioritization

Communication

Education

Bachelor's or Master's in Computer Science/Information Systems

Tools

Oracle

Boomi

SQL Server

Job description

Road Scholar in Boston seeks an experienced developer to support its Business Analytics initiative. You will design, build, and manage Data Warehouse Load and Transformation solutions, work with data modelling, and partner with business teams to translate requirements into technical designs.

This exempt, salaried role requires strong troubleshooting, Linux, Oracle, Boomi, API data ingestion, and a curious, proactive mindset.