Data Architect

3 weeks ago


Chicago, United States Ztek Consulting Full time

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-premises Oracle databases and Snowflake using Kafka and CDC extraction tools.
  • Platform Migration:
  • Lead the strategic planning and execution of migrating existing in-house data platforms to cloud, ensuring minimal disruption and data integrity.
  • Data Modeling for Snowflake and Databricks:
  • Develop efficient data models for cloud database to facilitate scalable data storage, processing, and analytics.
  • Data Pipeline Development:
  • Architect and implement data pipelines using Airflow and Python.
  • Analytics and Reporting:
  • Utilize Snowflake and Databricks for advanced reporting and analytics, providing actionable business insights.
  • Collaboration and Innovation:
  • Work with cross-functional teams to understand data needs and deliver technical solutions, mentoring on best practices.
  • Data Architecture: Demonstrated experience in migrating on-premises data to cloud and setting up stable, scalable frameworks
  • Databases: Proficiency in Oracle, Snowflake, and Databricks.
  • Data Integration: Experience with Kafka and CDC tools (like Debezium connector) for real-time data synchronization.
  • ETL Tools: Expertise in Airflow for data pipeline orchestration.
  • Programming: Advanced proficiency in Python for data processing and automation.
  • Data Modeling: Strong understanding of data modeling techniques and experience in designing scalable data models for cloud data warehouses.
  • Reporting Tools: Familiarity with BI tools and technologies for creating reports and dashboards.
  • Cloud Platforms: Knowledge of cloud infrastructure and services, preferably Azure, as it relates to Snowflake and Databricks integration.
  • Project Management: Experience in leading large-scale data migration and platform integration projects.
  • Communication: Excellent verbal and written communication skills for effective collaboration across teams. Strong analytical, problem-solving, and team management skills


  • Data Architect

    1 day ago


    Chicago, United States AgnesCole Consulting Full time

    Data ArchitectA globally recognised client of our is looking for a Data architect to join their team. The Architect will be an experienced professional with exceptional leadership skills and a robust background in data architecture to drive the development of a self-sustainable BI platformThis is an excellent opportunity to make your mark on a globally...

  • Data Architect

    2 days ago


    Chicago, United States AgnesCole Consulting Full time

    Data ArchitectA globally recognised client of our is looking for a Data architect to join their team. The Architect will be an experienced professional with exceptional leadership skills and a robust background in data architecture to drive the development of a self-sustainable BI platformThis is an excellent opportunity to make your mark on a globally...

  • Data Architect

    2 days ago


    Chicago, United States AgnesCole Consulting Full time

    Data ArchitectA globally recognised client of our is looking for a Data architect to join their team. The Architect will be an experienced professional with exceptional leadership skills and a robust background in data architecture to drive the development of a self-sustainable BI platformThis is an excellent opportunity to make your mark on a globally...

  • Data Architect

    15 hours ago


    Chicago, United States Request Technology, LLC Full time

    NO SPONSORSHIPPrincipal, Data ArchitectureSALARY: $196k - $200k plus 27% bonusLOCATION: Chicago, IL Hybrid 3 days in office and 2 days remote Looking for a candidate that does data architecture and design. Datalakes, data warehouse solutions. schema designs relational nonrelational data messaging design of data science data analytics Kafka and protocol...

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

  • Data Modeler

    4 weeks ago


    Chicago, Illinois, United States Cogent Data Solutions LLC Full time

    Job Description We are looking for a Data Modeler who will interact with data architects; database administrators; business analysts; product owners; report and application development teams; and data governance / data quality teams supporting a variety of modeling needs. If you are looking for a role developing and implementing data models we would love to...

  • Data Modeler

    1 month ago


    Chicago, United States Cogent Data Solutions LLC Full time

    Job Description We are looking for a Data Modeler who will interact with data architects; database administrators; business analysts; product owners; report and application development teams; and data governance / data quality teams supporting a variety of modeling needs. If you are looking for a role developing and implementing data models we would love to...


  • Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas.The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...


  • Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas.The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...


  • Chicago, United States Selby Jennings Full time

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas.The Principal, Data Architecture will have the following responsibilities: Design the data architecture of organization to support data driven...

  • Data Modeler

    1 week ago


    Chicago, Illinois, United States Cogent Data Solutions LLC Full time

    Job Description We are looking for a Data Modeler who will interact with data architects; database administrators; business analysts; product owners; report and application development teams; and data governance / data quality teams supporting a variety of modeling needs. If you are looking for a role developing and implementing data models we would love to...

  • Data Modeler

    1 month ago


    Chicago, United States Cogent Data Solutions LLC Full time

    Job Description We are looking for a Data Modeler who will interact with data architects; database administrators; business analysts; product owners; report and application development teams; and data governance / data quality teams supporting a variety of modeling needs. If you are looking for a role developing and implementing data models we would love...


  • Chicago, United States Avance Consulting Full time

    Job DescriptionJob DescriptionWe need a Senior DW Architect who can guide the impact analysis and the solutioningRelevant Experience: 11-12 yearsWe are looking for a solid Data Warehouse architect with the following experience:-1) Experience with Star Schema dimensional modeling2) Experience with Data Warehouse ETL Architecture3) Experience with Semantic...

  • 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 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 Request Technology, LLC Full time

    Principal, Data ArchitectSalary: Open + BonusLocation: Chicago, IL or Dallas, TXHybrid: 3 days onsite, 2 days remote Qualifications10+ years of related experience leading to Senior Architect level.Experience in design of data lake/warehouse solutions, preferably in the cloud.Experience in schema design for relational and non-relational data and messaging...


  • Chicago, United States Bank of America Full time

    Job Description:At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.One of the keys to driving Responsible Growth is being a great place to work for our...


  • Chicago, Illinois, United States Bank of America Full time

    Job Description:At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.One of the keys to driving Responsible Growth is being a great place to work for our...

  • Data Architect

    1 week ago


    Chicago, IL, 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...