Senior Business Intelligence and Analytics Engineer (Hybrid) - 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 – immunology, oncology, neuroscience, and eye care – and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on Twitter, Facebook, Instagram, YouTube and LinkedIn. 

Purpose

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.

In this role, you’ll be responsible for:

• 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 impactful data insights, discovering trends and patterns, anomalies, outliers, correlations to drive better business decisions
• Design/Develop impactful and intuitive data visualizations to effectively communicate data findings to both technical and non-technical audiences.
• Ability to work with business and cross functional teams to deliver and execute complex analytics problems.
• Develop curated datasets using Dataiku or similar tools like Alteryx, Tableau Data Prep per business use cases and facilitate self-service analytics.
• 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 on taxonomy, and other.
• Manage and prioritize multiple tasks to meet deadlines with efficient time management.
• Foster strong relationships with key business stakeholders and clients with strong interpersonal communication.
• Develop and deliver highly impactful and creative presentations.
• Perform requirement lifecycle management, epic and story creation (Jira/Confluence), change management, functional testing, coordinating user acceptance testing and training
• Expand BI and Analytics skillset through research, continuous learning, and development opportunities.

Tools and skills you will use in this role:

• Advanced SQL
• BI and Data Visualization and Data Discovery tools like Power BI
• Experience in Tableau or ThoughtSpot is nice to have
• Data Prep tools like Dataiku or similar tools like Alteryx, Tableau Data Prep
• Python
• Cloud data warehouse Snowflake or Amazon Redshift
• JIRA and Agile project methodology
• Highly autonomous and productive in accomplishing the deliverables with minimal direction

Qualifications

Experiences that make you a strong candidate for this role:

• Bachelor’s degree in computer science or related field with 6 + years of relevant experience or master’s degree with 5+ years of relevant experience.
• 4+ years of experience in BI and Analytics, Data Visualization, Data discovery, building curated data sets, insight generation and advanced analytics.
• 5+ years of hands-on working experience in writing complex SQL.
• 4 + years of hands-on experience with BI and Data Visualization tools like Power BI
• 3+ years of hands-on experience with Data Prep tools like Alteryx
• 3+ years of hands-on experience in cloud data warehouse, data lake like Snowflake
• Experience in Python 
• Experience in running user training sessions and building a power user business community.
• Excellent oral and written communication skills, analytical skills, and stakeholder engagement

Beneficial

• Experience with Life Sciences Commercial Pharma including insights into Sales Operations, marketing is a plus.
• Consulting experience in Business Intelligenceand Analytics domain

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

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 an equal opportunity employer and 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.

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