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.
Celerion Values: Integrity Trust Teamwork Respect
Celerion is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, genetic information, marital status, qualified protected veteran status, or disability.
Note: To make sure you don't miss important updates from us, please check your Spam folder for emails from @celerion.com, particularly interview invitations. If you find one there, mark it as "Not Junk" to ensure future Celerion emails land in your inbox. Please note that Gmail accounts have been particularly noted as routing to Spam.
