Lead Backend Engineer – DPS Core & Data Engine Squad

CCC Information Services; Chicago Heights (IL); On-site; USD 119,000 - 165,000; Full time

Benefits offered by this job

401K Match

Paid time off

Annual Incentive Plan

Performance Bonus

Comprehensive health insurance

Adoption Assistance

Tuition Reimbursement

Wellness Programs

Stock Purchase Plan options

Employee Resource Groups

Job summary

CCC Intelligent Solutions Inc. in the United States is seeking a Lead Backend Engineer to drive database modernization, performance optimization, and strategic refactoring of mission-critical systems.

You will be a key member of the DPS Core & Data Engine Squad, powering the system-of-record platform for internal DPS and external IES experiences with millions of transactions. The role emphasizes refactoring stored procedures, optimizing SQL, and building domain-aligned services in .NET.

Qualifications

• 8+ years of professional OO software development (C#/.NET).
• Expert SQL Server knowledge (SQL Server 2019).
• Refactor stored procedures and complex database logic.
• Performance tuning and indexing at scale.
• SQL source control and migrations.
• Familiarity with domain-driven design concepts.

Responsibilities

• Refactor stored procedures into smaller, testable units.
• Tune queries and design indexing strategies for performance.
• Design backward-compatible schema changes with safe rollout/rollback.
• Create facades and anti-corruption layers to extract logic into services.
• Refactor .NET Framework code for DPS workflows into maintainable modules.
• Implement dependency injection, observability, and error handling patterns.
• Establish performance baselines and participate in incident response.

Skills

C# / .NET

SQL Server

Stored procedures

Performance tuning

Database design

DDD concepts

Azure SQL

Observability

Unit testing

EF Core / Dapper

Tools

Azure DevOps

SQL Profiler

Application Insights

OpenAPI/Swagger

PowerShell

Job description

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.

The Role

We are seeking a Lead Backend Engineer who is passionate about database modernization, performance optimization, and strategic refactoring of mission-critical systems. You will be a key member of the DPS Core & Data Engine Squad, working on the system-of-record platform that powers both internal (DPS) and external (IES) claims management experiences supporting millions of transactions and billions of dollars in claims.

This is a modernization engineering role for someone who gets excited about:

• Refactoring complex stored procedures and carving out domain logic into maintainable services
• Optimizing SQL performance and improving system efficiency
• Creating safe migration patterns that enable continuous modernization while maintaining business continuity
• Working in .NET codebases and evolving them into clean, testable, domain-aligned modules

If you love the challenge of strategic system evolution and want to participate in evolving the technical architecture of a multi-year transformation from monolithic database logic to service-oriented architecture—this role is for you.

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

Operational Excellence (10%)

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

Requirements

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

Interview Policy & Privacy Notice

A video interview is required for this position. Video interviews are transcribed. Transcriptions are retained and may be reviewed by CCC and our recruiters. Candidates are not permitted to use generative AI or automated assistance during the interviews unless explicitly allowed by the interview team for a specific exercise. Our Job Applicant Privacy Notice is available.

About CCC's Commitment to Employees

CCC Intelligent Solutions understands that our employees play an integral role in our vision to shape a world where life just works. Our team is defined by our values of Integrity, Customer-Focus, Innovation, Inclusion & Diversity, Tenacity, and Connection. Through diverse perspectives, purposeful innovation, and the strength of connections, our technologies empower the people and industry relied upon to keep lives moving forward when it matters most. At CCC, together everyone can thrive as we innovate and collaborate, creating employee experiences that just work. We are committed to providing opportunities for our people to make real-life impacts, advance in their careers, and contribute to CCC’s success.

Benefits

• 401K Match
• Paid time off
• Annual Incentive Plan
• Performance Bonus
• Comprehensive health insurance
• Adoption Assistance
• Tuition Reimbursement
• Wellness Programs
• Stock Purchase Plan options
• Employee Resource Groups

For more information about our benefits, please check out our careers site.

Here, you belong. You are seen, valued, and respected. We celebrate you for who you are and all you bring. Every voice is heard and is important to our success. You can hear what employees have to say about our culture here