Senior Data Analyst, Reporting and Analytics, Insurable Risk
Walgreens
Job SummaryPrimarily responsible for reporting financial information related to claims, premiums and allocations to the Accounting and Finance stakeholders within the organization. This role is also responsible for managing, tracking and facilitating payments to outside suppliers for claims, insurance and related items. This role is responsible for eliminating discrepancies, organizing data and communicating complex financial information in an easy-to-understand manner. Job Responsibilities
- Acts as subject matter expert and advisor on topic of assigned analytical tools, enterprise data systems and/or analytical methodologies for the team
- Utilizes innovative data visual presentation strategies to ensure data is conveyed in meaningful and interpretive formats for all audience levels.
- Uses analytical and/or statistical methodologies and supporting tools for evaluating Company processes, business problems, and/or ROI of products and services.
- Collaborates with the account teams and contracting to identify and isolate variances resulting from over/under payment practices and factoring these into actual-to-expected results.
- Leads the utilization of all models and tools used to compare executed contract terms and conditions to parameters included in internal and external data sources. Identifies data source deficiencies among company data and suggests path to resolve.
- Performs specific tasks identified in the compliance monitoring program to include evaluation of definitions, price increase maintenance and network identification.
- Recommends improvements to standard model assumptions and multifaceted business problems within the organization. Updates processes, using findings from performance monitoring (For example, adding order logic steps to improve on data matching).
- Works cross functionally with peers in Sales, Finance, Law, Contract Development, and Contract Operations
“About Walgreens and WBAWalgreens (www.walgreens.com) is included in the U.S. Retail Pharmacy and U.S. Healthcare segments of Walgreens Boots Alliance, Inc. (Nasdaq: WBA), an integrated healthcare, pharmacy and retail leader with a 170-year heritage of caring for communities. WBA’s purpose is to create more joyful lives through better health. Operating nearly 9,000 retail locations across America, Puerto Rico and the U.S. Virgin Islands, Walgreens is proud to be a neighborhood health destination serving nearly 10 million customers each day. Walgreens pharmacists play a critical role in the U.S. healthcare system by providing a wide range of pharmacy and healthcare services, including those that drive equitable access to care for the nation’s medically underserved populations. To best meet the needs of customers and patients, Walgreens offers a true omnichannel experience, with fully integrated physical and digital platforms supported by the latest technology to deliver high-quality products and services in communities nationwide.”The actual salary an employee can expect to receive, plus bonus pursuant to the terms of any bonus plan if applicable, will depend on experience, seniority, geographic location, and other factors permitted by law. To review benefits, please visit jobs.walgreens.com/benefits."An Equal Opportunity Employer, including disability/veterans".
- Bachelor's Degree and at least 1 year of experience in Finance, Economics, Accounting, Math, Business, Actuarial Science, or Computer Science OR High School Diploma / GED and at least 4 years of experience in Finance, Economics, Accounting, Math, Business, Actuarial Science, or Computer Science.
- Experience collaborating with internal and external resources to develop strategies and project plans that meet department goals within budget and established timelines.
- Experience establishing and maintaining key relationships with internal (peers, business partners and leadership) and external (business community, clients and vendors) within a matrix organization to ensure quality standards for service.
- Experience developing ways of accomplishing goals with little or no supervision, depending upon oneself to resolve issues to ensure completed objectives and determining when escalation of issues is necessary.
- Experience using time management skills such as prioritizing/organizing and tracking details and meeting deadlines of multiple projects with varying completion dates.
- Experience in diagnosing, isolating, and resolving complex issues and recommending and implementing strategies to resolve problems.
- Experience with analyzing and reporting data in order to identify issues, trends, or exceptions to drive improvement of results and find solutions.
- Advanced level skill in Microsoft Excel (for example: using AVERAGE function, merging and centering cells, printing centered page and/or creating a pivot table).
- Advanced level skill in Microsoft PowerPoint (for example: changing picture styles, customizing animation and/or setting automatic slide timings).
- Advanced level skill in Microsoft Word (for example: adding developer tab, creating a macro, formatting table style, inserting comments and/or creating a mail merge).
- Willing to travel up to 10% of the time for business purposes (within state and out of state).
- Bachelor’s Degree in Statistics, Computer Science or Information Systems
- Master’s Degree / MBA
- Experience with advanced coding languages (e.g. SAS, SQL, C++, etc.)
- Experience with system administration (e.g. PROS, Vendavo, Vistaar, Salesforce.com, SharePoint, Wikis, etc.)
- Experience utilizing business intelligence tools in support of data analytics (e.g. Business Objects, Cognos, Tableau, PROS, etc)
- Certified as a SalesForce administrator or developer.
- Experience in coaching, mentoring, and training less senior team members.
- Experience with Pharmacy, Pharmaceutical Benefit Manager, Benefit Consultancy, or Managed Care company.
- Experience working with pharmacy data at a retail pharmacy, Pharmaceutical Benefit Manager, benefit consultancy, or managed care company.
- Experience with pharmaceutical industry pricing.
- Experience with project management (for example: planning, organizing, and managing resources to bring about the successful completion of specific project goals and objectives).
- Experience with systems such as Remedy and GIS preferred.
- Experience with data extraction, data mining, data acquisition, data profiling, data warehouse management, and statistical concepts
- At least 2 years working in a data warehouse/business intelligence/decision support systems environment or at least 2 years of IT experience.