Senior BI & Analytics Solutions Architect

AbbVie

Mettawa (IL)

On-site

USD 120,000 - 190,000

Full time

3 days ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Benefits offered by this job

Paid time off

Medical/dental/vision insurance

401(k)

Short-term incentive program

Job summary

AbbVie is seeking a Senior Business Intelligence and Analytics Engineer to join the Business Technology Solutions (BTS) team in the United States. You will partner with cross-functional stakeholders to deliver complex analytics projects, design and develop data models, and create compelling visualizations that drive informed business decisions.

You will mentor junior engineers, establish BI governance, and contribute to the digital transformation of a leading biopharma company while leveraging

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.

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 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

Skills

Advanced SQL

Power BI

Tableau

Dataiku

Alteryx

Python

Snowflake

Jira

Confluence

Data Modeling

Dimensional Modeling

Data Warehouse

Data Visualization

Education

Bachelor’s degree in computer science or related field

Master’s degree

PhD with 2 years’ experience

Tools