DMG Analyst, Multiple Levels

This is a fully remote position, open to applicants in United States.

📋 Description

• Optimize intricate T-SQL against large multi-terabyte claims datasets utilizing execution plans, Query Store, wait statistics, DMVs, and Extended Events, while measuring outcomes.

• Create and uphold clustered, nonclustered, filtered, and columnstore indexes, as well as partitioning and statistical strategies.

• Oversee database performance and address blocking and deadlocks.

• Optimize tempdb and memory usage.

• Collaborate with infrastructure teams on capacity planning, backups, and ensuring high availability.

• Design stored procedures, views, and data structures that facilitate data mining initiatives.

• Write, execute, and monitor SQL queries analyzing medical and pharmacy claims to identify overpayments and recovery prospects.

• Examine slowdowns, data inconsistencies, and decreases in findings through root-cause analysis.

• Enhance data mining and enrichment processes through the use of tools and automation.

• Manage small projects from start to finish, review SQL, mentor analysts, and work collaboratively across departments.

⛳️ Requirements

• Over 5 years of practical experience as a SQL Server DBA, database engineer, or performance-oriented database developer.

• Advanced knowledge of T-SQL and a proven track record in query optimization.

• Capability to interpret execution plans, pinpoint bottlenecks, and enhance queries.

• Extensive understanding of SQL Server internals, encompassing indexing, statistics, partitioning, Query Store, DMVs, wait stats, and Extended Events.

• Experience with multi-terabyte databases, billion-row tables, or enterprise data warehouses.

• Fundamental knowledge of database administration, including backup and recovery, high availability (Always On Availability Groups), security, and monitoring.

• Ability to manage multiple priorities and articulate technical trade-offs to non-technical stakeholders.

• Bachelor’s degree in computer science, information systems, or a related field, or equivalent experience.

• Bonus: Familiarity with medical and pharmacy claims or healthcare payment integrity.

• Bonus: Experience with Azure SQL Database, Azure SQL Managed Instance, or cloud database migrations.

• Bonus: Proficiency in automation using PowerShell or Python.

• Bonus: Knowledge of data warehouse design and columnstore indexing.

🏝️ Benefits

• Work remotely from anywhere in the US.

• Comprehensive Medical/Dental/Vision benefits.

• Flexible Spending Account (FSA)/Health Savings Account (HSA).

• Tuition reimbursement program.

• Competitive salary package.

• 401(k) plan with company matching contributions.

• Additional health and wellness benefits and perks.

• A flexible and trusting work environment where you’ll feel empowered to excel in your role.