Data Integration Specialist

  • location: Chicago, IL
  • type: Permanent
  • salary: $55,000 - $85,000 per year

job description

Data Integration Specialist

job summary:
Are you looking for your next career opportunity? come support our fast-growing technology-driven data platform in the logistics industry especially focused on processing data published by cargo carriers of all modes of transportation. The Data Integration Specialist will perform the critical task of processing data files using existing ETL procedures and create new ETL tools as needed; additionally, ensuring the integrity of data as it moves from source to data warehouse. The Specialist will also be able to design the mapping and techniques to process new data formats. They will work with client-side data suppliers to establish file transfer standards and understand how to shape source data to the required data models.

 
location: Chicago, Illinois
job type: Permanent
salary: $55,000 - 85,000 per year
work hours: 9am to 5pm
education: Bachelors
 
responsibilities:
  • Build and maintain ETL mappings and workflows
  • Create and manage automated data exchanges for file retrievals and submissions
  • Work with business and client liaisons to create standardized approaches to data sharing and integration
  • Document ETL processes, programs, and configuration procedures
  • Manage post-production data quality monitoring
  • Quickly identify and resolve data- and migration-related production issues
  • Perform routine to moderately complex data analysis and design for various business applications
  • Acquire data from primary or secondary data sources and maintain data systems and integrity
  • Develop procedures to enhance reporting and query capabilities to improve efficiency and accuracy
  • Develop innovative approaches to manipulate data sets in a way that enables clients to see patterns and trends
The essential functions of this role include:

  • working in a smoke free environment
 
qualifications:
  • Experience level: Entry Level
  • Minimum 1 year of experience
  • Education: Bachelors
 
skills:
  • ETL
  • SQL
  • SQL Database admin
  • SQL SERVER DATABASE ADMIN
  • SSIS
  • SSRS
  • Excel
  • Microsoft Azure

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Applications Specialist

  • location: Schaumburg, IL
  • job type: Permanent
  • salary: $80,000 - $120,000 per year
  • date posted: 11/5/2020

    Applications Specialist

  • location: Schaumburg, IL
  • job type: Permanent
  • salary: $80,000 - $120,000 per year
  • date posted: 11/5/2020