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
• Utilize scripting languages, Bash, PowerShell, Google Script, C#, and Python
• Perform AppWorx workload automation
• Perform data profiling and data modeling of both dimensional and non-dimensional data in 3NF
• Work remotely

An ideal candidate has the following:

• U.S. Citizenship
• A Master's degree from an accredited college or university in computer science, data science, engineering, or related field, required 8 years of technology delivery experience with at least 7 years focus on 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 and 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

• 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 processes 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