Integration Developer

SALARY: $77,875.20 - $91,603.20nLOCATION: 33 N.

High St.

Columbus, OH 43215nBENEFITS:nnMedical, Vision, Dental, Supplemental and Life InsurancenPaid Parental LeavenEmployee DiscountsnCOTA Bus PassnWellness InitiativesnOn-Site Chair MassagenOn-Site Health CoachnTuition ReimbursementnStudent Loan Repayment ProgramnPublic Pension through OPERS & Ohio Deferred CompensationnnnPOSITION SUMMARY:nThe Integration Developer will design, develop and maintain COTA's robust data infrastructure and data integration pipelines.

This role is essential in enabling seamless data integration across operational systems, ridership analytics, fare collection/validation, scheduling, employee experience, and customer service platforms.

The Integration Developer plays a key role in connecting transit operational systems (e.g., CAD/AVL, APC, fare collection and validation, GTFS feeds, scheduling software) with enterprise data analytics platforms, planning, reporting, and public-facing tools.nPerform other duties in alignment with the COTA Strategic Plan and in support of the organization's vision to Move Every Life Forward.nnESSENTIAL JOB FUNCTIONS:nnDesign and develop batch and near-real-time integrations for on-premises, SaaS, and cloud-based systems.nCreate ETL/ELT workflows and data pipelines using Microsoft Azure Data Factory (ADF).nBuild Power BI datasets to enable data analysts to generate insights from Snowflake and SQL Server data.nImplement database-to-database or API-based integrations utilizing the SQL Server ecosystem.nIntegrate source systems (e.g., CAD/AVL, APC, Infor GTFS) into Snowflake data warehouses.nProactively monitor, troubleshoot, and automate recovery processes to minimize business impact.nMigrate legacy SQL Server-based integrations to Azure ADF.nCollaborate with vendors, partners, and business units to identify suitable integration solutions.nWork with data architects and analysts to translate data needs into technical solutions.nParticipate in Agile development processes and collaborate with cross-functional teams.nEnsure integrations are secure, reliable, and cost-effective by working with Cybersecurity and Infrastructure teams.nAdhere to best practices, including DevOps, Infrastructure-as-Code (IaC), unit testing, and source code versioning.nDocument integration architecture, design, logic, data mappings, and processes according to organizational standards (e.g., COTA).nnnMINIMUM EDUCATION & EXPERIENCE REQUIRED:nnRequires a bachelor's degree in computer science or a related field and three (3) years' experience in Azure Data Factory (ADF), SQL Server, Snowflake, and/or APIs.

An equivalent combination of education and relevant experience will also be considered.nSnowPro® Associate: Platform Certification desired.nMicrosoft Certified: Azure Developer Associate desired.nnnCOTA 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 race, color, religion or belief, sex, sexual orientation, age, genetic information, gender identity, national origin, veteran or disability status

Full Time