Data Analyst

1 month ago


Mettawa Illinois, United States AbbVie Full time
Job Description

Key Responsibilities

 

Responsible for compliance with applicable Corporate and Divisional Policies and procedures.

Manage multiple projects and write Business Requirements Documents (BRDs) and technical design Documents (TRDs).

Use appropriate tools to collect, correlate and analyze data.

Record and maintain technical data for use in developing operating and instruction manuals.

Develop simple to complex ETL mappings in Informatica and document all business rules applied in ETL logic to ensure the development is in-line with Functional/Technical specification documents or any other requirements documentation.

Utilize AWS services to implement end to end data pipelines to derive insights.

Utilize Informatica MDM hub (Siperian) on 9.x and 10.x versions to make any design & architecture changes including configuring & fine-tuning fuzzy logic Informatica MDM to meet the changing business needs and implementing new processes & projects.

Conduct data warehouse/BI/Analytics/ETL applications development and testing using ETL tools like Informatica Powercenter.

Create technical documentations such as technical specification documents, technical design documents, Data flow diagrams, process diagrams and process illustrations.

Implement batch and continuous data ingestion pipelines using AWS SQS and Python connectors.

Collaborate with various departments, architects, project managers and technical managers to provide estimates, develop overall implementation solution plan and serve as a lead to implement solutions.

Implement concepts such as Streams, Tasks, Clustering, Data purge, semistructured (XML, JSON) and unstructured data handling and streaming data loads.

Assist in the development of standards and procedures.

Apply and execute standard information systems theories, concepts, and techniques.

Utilize Analysis, Design, Development, Testing, Data Analysis, Data Governance, Reporting, Impact Analysis, Applications Maintenance and cloud technologies.

Identifies the business benefits of alternative strategies.

Ensures compliance between business strategies and technology directions.

May prepare testing plans to confirm that requirements and system design are accurate and complete and user conduct trainings.

Identify process disconnects and translate them into improvement opportunities with cost savings or avoidance, productivity improvements, or revenue generating business benefits.

Develop business relationships and integrate activities with other IT areas to ensure successful implementation and support of project efforts.

Write SQL queries to analyze the data thoroughly and present results of analysis to larger group.

Perform complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshooting.

Analyze departmental processes and needs and make recommendations that are most effective means to satisfy those needs.

Develop data ingestion, data processing and raw data pipelines for different data sources to AWS.

Partner effectively with all teams to ensure all business requirements and SLAs are met, and data quality is maintained.

Communicate business needs and drivers to development groups to assure the implementation phase can fulfill the business need.

Establish organizational objectives and delegates assignments.



  • Mettawa, United States AbbVie Full time

    Job DescriptionJob DescriptionCompany DescriptionAbbVie'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...


  • Mettawa, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, United States AbbVie, Inc Full time

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


  • Mettawa, United States AbbVie Full time

    Job DescriptionJob DescriptionCompany DescriptionAbbVie'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...


  • Mettawa, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, United States AbbVie Full time

    Job DescriptionJob DescriptionCompany DescriptionAbbVie'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...


  • Mettawa, United States AbbVie Full time

    Job DescriptionJob DescriptionCompany DescriptionAbbVie'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...


  • Mettawa, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, United States AbbVie Full time

    Job DescriptionThe Marketing Analytics and Business Insights (MABI) team supporting AbbVie’s US Commercial organization is 200+ members strong and growing every day. We comprise highly respected researchers, analysts, and strategists striving to be the gold standard Research & Analytics organization within the biopharmaceutical industry. We serve as...


  • Mettawa, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, United States AbbVie Full time

    Job DescriptionJob DescriptionCompany DescriptionAbbVie'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...


  • Mettawa, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie'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...


  • Mettawa, United States AbbVie Full time

    Job DescriptionJob DescriptionCompany DescriptionAbbVie'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...