Data Management Engineer
ob Description – Data Management Engineer
Position Title: Data Management Engineer
Department: IT
Reports to: Director of IT
Location: Within 30 miles of Tulsa
Position Summary:
SmartLight Analytics is on a mission to lower the cost of healthcare by eliminating fraud, waste, and abuse. We are seeking a Data Management Engineer with a strong operations focus who thrives at the intersection of data engineering and operational excellence. In this role, you will be responsible for maintaining the data pipelines that power our analytics platforms, while closely monitoring daily operations to ensure files, loads, and jobs run smoothly.
If you’re equally comfortable writing optimized SQL, troubleshooting complex data loads, or collaborating with analysts to improve processes, this is your chance to play a mission-critical role in making healthcare more affordable.
Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States.
Key Responsibilities:
Monitor automated data loads and SQL jobs to ensure successful, timely execution; investigate failures and resolve issues quickly
Validate file continuity, record counts, and historical trends to ensure accuracy and integrity
Proactively detect and address late or missing files using both automated checks and ad-hoc SQL queries
Review “Pending Actions” dashboards and resolve statuses such as Loading, Move, Unknown, Load-Manual, Decrypt-Manual, Load-Error, Review
Document and communicate issues, resolutions, and operational impacts clearly to technical and business teams
Provide actionable insights into data quality, timeliness, and completeness to support client delivery
Partner with developers, analysts, and stakeholders to ensure pipelines meet analytic and reporting needs
Contribute to the advancement of data workflows into Azure Data Factory and Snowflake, helping shape SmartLight’s next-generation data platform
Required Skills and Qualifications:
Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field
3+ years of hands-on experience with T-SQL (stored procedures, functions)
T-SQL optimization, performance tuning, and troubleshooting skills
Excellent problem-solving skills, attention to detail, and accountability for operational reliability
Strong teamwork and communication skills, able to work across technical and business teams
Preferred Qualifications:
Experience monitoring and troubleshooting automated file-based ETL workflows
Familiarity with healthcare claims data and file formats (e.g., fixed width, csv)
Jira or similar ticketing systems experience
Background in data quality monitoring
About SmartLight Analytics
SmartLight Analytics was formed by a group of industry insiders who wanted to make a meaningful impact on the rising cost of healthcare. With this end in mind, SmartLight works for self-funded employers to reduce the wasteful spend in their healthcare plan through our proprietary data analysis. Our process works behind the scenes to save money without interrupting employee benefits or requiring employee behavior changes.