Data Architect

2 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 prepares each for success in college, career, and civic life. In order to fulfill this mission, we make three commitments to our students, their families, and all Chicagoans: academic progress, financial stability, and integrity. Six core values are embedded within these commitments - student-centered, whole child, equity, academic excellence, community partnership, and continuous learning.

The Office of Information and Technology Services (ITS) works to build the capacity of schools to use information and technology, digital transformation, maintain network infrastructure, security standards, and support other departments to meet district goals. ITS provides innovative technology solutions that improve the quality of education for students, reduce the administrative burden on educators, facilitate parent interaction, increase community engagement, and support CPS’ mission of transparency by focusing on the ease and equity of access to information.

**Job Summary**:
Under the direction of the Data Solutions Manager, the Data Architect will ensure the district’s data architecture is organized, accessible, secure, and meets the needs of business units. This role is responsible for designing warehouses and databases, and defining how data is collected and organized.

**The Data Architect will be held accountable for the following responsibilities**:

- Define and implement the long-term technology strategy and innovations roadmaps across analytics, data engineering, and data platforms
- Create standards, design patterns, and best practices for ETL development in an enterprise data warehouse environment.
- Oversee the expansion of existing data architecture and data query performance optimization.
- Assist with identifying future state architecture (data fabric, active metadata, Data Lake, Data Lakehouse).
- Perform current state data model assessments/target data models and gap analysis.
- Propose new database architecture and support data migration from an existing Legacy system to a new structure
- Create source-to-target mapping documents to transform the source data into the target warehouse and test final transformations.
- Maintain and create extensions to ODS.
- Assist in designing the data warehouse and ensure that data is stored and maintained in consistent formats.
- Counsel with Analysts and Subject Matter Experts on specific topics in order to accurately capture existing business rules/principles.
- Establish data modeling naming standards, abbreviations, guidelines, and best practices.
- Develop and maintain conceptual, physical, and logical data models.
- Stay current with the latest technologies and trends.
- Other duties as assigned.

**In order to be successful and achieve the above responsibilities, the Data Architect must possess the following qualifications**:
**Education Required**:

- A bachelor’s degree from an accredited college or university in computer science, data science, engineering, or related field, required.
- Master’s degree, preferred.

**Experience Required**:

- Minimum of seven (7) years of technology delivery experience with at least five (5) years focus in database system architecture and design including the following is required:

- Experience producing high-quality Solution architecture and design documents.
- Experience leading projects involving data warehousing, data modeling, and data analysis.
- Hands-on experience in performance tuning techniques.
- Experience with API, Web Service implementation (REST, API, SOAP API).
- Experience with Cloud data warehouse technologies (Azure Data Warehouse, Amazon Redshift, Snowflake).
- Experience with business intelligence tools and technologies such as ETL, Power BI, and Tableau.
- 10+ years of the above experience is preferred.

**Knowledge, Skills, and Abilities**:

