Data Warehouse Architect

2 weeks ago


Chicago, United States Avance Consulting Full time
Job DescriptionJob Description

We need a Senior DW Architect who can guide the impact analysis and the solutioning

Relevant Experience: 11-12 years

We are looking for a solid Data Warehouse architect with the following experience:-

1) Experience with Star Schema dimensional modeling

2) Experience with Data Warehouse ETL Architecture

3) Experience with Semantic Layer modeling

4) Experience with Informatica IICS for ETL

5) Experience with SAP BO for reporting. Including Universe building.

6) Nice to have and not a must. Someone with Time dimension refactoring for Data Warehouse.

7) Someone who can drive end to end impact analysis, solutioning and refactoring of DW, both from ETL as well as Reporting perspective.

8) Ability to communicate with the business stake holders in business terms.



  • Chicago, United States UScellular Full time

    Senior Data Warehouse Architect-INF001877 Employer : U.S. Cellular Corporation Job Title : Senior Data Warehouse Architect Location : 8410 W. Bryn Mawr Avenue, Chicago, IL 60631 Job Duties : ØDesign a high performing Enterprise Data Warehouse; ØCollaborate with the stakeholders and build solutions. ØParticipate in process improvement...


  • Chicago, United States UScellular Full time

    Job DescriptionAbout This RoleEmployer :       U.S. Cellular Corporation Job Title :        Senior Data Warehouse Architect Location :        8410 W. Bryn Mawr Avenue, Chicago, IL 60631Job Duties: Ø  Design a high performing Enterprise Data Warehouse;Ø  Collaborate with the stakeholders and build solutions. Ø  Participate in process...


  • Chicago, United States UScellular Full time

    About This RoleEmployer :       U.S. Cellular Corporation Job Title :        Senior Data Warehouse Architect Location :        8410 W. Bryn Mawr Avenue, Chicago, IL 60631 Job Duties: Ø  Design a high performing Enterprise Data Warehouse; Ø  Collaborate with the stakeholders and build solutions. Ø  Participate in process improvement...

  • Data Architect

    1 month ago


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

    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 every neighborhood, has access to a world-class learning experience that...


  • Chicago, United States Atlantic Partners Corporation Full time

    A large Asset Management firm is looking for a Data Architect with financial services exp.This person will l design and implement best-in-class data management solutions for metadata, master data and data quality management to enable data analytics capabilities across the Firm. Serving as subject matter expert on Microsoft SQL Server and Azure Data...

  • Senior Data Architect

    1 month ago


    Chicago, United States Atlantic Partners Corporation Full time

    A large Asset Management firm is looking for a Data Architect with financial services exp.This person will l design and implement best-in-class data management solutions for metadata, master data and data quality management to enable data analytics capabilities across the Firm. Serving as subject matter expert on Microsoft SQL Server and Azure Data...


  • Chicago, United States Mavens Guild Full time

    What we would like to see: Ideal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results. Incumbent's responsibilities will include conducting full development lifecycle — requirements, analysis,...


  • Chicago, United States Mavens Guild Full time

    What we would like to see: Ideal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results. Incumbent's responsibilities will include conducting full development lifecycle — requirements, analysis,...


  • Chicago, United States Infinite Computer Solutions Full time

    Job descriptionMSBI Expert having 5+ years of Experience in various data management projects like data migration, data warehousing and Business Intelligence. Must have handled data management project for complete SDLC life cycle 5+ years of Hands on experience in SSIS, SSRS and SSMS. Having very strong SQL Query and SSIS performance optimization skill...

  • Data Architect

    2 weeks ago


    Chicago, United States CyberTec Full time

    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 solution, with multiple data providers and multiple consumers. - Experience with MDM solutions and...


  • Chicago, United States Lorven technologies Full time

    Job DescriptionJob DescriptionJob Title: Healthcare Data Architect/ Data Governance SpecialistLocation: Charlotte, NCDescription: Work with the BA's and Business to understand the requirements Create the source to target mapping that documents the business name, definitions, business and data quality rules, RDM, Source and target and transformation...

  • Architect

    2 days ago


    Chicago, United States Motion Recruitment Full time

    Our client is seeking a motivated Snowflake/AWS Architect.Location: Hybrid role in Chicago/Peoria office (3x days onsite)Duration: 12 Months ContractJob description:Position’s Contributions to Work Group: Actual job title would be a Snowflake/AWS Integration Architect As an architect / Engineer you will lead all stages of software development including...

  • Architect

    2 days ago


    Chicago, United States Motion Recruitment Full time

    Our client is seeking a motivated Snowflake/AWS Architect.Location: Hybrid role in Chicago/Peoria office (3x days onsite)Duration: 12 Months ContractJob description:Position’s Contributions to Work Group: Actual job title would be a Snowflake/AWS Integration Architect As an architect / Engineer you will lead all stages of software development including...


  • Chicago, United States Syntricate Technologies Full time

    Remote role- Market rate Qualifications:Data Warehouse & ETL Developer At least five years of experience in data warehousing development, implementation, and support. Strong SQL analysis skills and experience in database tuning and optimization. Experience two years experience with data modeling. At least three years of experience in Oracle Data Integrator...

  • Data Architect

    7 days ago


    Chicago, United States ActiveCampaign Full time

    We are seeking an experienced Data Architect to guide the design, modeling, and implementation of our customer data platform. As a Data Architect, you can translate business requirements into data management and technology requirements, strategy, principles, and architectures. In this role you will play a pivotal role in implementing scalable and performant...


  • Chicago, United States Ask Staffing Full time

    Pay Range - $72 to $76 Location: 6045 S. Kenwood Avenue, Chicago, IL 60637 (This is a Hybrid role with 2 days in office) Data Warehouse Developer Requirements: • At least 7 years of experience in data warehousing development, implementation, and support. • Strong SQL analysis skills and experience in database tuning and optimization. •...

  • Cloud Data Architect

    2 weeks ago


    Chicago, United States Tekfortune Inc Full time

    Role: Cloud Data Architect Job Location: Chicago, IL Mandatory required skills Strong Data Background Job Description ¿ Responsible for ensuring that the data management and governance frameworks are in place and adhered to ¿ Responsible for Architecting, designing and building out the AWS services ¿ Responsible for guiding and resolving issues with AWS...


  • Chicago, United States Inizio Partners Full time

    About the job Data & BI Solution Architect OUR CLIENT Our client provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting-edge analytics techniques, and a consultative approach. Leveraging proprietary methodology and best-of-breed technology, our client's analytics team takes an industry-specific approach...


  • Chicago, United States Inizio Partners Full time

    About the job Data & BI Solution Architect OUR CLIENT Our client provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting-edge analytics techniques, and a consultative approach. Leveraging proprietary methodology and best-of-breed technology, our client's analytics team takes an industry-specific approach...


  • chicago, United States United Airlines Full time

    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. And we’re growing – in the years ahead, we’ll hire tens of thousands of people across every area of the airline. Our careers include a competitive benefits package aimed at keeping you happy, healthy and...