Application & Data Integration Developer

Celerion is committed to swift, exceptional clinical research through translational medicine. Every day, we use our experience, agility, and innovative research strategies to help get drugs to market faster.

Location: This is a fully remote position open to candidates residing in the Central or Eastern Time Zones only.

Employment Type: Full-Time

About the Role

We're looking for an Application & Data Integration Developer to help keep our data moving reliably across the business. You'll design and support the pipelines, integrations, and data models that connect our enterprise applications — working hands-on with Python or Perl, APIs, SQL, Snowflake, and ETL processes. If you enjoy solving problems where systems meet data, and you like variety in your day-to-day work, this role is for you.

What You'll Do

Design, build, and maintain integrations between our enterprise applications and systems

Develop integration solutions using Python, Perl, REST APIs, web services, and related technologies

Build and optimize data integrations using SQL, ETL/ELT tools, and platforms including SQL Server, Oracle, and Snowflake

Create and maintain Snowflake database objects, data models, and datasets that power our business applications, reporting, and analytics

Monitor, troubleshoot, and resolve issues across integrations, databases, and data pipelines to keep systems running smoothly

Support reporting and analytics work using tools like TIBCO Spotfire

Partner with IT teams, business stakeholders, vendors, and application owners to gather requirements and deliver practical technical solutions

Write and maintain clear technical documentation for integrations, data flows, database structures, and support processes

Follow our established development, testing, security, change management, and IT governance standards

Provide Level 1 Celexus support during U.S. business hours

What We're Looking For

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field — or equivalent experience

3-5 years of experience in application integration, software development, data integration, or database development

Programming experience with Python and/or Perl

Experience working with APIs and integration technologies

Strong SQL skills and experience with relational databases

Experience with SQL Server, Oracle, Snowflake, or similar database platforms

Experience building and maintaining Snowflake databases and data structures

Experience with ETL/ELT tools (e.g., Rivery)

Solid understanding of data modeling, data warehousing, and relational database concepts

Ability to translate technical requirements into reliable, maintainable solutions

Experience with business intelligence/reporting tools such as TIBCO Spotfire

Experience with VBA and Microsoft Office automation

Understanding of software development lifecycle (SDLC) and change management practices

Experience with scheduling, automation, monitoring, and orchestration tools

Snowflake certification or training is a plus

Strong analytical, problem-solving, and troubleshooting skills

Detail-oriented with a focus on data quality

Ability to manage multiple priorities and work independently

Strong written and verbal communication skills

Ability to collaborate effectively with both technical and non-technical stakeholders

Ability to create reliable, maintainable, and well-documented solutions

Work Schedule & Location

This is a fully remote position open to candidates residing in the Central or Eastern Time Zones . Standard U.S. business hours coverage is required to support Level 1 Celexus support needs.