What are the responsibilities and job description for the Data Management Engineer position at SmartLight Analytics?
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
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.
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
- 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
- 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
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.
