Data Engineer

Twice; Scottsdale (AZ); On-site; USD 80,000 - 100,000; Full time

Job summary

Twice in Scottsdale, AZ is seeking a Data Engineer with 3+ years of experience in data engineering. In this role, you'll design and maintain data pipelines using Azure tools, ensuring high-quality, governed data flows.

The ideal candidate will have strong SQL skills, a solid understanding of data modeling, and experience with cloud-based data platforms. Troon offers a dynamic environment focused on professional development and growth within the organization.

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).

Responsibilities

• Design, develop, and maintain end-to-end data pipelines to ingest data.
• Build and manage data integration processes using Azure tools.
• Implement and enforce medallion architecture for data refinement.
• Transform raw data into clean, validated datasets suitable for analytics.
• Collaborate with data analysts and scientists for reporting needs.

Skills

SQL

Data transformation techniques

Azure Data Factory

Azure Data Lake

Synapse Analytics

ETL/ELT pipeline design

Relational and dimensional data modeling

Data quality and validation techniques

Problem-solving skills

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or related field

Tools

PySpark

Spark

Databricks

CI/CD pipelines

DevOps practices in Azure

Job 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.

About Troon

Founded in 1990 and headquartered in Scottsdale, AZ, Troon is the world's largest professional club management company, specializing 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.