SmartLight Analytics ยท 1 month ago
SQL Server Data Engineer
SmartLight Analytics is focused on reducing healthcare costs through data analysis. They are seeking a Data Engineer responsible for building and maintaining data processing solutions within their healthcare analytics platform, with a focus on T-SQL development and data transformations.
AnalyticsHealth CareInformation TechnologySoftware
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
Qualification
Required
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
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
Company
SmartLight Analytics
SmartLight Analytics reduces health care costs for self-funded employers with analytics and results-oriented solutions.