Data Engineer

Troon; Scottsdale (AZ); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Healthcare benefits

401(k) with employer match

PTO and leaves

Job summary

Troon, headquartered in Scottsdale, AZ, is hiring a Data Engineer to design, build, and maintain scalable data pipelines within the Azure ecosystem. You will transform raw data for analytics, implement bronze/silver/gold data tiers, and collaborate with analysts and product teams to enable insightful reporting and decision-making.

Ideal candidates have 3+ years in data engineering, strong SQL, Azure Data Factory/Synapse/Lake experience, and a solid foundation in data modeling and Python.

Qualifications

• 3+ years of data engineering, ETL/ELT, or data integration experience.

Responsibilities

• Design, build, and maintain end-to-end data pipelines in Azure data platforms.
• Develop and manage data integration using Azure Data Factory, Azure Synapse, and/or Azure Data Lake.
• Implement medallion-style data architecture (bronze/silver/gold) for refined data.
• Transform raw data into clean, validated data sets for analytics.
• Create scalable data models and transformation logic for performance.
• Integrate data from APIs, SaaS platforms, databases, and third-party systems.
• Ensure data quality, consistency, and integrity across pipelines.
• Implement monitoring, alerting, and logging for pipeline health.
• Collaborate with analysts, scientists, and product teams for reporting needs.
• Maintain cost-efficient storage (Azure Data Lake, Synapse) and optimize performance.
• Document data flows, transformations, and dependencies.

Skills

SQL

Azure Data Factory

Azure Synapse

ETL/ELT

Data Modeling

Python

CI/CD

Problem Solving

Education

Bachelor's degree in Computer Science

Education/Experience equivalence

Tools

Azure Data Lake

Databricks

Delta Lake

Git

Job description

Troon Headquarters
Scottsdale, AZ 85254, USA

Description

Troon’s Corporate office, located in Scottsdale, AZ, is pleased to announce an excellent career opportunity for a Data Engineer! We are seeking a highly motivated individual who is eager to learn, contribute, and advance their career within a rapidly growing organization. The ideal candidate will bring a strong commitment to professional development and a desire to succeed in a dynamic corporate environment.

The Data Engineer designs, builds, and maintains scalable data integration pipelines and architectures within the Azure ecosystem, enabling the ingestion, transformation, and promotion of data across bronze, silver, and gold medallion layers. Ensures reliable, high-quality, and governed data flows that support analytics, reporting, and downstream applications. Serves as a technical leader in data engineering, driving best practices in pipeline design, data modeling, and platform optimization.

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
• Experience with Azure data services (Azure Data Factory, Azure Data Lake, Synapse Analytics)
• 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
• 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

Education Requirements:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field
• Equivalent combination of education and experience may be considered.

Benefits & Other Compensation: This position includes eligibility for the following benefits, subject to applicable plan terms:

• HealthcareBenefits– Medical,Dental, andVision coverage
• RetirementBenefits –401(k) with employer match (19 years of age and older)
• Time Off – Paid time off (PTO) and leaves of absence,in accordance withapplicable law and eligibility criteria

Eligibility for benefits and the specific terms, conditions, and offerings are governed by the applicableplandocuments and company policies, which may be amended at the Company’s discretion.

About Troon:

Founded in 1990 and headquartered in Scottsdale, AZ, Troon is the world’s largest professional club management company, that specializes in services in golf, hospitality, and residential communities.With more than 900 locations in 45+ states and 27+ countries, Troon is a leading employer in hospitality.Guided by values that emphasize being infectiously energetic, consciously kind, and humbly prosperous,Troon offers professionals the opportunity to grow and succeed within a globally respected organization.Learn more at www.troon.com .

Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.