Central Ohio Transit Authority (COTA)
Integration Developer
Central Ohio Transit Authority (COTA), Columbus, Ohio, United States, 43224
Join to apply for the
Integration Developer
role at
Central Ohio Transit Authority (COTA) 4 days ago Be among the first 25 applicants Join to apply for the
Integration Developer
role at
Central Ohio Transit Authority (COTA) Get AI-powered advice on this job and more exclusive features. SALARY:
$77,875.20 - $91,603.20
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
The 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.
Perform 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
Design and develop batch and near-real-time integrations for on-premises, SaaS, and cloud-based systems. Create ETL/ELT workflows and data pipelines using Microsoft Azure Data Factory (ADF). Build Power BI datasets to enable data analysts to generate insights from Snowflake and SQL Server data. Implement database-to-database or API-based integrations utilizing the SQL Server ecosystem. Integrate source systems (e.g., CAD/AVL, APC, Infor GTFS) into Snowflake data warehouses. Proactively monitor, troubleshoot, and automate recovery processes to minimize business impact. Migrate legacy SQL Server-based integrations to Azure ADF. Collaborate with vendors, partners, and business units to identify suitable integration solutions. Work with data architects and analysts to translate data needs into technical solutions. Participate in Agile development processes and collaborate with cross-functional teams. Ensure integrations are secure, reliable, and cost-effective by working with Cybersecurity and Infrastructure teams. Adhere to best practices, including DevOps, Infrastructure-as-Code (IaC), unit testing, and source code versioning. Document integration architecture, design, logic, data mappings, and processes according to organizational standards (e.g., COTA).
Minimum Education & Experience Required
Requires 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. SnowPro Associate: Platform Certification desired. Microsoft Certified: Azure Developer Associate desired.
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 race, color, religion or belief, sex, sexual orientation, age, genetic information, gender identity, national origin, veteran or disability status
Job Posted by ApplicantPro Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Transportation/Trucking/Railroad Referrals increase your chances of interviewing at Central Ohio Transit Authority (COTA) by 2x Get notified about new Integration Developer jobs in
Columbus, OH . Columbus, OH $64,000.00-$70,000.00 1 week ago Columbus, OH $110,000.00-$130,000.00 1 week ago Columbus, OH $106,900.00-$178,100.00 1 week ago Columbus, OH $150,000.00-$175,000.00 5 months ago Columbus, OH $106,900.00-$178,100.00 1 week ago Columbus, OH $140,000.00-$140,000.00 1 week ago Columbus, OH $56,000.00-$58,000.00 1 week ago Associate Software Engineer - 2025 Start Dates
Columbus, OH $90,000.00-$115,000.00 3 days ago Software Engineer [Multiple Positions Available]
Columbus, OH $106,900.00-$178,100.00 18 hours ago Reynoldsburg, OH $75,591.00-$92,407.00 1 week ago Columbus, OH $106,900.00-$178,100.00 1 month ago Columbus, OH $106,900.00-$178,100.00 5 days ago Columbus, OH $56,000.00-$58,000.00 1 day ago Software Engineer (Automated Program Analysis)
Columbus, OH $155,000.00-$175,000.00 6 months ago Columbus, OH $150,000.00-$200,000.00 2 weeks ago Specialist, Software Engineer (Java, SQL)
Columbus, OH $63,800.00-$205,800.00 3 weeks ago Software Engineer - Full Stack (Angular, .Net, C#, SQL)
Columbus, OH $106,900.00-$178,100.00 4 days ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Integration Developer
role at
Central Ohio Transit Authority (COTA) 4 days ago Be among the first 25 applicants Join to apply for the
Integration Developer
role at
Central Ohio Transit Authority (COTA) Get AI-powered advice on this job and more exclusive features. SALARY:
$77,875.20 - $91,603.20
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
The 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.
Perform 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
Design and develop batch and near-real-time integrations for on-premises, SaaS, and cloud-based systems. Create ETL/ELT workflows and data pipelines using Microsoft Azure Data Factory (ADF). Build Power BI datasets to enable data analysts to generate insights from Snowflake and SQL Server data. Implement database-to-database or API-based integrations utilizing the SQL Server ecosystem. Integrate source systems (e.g., CAD/AVL, APC, Infor GTFS) into Snowflake data warehouses. Proactively monitor, troubleshoot, and automate recovery processes to minimize business impact. Migrate legacy SQL Server-based integrations to Azure ADF. Collaborate with vendors, partners, and business units to identify suitable integration solutions. Work with data architects and analysts to translate data needs into technical solutions. Participate in Agile development processes and collaborate with cross-functional teams. Ensure integrations are secure, reliable, and cost-effective by working with Cybersecurity and Infrastructure teams. Adhere to best practices, including DevOps, Infrastructure-as-Code (IaC), unit testing, and source code versioning. Document integration architecture, design, logic, data mappings, and processes according to organizational standards (e.g., COTA).
Minimum Education & Experience Required
Requires 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. SnowPro Associate: Platform Certification desired. Microsoft Certified: Azure Developer Associate desired.
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 race, color, religion or belief, sex, sexual orientation, age, genetic information, gender identity, national origin, veteran or disability status
Job Posted by ApplicantPro Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Transportation/Trucking/Railroad Referrals increase your chances of interviewing at Central Ohio Transit Authority (COTA) by 2x Get notified about new Integration Developer jobs in
Columbus, OH . Columbus, OH $64,000.00-$70,000.00 1 week ago Columbus, OH $110,000.00-$130,000.00 1 week ago Columbus, OH $106,900.00-$178,100.00 1 week ago Columbus, OH $150,000.00-$175,000.00 5 months ago Columbus, OH $106,900.00-$178,100.00 1 week ago Columbus, OH $140,000.00-$140,000.00 1 week ago Columbus, OH $56,000.00-$58,000.00 1 week ago Associate Software Engineer - 2025 Start Dates
Columbus, OH $90,000.00-$115,000.00 3 days ago Software Engineer [Multiple Positions Available]
Columbus, OH $106,900.00-$178,100.00 18 hours ago Reynoldsburg, OH $75,591.00-$92,407.00 1 week ago Columbus, OH $106,900.00-$178,100.00 1 month ago Columbus, OH $106,900.00-$178,100.00 5 days ago Columbus, OH $56,000.00-$58,000.00 1 day ago Software Engineer (Automated Program Analysis)
Columbus, OH $155,000.00-$175,000.00 6 months ago Columbus, OH $150,000.00-$200,000.00 2 weeks ago Specialist, Software Engineer (Java, SQL)
Columbus, OH $63,800.00-$205,800.00 3 weeks ago Software Engineer - Full Stack (Angular, .Net, C#, SQL)
Columbus, OH $106,900.00-$178,100.00 4 days ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr