Senior Data Warehouse Engineer

When it comes to creating educational travel adventures that enrich the lives and fulfill the dreams of more than 100000 people every year theres no organization better than Road Scholar. Whats 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. Were 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 $110000 - $130000 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

Were seeking...

• 10 years of proven IT and business/industry work experience in a development role
• Bachelors or Masters 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
• Thats right were fully remote!
• To learn moreabout our benefits offerings check us out at 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 . 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.

  
  

  Required Experience:

  Senior IC