Solution Architect

Title: Solution Architect

Department: Central Ohio Transit Authority

Location: Columbus, Ohio- Onsite (If you have local candidates, it would be great, or they can be willing to relocate)

Client: State of Ohio

Visa: GC

Exp: 14 Years

Earliest Start Date: ASAP

Duration: 1 year

**Must have prior experience working on projects for public transportation planning and operations**

Note: Transportation domain experience is a must. It can be public or private.

Share candidates with Experience with Data warehousing.

Background:

This position is not part of a typical staff augmentation engagement. Instead, it is for an internal project with the client, where we are strengthening and expanding the client's project team to support a specific project.

Candidate Assessment Process:

Qualifications:

**Must have prior experience working on projects for public transportation planning and operations**

The role requires a seasoned solution architect with expertise in building data warehouses and data lakes using modern data engineering techniques and architecture. This person is expected to be available full-time for this project with the following skills and responsibilities:

• Expert in building data warehouses and analytics solutions using Snowflake.
• Mastery in buildingAzure cloud solutions, especially using ADF.
• Expert in GIT and branching strategies for Azure ADF.
• Expert inadministering Azure DevOps, including release management.
• Knowledgeable in optimizing cloud operational costs.
• Expert inSnowflake platform.
• Expert in modern data warehousing and data lake concepts.
• Expert in data protection, privacy, access control, and masking.
• Embrace infrastructure-as-code and make sure all deployment and release activities are automated.
• Accountable for the solution's architecture, design, non-functional, and quality requirements.
• Expert data modeler responsible for conceptual, logical models that meet business needs today and can withstand the test of time.
• Design a data platform to enable citizen analysts to perform self-service analytics.
• Ensure metadata like data catalog, data lineage, and labels are captured.
• Review and approve work in Snowflake and data lakes like DDL, metadata, and other scripts
• Review and approve pull requests for all the development activities.
• Assist with troubleshooting end-to-end solutions and help developers and testers.
• Should be able and willing to participate in development activities throughout the solution's technology stack.
• Should be an expert in Azure ADF, data pipelines, and Azure Integration run-time.
• Should be an expert in integrations utilizing REST API, RDBMS, Snowflake, and other data sources.
• Should have working knowledge of Azure DevOps.
• Should have a thorough understanding of GIT and branching strategies.
• Manage code related to pipelines and infrastructures in GIT.
• Perform unit tests.