About AbbVie AbbVie’s mission is to discover and deliver innovative medicines 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, eye care, virology, women’s health and gastroenterology, in addition to products and services across its Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on Twitter, Facebook, Instagram, YouTube and LinkedIn. Summary Senior Engineer will be a technical point of contact for US Allergan Aesthetics BTS (IT) and will work directly with business and technology teams to support the data integration & ETL efforts across critical business processes and various IT systems. This position requires a deep knowledge of ETL, data warehouse design and modelling concepts and must have hands on experience in technical and architectural design and advanced knowledge of databases. Responsibilities Implement 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. Coordinate with vendor teams to ensure project needs are addressed and effectively assign tasks and deliverables to team members based upon their abilities. Understand and adhere to corporate standards regarding applicable Corporate and Divisional Policies, including code of conduct, safety, GxP compliance, data security, and the software development lifecycle. Qualifications Qualifications Bachelor’s degree in Computer Science, Engineering, Math, Finance, Statistics, or related discipline. 8+ years of experience as an ETL developer/engineer and 6+ years of experience with ETL tools like Informatica PowerCenter, Informatica Cloud, Matillion etc. 6+ years of experience with advanced SQL (query optimization, data processing (ETL/ELT) and analytical functions. 3+ years of UNIX experience, including scripting Experience in designing and implementing end to end ETL architecture for business use cases. Experience in requirements gathering and writing functional specification for Data Integration and Extract, Transform & Load (ETL) processes Ability to develop and prepare use cases, functional specifications, mapping documents for data integration and technical requirements. Experience with MPP databases (Snowflake, Redshift, Bigquery, etc) Experience working with cross-functional team. Experience in data analysis and data audits Demonstrated ability to navigate ambiguous requests and manage multiple competing priorities, prioritizing effectively and independently in a fast-paced environment. Ability to communicate effectively (verbally/written) with technical and non-technical stakeholders at all levels. Preferred 3 years of experience in Agile environment and experience with JIRA. Experience with data catalog tools such as Alation and Collibra. Experience using modern business intelligence reporting tools (Tableau, PowerBI, ThoughtSpot etc.) Experience using advanced analytics such as Alteryx and Dataiku Significant Work Activities Continuous sitting for prolonged periods (more than 2 consecutive hours in an 8 hour day) Travel Yes, 5 % of the Time Job Type Experienced Schedule Full-time Job Level Code IC Equal Employment Opportunity At AbbVie, we value bringing together individuals from diverse backgrounds to develop new and innovative solutions for patients. As 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.