Senior Data Warehouse Engineer

🕒 September 14

🍂 Massachusetts – Remote

🍂 Massachusetts – Remote

💵 $110k - $130k / year

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Road Scholar

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 1975

✈️ Travel

🏨 Hospitality

📚 Education

Travel • Hospitality • Education

Road Scholar is a not-for-profit organization that offers educational travel and lifelong-learning adventures for adults (primarily age 50+), combining guided, themed trips around the world with online lectures and community programs. Founded in 1975 as Elderhostel, it provides multi-day learning-focused travel, resources like financial aid and solo-traveler support, and curated collections of trips spanning hundreds of destinations and special-interest topics.

📋 Description

• Design, build, and manage Data Warehouse Load and Transformation solutions • Document solutions and ensure adherence to technical standards • Support data modeling and collaborate on warehouse and reporting design • Partner with business teams to understand processes and translate technical design and implementation concepts • Conduct design reviews, testing, and compliance activities to ensure deliverable quality • Ensure solution performance and efficiency • Provide production support and troubleshoot Data Warehouse systems • Diagnose and resolve data and pipeline issues to minimize business impact • Partner with development, testing and quality, and production support teams to meet implementation dates and ensure smooth development-lifecycle transitions • Escalate issues and provide feedback on program specifications • Report to the Senior Director of Business Analytics

🎯 Requirements

• 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 another related field, or equivalent work experience • Knowledge and experience with Data Integration design, SQL, ETL tools, and data warehouse design, including star schema • Hands-on experience with Oracle, including Oracle Autonomous Database (ADB) • Experience with Boomi or a similar integration/ETL platform • Experience ingesting data from API-based data sources and SQL Server • Comfortable working in Linux environments, including file manipulation • Experience automating file transfers via SFTP • Strong troubleshooting skills and ability to diagnose and resolve production issues in complex data pipelines • Ability to learn new skills and technologies quickly • Ability to prioritize multiple deliverables and respond under pressure with competing priorities • Ability to drive results, innovation, and change • Strong written, verbal, analytical, problem-solving, and communication skills

🏖️ Benefits

• 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 • Paid week off at the end of December, in addition to PTO • Generous employee discounts on programs • Optional IATA membership • LinkedIn Learning access • Other professional development opportunities • Fully remote work environment