About SCAN
SCAN Group is a not-for-profit organization dedicated to tackling the most pressing issues facing older adults in the United States. SCAN Group is the sole corporate member of SCAN Health Plan, one of the nation’s leading not-for-profit Medicare Advantage plans, serving more than 285,000 members in California, Arizona, Nevada, and Texas. SCAN has been a mission-driven organization dedicated to keeping seniors healthy and independent for more than 40 years and is known throughout the healthcare industry and nationally as a leading expert in senior healthcare. SCAN employees are a group of talented, passionate professionals who are committed to supporting older adults on their aging journey, while also innovating healthcare for seniors everywhere. Employees are provided in-depth training and access to state-of-the-art tools necessary to do their jobs, as well as development and growth opportunities. SCAN takes great pride in recognizing our team members as experts in their fields and rewarding them for their efforts. If you are interested in becoming part of an organization that is innovating senior healthcare visit www.thescangroup.org, www.scanhealthplan.com, or follow us on LinkedIn; Facebook; and Twitter.
The Job
Responsible for generating reports and insights to support SCAN’s business and operational needs. The role is critical in providing insights to help understand future changes or needs by SCAN’s members and providers. The talent we’re seeking is someone quick to learn the business functions assigned to them and become a trusted analytics partner. Experience in SQL, managing projects from end-to-end, and working with leadership team is required.
You Will
- Utilize SQL to develop complex queries in support of report objects.
- Leverage clinical, quality, operations, finance (or other data information) to develop, test and deploy reports to non-production environments.
- Analyze, design and develop report mock-ups and prototypes that promote refinement of final requirements.
- Design/construct the report presentation layer to appropriately frame information and ensure intuitive use by consumers (tabular, visualizations, dashboards, etc.).
- Leverage reporting platform features and capabilities to create effective deliverables.
- Adhere to established templates, development standards and Software Development Life Cycle (SDLC).
- Interact with report consumers and other stakeholders to develop and propose appropriate report solutions.
- Lead and/or participate in business analysis activities to gather report requirements and sign-off from business stakeholders.
- Develop and maintain technical specifications and end-user documentation for assigned projects and analyses.
- Meet deadlines and maintain standards of accuracy and customer service.
- Mentor and/or provide guidance to other report analysts in the organization on practices and technology.
- Maintain professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, and participating in professional societies.
- Actively support the achievement of SCAN’s Vision and Goals.
- Other duties as assigned.
Your Qualifications
- Bachelor’s degree in Computer Science or related field preferred
- 2+ years developing complex reports is required.
- Experience diagnosing and resolving errors in complex reports is required.
- Experience developing reports against complex data sets is required.
- Experience with healthcare data preferred.
- Healthcare / Managed Care industry reporting and analysis experience including analyzing healthcare claims data and / or pharmacy data ideal, but not required.
- MS-SQL development, T-SQL, Stored Procedures, SQL Server, SSRS preferred, SSIS preferred, Tableau preferred, Alteryx preferred, Power BI preferred, Snowflake preferred.
- Strong logical and analytical skills.
- Ability to define systemic requirements for reports to ensure maintainability and perform acceptance testing.
- Ability to define monitoring requirements and implement protocols for handling subscriptions.
- Excellent interpersonal, communication, decision making, planning, time management, presentation and organization skills.
- Experience interacting with customers to define requirements and develop workable solutions.
- Ability to work independently and collaborative in team-based support environment.
What's in it for you?
- Base Pay Range: $80,300 to $128,500 annually
- An annual employee bonus program
- Robust Wellness Program
- Generous paid-time-off (PTO)
- 11 paid holidays per year, 1 floating holiday, birthday off, and 2 volunteer days
- Excellent 401(k) Retirement Saving Plan with employer match
- Robust employee recognition program
- Tuition reimbursement
- An opportunity to become part of a team that makes a difference to our members and our community every day!
We're always looking for talented people to join our team! Qualified applicants are encouraged to apply now!
At SCAN we believe that it is our business to improve the state of our world. Each of us has a responsibility to drive Equality in our communities and workplaces. We are committed to creating a workforce that reflects our community through inclusive programs and initiatives such as equal pay, employee resource groups, inclusive benefits, and more.
SCAN is proud to be an Equal Employment Opportunity and Affirmative Action workplace. Individuals seeking employment will receive consideration for employment without regard to race, color, national origin, religion, age, sex (including pregnancy, childbirth or related medical conditions), sexual orientation, gender perception or identity, age, marital status, disability, protected veteran status or any other status protected by law. A background check is required.
