Business Systems Analyst

Sunnyvale, California
Jul 10, 2021
Required Education
Bachelors Degree
Position Type
Full time
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 Follow @abbvie on Twitter, Facebook, Instagram, YouTube and LinkedIn.


  • Point of contact for IT with the business; Liaisons between IT and the business and resolves client and IT relationship issues.
  • Manages and provides advice on, the selection, design, justification, implementation, and business use of information systems.
  • Applies technical expertise to EDW and MDM systems and has substantial knowledge in Oracle & SQL server databases and substantial knowledge in building ETL and MDM processes using Informatica PowerCenter, Python, AWS EMR, AWS Glue and all related ETL & AWS technologies.
  • Analyzes business processes; elicits, analyzes, and documents business requirements; identifies alternative solutions, assesses feasibility, and makes recommendations typically seeking to exploit and leverage new or existing technology components.
  • Translates business requirements into functional requirements; performs data and process modeling; manages change; and leads, coordinates / performs testing, verification, and validation of requirements.

Major Requirements: - Core Responsibilities

  • Responsible for compliance with applicable Corporate and Divisional Policies and procedures.
  • Elicits and communicates the organization’s business strategy execution; works directly with business unit clients to understand specific business processes and needs and opportunities for improvement.
  • Identifies IT capabilities and information required to support the business processes and collaborates in the development of appropriate information management strategies, developing them as an integrated part of the business strategy execution.
  • Develops technology strategies that meet the requirements of the business. Ensures compliance between business initiatives and technology directions.
  • Prepare testing plans to confirm that requirements and system design are accurate and complete in addition to conducting trainings. Ensures there is a traceability from requirements to functionality.
  • Applies deep understanding of ETL mappings in Informatica, AWS Glue, Python scripting and documents all the business rules applied in ETL logic to ensure the development is in-line with Functional/Technical specification documents or any other requirements documentation.
  • Identify process disconnects and translate them into improvement opportunities with cost savings or avoidance, productivity improvements, or revenue generating business benefits.
  • Develops business relationships and integrates activities with other IT areas to ensure successful implementation and support of project efforts.
  • Analyzes departmental processes and needs and makes recommendations that are most effective means to satisfy those needs.
  • Analyses the most complex work procedures and job methods and presents concepts to simplify those procedures.
  • Accountable for the accuracy of the fit of the proposed solution to the business needs and the information upon which the business justification and prioritization decisions are made.
  • Also accountable for communicating the business need and drivers to development groups to assure the implementation phase can fulfill the business need. Exercises considerable latitude in determining objectives of assignment.
  • Accountable for actions and decisions taken by self and subordinates as applicable.



  • Bachelor’s degree with 6 years of experience or Masters with 5 years of experience
  • Extensive experience in Business System Analyst & Data analyst roles with excellent Pharma domain knowledge.
  • Extensive Project Management Experience with ETL development and Quality assurance acumen to verify the functionality against business requirements and to perform any code/design reviews.
  • Excellent SQL skills to query database to perform data analysis to further enhance business analysis.
  • Excellent understanding of Data management and Analytics technology stacks and latest trends.
  • Thorough understanding of Data integration with downstream systems like CRM and any other 3rd party software.

Significant Work Activities
Continuous sitting for prolonged periods (more than 2 consecutive hours in an 8 hour day)
Job Type
Job Level Code
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.