Senior SSRS Application Designer

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 Senior SSRS Application Designer at Gainwell, you are responsible for designing and/or creating, maintaining, deploying, and managing SSRS reports for internal business teams and our customers. Candidates will work collaboratively with IT staff, and business stakeholders to create, maintain, and support analytic reports and BI dashboards 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. The position supports required data integration, reporting and transformation processes crucial to the implementation and function of the Gainwell Medicaid Fiscal Agent services product. Serves as a team leader, coordinating team members’ activities, research on reporting tasks, requirement analysis, design of data specifications and mapping documents. Ability to effectively track team progress and report to Gainwell leaders, clients and partners.  The lead data analyst will use SQL to build complex queries and will refine those queries into reports within the SSRS tool.

Your role in our mission

Discover career satisfaction by design in this challenging position, where you will:

• Facilitates and/or participates 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.
• Works aggressively to define project scope. Ties data interface roster elements back to a valid requirement. Works with the customer and account management to control the scope of the project.
• Responds to action items by assigned due dates.
• Escalates concerns to project management, such as delays or risks of delays as early as possible.
• Creates accurate queries, reports, data mapping documents according to the mapping process.

What we're looking for

• 4 to 5 years of experience using Microsoft SQL Server BI Suite SSRS
• 4 to 5 years of experience with MS-SQL scripting (required)
• 3+ years SQL Server version 2014 or higher (required)
• Experience in a Healthcare IT working with claims, member and provider data strongly desired.
• Analytical skills in a SQL environment
• Experience with QNXT or FACETS Healthcare Payer Platforms preferred

What you should expect in this role

• Opportunities to travel through your work (0-10%)
• Remote in All USA Locations

The pay range for this position is $86,800.00 - $124,000.00 per year, however, the base pay offered may vary depending on geographic region, internal equity, job-related knowledge, skills, and experience among other factors. Put your passion to work at Gainwell. You’ll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits, and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.

 

We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You’ll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings.

 

Gainwell Technologies is committed to a diverse, equitable, and inclusive workplace. We are proud to be an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related me