Data Warehouse Engineer II

🔥 0 minutes ago

🇺🇸 United States – Remote

💵 $75k - $129k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 0%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

BCD Travel

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 2006

💼 Consulting

📦 Logistics

🏨 Hospitality

Consulting • Logistics • Hospitality

BCD Travel is a leading business travel management company that simplifies the conversation around corporate travel by offering integrated solutions and services to meet various program goals. With a global network spanning over 100 countries, BCD Travel provides tailored travel management services, risk management solutions, and innovative tools to enhance the travel experience for organizations and their employees. Their expertise in the travel industry has earned them multiple recognitions, and they are committed to sustainability and optimizing business travel programs.

📋 Description

• Serve as a technical subject matter expert within the Operations Technology Transformation organization • Design and implement scalable data architectures and reliable data flows into the enterprise data warehouse • Design and manage cloud-based data platforms, database schemas, and data models • Assemble and manage large, complex datasets • Architect and implement ETL/ELT data pipelines from internal and external sources • Establish data models, integration patterns, and engineering best practices • Develop scalable, secure, and cost-efficient enterprise data solutions • Monitor and improve platform and pipeline performance, reliability, and scalability • Support analytics tools, operational reporting, performance measurement, and business intelligence initiatives • Develop and optimize SQL queries, views, stored procedures, and database objects • Implement query tuning and performance optimization strategies • Provide technical guidance to analytics team members • Collaborate with product owners, stakeholders, analysts, and technology teams to translate requirements into technical solutions • Support delivery across development, testing, UAT, and production environments • Participate in solution design reviews, technical planning, and cross-functional initiatives • Diagnose and resolve pipeline failures, data quality issues, and performance bottlenecks • Implement monitoring, alerting, and observability solutions • Conduct root cause analysis and drive continuous improvements

🎯 Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field, or equivalent practical experience • Extensive experience in data engineering, data warehousing, or related technical roles • Strong experience designing and developing scalable ETL/ELT pipelines • Hands-on experience with AWS and/or Microsoft Azure data services • Advanced SQL development skills, including query optimization, stored procedures, and performance tuning • Experience working with large-scale structured and unstructured datasets • Strong understanding of data modeling, database design, and data integration principles • Experience supporting analytics, reporting, and business intelligence initiatives • Excellent problem-solving, troubleshooting, and analytical skills • Strong communication and stakeholder management abilities

🏖️ Benefits

• Flexible working hours and work-from-home or remote opportunities • Opportunities to grow your skillset and career • Work at the forefront of travel technology and help shape the future of business travel • Generous vacation days • Mental, physical, and financial wellbeing tools • Travel industry professional perks and discounts • Inclusive work environment where diversity is celebrated • Work From Anywhere opportunity for 60 days per year