Lead Backend Engineer – DPS Core & Data Engine Squad

CCC Intelligent Solutions is hiring a Lead Backend Engineer to modernize its DPS Core & Data Engine system-of-record platform. The role focuses on refactoring database and .NET systems, improving performance, and enabling a gradual transition to service-oriented architecture while maintaining production stability.

Responsibilities:

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

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