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.
