Choice Hotels is seeking a Data Engineer II to support the Data Engineering team within the Advanced Analytics group. In this hybrid role based in North Bethesda, MD, you will design and maintain ETL/ELT pipelines and data models while partnering with business stakeholders to ensure reliable, high-quality metrics.
Role Responsibilities
- Design, build, maintain, and optimize batch extract-transform-load (ETL/ELT) pipelines and data models supporting analytics, reporting, and business operations, with an emphasis on performance, scalability, reliability, and efficient resource usage.
- Partner with business operations and regional leaders to clarify requirements, define metrics, set delivery expectations, and prioritize work based on business impact.
- Deliver backlog items including pipelines, models, dashboards, and ad hoc requests; reduce future demand by automating recurring requests and creating reusable, self-serve data assets.
- Ensure quality and consistency of key business metrics across regions and systems by implementing automated data validation, transformation testing, reconciliation, monitoring, and alerting to verify 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 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 answers, and contributing to measurement of usage and accuracy.
- Prototype with users, gather feedback, and convert successful prototypes into production-ready solutions.
- Write clean, tested, and 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.
Required Qualifications
- Bachelor's degree in Computer Science, Engineering, or a related field required, or equivalent experience.
- At least 3 years of experience in data engineering, analytics engineering, or software engineering.
- Strong skills in SQL and Python.
- Hands-on experience with modern ELT/ETL tools (dbt, Fivetran, Airbyte, Airflow, Matillion) and a cloud data warehouse (Snowflake, BigQuery, Redshift, Databricks).
- Experience applying CI/CD practices to 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 (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 directly with non-technical stakeholders.
- Ability to manage multiple priorities and make sound tradeoffs in a fast-moving environment.
- Proficiency with Microsoft Outlook, Excel, PowerPoint, and Word.
- Demonstrates key competencies including Cultivates Innovation, Action Oriented, and Nimble Learning.
Technologies
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
Team and Reporting
This is an individual contributor role reporting to the Manager, Data Engineering. You will collaborate with 3 peer teammates and work regularly with cross-functional departments.
Work Location
The role is based at Choice Hotels corporate headquarters in North Bethesda, MD. The office is less than 15 miles from Washington, DC, one block from the North Bethesda Metro station (Red Line and MARC Brunswick line), with easy access to I-270 and free parking provided by Choice Hotels. This position is hybrid.
Compensation
The salary range is $107,000 to $127,000 per year. Pay placement within the range will be based on factors including 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.
Choice Cultural Values and Leadership Principles
- Cultural Values: Welcome and Respect Everyone; Be Bold; Be Quick; Listen; Be Curious; Show Integrity.
- Leadership Principles: Act with Intention; Lead with Authenticity; Grow & Deliver.
