Sr. Engineer Technology-Data & Integration

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. 

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.

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, Matillion etc.; (ii) 6 years with advanced SQL (query optimization, data processing (ETL/ELT) and analytical functions; (iii) 3 years of UNIX experience, including scripting; and (iv) experience in:

• • designing and implementing end to end ETL architecture for business use cases;
  • requirements gathering and writing functional specification for Data Integration and Extract, Transform & Load (ETL) processes;
  • developing and preparing use cases, functional specifications, mapping documents for data integration and technical requirements;
  • with MPP databases (Snowflake, Redshift, Bigquery, etc.);
  • working with cross-functional team; and
  • In data analysis and data audits.

Experience may be gained concurrently.

Salary Range: $197,995 - $202,500.00 per year.

Apply online at https://careers.abbvie.com/en send resume to [email protected]. Refer to Req ID: REF41149C. 

----------------------------------------------------------------------------

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 and long-term incentive programs.

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

AbbVie is an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives and serving our community.  Equal Opportunity Employer/Veterans/Disabled. 

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