Lead Business Intelligence and Analytics Solution Engineer

Posted 5 Days Ago
Be an Early Applicant
Mettawa, IL, USA
Hybrid
110K-209K Annually
Senior level
Healthtech • Pharmaceutical
The Role
Leads the design and delivery of business intelligence and analytics solutions, including data modeling, curated datasets, semantic models, dashboards, data visualizations, and actionable insights. Partners with stakeholders on requirements, governance, testing, training, and adoption. Uses SQL, Power BI, Tableau, Snowflake, Python, and data preparation tools while mentoring junior engineers, managing multiple projects, and promoting BI best practices.
Summary Generated by Built In
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.

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

Skills Required

  • Bachelor's degree in computer science or a related field with 7 years of relevant experience
  • Master's degree with 6 years of relevant experience, or PhD with 2 years of experience
  • Experience gathering requirements and creating functional and technical documentation
  • Experience engaging stakeholders and working with cross-functional teams
  • Experience running user training sessions and building a power-user business community
  • Experience with BI and analytics architecture, dimensional modeling, data products, data visualization, data discovery, curated datasets, insight generation, and advanced analytics
  • Hands-on experience writing complex SQL
  • Hands-on experience with Power BI and Tableau
  • Hands-on experience with Snowflake, including stored procedures and dynamic tables
  • Hands-on experience with Dataiku, dbt, or Alteryx
  • Experience with CI/CD, dbt, Azure Repos, and Git
  • Experience with Python

AbbVie Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about AbbVie and has not been reviewed or approved by AbbVie.

  • Retirement Support Retirement programs are portrayed as a standout, with a dollar‑for‑dollar 401(k) match up to 6% and an additional annual company contribution based on age and service. Feedback suggests this materially boosts perceived total compensation for many U.S. employees.
  • Parental & Family Support Paid parental and caregiver leave are emphasized, including up to 12 weeks of fully paid parental leave for all parents and 4 weeks of paid caregiver leave in the U.S. Feedback suggests these policies are a meaningful differentiator for employees balancing family needs.
  • Leave & Time Off Breadth Time off is described as extensive, with tiered vacation that scales with tenure, 17 company holidays, and two paid volunteer days in the U.S. Feedback suggests the breadth of leave contributes notably to overall benefits satisfaction.

AbbVie Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: North Chicago, IL
56,000 Employees
Year Founded: 2013

What We Do

AbbVie is a global biopharmaceutical company focused on creating medicines and solutions that put impact first — for patients, communities, and our world. We aim to address complex health issues and enhance people's lives through our core therapeutic areas: immunology, oncology, neuroscience, eye care, aesthetics and other areas of unmet need.

Similar Jobs

TransUnion Logo TransUnion

Industry Executive - Community Financial Institutions - Mountain

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Remote or Hybrid
7 Locations
13000 Employees
92K-154K Annually

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Actuarial Development Program - July 2027

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Hybrid
3 Locations
40000 Employees
61K-109K Annually

Samsara Logo Samsara

Accounting Manager

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
83K-139K Annually

NinjaTrader Logo NinjaTrader

Executive Assistant

Fintech • Software • Financial Services
Easy Apply
Hybrid
Chicago, IL, USA
430 Employees
85K-110K Annually

Similar Companies Hiring

Sailor Health Thumbnail
Healthtech • Social Impact • Telehealth
New York City, NY
20 Employees
Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
OneImaging Thumbnail
Healthtech
Miami, FL
62 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account