Senior SQL Server BI Developer

Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You’ll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You’ll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.

 

Summary

 

​​​​​​​As a Senior SQL Server BI Developer at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. Here are the details on this position.​

Your role in our mission

 

Develop your career as you support Gainwell’s focus on creating innovative, purpose-built technologies and solutions to deliver better health and human services outcomes.

 

• Experience in SQL Server 2008\2012 is mandatory. Should be able to write complex stored procedures and functions.
• Optimize long running queries using tuning advisor and Execution plan. Experience with SQL Server Analysis Services, Performance Tuning etc.,
• Utilizes database security regulations, policies, and guidelines.
• Build reporting deliverables using SSRS or Power BI using SQL Scripts.
• Participates in analysis and development of tasks related to business report requirements.
• Utilizes best practices, checklists and defined processes.
• Participates in data analysis for required database objects.
• Strong architectural and design skills with experience implementing various design patterns and frameworks.
• Strong debugging skills and able to identify and fix the issues/bugs identified in the Stored Procedure.
• Should know about Error Handling.
• Work experience in Agile projects.
   

What we're looking for

 

6+ years of SQL Server Development experience with SQL Server 2008/2012.  Additional experience required includes: 

• Previous experience with healthcare systems.   
• Ability to write complex stored procedures and functions.
• Optimize long running queries using tuning advisor and Execution plan
• SQL Server Analysis Services, Performance Tuning etc.,
• Utilizes database security regulations, policies, and guidelines.
• Build reporting deliverables using SSRS or Power BI using SQL Scripts.
• Knowledge of technology architecture, the product development life cycle, cloud technologies, software as a service, and product and platform configurations.
• Strong skills using and manipulating relational databases, event subscription-based communication and software development skills between modules.
• Willingness to lead and take ownership over assigned work and to mentor more junior colleagues in-role.

What you should expect in this role

 

• This position is part of a rotating on-call team.
• Fully remote opportunity with the option to work anywhere within the United States
• Video cameras must be used during all interviews, as well as during the initial week of orientation
• Fast paced, challenging and rewarding work environment.
• Work life balance.    
• Will require late evening work to overlap US work hours.