Senior SQL Analyst
Job description
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 Analyst 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
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 data analyst performing research on reporting needs, requirement analysis, design of data specifications, creation of mapping documents, presentation of findings to appropriate team members, clients and vendors. The data analyst will use SQL to build queries and will refine those queries into reports within the Microsoft SSRS tool.
- 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.
- Works toward delivering a first draft solution to ETL developers for coding, by rapidly understanding which details about the mapping can be deferred.
- Works closely with configuration team to ensure synchronicity of configuration to interfaces and mappings.
- Uses SQL, data models, data element dictionary and schema to perform data and business analysis.
- Creates unit test cases for area of responsibility.
- Supports Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing.
What we're looking for
4 years data analysis and business knowledge within a healthcare environment and testing arena- 3-5 years of Microsoft SQL experience specifically using SQL to build queries, reports and analyze healthcare data.
- 3+ years’ experience with the Microsoft Reporting Tool SSRS
- 2+ years’ experience with state Medicaid agencies and/or vendors focusing on analysis or provider, member and claims data.
- Microsoft SQL training and/or certification preferred
What you should expect in this role
Work remotely within the United States.- 10% or less in Travel
The pay range for this position is $69,400.00 - $99,200.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 medical condition), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. We celebrate diversity and are dedicated to creating an inclusive environment for all employees.
gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.