Data Engineer 2

Choice Hotels International • North Bethesda, MD

7d • $107,000 - $127,000 • Hybrid

About The Position

Choice Hotels is hiring a Data Engineer II for its Data Engineering team within the Advanced Analytics Team. The team builds and maintains data pipelines and tools that turn information from across the business into reliable, ready-to-use data for analysts, business leaders, and applications. This individual contributor role focuses on translating business questions into trusted data solutions that help Choice Hotels leaders make better decisions. The role is described as four days onsite in a hybrid arrangement, with locations listed as North Scottsdale, Arizona, or Rockville, Maryland. The posting also describes the worldwide corporate headquarters in North Bethesda, Maryland as the work location.

The Data Engineer II designs and supports data pipelines and models, partners with business stakeholders, improves data quality and reliability, supports data integration tool migrations and an internal conversational analytics application, and develops production-ready solutions from user feedback. The role includes participation in an on-call rotation and reports to the Manager, Data Engineering. The position has three peer teammates and regular collaboration with cross-functional departments. The role is not eligible for sponsorship.

Requirements

• Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent experience.
• At least 3 years of experience in data engineering, analytics engineering, or software engineering.
• Strong SQL and Python skills.
• Hands-on experience with modern ELT/ETL tools such as dbt, Fivetran, Airbyte, Airflow, or Matillion and a cloud data warehouse such as Snowflake, BigQuery, Redshift, or Databricks.
• Experience with 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 such as Bitbucket, GitHub, or GitLab, including pull requests and branching strategies.
• Familiarity with a major cloud platform: AWS, Azure, or GCP.
• Solid understanding of data modeling concepts, including 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.
• Proficiency in Microsoft Outlook, Excel, PowerPoint, and Word.
• Demonstrates the competencies Cultivates Innovation, Action Oriented, and Nimble Learning.

Nice To Haves

• Experience with infrastructure as code and containerization, such as Terraform, Docker, or Kubernetes.
• Experience with data governance and observability tools, such as Monte Carlo or Great Expectations.
• Experience with data platform or tooling migrations.
• Experience with applications that use large language models (LLMs) or conversational interfaces.
• Experience with business intelligence tools such as Tableau or Power BI.

Responsibilities

• Design, build, maintain, and optimize batch ETL/ELT pipelines and data models for analytics, reporting, and business operations, emphasizing performance, scalability, reliability, and efficient resource use.
• Partner with business operations and regional leaders to clarify requirements, define metrics, set delivery expectations, and prioritize work according to business impact.
• Deliver backlog items, including pipelines, models, dashboards, and ad hoc requests, while automating recurring requests and building reusable self-service data assets.
• Implement automated data validation, transformation testing, reconciliation, monitoring, and alerting to protect the accuracy, completeness, freshness, quality, and consistency of key business metrics.
• Monitor production pipelines, troubleshoot failures, investigate data discrepancies, implement corrective actions, document recurring issues, and participate in the on-call rotation.
• Support evaluation and migration of data integration tools through pipeline inventory, validation, parallel runs, and retirement of legacy jobs.
• Support the internal conversational analytics application by maintaining data connections, improving the quality of its answers, and helping measure usage and accuracy.
• Prototype solutions with users, gather feedback, and develop successful prototypes into production-ready solutions.
• Write clean, tested, well-documented code and participate in code and design reviews.
• Document standards and runbooks and provide training and hands-on support to encourage adoption of delivered solutions.

Benefits

• Medical, dental, and vision coverage.
• Paid leave and 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.
• Competitive compensation and benefits.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level