Back to jobs

Lead Business Intelligence and Analytics Solution Engineer

Mettawa, IL, United States

Live, first seen by us 64 days ago
Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Design and build data visualizations and dashboards for business stakeholders

  • Create semantic models with KPI measures under metric governance standards

  • Surface trends, anomalies and correlations to support business decisions

  • Serve as internal BI platform expert and run self-service training office hours

  • Mentor junior resources and lead BI solution architecture

From the employer’s posting
Design/Develop impactful and intuitive data visualizations to effectively communicate data findings
Strong knowledge of creating sematic models (involving complex logical attributes and KPI measures) adhering to metric governance standards.
discovering trends and patterns, anomalies, outliers, and correlations to drive better business decisions
Serve as internal SME on BI platform and drive the self-service COE with office hours training.
As lead engineer, mentor and guide junior resources in architecting BI solutions

Before you apply

Employer’s visa record
369 H-1B petitions approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.

What you’ll bring

All qualifications

Core experience

  • Bachelor’s degree in computer science or related field with 7 years of relevant experience or master’s degree with 6 years of relevant experience; PhD with 2 years’ experience.
  • Experience in requirements gathering, functional/technical documentation, stakeholder engagement, running user training sessions and building a power user business community.
  • Experience in BI and Analytics Architecture, Dimensional Modeling, Data Products, Data Visualization, Data discovery, building curated data sets, insight generation and advanced analytics.
  • Hands-on experience with BI and Data Visualization tools like Power BI, Tableau.
  • Hands-on experience in Snowflake (stored procs, dynamic tables).
  • Hands-on experience with Data Prep tools like Dataiku, dbt or Alteryx .
Qualification wording
Bachelor’s degree in computer science or related field with 7 years of relevant experience or master’s degree with 6 years of relevant experience; PhD with 2 years’ experience.
Experience in requirements gathering, functional/technical documentation, stakeholder engagement, running user training sessions and building a power user business community.
Experience in BI and Analytics Architecture, Dimensional Modeling, Data Products, Data Visualization, Data discovery, building curated data sets, insight generation and advanced analytics.
Hands-on experience with BI and Data Visualization tools like Power BI, Tableau.
Hands-on experience in Snowflake (stored procs, dynamic tables).
Hands-on experience with Data Prep tools like Dataiku, dbt or Alteryx .
Education & alternatives
Qualifications - Bachelor’s degree in computer science or related field with 7 years of relevant experience or master’s degree with 6 years of relevant experience; PhD with 2 years’ experience. - Experience in requirements gathering, functional/technical documentation, stakeholder engagement, running user training sessions and building a power user business community.

About AbbVie

AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow.

In the employer’s words · Read in context

Apply at AbbVie

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 18, 202664 days ago
Recorded sightings
514
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 64

Up longer than most. Similar jobs usually come down between day 5 and day 43.

Well past AbbVie’s usual: its jobs come down by about day 10.

From 16,020 similar postings that came down, and 315 of AbbVie’s. Coming down is not always a hire.

AbbVie is hiring

88 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Analyst hiring is picking up
  • Takes jobs down quickly
  • 25% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • Alteryx
  • Azure
  • dbt
  • Power BI
  • Snowflake
  • Tableau
  • R
  • SQL
Where the posting names them
- Data Prep tools like Dataiku or similar tools like Alteryx, Tableau Data Prep - Python, or R - Cloud data warehouse Snowflake
- Hands-on experience in CI/CD (dbt, azure repo, git). - Experience in Python. Additional Information
- BI and Data Visualization and Data Discovery tools like Power BI, Tableau - Data Prep tools like Dataiku or similar tools like Alteryx, Tableau Data Prep - Python, or R
- Hands-on experience in Snowflake (stored procs, dynamic tables). - Hands-on experience with Data Prep tools like Dataiku, dbt or Alteryx . - Hands-on experience in CI/CD (dbt, azure repo, git).
- Hands-on experience with Data Prep tools like Dataiku, dbt or Alteryx . - Hands-on experience in CI/CD (dbt, azure repo, git). - Experience in Python.
- Advanced SQL - BI and Data Visualization and Data Discovery tools like Power BI, Tableau - Data Prep tools like Dataiku or similar tools like Alteryx, Tableau Data Prep
- Hands-on working experience in writing complex SQL. - Hands-on experience with BI and Data Visualization tools like Power BI, Tableau. - Hands-on experience in Snowflake (stored procs, dynamic tables).
- Python, or R - Cloud data warehouse Snowflake - JIRA, Confluence and Agile project methodology
- Hands-on experience with BI and Data Visualization tools like Power BI, Tableau. - Hands-on experience in Snowflake (stored procs, dynamic tables). - Hands-on experience with Data Prep tools like Dataiku, dbt or Alteryx .
Tools and skills you will use in this role: - Advanced SQL - BI and Data Visualization and Data Discovery tools like Power BI, Tableau
- Experience in BI and Analytics Architecture, Dimensional Modeling, Data Products, Data Visualization, Data discovery, building curated data sets, insight generation and advanced analytics. - Hands-on working experience in writing complex SQL. - Hands-on experience with BI and Data Visualization tools like Power BI, Tableau.

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

