Data Engineer (SQL / SQL Server Focus)

Job Description

Data Engineer (SQL / SQL Server Focus) (Kind note, we cannot provide sponsorship for this role)

A leading professional services organization is seeking an experienced Data Engineer to join its team. This role supports enterprise-wide systems, analytics, and reporting initiatives, with a strong emphasis on SQL Server–based data platforms .

Key Responsibilities

• Design, develop, and optimize SQL Server–centric ETL / ELT pipelines to ensure reliable, accurate, and timely data movement across enterprise systems.
• Develop and maintain SQL Server data models , schemas, and tables to support financial analytics and reporting.
• Write, optimize, and maintain complex T-SQL queries , stored procedures, functions, and views with a strong focus on performance and scalability.
• Build and support SQL Server Reporting Services (SSRS) solutions, translating business requirements into clear, actionable reports.
• Partner with finance and business stakeholders to define KPIs and ensure consistent, trusted reporting outputs.
• Monitor, troubleshoot, and tune SQL Server workloads, including query performance, indexing strategies, and execution plans.
• Ensure adherence to data governance, security, and access control standards within SQL Server environments.
• Support documentation, version control, and change management for database and reporting solutions.
• Collaborate closely with business analysts, data engineers, and IT teams to deliver end-to-end data solutions.
• Mentor junior team members and contribute to database development standards and best practices.
• Act as a key contributor to enterprise data architecture and reporting strategy, particularly around SQL Server platforms.

Required Education & Experience