Data Engineer (SQL / SQL Server Focus)

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

• Bachelor’s or Master’s 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 optimization
• Index design and maintenance
• Stored procedures and performance tuning
• Strong 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.