Skip to main content

Search jobs

Search jobs

About Allergan Aesthetics

At Allergan Aesthetics, an AbbVie company, we develop, manufacture, and market a portfolio of leading aesthetics brands and products. Our aesthetics portfolio includes facial injectables, body contouring, plastics, skin care, and more. Our goal is to consistently provide our customers with innovation, education, exceptional service, and a commitment to excellence, all with a personal touch. For more information, visit www.AllerganAesthetics.com.

Senior Business Intelligence Engineer

Irvine, California Req ID 2202710 Category Marketing Division Allergan Aesthetics

Allergan Data Labs is on a mission to transform the Allergan Aesthetics business at AbbVie, the fourth pharmaceutical company in the world. Allergan Aesthetics brands include Botox, CoolSculpting, Juvéderm and more. The medical aesthetics business is ripe for disruption and we’re building a high performing team to do just that.

Our leadership has a fresh and innovative vision for how the company should approach digital marketing and analytics.  We’re looking for a strong, technically sound Sr. Business Intelligence Engineer who is interested in working within a startup-oriented environment while having the backing of a large company. If that’s you, please read on.

You Will:

  • Work with business requirements to identify and understand source data systems; provide resolutions to all data issues and coordinate with data analyst to validate all requirements
  • Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications using SQL
  • Design, develop, and debug new business intelligence tools to solve complex engineering challenges in a dynamic environment
  • Adapt ETL processes to accommodate changes in source systems and new business user requirements
  • Provide application analysis and data modeling design to collect data for centralized data warehouse
  • Ensure high levels of Business Intelligence availability through support functions and in-depth testing
  • Accountable for properly following all standards, processes and methodologies as applicable including but not limited to Quality Assurance (QA)
  • Collaborates with customers and stakeholders both within and beyond ADL
  • Act as a champion in the business to promote best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation
Qualifications:

Qualifications:

  • Four-year college degree in computer science or data engineering; or commensurate work experience
  • 3+ years’ experience using Snowflake (or SQL tool equivalent) and knowledge of AWS Infrastructure
  • Expertise in SQL and relational databases
  • Expertise in ETL and/or other data manipulation languages such as Python, SAS and R
  • Strong communication (verbal and written) and interpersonal skills to translate key business needs into data infrastructure
  • Creative in finding new solutions and designing innovative methods, systems and processes
  • Experience with connecting data sets to data visualization tools and creating reports using Tableau and Power BI
  • Strong project management and organizational skills, experience working on complex initiatives with cross-functional teams in a dynamic environment
  • Ability to work with a high level of autonomy, and to work productively as cross-functional team

#LI-ADL

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
ABBVIE

Most recent jobs

Sign up for job alerts

Join our talent network and receive AbbVie news and job alerts to your inbox.

Interested InPlease select a category or location option. Click “Add” to create your job alert.

Our Terms of Use, Cookie Policy and Privacy Policy explain how we collect and use information about you and the rights you have. By submitting your information, you acknowledge you have read those documents and consent to receive SMS communications and email jobs alerts from AbbVie.

Recently viewed jobs

You have not viewed any jobs recently.

Phishing scam alert

As an online job seeker, you could be a target of cyber (online) thieves seeking to secure personal information from you by sending you “phishing” messages.

Please be alert to and protect yourself from phishing scams. Find out how you can avoid being a victim of job phishing scams.

For Internal Candidates only - Notice of Filing of Labor Condition Application

Equal Employment Opportunity | Reasonable Accommodation