Data Engineer 2

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

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Paid time off

Retirement benefits

Employee discounts

Job summary

Choice Hotels in North Bethesda, MD is seeking a Data Engineer II to join the Advanced Analytics Data Engineering team. You will build and maintain ETL/ELT pipelines, data models, and dashboards to empower analysts and leaders with reliable, ready-to-use data.

You'll collaborate with cross-functional teams to define metrics, ensure data quality across regions, and participate in on-call rotations while writing clean, testable code and contributing to governance and observability tools.

Qualifications

• Bachelor's degree or equivalent experience in CS/Engineering or a related field.
• At least 3 years’ experience in data engineering, analytics engineering, or software engineering.
• Strong SQL and Python skills.
• Hands-on experience with ELT/ETL tools (dbt, Fivetran, Airbyte, Airflow, Matillion) and cloud data warehouses (Snowflake, BigQuery, Redshift, Databricks).
• Experience with CI/CD for data pipelines (Harness, Jenkins, GitHub Actions).
• Proficiency with Git-based source control (Bitbucket, GitHub, GitLab).
• Familiarity with AWS, Azure, or GCP.
• Solid data modeling knowledge (dimensional modeling, SCD).
• Strong communication and ability to work with non-technical stakeholders.

Responsibilities

• Design, build, maintain, and optimize batch ETL/ELT pipelines and data models for analytics and operations.
• Partner with business operations and regional leaders to clarify requirements and set delivery expectations.
• Deliver pipelines, models, dashboards, and ad hoc data requests while building reusable data assets.
• Protect data quality across regions by implementing automated validation, transformation testing, and monitoring.
• Monitor production pipelines, troubleshoot failures, and participate in on-call rotations.
• Support evaluation and migration of data integration tools and legacy jobs.
• Support internal conversational analytics by maintaining data connections and improving data quality.
• Prototype quickly with users, gather feedback, and turn prototypes into production solutions.
• Write clean, tested, well-documented code and participate in code/design reviews.
• Document standards and runbooks and provide training to drive adoption of delivered solutions.

Skills

SQL

Python

Data modeling

Stakeholder communication

Multi-priority management

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

dbt

Fivetran

Airbyte

Airflow

Matillion

Harness

Jenkins

GitHub Actions

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.

*** 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