Data Architect

Job Title: Data Architect
Location: Columbus, OH
Duration: Contract

Job Description
We are looking for an experienced Data Architect / SQL Developer Lead with strong expertise in database architecture, SQL development, data modelling, stored procedures, and data migration.
The ideal candidate will have hands-on experience designing scalable data solutions and leading database migration initiatives across different database platforms.

Key Responsibilities
Design and develop robust data architectures, database structures, and data models aligned with business and application requirements.
Lead SQL development activities, including complex queries, performance optimization, database objects, and stored procedures.
Develop logical and physical data models, including conceptual, relational, and dimensional modelling.
Lead and execute data migration projects across different database technologies, ensuring data accuracy, integrity, and minimal downtime.
Analyze existing database environments and develop effective strategies for database modernization and migration.
Perform database performance tuning, query optimization, indexing, and troubleshooting.
Work closely with application developers, data engineers, business teams, and technical architects to define data requirements and solutions.
Develop migration scripts, transformation logic, reconciliation processes, and data validation procedures.
Establish database development standards, best practices, naming conventions, and data governance guidelines.
Troubleshoot complex database issues and provide technical leadership to development teams.
Review technical designs and SQL code and mentor junior and mid-level developers.
Support production deployments, data conversion activities, and post-migration validation.