SQL Engineer - Senior Level

We are seeking a skilled and detail-oriented SQL Developer with more than 5 years of professional experience. This role requires a strong command of T-SQL, data manipulation, and report generation. The candidate should be capable of interpreting complex requirements, optimizing query performance, and ensuring data quality through proper testing and documentation.

Requirements

Key Responsibilities:

• Design, develop, and maintain intricate T-SQL queries, stored procedures, views, and functions.

• Analyze and convert business requirements into efficient, accurate SQL code, with correct handling of NULLs, outer joins, and date/time ranges.

• Execute data transformations, cleansing, validation, and enrichment tasks.

• Compose and schedule custom data scripts for insertion, updating, deletion, and movement operations, using transactions and appropriate isolation levels to guarantee consistent results.

• Design, generate, and maintain reports using business intelligence and reporting tools, and validate report output against source data.

• Engage in code reviews, peer programming, and unit testing cycles.

• Enhance existing queries to improve performance and scalability by analyzing execution plans, statistics, and index usage.

• Investigate data issues, perform root cause analysis, reconcile discrepancies between source systems, reports, and application screens, and assist with data integrity initiatives.

• Administer job automation and support ETL processes where necessary.

• Ensure comprehensive documentation of SQL logic, data dictionaries, and version histories.…