Sr. Engineer I - Data Engg & AI

Role: Data Engineer

Skills: Advances SQL

Job Summary

We are looking for a skilled Data Engineer (SQL) with handson experience in modern data stack tools including strong SQL expertise. The role involves building scalable data pipelines, ensuring highquality transformations, and enabling reliable data flows across the analytics ecosystem.

SQL Developers / Analytics Engineers

SQL Expertise

• Mastery of window functions: Proficient with ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LEAD(), LAG(), and other analytic functions for complex data analysis.
• Advanced aggregation techniques: Skilled in using GROUPING SETS, ROLLUP, and HAVING for multidimensional summaries.
• Recursive queries: Able to write and optimize recursive Common Table Expressions (CTEs) for hierarchical or complex data structures.
• Dynamic SQL: Experienced in constructing and executing SQL statements dynamically for flexible query logic.
• Pivoting and unpivoting data: Uses PIVOT and UNPIVOT operations to reshape datasets for reporting and analysis.
• Error handling and control-of-flow: Uses TRY...CATCH, CASE, and conditional logic to manage complex workflows and exceptions.
• Performance optimization: Understands how advanced functions impact query plans and applies indexing, partitioning, and statistics to maintain performance.