Data Engineer

Troon • Scottsdale, AZ

10d • Onsite

About The Position

Troon is hiring a Data Engineer for its corporate office in Scottsdale, Arizona. The role designs, builds, and maintains scalable data integration pipelines and architectures in the Azure ecosystem, enabling data ingestion, transformation, and promotion across bronze, silver, and gold medallion layers. It ensures reliable, high-quality, and governed data flows that support analytics, reporting, and downstream applications, and serves as a technical leader in data engineering by advancing best practices in pipeline design, data modeling, and platform optimization.

The position requires experience in data engineering, ETL/ELT development, or data integration, including building and maintaining production-grade pipelines and working with cloud-based data platforms. A bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field is required, though an equivalent combination of education and experience may be considered.

Troon is a professional club management company founded in 1990 and headquartered in Scottsdale, Arizona. It operates more than 900 locations in over 45 U.S. states and more than 27 countries, with services in golf, hospitality, and residential communities.

Requirements

• At least 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 is preferred.
• Strong proficiency in SQL and data transformation techniques.
• Experience with Azure data services such as Azure Data Factory, Azure Data Lake, and Synapse Analytics.
• Expertise in ETL/ELT pipeline design and orchestration.
• Strong understanding of relational and dimensional data modeling.
• Experience working with APIs, file-based ingestion, and streaming data sources.
• Knowledge of data quality, validation, and error-handling techniques.
• Strong problem-solving and troubleshooting skills.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field; an equivalent combination of education and experience may be considered.

Nice To Haves

• Experience implementing medallion architecture using bronze, silver, and gold layers.
• Experience integrating multiple enterprise systems, including CRM, ERP, and SaaS platforms.
• Experience supporting analytics or BI environments.
• 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.

Responsibilities

• Design, develop, and maintain end-to-end data pipelines that 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 bronze, silver, and gold medallion architecture for structured data refinement and consumption.
• Transform raw data into clean, validated, and enriched datasets 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 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.
• Maintain and optimize data storage solutions, such as Azure Data Lake and 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.

Benefits

• Medical, dental, and vision coverage, subject to applicable plan terms and eligibility criteria.
• 401(k) with employer match for employees aged 19 and older, subject to applicable plan terms and eligibility criteria.
• Paid time off and leaves of absence in accordance with applicable law and eligibility criteria.

What This Job Offers

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