- Ability to socialize and communicate the technical architecture and design to business and developers.
- Expert level knowledge of T-SQL, Stored Procedures, Data Modeling, Views, and Functions.
- Ability to resolve performance issues.
- Ability to collaborate and excel in complex, cross-functional teams involving data scientists, business analysts, and stakeholders
- Familiarity with latest trends in data engineering and data management (APIs, data virtualization, stream data integration, augmented data integration).
- Familiarity with SQL Server database administration.
- Familiarity with modern ETL integration solutions (SSIS, Ab Initio, Datastage, Informatica, Azure Data Factory).
- Ability to regularly learn and adopt new technology, especially in the AI/ML realm.
- Familiarity with Big Data is pref

  • Data Modeler

    Found in: beBee S US - 2 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

    Found in: beBee jobs US - 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

    Found in: beBee S US - 2 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...

  • Cloud Data Architect

    3 days ago

    Chicago, United States Avance Consulting Full time

    Job DescriptionJob DescriptionJob Title: Cloud Data ArchitectJob ID: 1403568BRPosition Type: TP/CTHLocation: Chicago, ILMandatory Skillset: Sample resume attached , AWS Services (Lambda Functions/ AWS RDS/ AWS Cloud watch/ Data Lake/ AWS EKS / AWS EC2/ AWS S3 Bucket), Data structure, DevOps (CI/CD/Openshift/Kubernetes) , ata structure, DevOps...

  • Cloud Data Architect

    17 hours ago

    Chicago, United States Avance Consulting Full time

    Job DescriptionJob DescriptionJob Title: Cloud Data ArchitectJob ID: 1403568BRPosition Type: TP/CTHLocation: Chicago, ILMandatory Skillset: Sample resume attached , AWS Services (Lambda Functions/ AWS RDS/ AWS Cloud watch/ Data Lake/ AWS EKS / AWS EC2/ AWS S3 Bucket), Data structure, DevOps (CI/CD/Openshift/Kubernetes) , ata structure, DevOps...

  • Senior Data Architect

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

    1 week ago

    Chicago, United States Atlantic Partners 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

    Found in: Appcast Linkedin GBL C2 - 2 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...

  • Cloud Data Solutions Architect

    Found in: Appcast US C2 - 1 week ago

    Chicago, United States IT Associates Full time

    Cloud Data solutions Architect - Azure Length: 12-24 + months.Hybrid 2-3 days in office in Ann Arbor, MIMulti-Million Dollar E-commerce clientAs a Cloud Data Solutions Architect focused on Data Solutions and Data Management, your primary responsibility will be to ensure building a scalable, secure and efficient data platform / Lakehouse with Azure /...

  • Cloud Data Solutions Architect

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    Chicago, United States IT Associates Full time

    Cloud Data solutions Architect - Azure Length: 12-24 + months.Hybrid 2-3 days in office in Ann Arbor, MIMulti-Million Dollar E-commerce clientAs a Cloud Data Solutions Architect focused on Data Solutions and Data Management, your primary responsibility will be to ensure building a scalable, secure and efficient data platform / Lakehouse with Azure /...

  • Data Architect

    2 days ago

    Chicago, United States Diverse Lynx Full time

    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 architecture domain. Strong experience with SQL and a good understanding of database...

  • Data Architect

    2 weeks ago

    Chicago, United States Cloudious LLC Full time

    Job DescriptionJob DescriptionJob Title: Data Architect (Snowflake and Azure)Long Term ContractLocation: Chicago - IL Onsite (3 days in office)Role: Data ArchitectKey Responsibilities: Data Integration and Synchronization: Design efficient data synchronization processes between on-premises Oracle databases and Snowflake using Kafka and CDC extraction tools....

  • Data Architect

    Found in: Talent US C2 - 1 week ago

    Chicago, United States Publicis Sapient Full time

    Job Description Publicis Sapient is looking for a Data Architect to join our team of bright thinkers and doers. You will team with top-notch technologists to enable real business outcomes for our enterprise clients by translating their needs into transformative solutions that provide valuable insight. Working with the latest data technologies in the...

  • Senior Data Warehouse Architect

    Found in: Talent US C2 - 6 days ago

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

  • Data Architect with Snowflake and Azure

    7 days ago

    Chicago, United States Marvica Technologies Full time

    Job DescriptionJob DescriptionHybrid with 3 days a week in Chicago Downtown - IL - Locals preferredData Architect (Snowflake and Azure):Key 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...

  • Data Architect with Snowflake and Azure

    17 hours ago

    Chicago, United States Marvica Technologies Full time

    Job DescriptionJob DescriptionHybrid with 3 days a week in Chicago Downtown - IL - Locals preferredData Architect (Snowflake and Azure):Key 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...

  • Data Architect

    Found in: Appcast US C2 - 5 days 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/TelephonicJob 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...

  • Data Architect

    Found in: Appcast Linkedin GBL C2 - 4 days 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/TelephonicJob 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...

  • Azure Data Platform Architect

    7 days ago

    Chicago, United States CareerBuilder Full time

    Role: Azure Data Platform Architect As an Azure Data Platform Architect at Collectiv, you will be responsible for delivering end-to-end data solutions on the Microsoft Azure cloud platform. You will work closely with our clients to understand their unique business needs and design, develop, and implement data solutions that align with their objectives. You...

  • Senior Data Architect- Hybrid Chicago

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    Chicago, United States UX Hires Full time

    Senior Data ArchitectLocation: Hybrid Chicago Area. Work onsite 3-5 days a week.Our client, a leader in global market access, is looking for a Sr. Data Architect – Team Lead. Their ideal candidate will work with their enterprise architect to develop a program, run as process owner, and build/configure acquire tooling to support the program. Experience with...