Consultant, Advanced Analytics

Role Overview

• Responsible for the development and execution of analyses that address specific client issues or initiatives.
• Proactively identifies trends and issues utilizing a comprehensive range of analytic techniques and tools, translating complex business questions into actionable analytical solutions.
• Liaises directly with client services, network development, and operational personnel, engages directly with clients to ensure the appropriateness of underlying assumptions and interpretations, and provides expert direction on client analytics solutions/services, both internally and externally.
• Lead the development and delivery of client analytics and reporting activities, driving client relationship building, and managing the overall project lifecycle of externally focused analytic deliverables.
• Independently develops and refines methodologies, tools, and templates to allow for the successful execution of analytic deliverables.
• Proactively identifies opportunities for innovation and efficiency.
• Supports the ongoing development of the Advanced Analytics group capabilities by sharing innovative approaches and solutions with the broader team, and actively mentoring junior team members.
• Participates in various activities to support the growth of the Advanced Analytics group including: Developing and delivering training content to Account Management and other internal functions.
• Leading the development and maintenance of appropriate documentation regarding advanced analytic approaches, metric definitions, etc.
• Presents complex analytical findings and strategic recommendations directly to clients, influencing their decision-making processes.

Requirements

• Candidate will have at least 2 years of experience in analytics/reporting, with a strong focus on client-facing roles or significant project ownership.
• Bachelor’s degree required.
• Advanced Analytical Skills – Expert in analyzing and synthesizing complex information to understand issues, identify root causes, and propose optimal solutions.
• Demonstrated ability to independently translate ambiguous business requirements into precise analytical questions and comprehensive solution designs.
• Proven ability to utilize and expand prospective business models.
• Technical Abilities
• Proficiency in Microsoft Excel (including advanced functions, VBA), and strong experience with Business Intelligence (BI) tools (e.g., Tableau, Power BI, MicroStrategy) for dashboard development and data visualization.
• Proficiency in SQL for data extraction and manipulation is required.
• Familiarity with Python or R for advanced analytics and automation is highly beneficial.
• Proven ability to independently manage diverse client and internal stakeholder relationships, effectively communicating complex analytical concepts to both technical and non-technical audiences.
• Demonstrated ability to independently plan, organize, and prioritize multiple complex projects, effectively balancing resources, skills, priorities, and timescales to achieve objectives.
• Adaptable and proactive in responding to changing circumstances, effectively managing, solving problems, and providing innovative solutions in ambiguous environments.
• Written and verbal communication skills, with a proven ability to adjust messaging to fit diverse audiences and deliver compelling presentations that drive action.
• Proven ability to manage strong working relationships within the company, and actively contribute to team knowledge sharing, mentorship, and best practices.
• Strong in using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to complex problems.
• Proactively identifies potential problems and independently creates robust contingency plans or “work-arounds” to ensure project success.

Tech Stack

• Python
• SQL
• Tableau
• VBA

Benefits

• Aetna Transparency in Coverage: Machine-Readable Files | Rakuten