Jobs
>
Chicago

    Data Architect - Chicago, United States - Allergan

    Allergan
    Allergan Chicago, United States

    2 weeks ago

    Default job background
    Description

    Area of Interest:
    Administrative Services


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

    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.

    #J-18808-Ljbffr
  • TD Synnex - SHI for Chicago Public Schools (Central Office)

    Data Architect

    1 week ago

    TD Synnex - SHI for Chicago Public Schools (Central Office) Chicago, United States

    Chicago Public Schools (CPS) is one of the largest school districts in the United States, serving over 320,000 students in 600+ schools and employing approximately 40,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and ...

  • Fanisko

    Data Architect

    1 day ago

    Fanisko Chicago, United States

    **Job Type**: · Contract · **Experience**: · 4 to 8 years · **Location**: · US · **Key Responsibilities**: · - Design and implement robust database architectures using MongoDB and SQL, ensuring scalability, reliability, and performance. · - Implement data governance policies and ...

  • United Airlines

    Principal Data Architect

    1 day ago

    United Airlines Chicago, United States

    **Description**: · There's never been a more exciting time to join United Airlines. We're on a path towards becoming the best airline in the history of aviation. Our shared purpose - Connecting People, Uniting the World - is about more than getting people from one place to anothe ...

  • Laiba Technologies

    Cloud Data Architect

    1 week ago

    Laiba Technologies Chicago, United States

    **Position: Cloud Data Architect** · **Location: Chicago, IL** · - 15+ years of experience · - Certifications ( AWS / Snowflake / Datawarehouse) · - Datawarehouse Architecture / Concepts · - Data Modelling Concepts & Architecture · - Data Structure & Architecture · - DB Experienc ...

  • Neocol

    Data Migration Architect

    4 hours ago

    Neocol Chicago, United States

    **Why Neocol?** · Neocol helps the world's most innovative subscription companies solve their most pressing initiatives to ignite outpaced subscription performance. As the largest pure-play Salesforce Summit Partner specifically dedicated to the subscription economy, Neocol has c ...

  • DataDelivers LLC

    Data Architect

    4 hours ago

    DataDelivers LLC Schaumburg, United States

    **Big Data and Product Architect** · **Product Strategy & Technology Team** · The Big Data and Product Architect at DataDelivers is a strategic and highly visible role responsible for designing and implementing solutions for the integration and ingestion of data into the company' ...

  • IT Associates

    Data Architect

    2 weeks ago

    IT Associates Chicago, United States

    Cloud Data Architect ( Data Migration to Azure / Cloud Data Solution Architecture) · Direct Hire OR Fulltime with Full Benefits and Bonus · Hybrid 2-3 days in office in Ann Arbor, MI · Multi-Million Dollar E-commerce client · As a Cloud Data Solutions Architect focused on Data ...

  • LTIMindtree

    Data Architect

    1 week ago

    LTIMindtree Chicago, United States

    About Us: · LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to m ...

  • The LaSalle Group

    Data Architect

    1 week ago

    The LaSalle Group Chicago, United States

    We are seeking a highly skilled and motivated Data Architect with hands-on experience in Microsoft Azure to join our client's dynamic team. As a Data Architect, you will play a critical role in designing, implementing, and managing our data architecture, ensuring reliability, sca ...

  • CyberTec

    Data Architect

    1 week ago

    CyberTec Chicago, United States

    Job Title : Data Architect- · Location: Chicago , IL Must live in Chicago and go downtown · Job Type : 75% onsite · Duration : 12 months · Opening : 1 Opening · Must have: - Data +Application Architect for MDM solution. · - Design a Unique Guest ID real-time integration solu ...

  • Keylent Inc

    Data Architect

    1 week ago

    Keylent Inc Chicago, United States

    This is old requirement · COGNIZANT / Client / Onsite · We have the following 3 positions to be filled immediately. Please make sure to submit QUALITY resumes and who are available Local / Ready to Relocate. Check with consultants if they have submitted earlier. · Location - C ...

  • TechWish

    Data Architect

    1 week ago

    TechWish Chicago, United States

    Data Architect · Must be local to Chicago · very strong skills with Snowflake · ****MUST HAVE VERY STRONG SNOWFLAKE · Work on a Snowflake DW design and implementation. · Design and deploy services to AWS using Terraform and Cloud formation stack. · Design CICD pipelines for ap ...

  • Analytic Recruiting Inc.

    Data Architect

    1 week ago

    Analytic Recruiting Inc. Chicago, United States

    A leading Supermarket chain are seeking an AI Architect/Director to enable AI capabilities across their business through apps & services. The role will support creating personalized experiences for shoppers and using cutting-edge analytics and first-party retail data from million ...

  • 66degrees

    Data Architect

    2 weeks ago

    66degrees Chicago, United States

    Overview of 66degrees · 66degrees is a leading consulting and professional services company specializing in developing AI-focused, data-led solutions leveraging the latest advancements in cloud technology. With our unmatched engineering capabilities and vast industry experience, ...

  • HUB International

    Data Architect

    1 week ago

    HUB International Chicago, United States

    At HUB International, we are a team of entrepreneurs. We believe in empowering our clients, and we do so by protecting businesses and individuals in our local communities. We help businesses evaluate their risks and develop solutions tailored to their needs. We believe in empower ...

  • Ztek Consulting

    Data Architect

    2 weeks ago

    Ztek Consulting Chicago, United States

    Job Role : · Data Architect (Snowflake & Azure) · Location : · Chicago, IL (Day 1 Onsite) · Mode of interview : · Skype, Video/Telephonic · Job Roles/Responsibilities: · Data Integration and Synchronization: · Design efficient data synchronization processes between on-prem ...

  • Diverse Lynx

    Data Architect

    2 weeks ago

    Diverse Lynx Chicago, United States

    Role: Data Architect · Position Type: Contract · Contract Duration: 6+ months with possibility of extension · Work Location: Chicago, IL ( Hybrid, onsite from day one) · Primary Skills: AWS, Python, Spark, KAFKA · Job Description: Strong expertise in Datawarehouse/data architec ...

  • V2soft

    Data Architect

    1 week ago

    V2soft Chicago, United States

    V2Soft ( ) is a global company, headquartered out of Bloomfield Hills, Michigan, with locations in Mexico, Italy, India, China, and Germany. At V2Soft, our mission is to provide high-performance technology solutions to solve real business problems. We become our customer's true ...

  • LTIMindtree

    Data Architect

    1 week ago

    LTIMindtree Chicago, United States

    About Us: · LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to m ...

  • NextRow

    Data Architect

    1 week ago

    NextRow Chicago, United States

    Job Description · NextRow is You must be a problem solver who looks to elevate the work of everyone around them. · - Provides expert guidance to projects to ensure that their processes and deliverables align with the Client target state architecture. · - Defines & develops ent ...