Sr Consultant National Programs

Posted 11 Days Ago
Be an Early Applicant
East Randolph, NY
1-3 Years Experience
Insurance
The Role
Provide analytical support for strategic initiatives, conduct industry trend research, analyze and summarize large datasets, support national program initiatives, query complex data stores, present findings to stakeholders, administer databases, lead reporting efforts, and develop business and technical processes for National Programs initiatives.
Summary Generated by Built In

The hiring range for this role is:

92,086.00 - 129,145.00

This is the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting. We may ultimately pay more or less than the hiring range and this hiring range may also be modified in the future. A candidate’s position within the hiring range may be based on several factors including, but not limited to, specific competencies, relevant education, qualifications, certifications, relevant experience, skills, seniority, performance, shift, travel requirements, and business or organizational needs. This job is also eligible for annual bonus incentive pay. 

We offer a comprehensive package of benefits including paid time off, 11 holiday medical/dental/vision insurance, generous 401(k) matching, lifestyle spending account and many other benefits to eligible employees. 

Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law. 

 

Provide analytical support for the development of the Division’s strategic initiatives including synthesizing, analyzing and summarizing large datasets via SQL, excel and Cognos. Conduct research on industry trends and summarize data to supplement findings. Collect, validate and analyze Blue Plan claim and enrollment data including the on-going development and maintenance of the Inter-Plan enrollment reporting process and other Market Solutions reporting needs. Support Association and Plan efforts relative to the delivery of national program initiatives through design, development and implementation of technical solutions.

Query large complex data stores to analyze trends and support business decisions. Summarize and present findings to stakeholders via Excel and/or PowerPoint. Work cross functionally across multiple teams to understand and communicate outcomes. Analyze Plan specific and system-wide impacts and present to various audiences across BCBSA and Plans.
Administer, maintain and provide technical oversight for quarterly Inter-Plan Program Enrollment (IPPER) processing. Maintain all databases, data collection and reporting processes supporting IPPER. Work with Blue Plans on a quarterly basis for successful submission of enrollment data and variance reports to ensure data accuracy proactively resolving any issues encountered. Support IPPER data adhoc queries synthesizing , analyzing and summarizing large datasets using SQL server and Cognos. Compile industry analysis using IPPER data to identify fortune 500 presence and other high priority industry analytics.
Lead ongoing reporting efforts for various market solution initiatives such as for provider data quality reporting, various production reports, claim volumes, etc. Responsible for ensuring all reporting deliverables are met with high accuracy and leading any technical enhancements needed.
Lead the development of business and technical processes and strategies to support National Programs initiatives including leading planning activities, develop project scope, oversee team efforts, develop and conduct training to ensure smooth transitions of all related components. The position will lead cross functional teams in documenting operating procedures and communicating outcomes to Plans and across BCBSA. This includes: Writing business requirements. Creating data models and based on data analysis and recommendations to enhance applications and/or emerging issues. Development of test plans and implementation and tracking of testing. Compiling materials and training end-users on new technology
Creation and maintenance of business documentation including, but not limited to, presentations, Standard Operating Procedures (SOPs), implementation guides, reference materials, training materials.
Act as primary contact with several customers including internal technical staff and Plan business/technical staff in support of BCBSA applications.

Education
Bachelors Degree
· Mathematics, Computer Science, databases/Information Management or equivalent work experience
Certifications
Experience
· Technical proficiency with Microsoft SQL programming knowledge (SQL server)
· Tableau/Cognos reporting package experience
Experience in productive meeting facilitation and communication
Blue Cross and Blue Shield or Healthcare Industry experience.
· Experience working in a dynamic multi-disciplinary team environment that is customer oriented.
Skills
Advanced knowledge of Microsoft Office (Excel, word, PowerPoint)
Demonstrated ability to frame problems and lead a team in solution development. (preferred)
Demonstrated ability to build relationships with key resource people whether internal or external. (preferred)
Demonstrated ability to lead development and testing of technical capabilities, summarize, communicate and deliver major findings to management (preferred)
Analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
Ability to work effectively in a team environment
Verbal, written and interpersonal communication skills; ability to summarize complex information and develop clear and concise communications for various audiences.
Relationship management skills; ability to work cooperatively and effectively with various levels of staff, including senior management, as needed.
People Management
No

#LI-Hybrid

Top Skills

Cognos
SQL
The Company
HQ: Chicago, IL
3,161 Employees
On-site Workplace
Year Founded: 1910

What We Do

Blue Cross Blue Shield Association is a national federation of 34 independent, community-based and locally operated Blue Cross and Blue Shield companies that collectively provide health care coverage for one in three Americans. BCBSA provides health care insights through The Health of America Report series and the national BCBS Health Index.

Jobs at Similar Companies

Outdoorsy Logo Outdoorsy

Director - Strategic Business Development

Insurance • Sharing Economy • Software • Travel
Hybrid
Austin, TX, USA
184 Employees
170K-200K Annually

MassMutual India Logo MassMutual India

Fullstack Senior Architect

Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana, IND
Easy Apply
Remote
USA
73 Employees
80K-110K Annually

Similar Companies Hiring

Outdoorsy Thumbnail
Travel • Software • Sharing Economy • Insurance
Austin, TX
184 Employees
Spark Advisors Thumbnail
Insurance
New York, NY
73 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account