[Hiring] Senior Data Warehouse Engineer @Road Scholar

Role Description

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.
• Design, build and manage Data Warehouse Load and Transformation solutions of varying complexity.
• Ensure completeness and efficiency of solutions and adherence to technical standards.
• Play a critical role partnering with other development teams, testing and quality, and production support.
• Meet implementation dates and allow smooth transition throughout the development life-cycle.
• Strong troubleshooting instincts and natural curiosity to understand complex data issues.

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

Qualifications

• 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, 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.
• Ability to prioritize multiple deliverables and respond under pressure with competing priorities.
• Ability to display creative thought leadership, drive results, innovation and change.
• Strong written, verbal, analytical, problem solving, and communication skills.

Benefits

• 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.
• Paid week off at the end of December to enjoy the holiday season.
• Generous employee discounts on our programs.
• Option to receive an IATA membership.
• Access to LinkedIn Learning and other professional development opportunities.
• Fully remote work environment.