Data and Analytics Engineer, Business Technology Solutions

    • Abbvie
  • North Chicago, IL
  • Posted 23 days ago | Updated 8 hours ago


On Site
Full Time


Mergers and acquisitions
Artificial intelligence
Machine Learning (ML)
Data profiling
Data cleansing
International relations
Information retrieval
Investor relations
Data Lake
IT consulting
Software development methodology
Microsoft Power BI
Qlik Sense
TIBCO Spotfire
Analytical skill
Cloud computing
Data modeling
Performance tuning
Project delivery
Risk management
Team leadership
Life sciences
Business intelligence
Data warehouse
Apache Hive
Cloudera Impala
Data manipulation
Data storage

Job Details

Company Description

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 - immunology, oncology, neuroscience, and eye care - and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at Follow @abbvie on Twitter, Facebook, Instagram, YouTube and LinkedIn.

Job Description

The Data & Analytics team in AbbVie's Information Research Business Platforms, part of the BTS (Business Technology Solutions), works closely with various domains including Medical Affairs (MA). Their objective is to improve and enhance the digital technology products that support the capabilities and enable better decision-making in the field of Medical Affairs.

As a Lead Data and Analytics Engineer, you will be required to oversee Medical Affairs data and analytics initiatives as well as overseeing initiatives within FOUNDRY Data Lake. You will perform the following:
  • Collaborate with cross functional teams to oversee end-to-end Business Intelligence/Analytics, and Data Warehouse solutions implemented.
  • Responsible for designing analytical solutions (using tools such as PowerBI, Spotfire, QlikSense, and Web) and reporting solutions for multiple business functions.
  • In addition, knowledge of AI/ML and other technologies like Chatbot is required.

In this role, you will be responsible for:
  • Acting as domain expert for Data & Analytics.
  • Leading data analysts to perform data profiling, data cleansing, and data transformation tasks.
  • Designing analytical solutions to meet current and future business needs and strategies.
  • Collaborate with the IR Data Lake BTS Organization and take charge of Data Onboarding initiatives for data and analytics related to a specific Business domain. Serve as the main contact for all analytical requirements for that particular business.
  • Coordinating with multiple development teams and managing solutions for different analytical and operational needs for the business functions.
  • Maintaining a close relationship with enterprise Infra teams and Cloud vendor to understand their roadmap, ensure platform support and solution viability.
  • Coordinate with Technical delivery lead and developers for project delivery.
  • Understanding organization's vision, goals, strategies and aligning with department priorities appropriately, determining critical success factors, evaluating, and pursuing initiatives based on fit with strategies.
  • Providing project status updates.
  • Providing innovative solution ideas along with execution strategies to help drive business effectiveness.
  • Using technical consulting skills, expertise and collaboration to translate business needs for technology delivery teams including vendor partners.
  • Ensuring that project estimates and timelines are complete, comprehensive, and risk tolerant.

Tools and skills you will use in this role:
  • PowerBI, Qliksense, SQL, Cloudera Workbench
  • SDLC process for data and analytics delivery.
  • Important - Clear and Excellent interpersonal communication, presentations, proofreading, editing, and formatting skills, owning Analytical solutions and navigating through the solutions during demos.


Experience that makes you a strong candidate for this role:

  • Bachelor's Degree with 7 year's experience; Master's Degree with 6 year's experience; PhD with 2 year's experience
  • Experience with any Business Intelligence tools like Power BI, QlikView, Qlik Sense, Spotfire etc
  • Experience delivering Data and Analytical initiatives on modern cloud-based data warehouse solutions like Cloudera including data modeling, schema design, and performance optimization.
  • Proven track record in project delivery involving business, functional and technical teams.
  • Proven experience identifying strategies for risk mitigation to reduce or eliminate issues.
  • Experience with leading teams, demonstrated ability to coordinate cross-functional teams towards task completion.
  • Excellent communication and presentation skills.

Beneficial :
  • Experience in Life sciences commercial operations domain.
  • BI/DW and Analytics experience will include one or more of the following roles: Senior Engineer, Product Owner, Data and Analytics Delivery Lead, Data/ System Analyst, Data/ Reporting, etc.
  • Aptitude in any of the languages and databases (SQL, Python, PySpark, Hive, Impala etc.) for data manipulation, data storage and automation tasks.
  • Understanding of ETL/ Orchestration tools (Informatica ETL (IICS and PowerCenter) etc..

Why Business Technology Solutions (BTS):

For anyone who wants to use technology and data to make a difference in people's lives, shape the digital transformation of a leading biopharmaceutical company, and secure sustainable career growth within a diverse, global team: we're ready for

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 posting based 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 or less 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.
  • This job is eligible to participate in our long-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 paid and may be modified at the Company's sole and absolute discretion, consistent with applicable law.

AbbVie is committed to operating with integrity, driving innovation, transforming lives, serving our community and embracing diversity and inclusion. It is AbbVie's policy to employ qualified persons of the greatest ability without discrimination against any employee or applicant for employment because of race, color, religion, national origin, age, sex (including pregnancy), physical or mental disability, medical condition, genetic information, gender identity or expression, sexual orientation, marital status, status as a protected veteran, or any other legally protected group status.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.