Data Pipeline Support Engineer

As a Data Pipeline Engineer at Health Catalyst, your primary role will be to provide 24x7 ETL Support for clients. You will participate in an on-call rotation to ensure support coverage outside US business hours (6 PM - 8 AM MST). Your responsibilities will include monitoring ETL jobs, troubleshooting and resolving failures, and taking proactive measures to prevent future issues. Key Responsibilities: - Monitor and resolve ETL job failures using Health Catalyst and client-provided documentation. Train team members on effective task performance. - Develop expertise in Health Catalyst's Data Operating System, configure queries, and schedule/execute Data Pipeline jobs. - Diagnose performance issues in Azure and SQL Server environments, recommending optimization strategies. - Maintain consistent communication with colleagues and clients concerning critical ETL-related concerns. - Manage and resolve support tickets related to ETL failures, ensuring timely updates and resolutions. - Participate in an on-call rotation to provide after-hours support, addressing ETL failures and assisting with long-running ETL jobs. Qualifications Required: - Proficiency in SQL with strong query development and optimization skills. - Exceptional troubleshooting and analytical problem-solving abilities. - Skilled in database monitoring, diagnostics, and performance tuning. - Hands-on experience with the ETL (Extract, Transform, Load) process. - Proficiency in tuning Azure and SQL Server queries, including interpreting execution plans. - In-depth knowledge of SQL Server indexing strategies, including clustered, non-clustered, and column store indexes.,