The Role
The Data Engineer will develop T-SQL stored procedures, manage data transformations, support reporting infrastructure, and collaborate on data requirements.
Summary Generated by Built In
Job Title: Data Engineer
Location: Hybrid - Within 35 miles of Tulsa, Oklahoma
Department: Information Technology and Product Development
Reports To: Sr. Director of Engineering
Job Summary:
The Data Engineer is responsible for building and maintaining robust data processing solutions within our healthcare analytics platform. This role focuses on developing T-SQL stored procedures, managing data transformations, and supporting our reporting infrastructure. The ideal candidate brings 8-10 years of hands-on experience with SQL Server and T-SQL development, with a passion for working with healthcare data.
We are seeking a talented Data Engineer to join our growing team. The ideal candidate will have solid experience with SQL Server database development and T-SQL programming. While knowledge of healthcare claims processing and reporting tools is beneficial, we provide comprehensive on-the-job training in these areas. This position offers an excellent opportunity to grow your career in healthcare analytics while working with meaningful data that directly impacts healthcare cost reduction.
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.
Location: Hybrid - Within 35 miles of Tulsa, Oklahoma
Department: Information Technology and Product Development
Reports To: Sr. Director of Engineering
Job Summary:
The Data Engineer is responsible for building and maintaining robust data processing solutions within our healthcare analytics platform. This role focuses on developing T-SQL stored procedures, managing data transformations, and supporting our reporting infrastructure. The ideal candidate brings 8-10 years of hands-on experience with SQL Server and T-SQL development, with a passion for working with healthcare data.
We are seeking a talented Data Engineer to join our growing team. The ideal candidate will have solid experience with SQL Server database development and T-SQL programming. While knowledge of healthcare claims processing and reporting tools is beneficial, we provide comprehensive on-the-job training in these areas. This position offers an excellent opportunity to grow your career in healthcare analytics while working with meaningful data that directly impacts healthcare cost reduction.
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:
- Develop and maintain T-SQL stored procedures for data processing and transformation
- Design and optimize SQL Server databases for healthcare analytics workflows
- Build data extraction and transformation processes using raw T-SQL
- Collaborate with cross-functional teams to understand data requirements and deliver solutions
- Support data quality initiatives and troubleshoot data processing issues
- Learn and utilize myDBR reporting tool for creating reports and visualizations
- Assist in developing healthcare claims processing workflows and data validation
- Participate in code reviews and maintain documentation for data processes
- Monitor and optimize database performance for large healthcare datasets
- Support ad-hoc data analysis requests from stakeholders
Qualifications:
Preferred Qualifications:
Who is SmartLight Analytics- Bachelor's degree in Computer Science, Information Systems, or related field
- 8-10 years of experience in data engineering or database development
- Strong proficiency in SQL Server and T-SQL programming
- Experience writing complex stored procedures, functions, and triggers
- Solid understanding of database design principles and optimization techniques
- Experience with data transformation and ETL processes using T-SQL
- Strong analytical and problem-solving skills
- Excellent communication and collaboration abilities
- Ability to work independently and manage multiple priorities
Preferred Qualifications:
- Experience with healthcare data, medical claims, or prescription claims processing
- Knowledge of myDBR or similar reporting tools
- Understanding of healthcare industry regulations and compliance requirements
- Experience with performance tuning and query optimization
- Background in data analysis or business intelligence
- Familiarity with Azure SQL Database or cloud platforms
- Knowledge of data visualization principles
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.
Top Skills
Mydbr
SQL Server
T-Sql
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
SmartLight Analytics was formed by a group of industry insiders driven to make a meaningful impact on the rising cost of employee healthcare. Using our statistical, clinical, fraud detection, coding and claims expertise we deliver the most complete wasteful spend reduction solution directly to self-funded employers.
SmartLight utilizes proprietary inferential analytics customized to your employee population, followed by expert clinical review on 100% of your medical claims. Our team partners with your TPA to implement solutions resulting in a lower per employee healthcare spend. We let your data tell us where to look without any preconceived notions about what the errors are beforehand.
Our approach is low-touch and involves zero employee involvement. SmartLight consistently delivers a higher ROI compared to other cost reduction solutions on the market.
