Data Architect

Libertyville, IL, United States

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 Twitter, Facebook, Instagram, YouTube and LinkedIn.

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.

Qualifications

Must possess a Bachelor’s degree or foreign academic equivalent in Computer Science, Applied Computer Science, Computer Engineering, Information Technology or a highly related field of study with 5 years of related experience.

In the alternative, employer will accept a Master’s degree in the aforementioned fields plus 2 years of related experience.

Each educational alternative with at least two (2) years of experience in the following:

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

implementing batch and continuous data ingestion pipelines using AWS SQS and Python connectors;

Streams, Tasks, Clustering, Data purge, semistructured (XML, JSON) and unstructured data handling and streaming data loads; (iv)

Analysis, Design, Development, Testing, Data Analysis, Data Governance, Reporting, Impact Analysis, Applications Maintenance and cloud technologies; (v)

complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshooting; &

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

Employer will accept any suitable combination of education, training or experience related to the job opportunity.

Apply online at https://careers.abbvie.com/en. Refer to Req ID: REF24643K.

Additional Information

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 and long-term incentive programs.

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.