About the role
- Develop high-quality database solutions that support operational and business needs.
- Develop, implement, maintain, and optimize stored procedures and functions using T-SQL.
- Maintain existing SQL Server databases and manage data warehouse-related activities.
- Analyze, audit, modify, and amend data in systems as requested by team members and business stakeholders.
- Respond to critical database incidents while ensuring the integrity of systems and data.
- Create, modify, and design SQL Server Reporting Services reports, data exports and imports, and SQL Server Integration Services packages.
- Develop procedures and scripts for data migration.
- Maintain file transfers and support external data exchange processes.
- Assist with development efforts to define and automate data gathering, analysis, and reporting processes.
- Investigate exceptions related to asset movements.
- Resolve software issues and maintain existing web and/or desktop applications.
- Learn, maintain, and upgrade existing company systems as needed.
- Develop new applications as requested to improve organizational productivity and processes, participating in the database development process from inception through delivery.
- Maintain standards consistent with current IT protocols and procedures and implement action plans as needed for change management.
- Communicate database changes to affected parties and support change management activities.
- Analyze and comprehend state requirements and rules, including COBC and EDI, to maintain and update existing SQL code as needed.
- Comprehend workers’ compensation, liability claims, and medical data to correctly interpret trends that support customer service and business decisions.
- Provide process improvements by automating manual processes.
- Train employees in the proper use of databases.
- Work effectively with project management, support, and other internal departments
- BS/MS degree in Computer Science, Engineering, or a related subject; or equivalent experience. Minimum of three years of experience as an SQL Developer or similar role.
- Minimum of three years of experience writing reports in SSRS.
- Minimum of one year of .NET programming experience.
- Excellent understanding and working knowledge of T-SQL programming and Microsoft SQL Server. Expert-level SQL analytical skills and ability to work with large amounts of data, review facts and figures, and analyze information to identify conclusions.
- Proficient knowledge of Microsoft Office suite, including Word, Excel, and PowerPoint.
- Ability to read, write, speak, and communicate fluently in English.
- Power BI, Azure Data Factory, Microsoft Fabric, and Power Apps experience preferred.
- Insurance industry experience is a plus.