Senior Data Warehouse Engineer
About The Position
Road Scholar is seeking an experienced, innovative, and motivated developer to support their Business Analytics initiative. This role will collaborate closely with other IT staff and business partners, reporting to the Senior Director of Business Analytics. The primary responsibility is for Data Load and Transformation processes that populate the Data Warehouse and related systems. The position will design, build, and manage Data Warehouse Load and Transformation solutions of varying complexity, ensuring completeness, efficiency, and adherence to technical standards. It also plays a critical role in partnering with other development teams, testing and quality, and production support to meet implementation dates and ensure a smooth transition throughout the development life-cycle. The ideal candidate has strong troubleshooting instincts, is energized by complex data issues, and possesses a natural curiosity to understand the root cause of problems, which is a key competency for success in this role. Road Scholar offers a remote work environment.
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 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
Responsibilities
- 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
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
- 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
- Opt-in to receive an IATA membership
- LinkedIn Learning access
- Fully remote work environment
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
Associate degree
