Business Intelligence - SSRS 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 ​Business Intelligence - SSRS Developer at Gainwell, you will be a part of an innovative healthcare technology company with a mission to serve the healthcare needs of our communities. You will use your programming and analytical skills to drive the development of healthcare administration products used, and relied upon, by millions of patients. Most importantly, you’ll have the chance to grow and develop as a professional through our exceptional developmental opportunities. 

Your role in our mission

 

Take a close look at some of the details that contribute to Gainwell’s industry-leading tools and technologies in this challenging position. 

 

• Design and develop reporting code based on requirement analysis, utilizing SQL and SQL Server Reporting Services (SSRS), and other available technologies
• Perform SQL server programming as well as tasks using SQL Server Integration Services and SQL Server Reporting Services
• Design and implementation of data models and data loading packages that deliver information in the most efficient manner possible for use in reporting and analytics by both IT and business users
• UAT testing of report code to ensure accuracy, performance, and fulfillment of requirements
• Collaborate with IT staff, and business stakeholders to create, maintain, and support ETL packages in a compliant, regulated environment.
• Escalate concerns to project management or Team Lead, assist in determining best practices and provide suggestions on how to improve current practices.
• Participate in JAD (Joint Application Design), RAD (Rapid Application Development) and DSD (Design Specifications Document) sessions to define and understand the business requirements and present detailed systems design documentation for reports, data interface files, data conversion and any other method of data exchange.
• Develop, test, manage and implement SSRS Packages from development server to production server using package configuration.
• Formulate and document ETL process design based on business requirements and system specification including source to target mapping and transformations.
• Proactively engage in continuous improvement efforts.
• Diagnose and resolve incident tickets and errors.
• Develop ETL specifications, data mapping and other documentation required for ETL development.
• Use SQL, data models, data element dictionary and schema to perform data and business analysis.
• Understand business data and perform quality assurance testing to ensure the data presented is correct.
• Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers.
• Support Unit Testing, System Integration Testing, End-to-End System Testing, and User Acceptance Testing.

What we're looking for

 

• 3+ years of directly applicable data experience Data, ETL and Reporting with experience with Microsoft SQL Server BI Suite (SSRS and MS SQL Scripting), MS SQL scripting and SQL Server version 2019 or higher
• Ability to build complex queries and reports using Microsoft SQL.
• Analytical and data analysis skills using Microsoft SQL (required)
• Recommended additional skills/experience – not required:
  • Healthcare IT working with claims, member and provider data systems
  • A solid understanding of Pharmacy Benefit Management (PBM)
  • QNXT or FACETS Healthcare Payer Platforms