at Pharmacyclics LLC (an AbbVie Inc. company) in Lake Forest, Illinois, United States
Job Description
Data Architect, Pharmacyclics LLC (an AbbVie Inc. company), Mettawa, IL. 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. 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: (i) data warehouse/BI/Analytics/ETL applications development and testing using ETL tools like Informatica Powercenter; (ii) implementing batch and continuous data ingestion pipelines using AWS SQS and Python connectors; (iii) 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; & (vi) 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 & reference REF24643K.