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

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

  • Data Architect

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

  • Data Architect

    4 weeks 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 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 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

    3 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

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

  • Data Modeler

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

  • Data Modeler

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


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


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

  • Data Architect

    1 week ago


    Chicago, United States TechWish Full time

    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 applications and deploy them. Design near real-time data pipelines using Kafka streaming...

  • Senior Data Architect

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

  • Senior Data Architect

    4 weeks 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 Laiba Technologies Full time

    **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 Experience - Snowflake Concepts - AWS Data Lake - ETL/Informatica/ Datastage - AWS Services/...


  • 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 1872 Consulting Full time

    Senior Data Architect - Data Modeling focus Chicago or Dallas - onsite 3 days/week, remote 2 days/week SUMMARY We are seeking a Senior Data Architect, with strong data modeling skills, to improve our current data posture on what is a leading real estate analytics platform. You'll spend a lot of your time developing data models using a variety of canonical...