SourceGas, LLC ETL/Integration Support Analyst I in Rapid City, South Dakota

ETL/Integration Support Analyst I

Apply Now

Job ID :


Category :

Information Technology

Location :

Rapid City, SD

Apply Now

Description :

Job Specifications

PAY RANGE: $21 - $27 per an hour.

Base salary is determined by the knowledge, skills and abilities of the applicant.

CLOSING DATE: This position will close on October 26, 2018.

LOCATION: Rapid City, SD


Responsible for supporting and troubleshooting enterprise integrations including extract, transform, load (ETL) processes, web services, APIs and point-to-point system integrations. This position will be responsible for ensuring support duties around the integration and business intelligence landscape are in order. This position will be expected to provide support in a timely manner as well as document support issues and their resolutions. You will work with delivery personnel to help provide direction on issue resolution and support recommendations.


Reports to application development manager with further direction and support from Senior and Principle roles.


  • Support, investigate and troubleshoot ETL/integration solutions.

  • Document support issues with ETL/Integration processes and solutions.

  • Monitor helpdesk tickets for issues and requests assigned to the team.

  • Monitor and administer automated ETL processes to verify execution and measure performance

  • Strive to continuously improve solution delivery processes and practices.

  • Understand and navigate data warehouse and/or data marts to provide support to end users regarding data issue or data questions.

  • Assist in the ongoing development of technical best practices for ETL-related activities including data movement, quality and cleansing.


  • Attend meetings with technical peers regarding BI/Integration solutions

  • Ability to handle support situations and deadlines with minimal supervision

  • Research potential solution for ongoing or outstanding issues.

  • Work with internal staff and/or vendors to assist with support issues.

  • Create reports and report templates.

  • Provide feedback to developers to help improve product delivery.

  • Provide Quality Assurance and Quality Control testing and provide feedback to developers.


  • Will support one or more client groups including interaction across all levels of the organization.


  • Excellent oral and written communication skills.


  • Minimum education of an Associate‚Äôs degree.


  • Associate degree in Computer Science, Application Development, Analytics, Data Warehousing or equivalent experience.


  • Knowledge and experience with object oriented programming languages preferred.

  • An understanding of relational databases and dimensional database models (star schema)

  • Experience with Business Object Data Services, Web Intelligence, Crystal Reports and Business Objects is a plus.

  • Experience with MuleSoft Enterprise Service Bus is a plus.

  • Basic knowledge of server based computing environment, including computer hardware, operating systems, networking, and middleware and database management systems.

  • Basic knowledge of information engineering concepts, including business area analysis, business system design, data modeling, and application construction.

  • Depending upon programming assignments, experience with but not limited to programming languages including Java and .NET.


  • Experience with Business Intelligence and Data Warehousing.

  • Experience with Extract, Transform and Load processes.

  • Experience with Process Mapping.

  • Experience with Object Oriented programming.

  • Experience with Web Services.

  • Experience with relational database concepts.


  • Applicant must be able to perform the essential job functions of the position with or without accommodation.

The information contained in this position description describes the general nature and level of work being performed in this job. This description is not intended to be an all-inclusive list of responsibilities, duties, and requirements for employees in this position. The incumbent is responsible for performing all duties in a safe and efficient manner in compliance with safe work procedures and safety regulations. This job description is not intended to constitute an offer or contract of employment. Job descriptions may and do change periodically. Where positions are covered by a collective bargaining unit agreement, the terms and conditions of the collective bargaining unit agreement will apply.

We are an EEO Employer