Data Engineer, Hybrid

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 X, Facebook, Instagram, YouTube, LinkedIn and Tik Tok.

Job Description

The US Commercial Business Technology Solutions is looking for Data Engineer who is responsible for working collaboratively with technology and business groups to conceptualize, design, develop, and implement data, software, and technology solutions that address significant scientific or business challenges. The role will involve researching, identifying, and integrating cutting-edge technology platforms to enhance productivity and efficiency within the team and across various business areas. Furthermore, the Data Engineer will play a role in advancing technology for US Commercial Data Services and Operations. The successful candidate will also be responsible for fostering productive collaborations and effective communication with other groups from diverse disciplines. Additionally, they will be responsible in understanding, analyzing and closing out the business enquiries on the data in a timely manner.

Responsibilities:

• Collaborate with MABI/Field Tools Business clients to gain a deep understanding of their business strategy and tactical priorities, and identify the corresponding data and technology requirements.
• Assess the existing data and technology capabilities within the business unit and other relevant areas of AbbVie. Recommend suitable applications to align with current business priorities.
•  Stay updated on industry trends and emerging technology solutions relevant to the assigned business area.
•  Utilize knowledge of current and emerging solutions to proactively contribute to the business strategy and identify opportunities for improvement. Conduct comprehensive analysis, identify insights, and develop business cases to communicate strategic opportunities to stakeholders.
• Advise business stakeholders on the most appropriate and optimal approaches to achieve their objectives, which may involve technology solutions, process changes, or other options.
• Collaborate with cross-functional teams to develop comprehensive project estimates and timelines by gathering input and feedback from all relevant stakeholders. Engage with IT and business functions to negotiate and secure the necessary resources.
•  Create and maintain system and project documentation, such as change requests, functional requirements, test plans, data migration plans, and cutover plans. Delegate relevant tasks to junior analysts as appropriate.
•  Validate the database design and ensure technical specifications are complete, consistent, concise, and feasible.
• Provide documentation of technical standards and best practices, incorporating contributions from team members.
• Collaborate with project development teams on the SDLC (Software Development Life Cycle) and code promotion process.
•  Review effort estimates for all activities including analysis, documentation, development, testing, bug fixing, deployment, and support.

Qualifications

• Bachelor's Degree with 5 years of experience; Master's Degree with 3 years of experience;  PhD with 2 years of experience.
• Proven experience in designing and implementing a full-scale Data Warehouse/Data Lake solution based on cloud databases such as Snowflake, Azure SQL Database, RedShift, etc.
• Proven experience in designing and implementing data ingestion solutions on IICS (Informatica Intelligent Cloud Services), Snowflake, and/or Azure Data Factory.
• Excellent programming skills in SQL, PL/SQL, and use these skills in day to day Analytics.
• At least 4 years of experience interpreting data analytic outputs and performing data audits using visualization reports or dashboards such as Qlik, Tableau, Power BI, etc.
• Experience handling IQVIA (WxDM, DDD), SHA & Specialty Pharmacy healthcare data.
• Hands on and thorough ability to create ETL mappings, Write SQL queries and be able to deploy the changes through SDLC lifecycle.
• Ability to work with IT and business teams to coordinate multiple IT projects in the sales planning area.
• Strong written and verbal communication skills.

Preferred:

• Good understanding of the Health care industry and related Commercial Sales and Rep Interaction data.
• Good Hands on Experience building ETL Mappings, promote the code through standard SDLC.
• Proven experience in working with multiple business stake holders, convert Functional requirements to Technical requirements, analyze the existing data and solve day to day business enquiries or problems.
• Experience working with Life Sciences Sales Planning and exposure to the Field/Rep facing Tools.

Additional Information

Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law: ​

• The compensation range described below is the range of possible base pay compensation that the Company believes in good faith it will pay for this role at the time of this posting based on the job grade for this position. Individual compensation paid within this range will depend on many factors including geographic location, and we may ultimately pay more or less than the posted range. This range may be modified in the future.​

• 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 incentive programs. ​

Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, incentive, benefits, or any other form of compensation and benefits that are allocable to a particular employee remains in the Company's sole and absolute discretion unless and until paid and may be modified at the Company’s sole and absolute discretion, consistent with applicable law. 

AbbVie is an equal opportunity employer and 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.

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