Data Architect

2 weeks ago

Salt Lake City, United States Stantec 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. Expertise in BI and data warehousing principles including data modeling, data quality, extract/transform/load process as they apply to data preparation for BI/ Analytic solutions. 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 preferred. Familiarity with K-12 Education is preferred.

Conditions of Employment

As a condition of employment with the Chicago Public Schools (CPS), employees are required to: Establish/Maintain Chicago Residency -

Employees are required to live within the geographic boundaries of the City of Chicago within six months of their CPS hire date and maintain residency throughout their employment with the district. The Chicago residency requirement does not apply to temporary/part-time positions, however, all CPS employees must be residents of Illinois. Be Fully Vaccinated Against COVID-19 -

Unless approved for a medical or religious exemption, all employees are required to be up-to-date on COVID-19 vaccinations, including boosters, and to submit proof of vaccination to the district within 30 days of hire. "Up-to-date" on vaccination is defined as being at least two weeks past all primary vaccine doses and any applicable boosters.

#J-18808-Ljbffr

  • Remote GCP Data Architect Urgent

    4 days ago

    Salt Lake City, United States tekHouse Full time

    100% Remote Contract 1099 or C2C 6 -9 month plus MUST be USC The primary role of the Data Architect is to support and expand the Data & Analytics platforms that process, store, organize the data critical for the data and analytics team. This role will have expertise in data movement and database technologies support data analytics and Machine Learning (ML) /...

  • Data Architect

    1 month ago

    Oklahoma City, United States InterEx Group Full time

    Our client, a specialty insurance company, is in search of a Data Architect. This role will report directly to the Head of Data. It is a permanent opportunity.**US Citizens or Green Card Holders Only - Cannot Provide SponsorshipResponsibilities:Collaborate with stakeholders to understand business requirements and translate them into data architecture...

  • Data Architect

    1 month ago

    Oklahoma City, United States InterEx Group Full time

    Our client, a specialty insurance company, is in search of a Data Architect. This role will report directly to the Head of Data. It is a permanent opportunity. Is your CV ready If so, and you are confident this is the role for you, make sure to apply asap. **US Citizens or Green Card Holders Only - Cannot Provide Sponsorship Responsibilities: Collaborate...

  • Data Architect

    1 month ago

    Oklahoma City, United States InterEx Group Full time

    Our client, a specialty insurance company, is in search of a Data Architect. This role will report directly to the Head of Data. It is a permanent opportunity.**US Citizens or Green Card Holders Only - Cannot Provide SponsorshipResponsibilities:Collaborate with stakeholders to understand business requirements and translate them into data architecture...

  • Data Architect

    1 month ago

    Oklahoma City, United States InterEx Group Full time

    Our client, a specialty insurance company, is in search of a Data Architect. This role will report directly to the Head of Data. It is a permanent opportunity.**US Citizens or Green Card Holders Only - Cannot Provide SponsorshipResponsibilities:Collaborate with stakeholders to understand business requirements and translate them into data architecture...

  • Senior Data Architect

    1 month ago

    Jersey City, United States Artemis Consultants Full time

    As a senior data architect, you will develop and manage data models, guidelines, and techniques. You may also manage the resources of a variety of business analysts to leverage design data analysis and visualization tools, and standardize data models and domains.Common Skillsets:10+ years of experience as Technical Architect/Data ArchitectExpertise in...

  • Senior Data Architect

    1 month ago

    Jersey City, United States Artemis Consultants Full time

    As a senior data architect, you will develop and manage data models, guidelines, and techniques. You may also manage the resources of a variety of business analysts to leverage design data analysis and visualization tools, and standardize data models and domains.Common Skillsets:10+ years of experience as Technical Architect/Data ArchitectExpertise in...

  • Senior Data Architect

    2 months ago

    Jersey City, United States Artemis Consultants Full time

    As a senior data architect, you will develop and manage data models, guidelines, and techniques. You may also manage the resources of a variety of business analysts to leverage design data analysis and visualization tools, and standardize data models and domains.Common Skillsets:10+ years of experience as Technical Architect/Data ArchitectExpertise in...

  • Data Architect

    2 weeks ago

    Jersey City, United States Tiger Analytics Full time

    Job DescriptionJob DescriptionTiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote...

  • Data Architect

    7 days ago

    Jersey City, United States Tiger Analytics Full time

    Job DescriptionJob DescriptionTiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote...

  • Data Architect

    1 month ago

    Jersey City, United States CENTSTONE SERVICES LLC Full time

    **data Architect - 5+ years** **Data modeling - Erwin** **Data Authority concept** **understating data concepts** **Data Catalog** Risk background is plus. AWS, private cloud Data catalogs, RDBMS Hybrid - 3 days a week - flexible in Jersey City Job Family Description: Highly proficient in data architecture disciplines with proficiency in the other...

  • Data Architect

    7 days ago

    Oklahoma City, United States Mosaic Personnel Full time

    Job DescriptionJob DescriptionWhy You'll Love This Data Architect RoleOpportunity to shape and innovate company's data management systemsLead technical initiatives to support operational and strategic goalsWork in a hybrid schedule with a competitive salary and comprehensive benefits packageJob Duties and ResponsibilitiesConceptualize and visualize...

  • SAP Data Architect

    6 days ago

    Jersey City, United States Damco Solutions Full time

    Job Description: As an SAP Data Architect, you will be responsible for designing, implementing, and maintaining SAP data architecture solutions to meet the organization's business requirements. You will work closely with cross-functional teams to ensure effective data Skills and Qualifications: Bachelor's or Master's degree in Computer Science,...

  • SAP Data Architect

    3 weeks ago

    Jersey City, United States Damco Solutions Full time

    Job Description: As an SAP Data Architect, you will be responsible for designing, implementing, and maintaining SAP data architecture solutions to meet the organization's business requirements. You will work closely with cross-functional teams to ensure effective data Skills and Qualifications: Bachelor's or Master's degree in Computer Science, Information...

  • Sr. Data Architect

    1 month ago

    Jersey City, United States Inizio Partners Corp Full time

    Job DescriptionJob DescriptionRole Overview:Expected to work in close collaboration with the internal team and client on data transformation, data engineering and data technology projectsWork with client to understand company needs to define architecture and build data solutions Plan and design the structure of a technology solutionUnderstanding of strategic...

  • Sr. Data Architect

    1 month ago

    Jersey City, United States Inizio Partners Corp Full time

    Job DescriptionJob DescriptionRole Overview:Expected to work in close collaboration with the internal team and client on data transformation, data engineering and data technology projectsWork with client to understand company needs to define architecture and build data solutions Plan and design the structure of a technology solutionUnderstanding of strategic...

  • Data Architect

    2 days ago

    Oklahoma City, United States Hartwig Staffing Full time

    Job DescriptionJob DescriptionHave you ever taken a company through a multi million dollar digital data migration? Or worked for a company that invests into their technology team versus seeing them as a cost center? Do you want to? Hartwig Staffing is partnered with an Oklahoma City based company who is looking for a Data Architect to help them digitally...

  • Data Architect

    3 days ago

    Oklahoma City, United States Hartwig Staffing Full time

    Have you ever taken a company through a multi million dollar digital data migration? Or worked for a company that invests into their technology team versus seeing them as a cost center? Do you want to? Hartwig Staffing is partnered with an Oklahoma City based company who is looking for a Data Architect to help them digitally transform their company. This...

  • Data Architect

    20 hours ago

    Oklahoma City, United States Hartwig Staffing Full time

    Have you ever taken a company through a multi million dollar digital data migration? Or worked for a company that invests into their technology team versus seeing them as a cost center? Do you want to? Hartwig Staffing is partnered with an Oklahoma City based company who is looking for a Data Architect to help them digitally transform their company. This...

  • Lead Data Architect

    2 weeks ago

    Kansas City, United States SS&C Full time

    SS&C is a global provider of investment and financial services and software for the financial services and healthcare industries. Named to Fortune 1000 list as top U.S. company based on revenue, SS&C is headquartered in Windsor, Connecticut and has 20,000+ employees in over 90 offices in 35 countries. Some 18,000 financial services and healthcare...