Senior Data Engineer (ETL pipelines)

Why Join Halcyon Labs We’re an AI-first global tech company with 25+ years of engineering leadership, 2,000+ team members, and 500+ active projects powering Fortune 500 clients, including HBO, Microsoft, Google, and Starbucks. From AI platforms to digital transformation, we partner with enterprise leaders to build what’s next. What powers it all? Our people are ambitious, collaborative, and constantly evolving. About the Client The health and fitness software and payment processing provider in the United States, Puerto Rico, Canada, and Mexico. Founded in 1981, they currently work with 7,000+ health clubs. Customer offerings include payment processing and gym management solutions that allow managers to track memberships and schedules and automate payment processing functions. What You’ll Do Design, implement, and optimize end-to-end ETL/ELT pipelines to ingest data from various sources into data lakes and data warehouses Use Azure Data Factory (ADF) and Azure Synapse for orchestrating complex data workflows Write complex, optimized SQL queries and transformations to clean, aggregate, and structure data for business needs Monitor, troubleshoot, and optimize existing data pipelines and SQL queries for maximum efficiency and cost-control in the cloud Work closely with Data Analysts, Power BI developers, and stakeholders to understand data requirements and deliver production-ready data assets What You Bring Extensive hands-on experience in Data Engineering with a focus on cloud-based ETL/ELT development Strong production experience with Azure Data Factory (ADF) and Azure Synapse Analytics Advanced knowledge of SQL (writing complex queries, stored procedures, indexing, and performance tuning) Solid understanding of Data Warehousing concepts (Star/Snowflake schemas, dimensional modeling) Experience working with different data formats (Parquet, JSON, CSV) Availability to work during U.S. business hours Nice to Have Experience with Databricks or PySpark Familiarity with Version Control tools (Git, Azure DevOps) Understanding of how data feeds into visualization tools like Power BI Azure certifications (e.g., DP-203: Azure Data Engineer Associate) English level Upper-Intermediate Legal & Hiring Information Halcyon Labs is proud to be an Equal Opportunity Employer committed to inclusion across minority, gender identity, sexual orientation, disability, age, and more. Reasonable accommodations are available to enable individuals with disabilities to perform essential functions. Please note: this job description is not exhaustive. Duties and responsibilities may evolve based on business needs. Compensation details are shared with candidates at the early stage of the recruitment process. The offer is not binding until a signed contract is in place. Your Benefits at Halcyon Labs Halcyon Labs benefits vary by location and contract type. Your recruiter will fill you in on the details. International projects In-office, hybrid, or remote flexibility Medical healthcare Recognition program Ongoing learning & reimbursement Well-being program Team events & local benefits Sports compensation Referral bonuses Top-tier equipment provision Halcyon Labs Culture We lead with trust, respect, and purpose. We believe in open dialogue, creative freedom, and mentorship that helps you grow, lead, and make a real difference. Ours is a culture where ideas are challenged, voices are heard, and your impact matters.