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 Serverbased data platforms .
Key Responsibilities
- Design, develop, and optimize SQL Servercentric 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
Bachelors or Masters degree in Computer Science, Information Systems, Data Engineering, or a related field.8+ years of hands-on experience working with SQL Server in enterprise data warehouse or financial reporting environments.Advanced expertise in T-SQL , including :Query optimizationIndex design and maintenanceStored procedures and performance tuningStrong experience with SQL Server Integration Services (SSIS) and SSRS .Solid understanding of data warehousing concepts , including star and snowflake schemas, and OLAP vs. OLTP design.Experience supporting large, business-critical databases with high reliability and performance requirements.Familiarity with Azure-based SQL Server deployments (Azure SQL, Managed Instance, or SQL Server on Azure VMs) is a plus.Strong analytical, problem-solving, and communication skills, with the ability to work directly with non-technical stakeholders.