Machinify - DMG Analyst (Multiple Levels)
Requirements
• 5+ years of hands-on experience as a SQL Server DBA, database engineer, or performance-focused database developer. • Expert-level T-SQL and a proven track record of query optimization: you can read an execution plan, pinpoint the bottleneck, and fix it (and you have a story about the time you did). • Deep knowledge of SQL Server internals, including indexing, statistics, partitioning, Query Store, DMVs, wait stats, and Extended Events. • A root-cause mindset: you don’t settle for workarounds, and you can show how getting to the bottom of a problem saved time, money, or both. • Experience working with large-scale data: multi-terabyte databases, billion-row tables, or enterprise data warehouses. • Solid grounding in database administration fundamentals such as backup and recovery, high availability (Always On Availability Groups), security, and monitoring. • A proactive problem-solver who can juggle multiple priorities and explain technical tradeoffs to non-technical partners. • Bachelor’s degree in computer science, information systems, or a related field, or equivalent experience. • Experience with medical and pharmacy claims or healthcare payment integrity. • Azure SQL Database, Azure SQL Managed Instance, or cloud database migrations. • Automation with PowerShell or Python. • Data warehouse design and columnstore indexing.
Responsibilities
• Make big data fast. Tune complex T-SQL against multi-terabyte claims datasets using execution plans, Query Store, wait statistics, DMVs, and Extended Events, and measure the before and after. • Make big data fast. • Engineer for performance. Design and maintain indexing (clustered, nonclustered, filtered, columnstore), partitioning, and statistics strategies that cut runtimes and resource usage at scale. • Keep the platform healthy. Monitor database performance, resolve blocking and deadlocks, tune tempdb and memory, and partner with infrastructure on capacity planning, backups, and high availability. • Keep the platform healthy. • Build the foundation. Develop the stored procedures, views, and data structures that power our data mining work, making thoughtful normalization and denormalization choices. • Build the foundation. • Find the money. Write, run, and monitor SQL that examines, interprets, and visualizes trends in medical and pharmacy claims, uncovering overpayments and new recovery opportunities. • Find the money. • Chase the root cause. Investigate every slowdown, data anomaly, and dip in findings until you know exactly why it happened, then fix it for good. Continual root-cause analysis prevents repeat issues, protects recovery dollars, and turns one-time fixes into lasting savings for Machinify and our clients. • Chase the root cause. • Automate and innovate. Continuously improve our data mining and enrichment processes, building tools and automation that make the whole team faster. • Automate and innovate. • Lead and level up the team. Own small projects end to end, review SQL and coach analysts on writing efficient queries, and work closely with other departments to align data insights with business goals. • Lead and level up the team.
Benefits
• Work from anywhere in the US! Machinify is digital-first. • Top Medical/Dental/Vision offerings • Tuition reimbursement • Competitive salary, 401(k) with company match • Additional health and wellness benefits and perks • Flexible and trusting environment where you’ll feel empowered to do your best work • The salary for this position is based on an array of factors unique to each candidate: Such as years and depth of experience, set skills, certifications, etc. We are hiring for different levels, and our Recruiting team will let you know if you qualify for a different role/range. • Equal Employment Opportunity at Machinify • We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace. Machinify is an employment at will employer. We participate in E-Verify as required by applicable law. In accordance with applicable state laws, we do not inquire about salary history during the recruitment process. If you require a reasonable accommodation to complete any part of the application or recruitment process, please let our recruiters know. See our Candidate Privacy Notice at: https://www.machinify.com/candidate-privacy-notice/
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT