Remote Database Engineer

Summary

Join Kaufman Hall's Revenue and Operations Improvement practice as a Database Engineer, working with large complex data sets for Clinical Documentation Improvement initiatives in healthcare systems across the country.

Requirements

• Minimum of 2 years of experience with Microsoft SQL Server, Azure, and SSIS
• Demonstrated ability to design, create and manipulate complex databases, with both transactional and analytical database systems
• Experience with data automation processes and ETL automation tools
• Experience with database design and development in a full stack environment
• Experience with database design with well-honed SQL skills, the ability to create relational data models, create and adjust complex views and stored procedures, tune database performance, and perform quality control testing using SQL
• Experience writing stored procedures
• Experience in performance tuning of queries, using SQL Profiler, evaluating execution plans, and other methods. Experience with Azure App Insights is a plus
• Experience with Microsoft Azure DevOps and Redgate
• Familiarity with Agile development models
• Ability to build and maintain effective and positive relationships with team members
• Excellent conceptual and analytical skills, organizational skills, critical thinking, written and verbal communication skills
• Excellent self-learner with high aptitude to acquire and learn new skills

Responsibilities

• Function as a database engineer, supporting multiple database solutions and developing database code for these solutions
• Work closely with others on the Tech Team to develop best-in-class data management solutions
• Work with the team to design/build modern, secure, and performant ETL processes for client data
• Revise existing systems and code to maintain effective data handling, conversion, input/output requirements, and storage
• Work within an Agile development environment and participate in all aspects of our software development life cycle (SDLC)
• Become a subject matter expert regarding our software applications, their database structures, and their application in solving complex business problems for our clients
• Work with the data and infrastructure team to design and build out an Azure SQL Managed Instance (MI) data warehouse and associated data models
• Become a SME and help the broader team make decisions on data model structure and outputs
• Communicate effectively with non-technical team members, leadership, and business contacts and promote a strong sense of teamwork

Benefits

• Health insurance
• Retirement benefits
• Paid time off
• Remote work, flexible hours