Franklin Fitch
Data Engineer (SQL / SQL Server Focus) (San Francisco)
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 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 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.
(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 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.