Remote Senior Data Warehouse Engineer

Road Scholar

Boston (MA)

Remote

USD 110,000 - 130,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Warehouse Engineer
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
Remote Senior Data Engineer — Cloud Data Warehousing & APIs
Remote Senior Data Engineer — Cloud Data Warehousing & APIs

CodeRoad • United States

Remote
USD 140,000 - 190,000
Remote USA contract
Paid time off
Health insurance assistance
+1
Remote SQL Developer: Data Warehouse & ETL Expert
Remote SQL Developer: Data Warehouse & ETL Expert

South Geeks LLC • United States

Remote
USD 90,000 - 140,000
100% remote work
Payment in USD
Paid time off
+5
Senior Big Data Engineer - Remote Analytics & Pipelines
Senior Big Data Engineer - Remote Analytics & Pipelines

Placements24 • United States

Remote
USD 120,000 - 180,000
Fully remote work
Home office setup allowance
Professional development & conferences
+2
Remote Data Engineer
Remote Data Engineer

Amend Treatment • Kansas City (MO)

Remote
USD 90,000 - 120,000
Remote SQL & Data Warehouse Engineer – ETL/BI
Remote SQL & Data Warehouse Engineer – ETL/BI

South Geeks LLC • United States

Remote
USD 110,000 - 160,000
Long-term projects
100% remote
Payment in USD
+6
Remote Senior Data Engineer: Pipelines, Warehousing & Cloud
Remote Senior Data Engineer: Pipelines, Warehousing & Cloud

QuadSoft Technologies • Texas

Remote
USD 100,000 - 130,000
Data Engineer - ETL, Warehousing & Cloud (Remote TX)
Data Engineer - ETL, Warehousing & Cloud (Remote TX)

ADA • San Francisco (CA)

Remote
USD 57,000 - 81,000
Remote Data Engineer - Build scalable data pipelines & models
Remote Data Engineer - Build scalable data pipelines & models

Perfectserve • United States

Remote
USD 115,000 - 140,000
Health insurance
401(k) with company match
Remote-first US
+2
Remote Data Warehouse Engineer | ETL, Power BI & SSRS
Remote Data Warehouse Engineer | ETL, Power BI & SSRS

UST • Atlanta (GA)

Remote
USD 62,000 - 93,000
401(k) with employer matching
Medical, dental, and vision insurance
HSA and FSA options
+1