Data Architect in Columbus

Energy Jobline is the largest and fastest growing global Energy Job Board and Energy Hub. We have an audience reach of over 7 million energy professionals, 400,000+ monthly advertised global energy and engineering jobs, and work with the leading energy companies worldwide.

We focus on the Oil & Gas, Renewables, Engineering, Power, and Nuclear markets as well as emerging technologies in EV, Battery, and Fusion. We are committed to ensuring that we offer the most exciting career opportunities from around the world for our jobseekers.

Job DescriptionJob Description

SALARY: $79,788.80 - $93,870.30

LOCATION: 33 N. High St. Columbus, OH 43215

BENEFITS:

• Medical, Vision, Dental, Supplemental and Life Insurance
• Paid Parental Leave
• Employee Discounts
• COTA Bus Pass
• Wellness Initiatives
• On-Site Chair Massage
• On-Site Health Coach
• Tuition Reimbursement
• Student Loan Repayment Program
• Public Pension through OPERS & Ohio Deferred Compensation

POSITION SUMMARY:

COTA's Data Architect defines and advances the enterprise data architecture strategy to ensure alignment with organizational priorities and roadmaps. This role provides strategic and hands‑on leadership in designing and governing the data ecosystem that supports COTA's analytics and data management capabilities. The Data Architect drives innovation, cultivates trust, and delivers solutions that cultivates a data-centric transit culture.

Performs other duties in alignment with the COTA Strategic Plan and in support of the organization's vision to Move Every Life Forward.

ESSENTIAL JOB FUNCTIONS:

• Lead the development and ongoing advancement of COTA's enterprise data architecture framework by defining and delivering conceptual, logical, and physical models that govern how data is stored, processed, and accessed, ensuring alignment with organizational goals and future scalability.
• Design and implement modern data architecture leveraging cloud platforms (e.g., AWS, Azure), data warehouse technologies including Snowflake, and emerging capabilities in AI and Power BI.
• Define database architectures that meet performance, resiliency, recoverability, and cost objectives.
• Champion data confidentiality, security, and compliance by applying protection controls and establishing security patterns at the database, table, column, and API levels.
• Develop reusable architectural patterns for dynamic tables, ingestion zones, and domain aligned data products.
• Provide expert guidance on SQL Server and other database platforms, including troubleshooting, tuning, monitoring, and architectural optimization.
• Advise on database implementations to ensure alignment with enterprise standards and compliance obligations.
• Lead large scale data migration initiatives from legacy environments to cloud or hybrid architectures.
• Define target state architectures and transition plans that modernize data ecosystems and accelerate adoption of emerging technologies.
• Establish standards for Data-as-a-Product, including metadata, lineage, ownership, and interoperability.
• Oversee data quality, validation, and cutover strategies to ensure successful platform transitions.
• Mentor database administrators, engineers, and solution teams to promote consistent adoption of architectural best practices.
• Influence business and technology stakeholders through clear communication, structured reasoning, and technical expertise.
• Demonstrate deep experience designing conceptual and logical data models, canonical models, and domain aligned data products.
• Regular, predictable and punctual attendance required; and,
• Performs other duties as assigned.

MINIMUM EDUCATION & EXPERIENCE REQUIRED:

• Bachelor's degree in computer science or a related field and a minimum of five (5) years of experience. An equivalent combination of education and relevant experience will also be considered.

COTA is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. All employment decisions are based on job needs, job requirements and individual qualifications, without regard to , , or belief, , , , genetic information, , , veteran or status

Job Posted by ApplicantPro

If you are interested in applying for this job please press the Apply Button and follow the application process. Energy Jobline wishes you the very best of luck in your next career move.