Reporting Analyst - Frederick, MD

Position Description:

We'll put you in the driver's seat on vital projects that
have strategic importance to our mission of helping people lead healthier
lives. As the Report Analyst you are joining a diverse team for Claim and
Provider Services within the Benefit Ops XL Health division. Yes, we share a
mission that inspires. We need your organizational talents and business
discipline to help fuel ours. It's the opportunity to do your life's best
work.(sm)



Primary Responsibilities:

• Assess reporting results through data investigation,
  analysis, and evaluation
• Analyze data and trends and create documentation supporting all of the reports
• Prepare written analysis and summarize results using graphical representations
  and professional formatting
• Ensure that reports support the overall scope of company's business strategies
• Maintain data integrity and ongoing quality control of delivered reports
• Work closely with all levels of end users, including executive level staff, to
  quickly develop reports which will be used to make strategic business decisions
• Create detailed documentation outlining report criteria and provide
  recommendations to the requestor based on the results of the report
• Initiate new projects that benefit the goals of the company
• Have advanced knowledge of one or more areas of health plan operations -
  utilization, claims processing, claims payment, fraud, waste and abuse, and/or
  enrollment
• QA reports for not only coding errors and issues, but also make suggestions on
  data representation
• Ownership of a large-scale, ongoing project and/or area that may contain
  multiple reports, analysis, and representations

Success
Factors:

• Strong analytical and problem solving skills and
  abilities
• Ability to interface with multiple users across the organization and
  effectively project manage reporting requirements from start to finish
• Ability to work in a rapidly changing and growth oriented environment with
  regularly changing priorities and developing opportunities
• Demonstrate strong communication (both verbal and written), and customer
  service skills, and exchange information with others clearly and concisely
• Ability to manage own work flow and meet deadlines while responding to frequent
  demands of multiple customers (internal and external)
• Take ownership of each project from start to finish and follow-up with
  management on project status
• Extensive professional experience in data analysis and report
  design/development
• Extensive knowledge of reporting programs and tools
• In-depth knowledge and experience with relational database concepts and query
  tools
• Sound knowledge of SQL and data extraction methodologies
• Strong report presentation skills
• Excellent communication and interpersonal skills

• High school diploma or GED is required
• 3+ years of healthcare claims specific reporting
  experience
• 3+ experience performing significant data analysis and
  report development
• Must have experience applying critical thinking skills to
  find solutions
• Current proficiency in Microsoft Excel:  
• Sound knowledge of SQL and data extraction methodologies 

Preferred Qualification:

• Advanced Excel skills are a plus:  Experience utilizing pivot tables would be
  helpful but not required