Sr. Engineer Technology-Data & Integration

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 www.abbvie.com. Follow @abbvie on Twitter, Facebook, Instagram, YouTube and LinkedIn. 

Job Description

Key Responsibilities

• Working directly with business and technology teams to support the data integration & ETL efforts across critical business processes and various IT system;
• Implementing integration solutions for projects related to Allergan Aesthetics Moxie (Customer Relationship Management), Snowflake data warehouse, MDM (Master Data Management), Salesforce Marketing Cloud, Salesforce Commerce Cloud and other commercial applications;
• Technical lead for US CoolSculpting Rewards loyalty program and its integration with other commercial systems;
• Produce recommendations and insights for stakeholders that will help shape effective analytic and data strategies;
• Recognize and adopt best practices in reporting, analysis, ETL, data integrity, test automation, data quality validation, and documentation;
• Build and maintain SQL scripts and complex queries for data analysis and extraction.
• Design, engineer, and implement enterprise-level data, data migration and ETL solutions.
• Conceive, design, engineer, and implement architectural solutions by studying information needs;
• Conferring with users;
• Studying systems ow, data usage, and work processes;
• Investigate problems and resolve key project hurdles and assumptions by effectively utilizing available information and technical expertise.

Qualifications

Education & Experience

Must possess a Bachelor’s degree in Computer Science, Engineering, Math, Finance, Statistics, or related discipline, and 7 years of experience as an ETL developer/engineer. Of the experience required, must have: (i) 6 years with ETL tools like Informatica PowerCenter, Informatica Cloud, Matillio