Data Engineer 2

Choice Hotels is hiring a Data Engineer II on the Data Engineering team within the Advanced Analytics group (North Bethesda, MD, hybrid).

Responsibilities

• Design, build, maintain, and optimize batch ETL/ELT pipelines and data models for analytics, reporting, and business operations, prioritizing performance, scalability, reliability, and efficient resource use
• Partner with business operations and regional leaders to clarify requirements, define metrics, set delivery expectations, and prioritize by business impact
• Deliver items from the data and analytics backlog (pipelines, models, dashboards, and ad hoc requests)
• Reduce future demand by automating recurring requests and creating reusable, self-serve data assets
• Protect metric quality and consistency across regions and systems using automated data validation, transformation testing, reconciliation, monitoring, and alerting (accuracy, completeness, freshness)
• Monitor production pipelines, troubleshoot failures, investigate data discrepancies, apply corrective actions, and document recurring issues to improve reliability (including participation in an on-call rotation)
• Support evaluation and migration of data integration tools, including pipeline inventory, validation, parallel runs, and retirement of legacy jobs
• Support an internal conversational analytics application by maintaining data connections, improving data quality for its answers, and helping measure usage and accuracy
• Prototype with users, collect feedback, and convert successful prototypes into production-ready solutions
• Write clean, tested, and well-documented code and participate in code and design reviews
• Document standards and runbooks (step-by-step operating guides), and provide training and hands-on support to drive adoption

Requirements

• Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent experience)
• 3+ years 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, Matillion
• Experience with a cloud data warehouse such as Snowflake, BigQuery, Redshift, or Databricks
• CI/CD experience for data pipelines with automated testing, version-controlled deployments, and promotion across dev and production using tools such as Harness, Jenkins, or GitHub Actions
• Proficiency with Git-based source control (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 including dimensional modeling and slowly changing dimensions
• Strong communication skills and comfort working with non-technical stakeholders
• Ability to manage multiple priorities and make tradeoffs in a fast-moving environment
• Proficient with Microsoft Outlook, Excel, PowerPoint, and Word
• Demonstrates key competencies: Cultivates Innovation, Action Oriented, Nimble Learning

Technology

• SQL, Python
• dbt, Fivetran, Airbyte, Airflow, Matillion
• Snowflake, BigQuery, Redshift, Databricks
• Harness, Jenkins, GitHub Actions
• Git, Bitbucket, GitHub, GitLab
• AWS, Azure, GCP
• Dimensional modeling, Slowly changing dimensions
• Microsoft Outlook, Excel, PowerPoint, Word
• Terraform, Docker, Kubernetes
• Monte Carlo, Great Expectations
• Tableau, Power BI

Compensation & Location

• Location: North Bethesda, MD (hybrid)
• Salary range: USD 107,000 to 127,000 per year
• Pay position within the range based on factors including education, qualifications, certifications, experience, skills, seniority, geographic location, performance, shift, travel requirements, sales or revenue-based metrics, and business or organizational needs
• Based in Choice Hotels worldwide corporate headquarters in North Bethesda, MD (less than 15 miles from Washington, DC; one block from the North Bethesda Metro station)

Team & Reporting

• Individual contributor role reporting to the Manager, Data Engineering
• Collaborate with 3 peer teammates and cross-functional departments regularly

Benefits

• 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

Choice Cultural Values

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

Choice Leadership Principles

• Act with Intention
• Lead with Authenticity
• Grow & Deliver