Data Engineer 2 - Data Engineering

** This role is not eligible for sponsorship AND is four days onsite hybrid at our N. Scottsdale, AZ office - OR - Rockville, MD HQ **

Who are we looking for? 

Choice Hotels, one of the world’s largest lodging franchisors, has an exciting new opportunity as our Data Engineer II in the Data Engineering team within our Advanced Analytics Team. The Data Engineering team is the team that builds and maintains the data pipelines and tools that turn information from across our business into reliable, ready-to-use data for analysts, business leaders, and applications. As a key member of our Data Engineering team, you will turn business questions into trusted data solutions that help leaders across Choice Hotels make faster, better decisions. 

Are you a hands-on problem solver with strong SQL and Python skills who enjoys partnering directly with business teams? We invite you to apply today for our Data Engineer II role and #MakeItYourChoice. 

Your Responsibilities  

• Design, build, maintain, and optimize batch extract-transform-load (ETL/ELT) pipelines and data models that power analytics, reporting, and business operations, with a focus on performance, scalability, reliability, and efficient resource use. 

• Partner with business operations and regional leaders to clarify requirements, define metrics, establish delivery expectations, and prioritize work based on business impact. 

• Deliver items from the data and analytics backlog, including pipelines, models, dashboards, and ad hoc requests, and reduce future demand by automating recurring requests and building reusable, self-serve data assets. 

• Protect the quality and consistency of key business metrics across regions and systems by implementing automated data validation, transformation testing, reconciliation, monitoring, and alerting to confirm data accuracy, completeness, and freshness. 

• Monitor production pipelines, troubleshoot failures, investigate data discrepancies, implement corrective actions, and document recurring issues to improve reliability and reduce operational overhead, including participation in the on-call rotation. 

• Support the evaluation and migration of our data integration tools, including pipeline inventory, validation, parallel runs, and retirement of legacy jobs. 

• Support our internal conversational analytics application by maintaining data connections, improving data quality for its answers, and helping measure usage and accuracy. 

• Prototype quickly with users, gather feedback, and turn successful prototypes into production-ready solutions. 

• Write clean, tested, well-documented code and take part in code and design reviews. 

• Document standards and runbooks (step-by-step operating guides), and provide training and hands-on support to drive adoption of delivered solutions.

Your Experience, Skills & Competencies

• Bachelor's degree in Computer Science, Engineering, or a related field required, or equivalent experience.

• At least 3 years’ experience in data engineering, analytics engineering, or software engineering.

• Strong SQL and Python skills.

• Hands-on experience with modern ELT/ETL tools (e.g., dbt, Fivetran, Airbyte, Airflow, Matillion) and a cloud data warehouse (e.g., Snowflake, BigQuery, Redshift, Databricks).

• Experience with continuous integration and continuous delivery (CI/CD) practices for data pipelines, including automated testing, version-controlled deployments, and promotion of changes across development and production environments, using tools such as Harness, Jenkins, or GitHub Actions.

• Proficiency with Git-based source control (e.g., Bitbucket, GitHub, GitLab), including pull requests and branching strategies.

• Familiarity with a major cloud platform (AWS, Azure, or GCP).

• Solid understanding of data modeling concepts, such as dimensional modeling and slowly changing dimensions.

• Strong communication skills and comfort working directly with non-technical stakeholders.

• Ability to manage multiple priorities and make sound tradeoffs in a fast-moving environment.

• Proficient in Microsoft Outlook, Excel, PowerPoint and Word.

• Demonstrates key competencies to include: Cultivates Innovation, Action Oriented, Nimble Learning.

• Preferred: experience with infrastructure as code and containerization (e.g., Terraform, Docker, Kubernetes) and with data governance and observability tools (e.g., Monte Carlo, Great Expectations).

• Preferred: experience with data platform or tooling migrations, applications that use large language models (LLMs) or conversational interfaces, or business intelligence tools such as Tableau or Power BI.

Your Team

This is an individual contributor role that will report to the Manager, Data Engineering. You will have 3 peer teammate(s) and collaborate with cross functional departments on a regular basis.

Your Work Location

As our Data Engineer II, you will be based in our beautiful, state-of-the-art worldwide corporate headquarters in North Bethesda, MD. Less than 15 miles from Washington, DC, we’re located one block away from the North Bethesda Metro station, with service on the Red Line and the MARC Brunswick line, easy access to I-270, and plenty of free parking provided by Choice Hotels.

Salary Range

The salary range for this position is $107,000 to $127,000 annually.

The pay range listed is for this position and is what Choice Hotels reasonably expects to pay. We may ultimately pay more or less than the posted range, and the range may be modified in the future. An employee’s pay position within the pay range will be based on several factors including, but not limited to, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, shift, travel requirements, sales or revenue-based metrics, and business or organizational needs.

*** PLEASE NOTE: This role is not eligible for sponsorship *** 

Choice prioritizes our associate wellbeing by offering a comprehensive benefits program that is both competitive and flexible to help you achieve your wellbeing goals - here are just a few:

• Competitive compensation and benefits, including medical, dental, and vision coverage
• Leave and paid time-off for holidays, vacation, personal, family, volunteer, sick, jury duty, bereavement, military, and religious observance
• Financial benefits for retirement and health savings
• Employee recognition programs
• Discounts at Choice hotels worldwide

About Choice

Choice Hotels International, Inc. (NYSE: CHH), is one of the largest lodging franchisors in the world. With 7,500 hotels in 45+ countries and territories, we offer a range of high-quality lodging options in the upper upscale, upper midscale, midscale, extended stay, and economy segments. We’re the hotel company for those who choose to bet on themselves — the striver, the dreamer, the entrepreneur — because that’s who we are, too.

At Choice, we are united by the simple belief that tomorrow will be even better than today — for associates, our company, and our franchisees. At our worldwide corporate headquarters in North Bethesda, Maryland, at our technology center in Scottsdale, Arizona, and through our associates around the globe, every voice is heard and every idea is listened to, no matter what area of the company they come from. We are united in supporting the entrepreneurial dreams of our thousands of franchise owners, which propels us forward — giving our work at Choice a purpose larger than our business.

Our corporate office locations:

North Bethesda, MD — Located at Pike & Rose, our worldwide headquarters is less than 15 miles from Washington, D.C., one block away from the North Bethesda Metro station, with easy access to I-495, complimentary parking, electronic charging stations, restaurants and retail.

Scottsdale, AZ — Located at the northwest corner of Loop 101, the Scottsdale office is home to our technology, eCommerce and customer service organizations, with easy access to complimentary parking, electronic charging stations, restaurants and retail.

Minneapolis, MN — Select roles are based in our Minneapolis office on Highway 394, near the intersection with Highway 100, only five minutes from downtown.

Field/Remote — Select roles designated as field/remote will require associates to work from a home office, connecting virtually with Choice team members and leadership on Zoom, with possible required travel depending on the role.  

Choice’s Cultural Values

Welcome and Respect Everyone | Be Bold | Be Quick | Listen | Be Curious | Show Integrity

Choice’s Leadership Principles

Act with Intention | Lead with Authenticity | Grow & Deliver