Analyst, Data Analytics

Hbcu Connect, Llc; Deerfield (IL); On-site; USD 65,000 - 114,000; Full time

Job summary

Walgreens is seeking a data analyst to collaborate with account teams and contracting to identify variances from over/under payment practices and incorporate them into actual-to-expected results. You will help develop innovative data analyses and visualizations for strategic business issues, while providing service to internal and external customers.

The role involves preparing standard and ad hoc reports, working with cross-functional teams, and using advanced Excel and BI tools to drive

Qualifications

• Bachelor’s degree or higher with strong quantitative focus.
• Experience collaborating to meet goals within budget and timelines.
• Proven ability to translate data into actionable insights.
• Advanced Excel skills including pivot tables and analyses.
• Experience with data visualization and BI tools.
• Familiarity with statistical concepts and data mining.

Responsibilities

• Identify variances from over/under payment practices and translate into actual-to-expected results.
• Develop innovative data visualization strategies for clear communication.
• Implement analytical methods and supporting tools to evaluate processes and ROI.
• Prepare management reports and ad hoc analyses.
• Collaborate cross-functionally with Sales, Finance, Law, and Contract Operations.
• Ensure data integrity and lead issue resolution with detailed recommendations.

Skills

Advanced Excel

PowerPoint

Word

SAS

SQL

C++

Tableau

Salesforce

Data analysis

Data visualization

Education

Master’s Degree

Bachelor’s Degree in Statistics, Engineering, Computer Science or Information Systems

Tools

SAS

SQL

Tableau

Cognos

Business Objects

PROS

Salesforce.com

Power BI

Job description

Job Summary

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. Assist in the development of timely, innovative, objective analysis which lead to fact-based solutions for strategic business issues. Provides customer service to internal and external customers, including meeting quality standards for services, and evaluation of customer satisfaction.

Job Responsibilities

• Assists in the development and the utilization of innovative data visual presentation strategies to ensure data is conveyed in meaningful and interpretive formats for all audience levels.
• Assists in the development and implementation of innovative 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.
• Assists in the development and maintenance of an automated process to identify data and process integrity issues. Provides leadership with detailed recommendation for issue resolution. Identifies both up and down stream impact of identified issues and fully communicates with any impacted parties.
• Assist in the development of timely, innovative, objective analysis which leads to fact-based solutions for strategic business issues. Identifies, formulates, and drives problem definition and hypothesis formulation as it relates to the specific business environment. Synthesizes externally syndicated data with internal experience.
• Prepares standard and ad hoc management reports and presentations for projects. Utilizes query based tools to create and run queries used for data mining and analytics to support other job responsibilities and ad hoc projects.
• Performs specific tasks identified in the compliance monitoring program to include evaluation of definitions, price increase maintenance and network identification.
• Provides customer service to internal and external customers, including meeting quality standards for services, and evaluation of customer satisfaction.
• Works cross functionally with peers in Sales, Finance, Law, Contract Development, and Contract Operations.

About Walgreens

Founded in 1901, Walgreens (www.walgreens.com) has a storied heritage of caring for communities for generations and proudly serves nearly 9 million customers and patients each day across its approximately 8,500 stores throughout the U.S. and Puerto Rico, and leading omni channel platforms. Walgreens has approximately 220,000 team members, including nearly 90,000 healthcare service providers, and is committed to being the first choice for retail pharmacy and health services, building trusted relationships that create healthier futures for customers, patients, team members and communities.

Basic Qualifications

• Bachelor's Degree OR High School Diploma/GED and at least 3 years of experience in Finance, Economics, Accounting, Math, Business, Actuarial Science, or Computer Science.
• Experience collaborating with internal and external resources to assist in the development of 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).

Preferred Qualifications

• MasterâEUR(TM)s Degree
• BachelorâEUR(TM)s Degree in Statistics, Engineering, Computer Science or Information Systems.
• Knowledge of advanced coding languages (e.g. SAS, SQL, C++, etc.).
• Experience with system administration (e.g. PROS, Vendavo, Vistaar, Salesforce.com, SharePoint, Wikis, etc.).
• Experience with business intelligence tools in support of data analytics (e.g. Business Objects, Cognos, Tableau, PROS, etc).
• Experience with learn coaching, mentoring, and training staff.
• Knowledge of Pharmacy, Pharmaceutical Benefit Manager, Benefit Consultancy, or Managed Care company.
• Experience with working with pharmacy data at a retail pharmacy, Pharmaceutical Benefit Manager, benefit consultancy, or managed care company.
• Knowledge of 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).
• Knowledge of systems such as Remedy and GIS.
• Experience with data extraction, data mining, data acquisition, data profiling, and data warehouse management.
• Experience in a data warehouse/business intelligence/decision support systems environment or IT experience.
• Knowledge of statistical concepts and data mining techniques.

We will consider employment of qualified applicants with arrest and conviction records.

The Salary below is being provided to promote pay transparency and equal employment opportunities at Walgreens. The actual hourly salary within this range that you will be offered will depend on a variety of factors including geography, skills and abilities, education, experience and other relevant factors. This role will remain open until filled. To review benefits, please click here jobs.walgreens.com/benefits. If you are applying on a job board or unable to click on the link, please copy and paste this URL into your browser jobs.walgreens.com/benefits

Salary Range: $65000 - $113750 / Salaried