Skip to content

Lead Business Intelligence and Analytics Solution Engineer

AbbVie LogoAbbVie
Apply View Organization

Location

Chicago, IL

Posted

3 days ago

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
  • 5+ years of experience in BI and Analytics Architecture, Dimensional Modeling, Data Products, Data Visualization, Data discovery, building curated data sets, insight generation and advanced analytics
  • 5+ years of hands-on working experience in writing complex SQL
  • 5+ years of hands-on experience with BI and data visualization tools like Power BI, Tableau
  • 3+ years of hands-on experience in Snowflake (stored procs, dynamic tables)
  • 3+ years of hands-on experience with data prep tools like Dataiku, dbt or Alteryx
  • 3+ years of hands-on experience in CI/CD (dbt, Azure Repo, git)
  • 3+ years of experience in Python
  • 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

Preferred

  • Experience with Life Sciences Commercial Pharma including insights into sales operations, marketing
  • Consulting experience in Business Intelligence and Analytics domain

‌