Data Reporting Analyst III

Responsible for producing and, where possible, automating reports from various sources to provide actionable information and business intelligence for the alternate member channels (Frequently Asked Questions, Email Us and Chat). Working with marginal oversight, the incumbent is responsible for performing complex research, analysis, automation, and reporting of utilization, satisfaction, call deflection and other key operational information. Mine data from appropriate system and perform analysis on data. Implement best practices for retrieving and linking data across multiple applications to formulate cohesive reporting. Collaborate with IT to understand how data is structured and how to best query the data for reporting purposes. Automate and streamline reporting to minimize manual efforts. Design, build and deploy reports, dashboards and data visualizations. Work cross-functionally to gather requirements and translate them into reports. Assess and improve existing reporting and other processes, helping to identify enhancement ideas and opportunities to efficiently maintain and store data across channels over time. Function as the key point of contact for intake of new reporting and analysis requests. Evaluate all data and report findings for accuracy, completeness, intent, and scope, etc. Present data and provide feedback to client/customer, making recommendations where appropriate. Develop relationships with subject matter experts (SME). Seek and adopt best practices in data reporting and documentation. Mentor and train junior analysts. Perform other relevant tasks as assigned by management. Education: Bachelor's degree preferred or relevant work experience required. Experience: Requires a minimum of 6 years experience, preferably in health insurance. Must have strong experience in Excel (VBA Macros) and SQL Must have experience with automated tools Knowledge: Strong PC skills including Excel, Access, SQL and VBA Understand interdependencies among data Must be detail oriented with strong follow-up skills Proven time management skills are necessary. Must demonstrate the ability to handle multiple tasks and respond with a sense of urgency as required. Ability to represent the team in cross-functional meetings and workgroup sessions. Prefer knowledge of Tableau, Adobe Analytics, and SharePoint sites Prefer strong database management skills Prefer 5 years data reporting experience Skills and Abilities: Organizational, Multitasking, Analytical Thinking and strong Interpersonal Skills