Data Engineer
Troon · Scottsdale, AZ · 1 mo ago
Information TechnologyFull-time
Key Responsibilities
- Design, develop, and maintain end-to-end data pipelines to ingest data from internal and external systems into Azure data platforms
- Build and manage data integration processes using tools such as Azure Data Factory, Azure Synapse, and/or Azure Data Lake
- Implement and enforce medallion architecture (bronze, silver, gold) for structured data refinement and consumption
- Transform raw data into clean, validated, and enriched datasets suitable for analytics and business use
- Develop and optimize data models and transformation logic for performance and scalability
- Integrate data from APIs, SaaS platforms, databases, and third-party systems
- Ensure data quality, consistency, and integrity across all pipeline stages
- Implement monitoring, alerting, and logging for pipeline performance and failures
- Collaborate with data analysts, data scientists, and product teams to support reporting and advanced analytics needs
- Maintain and optimize data storage solutions (e.g., Azure Data Lake, Synapse) for cost and performance efficiency
- Establish and follow best practices for version control, CI/CD, and deployment of data pipelines
- Document data flows, transformations, and system dependencies
Required Qualifications
- 3+ years of experience in data engineering, ETL/ELT development, or data integration
- Hands-on experience building and maintaining production-grade data pipelines
- Experience working within cloud-based data platforms (Azure preferred)
Preferred Qualifications
- Experience implementing medallion architecture (bronze/silver/gold layers)
- Experience integrating multiple enterprise systems (CRM, ERP, SaaS platforms)
- Experience supporting analytics or BI environments
Required Knowledge and Skills
- Strong proficiency in SQL and data transformation techniques
- Expertise in ETL/ELT pipeline design and orchestration
- Strong understanding of data modeling (relational and dimensional)
- Experience working with APIs, file-based ingestion, and streaming data sources
- Experience with Azure data services (Azure Data Factory, Azure Data Lake, Synapse Analytics)
- Knowledge of data quality, validation, and error-handling techniques
- Strong problem-solving and troubleshooting skills
Preferred Knowledge and Skills
- Experience with PySpark, Spark, or Databricks
- Familiarity with Delta Lake and lakehouse architectures
- Experience with CI/CD pipelines and DevOps practices in Azure
- Knowledge of data governance, lineage, and cataloging tools
- Experience optimizing performance and cost in cloud environments
About Troon
Troon is the world’s largest professional club management company, specializing in services in golf, hospitality, and residential communities. Founded in 1990 and headquartered in Scottsdale, AZ, Troon operates more than 900 locations in 45+ states and 27+ countries, making it a leading employer in hospitality.