Data Engineer

BallenIsles Country Club • Phoenix, AZ

12d • 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 within the Azure ecosystem. It supports ingestion, transformation, and promotion of data through bronze, silver, and gold medallion layers, ensuring reliable, high-quality, governed data flows for analytics, reporting, and downstream applications. The Data Engineer also serves as a technical leader in data engineering, advancing best practices in pipeline design, data modeling, and platform optimization.

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 with cloud-based data platforms; Azure is preferred.
• Strong proficiency in SQL and data transformation techniques.
• Experience with Azure data services, including 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, such as 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 pipelines that ingest data from internal and external systems into Azure data platforms.
• Build and manage data integration processes using 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 data pipeline deployment.
• Document data flows, transformations, and system dependencies.

Benefits

• Medical, dental, and vision coverage.
• 401(k) with employer match, subject to plan terms and an age requirement of 19 or older.
• 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