Data Engineer 2
Choice Hotels International, Inc.10 days ago
Bethesda, MD, USAMid Level
Base Salary
$107k - $127k/yr
Responsibilities
- Design, build, maintain, and optimize batch ETL/ELT pipelines and data models for analytics, reporting, and business operations.
- Partner with business operations and regional leaders to clarify requirements, define metrics, set delivery expectations, and prioritize work.
- Deliver pipelines, models, dashboards, and ad hoc requests while automating recurring work and building reusable self-service data assets.
- Implement automated data validation, transformation testing, reconciliation, monitoring, and alerting to ensure data accuracy, completeness, and freshness.
- Monitor production pipelines, troubleshoot failures, investigate discrepancies, implement corrective actions, and participate in the on-call rotation.
- Support evaluation and migration of data integration tools through inventory, validation, parallel runs, and legacy-job retirement.
- Maintain data connections and improve quality, usage measurement, and answer accuracy for the internal conversational analytics application.
- Prototype solutions with users, gather feedback, and convert successful prototypes into production-ready solutions.
- Write clean, tested, documented code and participate in code and design reviews.
- Document standards and runbooks and provide training and hands-on support for delivered solutions.
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 and a cloud data warehouse.
- Experience with CI/CD practices for data pipelines, automated testing, version-controlled deployments, and promotion across development and production environments.
- Proficiency with Git-based source control, pull requests, and branching strategies.
- Familiarity with AWS, Azure, or GCP.
- 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 sound tradeoffs in a fast-moving environment.
- Proficiency with Microsoft Outlook, Excel, PowerPoint, and Word.
- Preferred experience with Terraform, Docker, Kubernetes, data governance and observability tools, data platform or tooling migrations, LLM or conversational applications, Tableau, or Power BI.
Benefits
- Medical, dental, and vision coverage.
- Paid holidays, vacation, personal, family, volunteer, sick, jury duty, bereavement, military, and religious-observance leave.
- Retirement and health savings benefits.
- Employee recognition programs.
- Discounts at Choice Hotels worldwide.
- Four days onsite in a hybrid arrangement at the North Bethesda/Rockville, Maryland headquarters or Scottsdale, Arizona office; complimentary parking is available at the stated office locations.
Tech Stack
AirbyteAmazon RedshiftApache AirflowAWSAzureDatabricksdbtDockerGitGitHub ActionsGoogle BigQueryGoogle Cloud PlatformHarnessJenkinsKubernetesPythonSnowflakeSQLTerraform
Categories
Data Engineering
About Choice Hotels International, Inc.
Choice Hotels International is a public lodging franchisor with a portfolio of brands including Comfort, Quality Inn, Clarion, Cambria, Sleep Inn, Econo Lodge, and the Ascend Hotel Collection, serving leisure and business travelers. It earns primarily from franchise fees and reservation, loyalty, and technology services provided to independently owned hotels. Founded in 1939 and headquartered in Rockville, Maryland, Choice trades on the NYSE (CHH) and franchises thousands of properties across the U.S. and internationally.