About This Role

CPC Logistics is seeking a Systems Integration Developer to help build, support, and improve systems that connect operational data, internal applications, file-based workflows, legacy tools, and third-party platforms.

This is a hands-on backend role focused on SQL, integrations, automation, and production troubleshooting. This is not a front-end position and not solely a reporting role however, Power BI is an important component of this role and will be required as part of delivering end-to-end solutions.

The primary database platform for this role is Microsoft SQL Server. Experience with DB2 LUW is helpful but not required. Candidates should be comfortable learning DB2 and working with cross-database integrations.

We are looking for someone who enjoys solving real-world integration problems, working across both modern and legacy systems, and building reliable backend processes.

What You’ll Do

• Design, build, and support database-driven integration solutions
• Write, optimize, and troubleshoot complex SQL queries, views, and stored procedures
• Build and maintain REST API integrations between internal and external systems
• Develop and support .NET backend services and automation processes
• Support file-based workflows including monitoring, validation, imports, exports, and archiving
• Work with DB2 databases and ODBC-based integrations
• Support and enhance legacy business logic (VBScript, classic ASP, etc.)
• Troubleshoot live issues involving databases, APIs, services, files, and integrations
• Implement strong logging, validation, retry logic, and defensive error handling
• Develop and support Power BI data models and reporting solutions
• Partner with internal teams to deliver reliable technical solutions

What We’re Really Looking For

Strong skills in:

• SQL Server and database development
• Power BI development and data modeling
• API integrations
• Backend automation
• Cross-system troubleshooting
• Legacy-to-modern system support
• Reliable production code

This role is a strong fit for someone who can follow data from source to destination, understand how systems interact, and solve integration problems independently.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field or equivalent technical experience
• Strong experience with Microsoft SQL Server in production environments
• Advanced SQL skills (joins, CTEs, aggregations, subqueries, tuning)
• Experience with Power BI (data models, reports, performance tuning)
• Experience building or supporting REST API integrations
• Experience with C# and .NET backend development
• Experience troubleshooting live production issues
• Experience working with JSON, CSV, Excel, and structured data
• Experience working with relational databases in production environments
• Experience with DB2 or ability to learn DB2 platform nuances
• Strong problem-solving skills and ability to work independently
• Strong written and verbal communication skills

Preferred Qualifications

• Experience with DB2
• Experience using ODBC in application development
• Experience building Windows Services or background processes
• Experience with .NET 8
• Experience with structured logging (Serilog or similar)
• Experience with VBScript
• Experience with classic ASP
• Experience with file-processing automation
• Experience in logistics, transportation, or operational environments

Technical Environment

You may work with technologies such as:

Primary Database

• Microsoft SQL Server

Secondary Database

• DB2

Development & Integration

• C#
• .NET 8
• REST APIs
• JSON / CSV / Excel workflows
• Windows Services / Worker Services
• ODBC

Legacy Technologies

• VBScript
• Classic ASP

Reporting & Analytics

• Power BI

What Success Looks Like

In this role, success means you can:

• Understand how data moves across systems
• Build integrations that are stable and supportable
• Troubleshoot issues across multiple technologies
• Support both modern and legacy systems
• Reduce manual work through reliable automation
• Write clean, maintainable production code

Why Join CPC Logistics

CPC Logistics is a stable, established transportation logistics company with over 50 years in the industry. We provide a supportive environment where developers can make meaningful contributions and grow their careers over the long term.

This is a smaller development team, which means you’ll have a broad canvas to work with and the opportunity to take ownership of important systems and initiatives. While the role will initially focus on immediate business needs, there is significant opportunity to expand into additional development disciplines over time.

This position offers:

• Long-term career stability
• Growth opportunity within the role
• Broad technical exposure across multiple systems
• Ownership of meaningful projects and integrations
• Self-directed professional growth
• Ability to help shape future platforms and integrations

We are looking for someone interested in a long-term commitment who enjoys learning, growing, and making meaningful technical contributions.

Compensation & Benefits

• Salary Range: $95,000 – $115,000 (based on experience)
• Potential for Yearly Performance Bonus - If BOD approved
• Full Benefits Package (Health, Dental, Vision)
• Paid Time Off and Holidays

Work Location & Requirements

• This role is onsite in the St. Louis, Missouri area
• Hybrid flexibility available on an as-needed basis
• Candidates should be local to the St. Louis region or willing to relocate
• Candidates must be authorized to work in the United States
• We are unable to sponsor visas for this position
• No third-party recruiters or agencies

Application Instructions

To help us identify serious candidates, please include a brief note describing your experience with:

• SQL Server
• Power BI
• Backend integrations

Applicants who do not include this information may not be considered.

Pay: $95,000.00 - $115,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Education:

• Bachelor's (Preferred)

Experience:

• Microsoft SQL Server: 3 years (Required)
• Power BI: 3 years (Required)
• RESTful API: 2 years (Required)
• C# and .NET: 2 years (Required)
• Logistics, Transportation or Operational Environments: 2 years (Preferred)
• JSON, CVS, EXCEL: 2 years (Required)

Location:

• Chesterfield, MO 63017 (Required)

Ability to Commute:

• Chesterfield, MO 63017 (Required)

Work Location: In person