Blog

Hello,

We are currently trying to fill up this role. Solution Arquitect for a Public Transportation client in Columbus Ohio.  The client is looking for a resource who can work onsite 5 days a week during 1 year contract. We are aiming LOCAL CANDIDATES, however RELOCATION is being accepted. Ideally we are looking for GC Holders or US Citizens but other work authorizations are good also. There is flexibility on the rate and we can discuss it on the phone, but the candidates need to have strong experience in data warehousing and Transportation domain, public or private.

Client: COTA Central Ohio Transit Authority
Job Title: Solution Architect

Location: Columbus, Ohio- Onsite

Position Type: Full Time (1 Year contract)

Desired Rate: $85/hr to $95/hr on C2C

Qualifications:

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

Candidate needs to have 10-12+ years of experience

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 building Azure cloud solutions, especially using ADF.

• Expert in GIT and branching strategies for Azure ADF.

• Expert in administering Azure DevOps, including release management.

• Knowledgeable in optimizing cloud operational costs.

• Expert in Snowflake 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.

Best Regards!