Senior Backend Engineer – DPS Core, Data Engine Squad

CCC Intelligent Solutions

Senior Backend Engineer focused on database modernization for CCC Intelligent Solutions. Refactoring complex stored procedures and optimizing SQL performance in a hybrid work environment.

Posted 5/7/2026full-timeChicago • Illinois • 🇺🇸 United StatesSenior💰 $119,030 - $147,000 per yearWebsite

Tech Stack

Tools & technologies

.NETSQL

About the role

Key responsibilities & impact

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

What you’ll need

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)

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

C#.NETSQL Serverstored proceduresquery optimizationdatabase designperformance tuningindexing strategiestransaction isolation levelslocking

Soft Skills

collaborationincident responseproblem-solvingdocumentationcommunication