Senior Business Intelligence Engineer (Req ID 2202710)

Irvine, CA
Personalization & Analytics
Full-time
Apply

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.

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


Required Experience & Skills

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

Core Values

  • Be Humble: You're smart yet always interested in learning from others.
  • Work Transparently: You always deal in an honest, direct, and transparent way.
  • Take Ownership: You embrace responsibility and find joy in having the answers.
  • Learn More: Through blog posts, newsletters, podcasts, video tutorials, and meetups, you regularly self-educate and improve your skill set.
  • Show Gratitude: You show appreciation and return kindness to those you work with.

Perks

  • Competitive salary.
  • Competitive annual bonus targets.
  • 401k with dollar-for-dollar match, up to 6% of eligible earnings (base, bonus).  Plus, additional company contribution.
  • RSU grants (Long Term Incentives) for approved roles.
  • Comprehensive medical, dental, vision and life insurance.
  • 17 paid holidays per year, including 3 floating holidays.
  • Annual Paid Time Off (PTO), with separate sick days
  • 12 weeks paid Parental Leave
  • Caregiver Leave
  • Adoption and Surrogacy Assistance Plan
  • Flexible workplace accommodations.
  • Free gym membership for those in our Irvine, CA WeWork office.
  • We celebrate our wins with opportunities to attend Lakers, Knicks, Anaheim Ducks, Anaheim Angels and NY Rangers games.
  • Opportunities to attend concerts, festivals and other live entertainment events in recognition of delivering great work.
  • Attend AWS Re:Invent in person (Las Vegas) or virtually each year.
  • Tuition reimbursement.
  • Attend a tech or marketing conference of your choice each year.
  • A MacBook Pro and accompanying hardware to do great work.
  • A modern productivity toolset to get work done: Slack, Miro, Loom, Lucid, Google Docs, Atlassian and more.
  • Generous discounts on SkinMedica skin care products.
  • Discounted aesthetic treatment days multiple times a year.
  • $600 worth of Alle benefits per year to use towards aesthetic treatments & products.
  • Eligible for donation matching to over 1.5 million nonprofit organizations.
Apply for this job

Driving 

change

 through 

technology