SSIS Developer

Post Date

Jun 12, 2025

Location

New Bremen,
Ohio

ZIP/Postal Code

45869
US
Aug 13, 2025 Insight Global

Job Type

Perm

Category

Programmer / Developer

Req #

COL-788342

Pay Rate

$95k - $140k (estimate)

Job Description

The Data Engineer is a critical role in the development of InfoLink, Crowns global fleet management software solution.

Programming - Design, build and optimize scalable SSIS ETL data pipelines and stores. Clean, prepare and optimize data for consumption in applications and analytics platforms. Participate in peer code reviews to uphold internal standards.
Testing - Ensure procedures are thoroughly tested before release. Write unit tests and record test results. Detect, define, and debug programs whenever problems arise. Assist with system testing.
Documentation and Training - Provide training to users and knowledge transfer to support personnel and other staff members as required. Prepare system and programming documentation in accordance with internal standards.
System Analysis - Interface with users to extract functional needs and determine requirements. Conduct detailed systems analysis to define scope and objectives and design solutions. Create documentation per internal standards. Work with Business Analyst to help develop and write system requirements.
Project Leadership - Establish project plans and schedules and monitor progress providing status reports as required. Perform other duties as assigned.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form. The EEOC "Know Your Rights" Poster is available here.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

Bachelors degree in Computer Science, Software/Computer Engineering, Information Systems, or related field
Minimum 3 years of related experience, including SQL Server, NoSQL, ETL using SSIS, and Data Integration
Main need is SSIS development experience
Migration of moving from MySQL to SQL server- migrating the data and data structures
Reliable transportation to travel locally between company locations during scheduled workday

Nice to Have Skills & Experience

Data-related experience with, or similar to:

AWS Technologies (RDS, SQS, S3, EC2, etc.)
SQL Server, C#, .NET
SSIS ETL Development
SQL (query language), basic understanding of transactional and reporting databases, strong problem-solving skills and ability to work independently.
Python, GitHub, PowerBI
Familiarity with Kanban/Agile practices, test driven development
Aurora/MySQL (SQL)
DynamoDB (NoSQL)
Kibana (log files

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.