The Role
Build scalable data pipelines, maintain reliable data flows across the analytics ecosystem, and deliver high-quality data transformations. Requires advanced SQL expertise, including window functions, aggregations, recursive CTEs, dynamic SQL, pivoting, error handling, and query performance optimization using indexing, partitioning, and statistics.
Summary Generated by Built In
Role: Data Engineer
Skills: Advances SQL
Job Summary:
We are looking for a skilled Data Engineer (SQL) with hands‑on experience in modern data stack tools including strong SQL expertise. The role involves building scalable data pipelines, ensuring high‑quality 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.
Skills Required
- Hands-on experience as a data engineer, SQL developer, or analytics engineer
- Advanced SQL expertise
- Mastery of SQL window functions, including ROW_NUMBER, RANK, DENSE_RANK, NTILE, LEAD, and LAG
- Experience with GROUPING SETS, ROLLUP, and HAVING
- Ability to write and optimize recursive Common Table Expressions
- Experience constructing and executing dynamic SQL
- Experience with PIVOT and UNPIVOT operations
- Knowledge of TRY...CATCH, CASE, and conditional control-of-flow logic
- SQL query performance optimization using indexing, partitioning, and statistics
- Experience with modern data stack tools
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Anblicks is a Cloud Data Analytics Company based out of Dallas, TX, with offices in USA, India, and Australia. Since 2004, Anblicks has been helping customers by bringing value to their data and implementing modern data architecture and advanced analytics solutions in the cloud.
