Skip to main content

This job has expired

You will need to login before you can apply for a job.

Senior Data Engineer - Commercial Data

Lake County, Illinois
Start date
Feb 16, 2024

Job Details

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 oversee and ensure the successful completion of business and project cut-over activities.

In this role you will be responsible for:

  • Collaborate with CDM (Commercial Data Management) 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.
  • Review data models for development projects and assist team members in understanding and adhering to established standards.
  • Coordinate and submit ServiceNow requests for new database accounts, permissions, and collaborate with DBAs for approval.
  • 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.
  • Manage and approve system access and conduct regular recertification exercises to maintain system and data security.
  • Review effort estimates for all activities including analysis, documentation, development, testing, bug fixing, deployment, and support.

Tools and skills you will use in this role:

  • Snowflake
  • Informatica Intelligent Cloud Services (IICS)
  • Power BI, Qlik
  • Unix/Linux Scripting Skills
  • Erwin Data Modeler
  • Python, R


Experiences that make you a strong fit for this role: 


  • Bachelor’s Degree with 6 years’ experience; Master’s Degree with 5 years’ experience; PhD with 0 years’ experience OR equivalent work 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 NoSQL.
  • Experience interpreting data analytic outputs and performing data audits using visualization reports or dashboards such as Qlik, Tableau, Power BI, etc.
  • Experience using one of the Data Modeling tools such as Erwin Data Modeler, DbVisualizer, Lucidchart, etc.
  • Experience working in Unix/Linux environments.
  • Experience handling IQVIA (WxDM, DDD), SHA & Specialty Pharmacy healthcare data.
  • Knowledge in Python or R with at least one Data science and Machine learning framework like PyTorch, TensorFlow, Scikit-Learn is a plus.
  • Ability to gather requirements and develop and prepare use cases, functional specifications, mapping documents for data integration, and technical requirements for data warehouse applications.
  • Ability to work with IT and business teams to coordinate multiple IT projects in the sales planning area.
  • Strong written and verbal communication skills. 


  • Project Management skills
  • Strong understanding of the pharmaceutical industry and related data
  • Experience working with Life Sciences Sales Planning and Sales Operations Teams.


If you believe you’re a great fit for this job but don’t have all of the experiences listed above, we encourage you to apply anyway!


Why Business Technology Solutions

For anyone who wants to use technology and data to make a difference in people’s lives, shape the digital transformation of a leading biopharmaceutical company, and secure sustainable career growth within a diverse, global team: we’re ready for you.

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

Stock Symbol: ABBV

Stock Exchange: NYSE

Company info
1 North Waukegan Road
North Chicago

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert