Great companies need great teams to propel their operations. Join the group that solves business challenges and enhances the way we work and grow. Working at Gainwell carries its rewards. You’ll have an incredible opportunity to grow your career in a company that values your contributions and puts a premium on work flexibility, learning, and career development.
Summary
In this role, 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. The State Report Data Analyst is primarily responsible for performing data analysis design, trend and analyze data, and developing analytical reports that provide aggregate and detailed information related to Medicaid claims data using Oracle PL/SQL. Data analysis includes preparing and presenting results/findings in reports to the client. A successful candidate will understand both medical and pharmacy claims data along with knowledge of SQL development including analytic functions, CTEs, and complex joins. A clinical background is a plus!
Your role in our mission
- Create complex PL/SQL queries and processes to generate reports to support the New Jersey Department of Health and Department of Human Services in implementing protocols, evaluating drug utilization and monitoring cost savings.
- Trend and analyze data to identify areas for potential healthcare quality enhancement and improvement.
- Provide information about drug claim volume and payments to help guide the state in managing drug-related policies and programs.
- Measure the state's performance on various metrics.
- Collaborate with the MEP Report Writer for specific projects and back up as needed.
- Communicate regularly with managers at Gainwell and the state to understand their needs and then design, execute, and present reports for various projects.
What we're looking for
- Minimum of 3 years of hands-on experience creating SQL queries, preferably for a Healthcare industry.
- Experience with Oracle PL/SQL or Microsoft SQL, including analyzing and modifying existing SQL queries and advanced SQL concepts such as analytic functions, CTEs, and complex joins.
- Experience in health-related analytics and/or biostatistics
- Advanced knowledge of Microsoft Excel, including the use of formulas, pivot tables, and Excel tables.
- Strong organizational skills for keeping track of report requests and priorities
- Create and maintain documentation related to new and existing reports
- Excellent verbal and written communication skills and attention to detail
What you should expect in this role
- Fully remote options from US locations only
- Travel only if requested for client meetings
- Video cameras must be used during all interviews, as well as during the initial week of orientation
- The deadline to submit applications for this posting is April 1, 2025
#LI-HC1
#LI-Report Data Analyst
#LI-T-SQL
The pay range for this position is $58,200.00 - $83,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.
