Job Description
Job Summary: This role will partner with internal Walgreens IT data engineering and Analytics teams to implement and maintain data infrastructure environments that enables report automation for the Walgreens Health Care Quality Improvement program.
As a Senior Analytics Engineer, you’ll collaborate with a cross functional team of data analysts, BI developers, system administrators, and information users to help deliver performance insights across Walgreens Health.
Local Chicago area candidates would be expected to come into the office as needed.
Job Responsibilities: - Oversees the delivery of Walgreens Health CQI data initiatives and projects. Supports long term and ad-hoc data ETL and data warehousing activities to meet Walgreens Health reporting and analytics deliverables.
- Designs, develops, and deploys dimensional databases and data pipelines to support reporting and analytics projects.
- Creates data staging and pre processing standards for populating logical and physical data models tied to report specific working tables for both enterprise business intelligence and pre defined reporting solutions.
- Applies data extraction, transformation, and loading best practices in order to integrate large data sets from various internal Walgreens production system sources and third party files.
- Perform data profiling and data analysis across internal production systems, manually maintained data, and standard healthcare data sets. (e.g., member eligibility, medical claims, pharmacy claims, HEDIS ECDS files)
- Developing internal tools for automation of all development-related activities (data processing, QA, data validation, etc.)
About Walgreens and WBA
Walgreens ( 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
#LI-TO1
Basic Qualifications
- Demonstrable, hands on experience in writing and tuning SQL based ETL/ELT scripts
- Experience configuring and deploying logically separated data environments using ETL/ELT services that include but are not limited to Azure Data Factory, Databricks, or Snowflake.
- Experience providing thought leadership and introducing tool agnostic semantic data layer improvements related to BI technology platform such as PowerBI, Tableau, or Looker.
- Strong verbal and written communication skills with technical teams, internal stakeholders, customers, and vendor partners.
- At least 2 years of experience contributing to financial decisions in the workplace.
- At least 2 years of direct leadership, indirect leadership and/or cross functional team leadership.
- Willing to travel up to/at least 5% of the time for business purposes (within state and out of state).
Preferred Qualifications
- Data Management\\Certified Analytics Professional (CAP)
- Familiarity with healthcare and clinical analytics concepts
Job Tags
Local area,