Data Engineer 2

CHN Choice Hotels International Services; North Bethesda (MD); Hybrid; USD 107,000 - 127,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive benefits

Paid time off

Employee recognition

Hotel discounts

Job summary

Choice Hotels International is seeking a Data Engineer II to design, build, and maintain ETL/ELT pipelines and data models powering analytics and operations. You will partner with regional leaders to clarify requirements, deliver data assets, and automate recurring data tasks.

Join a team focused on data quality, scalable pipelines, and trusted metrics across the organization. Experience with modern ELT tools and cloud data warehouses is preferred, along with strong SQL, Python, and

Qualifications

• 3+ years in data/analytics engineering or software engineering.
• Bachelor's degree in CS/Engineering or related field or equivalent experience.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines and data models for analytics and reporting.
• Collaborate with stakeholders to clarify requirements and define metrics.
• Deliver pipelines, dashboards, and data assets; automate recurring requests.
• Ensure data quality through validation, testing, and monitoring.

Skills

SQL

Python

ELT/ETL tools

CI/CD

Git-based workflows

Cloud platforms

Data modeling

Communication

Education

Bachelor's degree in CS/Engineering or related field

Tools

dbt

Fivetran

Airflow

Airbyte

Matillion

Snowflake/BigQuery/Redshift/Databricks

Job description

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.

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.

Benefits

• 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.

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 CONNECT THE WORLD THROUGH THE POWER OF HOSPITALITY We bring together the people, brand and technology that enable the success of others – welcoming every guest, every partner, everywhere their journey takes them.

Visit http://careers.choicehotels.com to learn more.