Data Engineer 2

Choice Hotels • North Bethesda, MD

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

About The Position

Choice Hotels is hiring a Data Engineer II on 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 develops trusted data solutions that help leaders make business decisions and works directly with business teams.

The role focuses on batch ETL/ELT pipelines and data models for analytics, reporting, and business operations. It also supports production reliability, data quality, integration-tool evaluation and migration, and an internal conversational analytics application. The position reports to the Manager, Data Engineering and collaborates regularly with cross-functional departments and three peer teammates.

The position is described as four days onsite in a hybrid arrangement at the North Scottsdale, Arizona office or the Rockville, Maryland headquarters. The posting also describes the role as based at the worldwide corporate headquarters in North Bethesda, Maryland. The role is not eligible for sponsorship. The stated annual salary range is $107,000 to $127,000.

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, 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.
• 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 using 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, with attention to 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 by business impact.
• Deliver backlog items such as pipelines, models, dashboards, and ad hoc requests; automate recurring requests and build reusable, self-service 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 for data accuracy, completeness, and freshness.
• Monitor production pipelines, troubleshoot failures, investigate discrepancies, implement corrective actions, and document recurring issues; participate in the on-call rotation.
• Support evaluation and migration of data integration tools, including pipeline inventory, validation, parallel runs, and retirement of legacy jobs.
• Support the internal conversational analytics application by maintaining data connections, improving answer data quality, and helping measure usage and accuracy.
• Prototype with users, gather feedback, and turn 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.
• Complimentary parking at the described corporate office locations.

What This Job Offers

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