Salary range is:

$84,723.57 - $125,000.00

This position is bonus and/or commission eligible.

The RoleWe are seeking a Software Engineer who is passionate about building new services, database modernization, performance optimization, and strategic refactoring of mission-critical systems. You will be a key member of a squad within the Casualty 3rd Party Integration Team, working on the platform that powers claims management integrations supporting millions of transactions and billions of dollars in claims.

This role balances greenfield service development with legacy modernization. You will build new services using Clean Architecture and domain-driven design principles while also refactoring existing database-centric logic into maintainable, service-oriented solutions. Strong SQL Server skills are essential, but this is not exclusively a database role — you will write C#/.NET services, design APIs, and build integration capabilities.

Key Responsibilities:

Greenfield Service Development (40%)

- Design and build new backend services using Clean Architecture, CQRS, and domain-driven design (DDD) principles

- Implement anti-corruption layers (ACL) to isolate new services from legacy system dependencies

- Create well-defined APIs and service contracts for integration workflows

- Apply bounded context design to ensure clear domain boundaries and service autonomy

- Write clean, testable code with comprehensive unit and integration test coverage

Database Engineering & Modernization (35%)

-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 at scale

- 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

Operational Excellence & Integration Support (25%)

- Build and maintain integration services for data exchange and workflow orchestration

- 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

Must-Have:

- 4+ years of professional software development experience in C#/.NET

- Solid SQL Server knowledge:

- Query optimization (execution plans, index tuning)

- Stored procedure, function, and trigger development/refactoring

- Database design and normalization

- Performance tuning (complex joins, aggregations, multi-million row tables)

- Understanding of indexing strategies (clustered, non-clustered, filtered, columnstore)

- Transaction isolation levels, locking, and concurrency management

- C# and .NET Framework/.NET Core (legacy and modern)

- Clean Architecture 6 experience structuring applications with clear separation of concerns (Domain, Application, Infrastructure, Presentation layers)

- Domain-Driven Design (DDD) 6 practical experience with bounded contexts, aggregates, entities, value objects, and repositories

- Anti-Corruption Layer (ACL) 6 experience building isolation boundaries between legacy systems and new services

- Experience refactoring established, production systems while maintaining stability

- SQL source control (migrations, version control for schema/stored procedures)

- Unit testing frameworks (xUnit, NUnit) and writing testable code

Highly Desired:

- Experience with strangler fig and facade patterns in practice

- Hands-on experience migrating logic from stored procedures  service layer in production systems

- CQRS (Command Query Responsibility Segregation) pattern experience

- Azure SQL Database, Azure DevOps experience

- Observability tools (Application Insights, SQL Profiler)

- API design and versioning (REST, OpenAPI/Swagger)

- Experience with microservices architecture and event-driven patterns

- Familiarity with Entity Framework Core, Dapper, or other ORMs  and knowing when to use native SQL instead

- Azure services (Event Hubs, Azure Functions, Azure Storage)

- PowerShell for database scripting/automation

Nice to Have:

- AI-assisted development  experience using AI coding tools (GitHub Copilot, ChatGPT, or similar) to accelerate development workflows, code generation, and problem-solving

- Python  scripting, data analysis, automation, or tooling

- SQL Agent jobs and automated workflow patterns

- Experience with container-based deployments (Docker, Azure Container Apps)