Description

Design, develop, and optimize complex SQL Server environments to support business intelligence and reporting infrastructure.

This role is on-site.

Responsibilities

• Write and tune complex T-SQL queries, stored procedures, functions, and views for high-performance data retrieval.
• Troubleshoot and support SSIS ETL packages, data flows, and integration processes in collaboration with SSIS developers.
• Partner with Power BI developers to ensure underlying SQL structures and data models enable accurate and efficient dashboarding.
• Perform data profiling, validation, and quality checks across source and target systems to resolve discrepancies.
• Document data flows, schema changes, and technical processes to maintain system long-term maintainability.

Required Skills

• 15+ years of experience as a SQL Developer, with at least 10 years in complex T-SQL optimization.
• Strong proficiency in Microsoft SQL Server and T-SQL.
• Demonstrated experience working with SSIS for ETL/data integration.
• Experience collaborating with Power BI developers on data modeling and reporting layers.
• Ability to translate business requirements into technical specifications for diverse stakeholders.
• Bachelor's degree in a relevant field or equivalent practical experience.
• Strong communication skills to explain technical concepts to non-technical audiences.

Preferred Skills

• Experience in financial services (asset management, hedge fund, private credit).
• Familiarity with data warehousing concepts and front/middle/back-office reporting.

Key Skills

Education

Bachelor's degree