Lead ETL/Data Engineering

What will I be doing?

• Design, architect, develop and maintain components of Zenoti
• Collaborate with a team of product managers, developers, and quality assurance engineers to define, design and deploy new features and functionality
• Build software that ensures the best possible usability, performance, quality and responsiveness of features
• Work in a team following agile development practices (SCRUM)
• Learn to scale your features to handle 2x to 4x growth every year and manage code that has to deal with millions of records and terabytes of data
• Release new features into production every month and get real feedback from thousands of customers to refine your designs
• Be proud of what you work on, and obsess about the quality of your work. Join our team to do the best work of your career.

What skills do I need?

• 6+ years' experience developing ETL solutions and data pipelines with expertise in processing trillions of records efficiently
• 6+ years' experience with SQL Server, T-SQL, stored procedures, and deep understanding of SQL performance tuning for large-scale data processing
• Strong understanding of ETL concepts, data modeling, and data warehousing principles with hands-on experience building data pipelines using Python
• Extensive experience with Big Data platforms including Azure Fabric, Azure Databricks, Azure Data Factory (ADF), Amazon Redshift, Apache Spark, and Delta Lake
• Expert-level SQL skills for complex data transformations, aggregations, and query optimization to handle trillions of records with optimal performance
• Hands-on experience creating data lakehouse architectures and implementing data governance and security best practices across Big Data platforms
• Strong logical, analytical, and problem-solving skills with ability to design and optimize distributed computing clusters for maximum throughput
• Excellent communication skills for cross-functional collaboration and ability to work in a fast-paced environment with changing priorities
• Experience with cloud-native data solutions including Azure Data Lake, Azure Synapse, and containerization technologies (Docker, Kubernetes)
• Proven track record of implementing CI/CD pipelines for data engineering workflows, automating data pipeline deployment, and monitoring performance at scale

Benefits

• Attractive Compensation
• Comprehensive medical coverage for yourself and your immediate family
• An environment where wellbeing is high on priority – access to regular yoga, meditation, breathwork, nutrition counseling, stress management, inclusion of family for most benefit awareness building sessions
• Opportunities to be a part of a community and give back: Social activities are part of our culture; You can look forward to regular engagement, social work, community give-back initiatives