Job details
Job type full-time
Full job description
About allergan aesthetics
At allergan aesthetics, an abbvie company, we develop, manufacture, and market a portfolio of leading aesthetics brands and productsOur aesthetics portfolio includes facial injectables, body contouring, plastics, skin care, and moreOur goal is to consistently provide our customers with innovation, education, exceptional service, and a commitment to excellence, all with a personal touchFor more information, visit www.allerganaesthetics.com.
Allergan data labs (adl) is on a mission to transform the allergan aesthetics business at abbvie, the fourth largest pharmaceutical company in the worldAllergan aesthetics brands are iconic household names that include botox, coolsculpting and juvéderm among othersThe aesthetics business is ripe for disruption and we`re building a high performing team to do just that.
Our team has been tasked with rebuilding the allergan consumer rewards and loyalty program holisticallyWe are utilizing machine learning in an effort to intelligently engage our rewards program members in a more personalized and effective wayIn its current state this program services over 6 million users and is present in nearly 25,000 medical offices/spas in the u.sWe’re looking for a lead bi engineer who is interested in working within a startup oriented environment while having the backing of a large companyIf that’s you, please read on.
You will:
Lead bi engineering (bie) team in adoption of best practices in reporting, analyses, data integrity, test design, validation, and documentation
Work with stakeholders to understand our business strategy, translate that strategy into a vision for bi and data warehousing, and proactively define and execute on a plan to achieve that vision
Be a player-coach - build and maintain a well-designed data warehouse that enables the data teams to support adl with high impact dashboards and data visualizations as well as ad-hoc reporting, analyses, and data processing needs
Lead and mentor team members through sprints, design sessions and code reviews
Ability to support the creation of a single source of truth for various data analyses leveraging agreed upon data definitions, and creating a common data foundation and semantic layers to be consumed by business
Represent bie team in collaboration and partnership with other functions within adl (i.eDigital marketing, product engineering, etc.) as well as departments external to adl (i.eBrand teams, finance, etc.)
Own the design, development, and maintenance of multiple scalable bi and data solutions supporting internal/external global stakeholders
Coordinate bie project prioritization with stakeholders, data engineering, data science, and data analytics teams, managing and executing competing priorities from end to end within defined timelines
Develop agile feedback loop mechanisms supporting the evaluation of new initiatives, measuring process effectiveness and providing recommendations for improved end state
Qualifications
Bachelor’s degree in computer science, engineering, math, finance, statistics or related discipline.
5+ years in relevant experience as a business intelligence engineer, full stack business intelligence analyst, data scientist, data engineer, or equivalent.
5+ years of experience with advanced sql (query optimization, data processing (etl/elt) and analytical functions)
5+ years of experience with schema design and dimensional data modeling.
Advanced experience using modern business intelligence reporting tools (tableau, looker, microstrategy, quicksight, etc.)
Ability to communicate effectively (verbally/written) with technical and non-technical stakeholders at various levels, from operational roles to executive leadership.
Demonstrated ability to navigate ambiguous requests and manage multiple competing priorities, prioritizing effectively and independently in a fast-paced environment.
Experience with scripting languages (r or python) supporting automation, data manipulation and basic mathematical computations.
Experience with mpp databases (snowflake, redshift, bigquery, etc)
Experience implementing data quality, data security and data privacy in a data warehouse.
Preferred:
Advanced degree in computer science, engineering, math, finance, statistics or related discipline is a plus.
Experience with building or using in-house elt tool/framework in a git based environment.
Experience with aws (or equivalent public cloud) using lambda functions and step functions.
Knowledge of digital marketing for consumer facing products.
2+ years of experience leading 2+ team members in business intelligence or data engineering
Significant work activities
Continuous sitting for prolonged periods (more than 2 consecutive hours in an 8 hour day)
Travel
No
Job type
Experienced
Schedule
Full-time
Job level code
Ic
About abbvie
Abbvie’s mission is to discover and deliver innovative medicines that solve serious health issues today and address the medical challenges of tomorrowWe strive to have a remarkable impact on people’s lives across several key therapeutic areas: immunology, oncology, neuroscience, eye care, virology, women’s health and gastroenterology, in addition to products and services across its allergan aesthetics portfolioFor more information about abbvie, please visit us at www.abbvie.comFollow @abbvie on twitter, facebook, instagram, youtube and linkedin.
Equal employment opportunity
At abbvie, we value bringing together individuals from diverse backgrounds to develop new and innovative solutions for patientsAs an equal opportunity employer we do not discriminate on the basis 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, protected veteran status, or any other legally protected characteristic.
