Franklin Fitch · 3 weeks ago
Data Engineer (SQL / SQL Server Focus)
San Francisco, CA
Full-time
Onsite
Senior Level, Lead/Staff
$150K/yr - $180K/yr
8+ years expFranklin Fitch is a leading professional services organization seeking an experienced Data Engineer to join its team. This role focuses on supporting enterprise-wide systems, analytics, and reporting initiatives with an emphasis on SQL Server-based data platforms.
Big DataProfessional NetworkingRecruitingStaffing Agency
No H1B
Hiring Manager
Alex B.
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
Qualification
Required
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
Strong analytical, problem-solving, and communication skills, with the ability to work directly with non-technical stakeholders
Preferred
Familiarity with Azure-based SQL Server deployments (Azure SQL, Managed Instance, or SQL Server on Azure VMs) is a plus
Company
Franklin Fitch
Franklin Fitch provides recruitment for networking infrastructure, server infrastructure, big data, project management and cyber security.
51-200 employees
Funding
Current Stage
Growth StageRecent News
Insider Media
2023-12-25
Company data provided by crunchbase