Senior Data Engineer

Role Overview

• Design, implement, and maintain logical and physical data structures within the MIR Data Layer
• Build and evolve metadata-driven schemas supporting: Document metadata, Transaction and workflow state, Event based and audit data, Reporting and analytics use cases
• Implement data solutions that support large-scale, concurrent workloads
• Optimize schemas, indexes, and access patterns to improve throughput and latency
• Leverage Memory-Optimized Tables (In-Memory OLTP) for performance-critical paths where appropriate, under architectural guidance
• Implement and support event-driven data processing within the MIR Data Layer
• Work with SQL Service Broker queues and services, including: Asynchronous processing, Status tracking and reconciliation, Retry and error-handling patterns
• Help ensure event processing is idempotent, traceable, and operationally reliable
• Build data structures that enable enterprise reporting and analytics without impacting transactional workloads
• Support snapshotting and reporting-friendly schemas for downstream consumers
• Assist in ensuring audit data is accurate, consistent, and compliant with regulatory expectations
• Contribute to cloud-readiness efforts for the MIR Data Layer
• Support migration and proof-of-concept work targeting: Amazon RDS for SQL Server, Azure SQL Database / Azure SQL Managed Instance
• Help adapt data designs to managed-platform constraints while preserving performance and correctness
• Participate in production readiness, stability, and incident resolution for the MIR Data Layer
• Debug and resolve complex production issues, including: Performance degradation, Blocking, deadlocks, and resource contention, Event based or Service Broker processing failures
• Partner closely with DBAs, SRE, and platform teams to improve monitoring and alerting, Support HA/DR and failover scenarios, Reduce repeat data-layer incidents
• Participate in on-call rotations or escalation coverage as appropriate for a senior-level role
• Ensure new data-layer implementations meet operability and supportability standards before release

Requirements

• Bachelor’s degree, or equivalent work experience
• 5 + years of relevant experience
• Strong hands-on experience with Microsoft SQL Server (SQL Server 2019/2022 preferred) in enterprise, high-volume environments
• Proven ability to design and implement complex, high-performance relational data structures, including metadata-driven and workflow-centric schemas
• Practical experience with SQL Service Broker, including queue usage and basic operational troubleshooting
• Working knowledge of Memory-Optimized Tables (In-Memory OLTP) and associated performance and concurrency considerations
• Medium-level experience with .NET / C#, specifically for: Data access and persistence patterns
• Efficient database interaction from applications
• Debugging data-access issues between application and database layers
• Demonstrated ability to debug and resolve production data issues, including: Query performance bottlenecks, Blocking and deadlocks, Failures in asynchronous or event-driven processing
• Experience supporting reporting and analytics sourced from transactional systems
• Solid understanding of database operations and maintenance, including indexing, statistics, and capacity considerations
• Exposure to cloud-managed SQL platforms (AWS RDS and/or Azure SQL) with awareness of differences from on-prem SQL Server.

Tech Stack

• AWS
• Azure
• Cloud
• MS SQL Server
• SQL
• .NET

Benefits

• Healthcare (medical, dental, vision)
• Basic term and optional term life insurance
• Short-term and long-term disability
• Pregnancy disability and parental leave
• 401(k) and employer-funded retirement plan
• Paid vacation (from two to five weeks depending on salary grade and tenure)
• Up to 11 paid holiday opportunities
• Adoption assistance
• Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law