Data Architect

Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today.

Responsibilities:

The Data Architect will support Barrow Wise's CPS project and perform the following duties:

• Enable the management and sharing of infectious disease data between Chicago Public Schools and the Health Department

• Improvement of data quality (business processes, governance, systems/applications, etc.)

• Efficiency of public health response to disease outbreaks for Chicago Public School students

• 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 Analysts and Subject Matter Experts on specific topics 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

• Utilize various ETL tools, including MS SSIS and Ab Initio

• Perform ETL transformations between data stored in MS SQL Server Management Studio, Azure SQL Database, Oracle databases, and ServiceNow