Job description

Position Description: Maintain and enhance our SQL Server-based database architecture supporting legal settlement administration. This role is ideal for someone with strong T-SQL expertise, hands-on experience in modern ETL/ELT workflows, and a passion for performance optimization. You’ll work across stored procedures, Service Broker messaging, and Power BI reporting to ensure scalable, secure, and efficient data operations. Essential Duties & Key Responsibilities: • Develop and maintain SQL Server database objects (tables, views, procedures, functions, triggers, indexes) • Write advanced T-SQL including dynamic SQL and JSON handling • Use defensive programming for error handling and poison message mitigation • Optimize query performance using execution plans, indexing strategies, and DMVs • Design and maintain CI/CD pipelines for database deployments • Apply 3NF normalization and denormalization strategies • Architect Medallion data layers (Bronze/Silver/Gold) • Integrate authentication with Azure AD and manage service principals • Develop ETL/ELT pipelines using Azure Data Factory or SSIS • Support data warehouse payloads and Slowly Changing Dimension (SCD) processing* • Create and optimize Power BI and SSRS reports* • Apply event-driven architecture within the database* • Manage data dictionaries and governance platforms* • Use schema management tools like RedGate, Apex SQL, dbForge, and Visual Studio Database Projects • Other duties as assigned Requirements & Qualifications: • 5+ years SQL Server development experience (2019/2022 preferred) • Advanced T-SQL, dynamic SQL, JSON handling, and stored procedures • Strong performance tuning and query optimization skills • Experience with Service Broker, CI/CD pipelines, and Medallion architecture • Knowledge of security features: RLS, encryption, Azure AD integration • ETL/ELT expertise using ADF or SSIS; bulk operations and data validation • Power BI/SSRS reporting and capacity management • Familiarity with schema tools (RedGate, Apex SQL, dbForge, VS Database Projects) • Strong analytical mindset and configuration-driven development approach Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is frequently required to sit, use hands to finger, handle, or feel objects, tools, or controls; and reach with hands, talk, and hear. The employee frequently views a computer monitor and frequently uses a computer keyboard. Specific vision abilities required by this job include close vision, peripheral vision, depth perception, and the ability to adjust focus. The employee is regularly required to be mobile, and the employee occasionally travels both short and long distances via a variety of conveyances. Milestone & Co LLC is an Equal Opportunity Employer Minorites/Females/Veterans/Individuals with Disabilities/Sexual Orientation/Gender Identity

Requirements