Lead Backend Engineer – DPS Core & Data Engine Squad

CCC Intelligent Solutions Inc.

Where
Hybrid in Chicago (Green St), IL
Pay
$119K a year

Posted 8 days ago· Checked live at CCC Intelligent Solutions Inc. 3 days ago

Live.Open on the employer's own site.

See how you score for this job

One sentence and your resume. We score it against what CCC Intelligent Solutions Inc. asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on CCC Intelligent Solutions Inc.'s own hiring page 3 days ago.
What is the job?
$119,030.52 - $165,000.00 This position is bonus and/or commission eligible. CCC Intelligent Solutions Inc. (CCC) is a leading cloud platform for the multi-trillion-dollar insurance economy, creating intelligent experiences for insurers, repairers, automakers, part suppliers, and more.
What does it pay?
$119K a year, as the posting states.
Our verdict
Live. Open on the employer's own site.

What the job is

$119,030.52 - $165,000.00 This position is bonus and/or commission eligible.

CCC Intelligent Solutions Inc. (CCC) is a leading cloud platform for the multi-trillion-dollar insurance economy, creating intelligent experiences for insurers, repairers, automakers, part suppliers, and more.

Salary range is

$119,030.52 - $165,000.00 This position is bonus and/or commission eligible.

CCC Intelligent Solutions Inc. (CCC) is a leading cloud platform for the multi-trillion-dollar insurance economy, creating intelligent experiences for insurers, repairers, automakers, part suppliers, and more. At CCC, we’re making life just work by empowering more than 35,000 businesses with industry-leading technology to get drivers back on the road and to health quickly and seamlessly. We’re pushing boundaries with innovative AI solutions that simplify and enhance the claims and repair journey. Through purposeful innovation and the strength of its connections, CCC technologies empower the people and industry relied upon to keep lives moving forward when it matters most. Learn more about CCC at www.cccis.com.

Key Responsibilities

Database Engineering & Modernization (60%)

Stored procedure refactoring: Analyze, optimize, and decompose complex stored procedures into smaller, testable, well-documented units

  • Performance engineering: Query tuning, indexing strategy, execution plan analysis, optimizing data access patterns
  • Schema evolution: Design backward-compatible schema changes with safe rollout/rollback patterns
  • Migration seams: Create facades, wrappers, and anti-corruption layers around stored procedures to enable gradual extraction of business logic into services

Legacy .NET Modernization (30%)

  • Refactor .NET Framework code supporting DPS workflows into maintainable, testable modules
  • Implement strangler fig patterns to incrementally move logic from database service layer while maintaining production stability
  • Build domain-aligned modules/services with clear contracts that enable the Domain & Services Squad to extract capabilities
  • Establish patterns for dependency injection, observability, and error handling in established .NET codebases

Technical Skills

  • 8+ years of professional software development experience in object-oriented languages (C#/.NET required)
  • Expert-level SQL Server knowledge (SQL Server 2019):
  • Advanced query optimization (execution plans, index tuning, query hints)
  • Stored procedure, function, and trigger development/refactoring
  • Database design and normalization
  • Performance tuning at scale (multi-million row tables, complex joins, aggregations)
  • Understanding of indexing strategies (clustered, non-clustered, filtered, columnstore)
  • SQL Agent jobs and automated workflow patterns
  • Transaction isolation levels, locking, and concurrency management
  • C# and .NET Framework/.NET Core (legacy and modern)
  • Experience refactoring established systems while maintaining production stability
  • SQL source control (migrations, version control for schema/stored procedures)

Highly Desired

  • Experience with strangler fig, anti-corruption layer, and facade patterns in practice
  • Hands-on experience migrating logic from stored procedures → service layer in production systems
  • Familiarity with domain-driven design (DDD) concepts (bounded contexts, aggregates, repositories)
  • Azure SQL Database, Azure DevOps experience
  • Observability tools (Application Insights, SQL Profiler)
  • API design and versioning (REST, OpenAPI/Swagger)
  • Unit testing frameworks (xUnit, NUnit) and test data builder patterns
  • PowerShell for database scripting/automation
  • Experience with microservices architecture and event-driven patterns
  • Familiarity with Entity Framework Core, Dapper, or other ORMs (and knowing when to use native SQL)

Similar open jobs

Software engineer jobs in Chicago (283)Jobs in Chicago (6815)