Data Architect - Salt Lake City, United States - Stantec

Stantec Salt Lake City, United States

3 weeks ago

Description

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

Data Architect

1 week ago

Barr Engineering Company Salt Lake City, United States

Job Description: · Summary: We are seeking a skilled and experienced data architect to join our dynamic team. The successful candidate will play a crucial role in architecting robust data solutions while also providing support to our Business Intelligence (BI) team in data sourc ...
Lead Data Architect

19 hours ago

Confluent Salt Lake City, United States

With Confluent, organizations can harness the full power of continuously flowing data to innovate and win in the modern digital world. We have a purpose that drives us to do better every day · we're creating an entirely new category within data infrastructure - data streaming. T ...
Lead Data Architect

1 day ago

Confluent Salt Lake City, United States

Confluent · Lead Data Architect · Salt Lake City , · Utah · Apply Now · With Confluent, organizations can harness the full power of continuously flowing data to innovate and win in the modern digital world. We have a purpose that drives us to do better every day – we're crea ...
Data warehouse architect

5 days ago

University of Utah Health Salt Lake City, United States

Overview · Local, Hybrid position. Need to live in area or be willing to relocate. · As a patient-focused organization, University of Utah Health exists to enhance the health and well-being of people through patient care, research and education. Success in this mission requires a ...
Principal Data Architect RandD

3 days ago

BIOMERIEUX, INC. Salt Lake City, United States

Principal Data Architect RandD - Solution Design - All genders · Location: Salt Lake City, United States Position Type: Unfixed Term Job Function: Software Development · Share: · A family-owned company, bioMerieux has grown to become a world leader in the field of in vitro diagno ...
Data Warehouse Architect III

2 weeks ago

University of Utah Salt Lake City, United States

Overview · Local, Hybrid position. Need to live in area or be willing to relocate. · As a patient-focused organization, University of Utah Health exists to enhance the health and well-being of people through patient care, research and education. Success in this mission requires a ...
T-Data-Architect: Sr Data Architect

3 weeks ago

Streamlinity LLC Salt Lake City, United States

Job Locations: Dallas, TX, USA; USARequired Experience: YearsSkills : Data Modeling, 3NF, Star Schema · Learn more about the general tasks related to this opportunity below, as well as required skills. · Skill set 3NF Data Modeling Dimension Data Modeling Data lineage - Source ...
Azure Data Platform Solution Architect

2 days ago

Avanade Salt Lake City, United States

Azure Data Platform Solution Architect · Harness the power of data to drive business success as an Azure Data Platform Solution Architect at Avanade, where every insight paves the way for innovation. · Come join us: · Embark on a journey where your expertise in data engineering s ...
Data Architect

2 days ago

Intermountain Health West Jordan, United States

Job Description: · Employer: IHC Health Services, Inc. (D/B/A Intermountain Health) · Job Title: Data Architect Operations · Degree Required: Masters degree or equivalent foreign education · Academic Discipline(s): Computer Science or Electrical Engineering · Experience Required: ...
Enterprise Data Center Architect

2 weeks ago

latitude Layton, United States

Enterprise Data Center Architect · Location: Hill AFB, UT · ****This position requires an Active Secret Clearance**** · Essential Duties & Responsibilities: · •The Enterprise Data Center Architect (DCA) is, in conjunction with the Hill CEDC Chief Technical Officer (CTO), is r ...
Enterprise Data Center Architect

3 weeks ago

Latitude, Inc. Layton, United States

Job Description · Job DescriptionEnterprise Data Center Architect · Location: Hill AFB, UT · ****This position requires an Active Secret Clearance**** · Essential Duties & Responsibilities: · • The Enterprise Data Center Architect (DCA) is, in conjunction with the Hill CEDC Chi ...
Solution Architect

1 week ago

ReliaQuest Salt Lake City, United States

Solution/Software Architect · Our software innovation team is rapidly growing and looking for a Solution/Software Architect to be part of a fast-paced, high-energy team. Our engineers are serious about the success of the company and are given the tools and environment they need ...
Architect & Design Sales Manager Salt Lake City

1 week ago

Cosentino Group Salt Lake City, United States

What are we looking for · At Cosentino () we are looking for a Commercial Sales Manager to join our Distribution team in Salt Lake City, who will have the opportunity to work in a multinational environment, in full expansion, surrounded by numerous challenging projects that you ...
Sr. Security Engineer/Architect

2 weeks ago

ConsultNet Technology Services and Solutions Salt Lake City, United States

Sr. Security Engineer/Architect · Salt Lake City, UT · 6 month Contract to Hire · Pay Range: $ $100.00 per hr / Salary Target: $175K - $200K · Job Description: · Our client is a leading provider of innovative billing solutions, committed to delivering secure, efficient, and relia ...
Staff Software Engineer, Data Platform

3 weeks ago

SoFi Salt Lake City, United States

Who we are: · Shape a brighter financial future with us. · Together with our members, we're changing the way people think about and interact with personal finance. · We're a next-generation financial services company and national bank using innovative, mobile-first technology to ...
Sr. Specialist, Network Systems Engineer

1 week ago

L3 Technologies Salt Lake City, United States

Job Title: Sr Specialist Network Systems Engineer · Job Code: 9672 · Job Location: USA-UT-Salt Lake City · Job Schedule: 9/80, every other Friday off · Job Description : · The Senior Specialist, Network Systems Engineer will be responsible for the development of advanced co ...
Application Engineer

1 week ago

Altair Engineering Salt Lake City, United States

Transforming the Future with the Convergence of Simulation and Data · Application Engineer · Do you like a challenge, are you a complex thinker who likes to solve problems? If so, then you might be the new Altairian we are searching for. At Altair, your curiosity matters. We pr ...
Senior Geotechnical Engineer

1 week ago

Universal Engineering Sciences Salt Lake City, United States Full time

Job Responsibilities: · Perform and manage geotechnical engineering investigations and studies · Work closely with clients, including owners, architects, and other design professionals to determine project needs · Prepare scopes of service, proposals, and budget estimates · Work ...
System Administrator

2 weeks ago

Chickasaw Nation Industries Salt Lake City, United States

It's fun to work in a company where people truly BELIEVE in what they're doing · We're committed to bringing passion and customer focus to the business. · SUMMARY · The System Administrator acts as the lead system administrator to serve the needs of the DPG/WDTC data science supp ...
Information Assurance

4 days ago

General Dynamics Information Technology Salt Lake City, United States

The Information System Security Engineer (ISSE) is primarily responsible for conducting information system security engineering activities with a focus on lifecycle of current systems and future requirement scoping. The position will collect and process the captured information s ...