Data Architect

4 weeks ago

Chicago, United States Novalink Solutions LLC Full time
Job DescriptionJob DescriptionCPS is currently supporting a grant project focused on improving health information exchange between the Chicago Department of Public Health (CDPH) and Chicago Public Schools: The Epidemiology and Laboratory Capacity (ELC) Program. The three major goals of the grant are as follows: A. Management and sharing of communicable disease data between Chicago Public Schools and the Local Health Department B. C. Improvement of data quality (business processes, governance, systems/applications, etc.) Efficiency of public health response to disease outbreaks for Chicago Public School students Job Summary: Under the direction of the Data Solutions Manager and in connection with the ELC Program team, the Data Architect will ensure the ELC Program’s data architecture is organized, accessible, secure, and meets the needs of the program and associated 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. DATA ARCHITECT ● 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. ● Drive best practice solutions for data in a collaborative environment. ● Provide insight and strategies for data architecture solutions. ● Coordinate with a Solutions Architect to find the best data solution and workflows to support projects. ● Lead architectural design and strategy discussions. ● Familiarity with various ETL tools including MS SSIS and Ab Initio. ● Familiarity with ETL transformations between data stored in MS SQL Server Management Studio, Azure SQL Database, Oracle databases and ServiceNow. ● Experience with scripting languages, Bash, PowerShell, Google Script and some C# and Python. ● Familiarity with AppWorx workload automation ● Extensive work with data profiling. ● Extensive work with data modeling both dimensional and non-dimensional data in 3NF. ● Experience in conceptual, logical, physical data modeling ● 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:

