Job details
Job type full-time number of hires for this role 1
Qualifications
Sql: 1 year (preferred)
Full job description
Description - external
Summary:
Avēsis is a rapidly growing eye care, dental and hearing insurer serving approximately 8.5 million members for both commercial and government programsAn opportunity exists for a key resource in the full life cycle of reporting within the business intelligence reporting departmentThis position collaborates with other team members and other business areas in the development, documentation, distribution, and testing of new and existing reportsThis is an ideal fit for someone with strong technical comprehension with an inherent analytical ability to understand data, recognize trends, and communicate its overall meaning.
Essential job functions:
Work in partnership with management to ensure the accurate collection, analysis, and distribution of data.
Design, build, test, and ensure reports are implemented, maintained, and updated based upon business requirements.
Collaborate with leadership to provide meaningful and credible feedback on reporting capabilities and needs.
Translate business needs into technical requirementsFormulate test plans.
Partner with it, database administrators, and business stakeholders to ensure that data and sources are defined and accessible.
Routinely conduct data validation.
Extract a variety of data using ms sql.
Responsible for the creation, maintenance, and publication of assigned reports.
Ensure that reports and data files are created within guidelines.
Analyze data to identify trends impacting customer experiencePresent information and recommendations to leadership.
Qualifications - external
Qualification requirements:
Education:
Bachelor’s degree required.
Majors or concentrations related to business technology preferred.
Other major considered with demonstrated experience.
Experience:
3-5 years related experience in business intelligence/business analytics.
Multiple years of interaction with business and technology partners in collecting and translating business needs into deliverables.
Proven ability in report creation and data visualization.
Skills:
Understand concepts of relational databases.
Skilled ms sql coder.
Proficient with ms excel.
Strong analytical abilities.
A self-motivated, independent worker who also enjoys contributing to a team effort.
Excellent time management skills with the ability to prioritize work and strategize deadlines.
Embrace collaborating with a diverse team located in varying geographic regions.
Skilled communicator.
Proven usage of fundamentals of requirements gathering, design and testing.
Problem solving and issue resolution skills.
Confident to recommend innovative ideasWilling to experiment with advanced tools, technology, and processes to discover new solutions.
Preferred:
Knowledge of tableau, ssrs, ssis, smartsheets or similar reporting tools.
Exposure to retrieving data from genesys call center software.
Exposure to reporting data from ivanti heat system.
Experience in healthcare insurance.
Knowledge of medicaid and/or medicare, cms.
About avesis:
Avesis has been providing essential ancillary benefit solutions since 1978Since its inception avesis has developed, administered and refined its offerings to provide clients with best-in-class product choices and servicesToday, our programs cover more than 8.5 million members throughout the countryWe strive for excellence in all that we do and our benchmark performance in terms of member satisfaction and client retention underscores this singular focus.
The continued upward spiral in health care costs has challenged sponsors, providers and payers of health benefits to deliver high quality care in the most cost-effective manner possibleThe avesis benefits menu has been created to meet that challenge by making available quality essential ancillary benefit services at the lowest possible price while never sacrificing the highest quality of serviceProviding outstanding customer service is a top priority, and our core values of accountability, empowerment, excellence, and integrity help us achieve high member and client satisfaction.
As of january 2016 avesis is a wholly-owned, independent subsidiary of the guardian life insurance company, a distinction that brings even more capabilities to avesisThe guardian is a fortune 250 mutual insurance company that has put its policyholders and clients above all else for more than 150 years, and it has earned them not only a great reputation but awards and accolades from such authorities as j.dPowerAdhering to high standards, doing the right thing, and making people count are the founding principles that has kept guardian financially sound and made them one of the largest insurance companies in the country.
In january 2017, premier access joined the avesis familyPremier access has focused on direct state contracts for medicaid and chip, specifically in california and utahThey were one of the original participants in the chip and medicaid programs#avesis2020
Avesis is an equal opportunity employerAll qualified applicants will be considered for employment without regard to age, race, color, creed, religion, sex, affectional or sexual orientation, national origin, ancestry, marital status, disability, military or veteran status, or any other classification protected by applicable law.
Job type: full-time
Benefits:
401(k)
Dental insurance
Health insurance
Life insurance
Paid time off
Vision insurance
Schedule:
8 hour shift
Experience:
Sql: 1 year (preferred)
Work location:
Fully remote
Work remotely:
Yes
