SQL Server Database Developer Job at eSense Incorporated, Fairfield, CA

c2NoeFljalFWT0pJM1VobnNWNFk0TlN3M2c9PQ==
  • eSense Incorporated
  • Fairfield, CA

Job Description

Overview

We are seeking a Senior-Level SQL Server Database Developer with strong hands-on experience in SQL Server Database and Data Warehouse development.

⚠️ This is NOT a BI / Reporting role. Candidates focused only on reports or dashboards should not apply.

🚫 This role is NOT for BI Report Developers

Candidates whose primary experience is in Power BI, SSRS, or dashboard/report creation without strong database, ETL, and data warehouse development experience should not apply.

The ideal candidate will have deep expertise in ETL development using SSIS, data modeling, data marts, and Kimball methodology, with the ability to design and optimize enterprise-level data warehouse solutions.

Key Responsibilities

  • Design, develop, and maintain SQL Server databases and Data Warehouse solutions
  • Build and optimize ETL pipelines using SSIS for large and complex data sets
  • Develop and maintain data marts following Kimball dimensional modeling methodology
  • Perform data modeling (fact tables, dimension tables, star/snowflake schemas)
  • Optimize SQL queries, stored procedures, functions, and indexes for performance
  • Ensure data quality, integrity, and consistency across systems
  • Collaborate with application teams, architects, and stakeholders to translate business requirements into technical solutions
  • Support deployment, troubleshooting, and performance tuning in production environments
  • Document database designs, ETL processes, and best practices

Required Skills & Experience

  • Senior-level experience as a SQL Server Database Developer
  • Strong expertise in Microsoft SQL Server
  • Significant hands-on experience with SSIS / ETL development
  • Proven experience in SQL Server Data Warehouse development
  • Strong knowledge of data modeling concepts
  • Hands-on experience creating data marts
  • Solid understanding and implementation of Kimball Methodology
  • Advanced SQL skills (complex queries, performance tuning, indexing)
  • Experience working with large, complex datasets

Nice to Have

  • Experience with high-volume or enterprise data environments
  • Strong problem-solving and analytical skills
  • Ability to work independently and mentor junior developers
  • Excellent communication and documentation skills

Important Note

🚫 This role is NOT for BI Report Developers

Candidates whose primary experience is in Power BI, SSRS, or dashboard/report creation without strong database, ETL, and data warehouse development experience should not apply.

Job Tags

Similar Jobs

Verra Mobility

Cloud Systems Engineer Job at Verra Mobility

 ...individual tolling authorities. Position Overview The Cloud Systems Engineer collaborates with architecture and engineering teams to...  ...and NetApp, leveraging features such as SnapMirror and block-level replication for robust data protection. Troubleshoot and... 

CMA Gift & Home

Outside Sales Representative Job at CMA Gift & Home

 ...winning company and team of sales professionals. This is a great entry level position to start in B2B sales! Candidates will be...  ...door sales Be highly self-driven and motivated - no micro management Aggressively and creatively search, find and open new retail... 

MSR Technology Group

Heavy Equipment Mechanic Job at MSR Technology Group

 ...Group DBA Infomatics has been an Inc 500/5000 corporation for the last 7 years in a row. We have an urgent need for Abrams Heavy Equipment Mechanic, and this is an Onsite role in Fort Cavazos, TX. Please find the job details below. Title: Abrams Heavy Equipment... 

Iowa Department of Transportation

GIS Specialist Job at Iowa Department of Transportation

 ...GIS Specialist Print ( Apply ? GIS Specialist Salary $72,238.40 - $111,238.40 Annually Location Ames - 50010 - Story County, IA Job Type Full-time Job Number 26-01786 Agency 645 Iowa Department of Transportation Opening... 

China Global Connections

Geography and History Teacher Job at China Global Connections

We are looking for a Geography and History Teacher for an international school located in Beijing. This is position is available from the upcoming 2026/27 academic year in February 2026.About the schoolThis international educational institution is located in Chaoyang District...