RequirementsEducation 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: ● 5-7 years of technology delivery experience with at least 3 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. DATA ARCHITECT ○ 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. ○ 8+ 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). ● Familiarity with K-12 Education is preferred.

  • Azure Data Architect

    4 days ago

    chicago, United States Hexaware Technologies Full time

    Role: Azure Data ArchitectLocation: Chicago, IL/NJExperience: 12- 15 yearsWork Mode: RemoteJob Description –Someone with a balanced mix of technical and business skills and working with an enterprise architecture team for strategic direction.Develop and drive domain/application standards and best practices that align with enterprise direction.Proven work...

  • Azure Data Architect

    2 weeks ago

    Chicago, United States Hexaware Technologies Full time

    Role: Azure Data ArchitectLocation: Chicago, IL/NJExperience: 12- 15 yearsWork Mode: RemoteJob Description –Someone with a balanced mix of technical and business skills and working with an enterprise architecture team for strategic direction.Develop and drive domain/application standards and best practices that align with enterprise direction.Proven work...

  • Azure Data Architect

    2 weeks ago

    Chicago, United States Hexaware Technologies Full time

    Role: Azure Data ArchitectLocation: Chicago, IL/NJExperience: 12- 15 yearsWork Mode: RemoteJob Description –Someone with a balanced mix of technical and business skills and working with an enterprise architecture team for strategic direction.Develop and drive domain/application standards and best practices that align with enterprise direction.Proven work...

  • Azure Data Architect

    5 days ago

    chicago, United States Hexaware Technologies Full time

    Role: Azure Data ArchitectLocation: Chicago, IL/NJExperience: 12- 15 yearsWork Mode: RemoteJob Description –Someone with a balanced mix of technical and business skills and working with an enterprise architecture team for strategic direction.Develop and drive domain/application standards and best practices that align with enterprise direction.Proven work...

  • Senior Data Architect

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

  • Lead Data Architect

    1 month ago

    Chicago, United States Enzo Tech Group Full time

    Lead Data ArchitectThe Lead Data Architect will be essential in developing and implementing robust data governance policies and practices. This individual will work collaboratively with business and IT teams to ensure data assets comply with industry standards and regulatory requirements. The ideal candidate will have extensive experience in data...

  • Senior Data Architect

    4 weeks ago

    Chicago, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas immunology, oncology, neuroscience, and eye care and products and services in our...

  • Data Architect Manager

    2 months ago

    Chicago, Illinois, United States Origami Risk Full time

    The Data Architect Manager is a critical player-coach role that combines hands-on technical leadership with strategic management responsibilities in a SaaS B2B environment. This position involves actively contributing to projects as a Senior Data Architect while leading and mentoring a team of highly qualified Data Architects. This person is responsible for...

  • Senior Data Architect

    1 month ago

    Chicago, Illinois, United States Bounteous Full time

    Bounteous x Accolite makes the future faster for the world's most ambitious brands. Our services span Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing. We are guided by Co-Innovation, our proven methodology of collaborative partnership. Bounteous x Accolite brings together 5000+ employees spanning North America,...

  • Data Architect with AWS and DevOps

    1 month ago

    Chicago, United States VDart Inc Full time

    Job DescriptionJob DescriptionJob Title: Data Architect with AWS and DevOpsLocation: Chicago, Illinois - OnsiteDuration: / Term: 6+ months ContractMandatory skills: AWS Architecture, DevopsJob Description:Responsible for ensuring that the data management and governance frameworks are in place and adhered toResponsible for Architecting Data engineering...

  • Azure Data Bricks Architect- Hybrid)

    2 weeks ago

    Chicago, United States PSRTEK Full time

    Job DescriptionJob DescriptionSr Data Engineer /Architect Chicago, IL - HybridMandatory Skills / Required Experience Experience in implementing large data and analytics platforms. Deep experience architecting and building data platforms on Azure with strong experience on Medallion Architecture. Experience architecting and building data platforms on...

  • IT Architect- Data Product Solutions

    1 week ago

    Chicago, United States Retail Business Services Full time

    Category/Area of Expertise: Data-Science & Analytics Job Requisition: 383459_external_USA-IL-Chicago_6242024 Address: USA-IL-Chicago-300 South Riverside Plaza Store Code: Arch/Data - Business Intell & Analy (5119250) Ahold Delhaize USA, a division of global food retailer Ahold Delhaize, is part of the U.S. family of brands, which also includes five leading...

  • IT Architect- Data Product Solutions

    1 month ago

    Chicago, Illinois, United States Ahold Delhaize USA Full time

    Address: USA-IL-Chicago-300 South Riverside Plaza Store Code: Arch/Data - Business Intell & Analy Ahold Delhaize USA, a division of global food retailer Ahold Delhaize, is part of the U.S. family of brands, which also includes five leading omnichannel grocery brands - Food Lion, Giant Food, The GIANT Company, Hannaford and Stop & Shop. Ahold Delhaize USA...

  • Big Data Architect

    15 hours ago

    Chicago, Illinois, United States Tiger Analytics Full time

    Job OverviewTiger Analytics, a leading advanced analytics consulting firm, is seeking a highly skilled Big Data Engineer to join our team. Our company provides expert analytics services to Fortune 500 companies, helping them unlock business value from data.The ideal candidate will have a strong background in traditional and modern Big Data technologies,...

  • Azure Databricks Cloud Data Architect

    3 weeks ago

    Chicago, Illinois, United States Itl Usa Full time

    Job description Infosys is seeking an Azure Databricks Cloud Data Architect.Required Qualifications:Candidate must be located within commuting distance of Chicago, IL or be willing to relocate to this location.At least 7 years of Information Technology experienceHands on experience in architecting Cloud data solutions using Azure Synapse, Databricks, Python,...

  • Azure Databricks Cloud Data Architect

    3 weeks ago

    Chicago, United States Itl Usa Full time

    Job description Infosys is seeking an Azure Databricks Cloud Data Architect.Required Qualifications:Candidate must be located within commuting distance of Chicago, IL or be willing to relocate to this location.At least 7 years of Information Technology experienceHands on experience in architecting Cloud data solutions using Azure Synapse, Databricks, Python,...

  • Azure Data Architect

    6 days ago

    Chicago, United States Hexaware Technologies Full time

    Role – Azure Data Architect / Data ModelerLocation – Chicago, ILJob Type – HybridJob Description 10+ years of experience delivering data and data analytics solutions in Azure Ecosystem10+ years of experience in building OLTP and OLAP database modelsStrong work experience as a Data Modeler working in Azure Ecosystem.Expertise in Ralph Kimball/Inmon...

  • Azure Data Architect

    5 days ago

    Chicago, United States Hexaware Technologies Full time

    Role – Azure Data Architect / Data ModelerLocation – Chicago, ILJob Type – HybridJob Description 10+ years of experience delivering data and data analytics solutions in Azure Ecosystem10+ years of experience in building OLTP and OLAP database modelsStrong work experience as a Data Modeler working in Azure Ecosystem.Expertise in Ralph Kimball/Inmon...

  • Sustainability Data Architect

    2 months ago

    Chicago, United States Mars Full time

    Job Description:Transformational role (three-year period) | hybrid | full-timeAs we continue to prioritize Sustainability as a key driver to our success in Mars Wrigley, we are looking for a Data Solution Architect to bring knowledge and leadership to build our foundational sustainability data strategy, data models, advanced data solutions and consult on the...

  • Enterprise Data Architect

    4 weeks ago

    Chicago, United States Northern Trust Full time

    About Northern Trust: Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889. Northern Trust is proud to provide innovative financial services and guidance to the world's most successful individuals, families, and institutions by remaining true to our enduring...