Senior Data Warehouse Engineer

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 more about 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.