Come to work each day with an inclusive and collaborative business technology team. As a Senior Business Intelligence and Analytics Engineer in AbbVie Business Technology Solutions (BTS), you’ll have opportunities to contribute to the digital transformation of a leading biopharma company, helping to create solutions that impact patients and their communities for the better. 

Responsibilities

  • Foster strong relationships with key business stakeholders and clients with strong interpersonal communication and able to work with business and cross-functional teams to deliver and execute complex analytics projects. 
  • A successful candidate will bring analytics knowledge of best-in-class business intelligence practices, deep understanding of Data Modeling, Dimensional Modeling and Data warehouse 
  • Help business stakeholders by providing actionable data insights, discovering trends and patterns, anomalies, outliers, and correlations to drive better business decisions 
  • Design/Develop impactful and intuitive data visualizations to effectively communicate data findings 
  • Develop mockups based on business requirements and curate data to scope out reporting needs 
  • Strong knowledge of creating sematic models (involving complex logical attributes and KPI measures) adhering to metric governance standards. 
  • Establish and follow BI and Analytics best practices including peer review, code review, documentation, coding standards, data quality and ensure reproducibility and compliance. 
  • Serve as internal SME on BI platform and drive the self-service COE with office hours training. 
  • Establish data and metric governance around the curated datasets and metrics, and best practices 
  • Conceive, design, engineer, and implement technology solutions by studying information needs; conferring with users; studying systems flow, data usage, and work processes; investigating problem areas; Demonstrate the ability to resolve key project hurdles and assumptions by effectively utilizing available information and technical expertise 
  • Demonstrate high proficiency across a wide range of technologies and platforms related to design and development, programming languages, data integration, data warehousing, data analysis and visualization tools, data storage, network connectivity, and virtualization/cloud environments 
  • As lead engineer, mentor and guide junior resources in architecting BI solutions and manage and prioritize multiple projects to meet priorities with efficient time management 
  • Perform requirement lifecycle management, epic and story creation (Jira/Confluence), change management, functional testing, coordinating user acceptance testing and training 

Tools and skills you will use in this role: 

  • Advanced SQL 
  • BI and Data Visualization and Data Discovery tools like Power BI, Tableau 
  • Data Prep tools like Dataiku or similar tools like Alteryx, Tableau Data Prep 
  • Python, or R 
  • Cloud data warehouse Snowflake  
  • JIRA, Confluence and Agile project methodology 

Qualifications

  • Bachelor’s degree in computer science or related field with 7 years of relevant experience or master’s degree with 6 years of relevant experience; PhD with 2 years’ experience.
  • Experience in requirements gathering, functional/technical documentation, stakeholder engagement, running user training sessions and building a power user business community. 
  • Able to work with business and cross-functional teams to deliver and execute complex analytics projects. Highly autonomous and productive in accomplishing the deliverables with minimal direction. 
  • Experience in BI and Analytics Architecture, Dimensional Modeling, Data Products, Data Visualization, Data discovery, building curated data sets, insight generation and advanced analytics. 
  • Hands-on working experience in writing complex SQL. 
  • Hands-on experience with BI and Data Visualization tools like Power BI, Tableau. 
  • Hands-on experience in Snowflake (stored procs, dynamic tables).  
  • Hands-on experience with Data Prep tools like Dataiku, dbt or Alteryx .
  • Hands-on experience in CI/CD (dbt, azure repo, git). 
  • Experience in Python. 

Additional Information

Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law: ​

  • The compensation range described below is the range of possible base pay compensation that the Company believes in good faith it will pay for this role at the time of this postingbased on the job grade for this position. Individual compensation paid within this range will depend on many factors including geographic location, and we may ultimately pay more orless than the posted range. This range may be modified in the future. ​

  • We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick), medical/dental/vision insurance and 401(k) to eligible employees.​

  • This job is eligible to participate in our short-term incentive programs. ​

Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission,incentive, benefits, or any other form of compensation and benefits that are allocable to a particular employee remains in the Company's sole and absolute discretion unless and until paidand may be modified at the Company’s sole and absolute discretion, consistent with applicable law. ​

AbbVie is an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives and serving our community.  Equal Opportunity Employer/Veterans/Disabled. 

US & Puerto Rico only - to learn more, visit https://www.abbvie.com/join-us/equal-employment-opportunity-employer.html

US & Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:

https://www.abbvie.com/join-us/reasonable-accommodations.html

Company Description

About AbbVie

AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas including immunology, oncology and neuroscience - and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on LinkedIn, Facebook, Instagram, X and YouTube.

About AbbVie

People
About 57,000 in 2025, up 4% from the year before.Annual report (SEC Form 10-K)
Company
Listed as ABBV.
H-1B visas
76 approved for new hires in fiscal 2025.US Citizenship and Immigration Services
Layoff notices
Notices this year and last cover 144 people. The latest was filed May 19, 2026.State WARN notices

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Mettawa, IL, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.