Data Engineer
Posted 2025-08-23
Remote, USA
Full Time
Immediate Start
<span style="font-size:11pt;"><span style="background:#FFFFFF;"><span><span style="font-family:Calibri, sans-serif;"><b><span style="font-size:12pt;"><span style="background:#FFFFFF;"><span style="color:#000000;">Job Title: </span></span></span></b><span style="font-size:12pt;"><span style="background:#FFFFFF;"><span style="color:#000000;">Data Engineer</span></span></span></span></span></span></span><br><span style="font-size:11pt;"><span style="background:#FFFFFF;"><span><span style="font-family:Calibri, sans-serif;"><b><span style="font-size:12pt;"><span style="background:#FFFFFF;"><span style="color:#000000;">Location:</span></span></span></b><span style="font-size:12pt;"><span style="background:#FFFFFF;"><span style="color:#000000;"> Hybrid - Within 35 miles of Tulsa, Oklahoma<br><b>Department:</b> Information Technology and Product Development<br><b>Reports To:</b> Sr. Director of Engineering</span></span></span></span></span></span></span><br><br><span style="font-size:11pt;"><span style="background:#FFFFFF;"><span><span style="font-family:Calibri, sans-serif;"><b><span style="font-size:12pt;"><span style="background:#FFFFFF;"><span style="color:#000000;">Job Summary:</span></span></span></b></span></span></span></span><br><span style="font-size:11pt;"><span style="font-family:Calibri, sans-serif;">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 2-4 years of hands-on experience with SQL Server and T-SQL development, with a passion for working with healthcare data.</span></span><br><br><span style="font-size:11pt;"><span style="font-family:Calibri, sans-serif;">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.</span></span><br><br><span style="font-size:11pt;"><span style="background:#FFFFFF;"><span><span style="font-family:Calibri, sans-serif;"><span style="font-size:12pt;"><span style="background:#FFFFFF;"><span style="color:#2b333a;">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. </span></span></span></span></span></span></span><br><br><span style="font-size:11pt;"><span style="background:#FFFFFF;"><span><span style="font-family:Calibri, sans-serif;"><b><span style="font-size:12pt;"><span style="background:#FFFFFF;"><span style="color:#000000;">Key Responsibilities:</span></span></span></b></span></span></span></span><div style="margin-bottom:11px;"><ul><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Develop and maintain T-SQL stored procedures for data processing and transformation</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Design and optimize SQL Server databases for healthcare analytics workflows</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Build data extraction and transformation processes using raw T-SQL</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Collaborate with cross-functional teams to understand data requirements and deliver solutions</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Support data quality initiatives and troubleshoot data processing issues</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Learn and utilize myDBR reporting tool for creating reports and visualizations</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Assist in developing healthcare claims processing workflows and data validation</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Participate in code reviews and maintain documentation for data processes</span></span></span></span></span></li></ul><ul><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="background:#FFFFFF;"><span style="line-height:115%;"><span><span style="font-family:Calibri, sans-serif;"><span style="color:#000000;">Monitor and optimize database performance for large healthcare datasets</span></span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="background:#FFFFFF;"><span style="line-height:115%;"><span><span style="font-family:Calibri, sans-serif;"><span style="color:#000000;">Support ad-hoc data analysis requests from stakeholders</span></span></span></span></span></span></li></ul><div style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="background:#FFFFFF;"><span><span style="font-family:Calibri, sans-serif;"><b><span style="font-size:12pt;"><span style="background:#FFFFFF;"><span style="color:#000000;">Qualifications:</span></span></span></b></span></span></span></span><ul><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Bachelor's degree in Computer Science, Information Systems, or related field</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">2-4 years of experience in data engineering or database development</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Strong proficiency in SQL Server and T-SQL programming</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Experience writing complex stored procedures, functions, and triggers</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Solid understanding of database design principles and optimization techniques</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Experience with data transformation and ETL processes using T-SQL</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Strong analytical and problem-solving skills</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Excellent communication and collaboration abilities</span></span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span><span style="font-family:Calibri, sans-serif;">Ability to work independently and manage multiple priorities</span></span></span></span></span></li></ul><br><span style="font-size:11pt;"><span style="background:#FFFFFF;"><span><span style="font-family:Calibri, sans-serif;"><b><span style="font-size:12pt;"><span style="background:#FFFFFF;"><span style="color:#000000;">Preferred Qualifications:</span></span></span></b></span></span></span></span><ul><li style="margin-top:19px;margin-bottom:11px;margin-left:8px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span style="font-family:Calibri, sans-serif;">Experience with healthcare data, medical claims, or prescription claims processing</span></span></span></span></li><li style="margin-top:19px;margin-bottom:11px;margin-left:8px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span style="font-family:Calibri, sans-serif;">Knowledge of myDBR or similar reporting tools</span></span></span></span></li><li style="margin-top:19px;margin-bottom:11px;margin-left:8px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span style="font-family:Calibri, sans-serif;">Understanding of healthcare industry regulations and compliance requirements</span></span></span></span></li><li style="margin-top:19px;margin-bottom:11px;margin-left:8px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span style="font-family:Calibri, sans-serif;">Experience with performance tuning and query optimization</span></span></span></span></li><li style="margin-top:19px;margin-bottom:11px;margin-left:8px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span style="font-family:Calibri, sans-serif;">Background in data analysis or business intelligence</span></span></span></span></li><li style="margin-top:19px;margin-bottom:11px;margin-left:8px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span style="font-family:Calibri, sans-serif;">Familiarity with Azure SQL Database or cloud platforms</span></span></span></span></li><li style="margin-top:19px;margin-bottom:11px;margin-left:8px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span><span style="font-family:Calibri, sans-serif;">Knowledge of data visualization principles</span></span></span></span></li></ul></div><span style="font-size:11pt;"><span style="background:#FFFFFF;"><span><span style="font-family:Calibri, sans-serif;"><b><span style="font-size:12pt;"><span style="background:#FFFFFF;"><span style="color:#000000;">Who is SmartLight Analytics</span></span></span></b></span></span></span></span><br><br><span style="font-size:11pt;"><span style="font-family:Calibri, sans-serif;"><span style="font-size:12pt;"><span style="color:#000000;">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.</span></span></span></span></div>