Franklin Fitch
Data Engineer (SQL / SQL Server Focus)
Franklin Fitch, San Francisco, California, United States, 94199
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 .
Base pay range $150,000.00/yr - $180,000.00/yr
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.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
#J-18808-Ljbffr
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 .
Base pay range $150,000.00/yr - $180,000.00/yr
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.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
#J-18808-Ljbffr