Senior Backend Engineer – DPS Core & Data Engine Squad

CCC Intelligent Solutions•Chicago, IL

10d•$106,277 - $165,000

About The Position

CCC Intelligent Solutions Inc. (CCC) is seeking a Senior Backend Engineer to join the DPS Core & Data Engine Squad. This role focuses on database modernization, performance optimization, and strategic refactoring of mission-critical systems. The engineer will work on the system-of-record platform that supports millions of transactions and billions of dollars in claims for both internal (DPS) and external (IES) claims management experiences. The position involves refactoring complex stored procedures, optimizing SQL performance, creating safe migration patterns for continuous modernization, and evolving .NET codebases into clean, testable modules. This is an opportunity for someone passionate about strategic system evolution and contributing to a multi-year transformation from monolithic database logic to a service-oriented architecture.

Requirements

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).

Nice To Haves

Experience with strangler fig, anti-corruption layer, and facade patterns in practice.
Hands-on experience migrating logic from stored procedures to 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).

Responsibilities

Analyze, optimize, and decompose complex stored procedures into smaller, testable, well-documented units.
Perform query tuning, indexing strategy, execution plan analysis, and optimize data access patterns.
Design backward-compatible schema changes with safe rollout/rollback patterns.
Create facades, wrappers, and anti-corruption layers around stored procedures to enable gradual extraction of business logic into services.
Refactor .NET Framework code supporting DPS workflows into maintainable, testable modules.
Implement strangler fig patterns to incrementally move logic from the 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.
Implement performance baselines, regression detection, and alerting for data-intensive workflows.
Participate in incident response for data/performance-related production issues.
Create diagnostic tooling and runbooks to reduce time-to-resolution.
Collaborate with SRE/DevOps on deployment safety (blue/green, feature flags, canary releases for schema changes).