Notice: A session had already been started - ignoring session_start() in /home/peerss5/public_html/peer_ats/modules/careers/CareersUI.php on line 2
Peer Solutions Group - Careers

Shortcuts:

IMAGE: Return to Main IMAGE: Show All Jobs

Position Details: ETL Developer (SSIS, SSRS) - Des Moines, IA

Location: Des Moines, IA
Duration:
Type: Contract

Description:

We are hiring a Senior level ETL Developer who may work with more than one database architecture or have deep knowledge in a specific application database or set of databases to support architectural or decision support activities.

 

Location: Des Moines, IA
Duration: 12+ months
Candidate Type: W2 or Corp-to-Corp

Interview Type: In Person only

Responsibilities

  • Refine business requirements into technical requirements and specifications
  • Design and develop SSIS packages, database objects, tables, stored procedures and views
  • Performance tuning the stored procedures and T-SQL.
  • Communicate accurate and useful status updates
  • Manage and report time spent on all work activities
  • Data extraction from WSI SQL tables
  • Mapping of worksheets to import table supplied by BasicGov
  • Validated imported data
  • Build cross-reference SQL table to equate WSI data to new SQL data
  • Execute this process multiple times to verify all pertinent data is exported and imported
  • Support go-live
  • Analyze and digest business and technical requirements as provided by multiple sources
  • Analyze and develop mapping and translations between the data elements in client, carrier and payroll systems, interfacing with the Benefitsolver platform
  • Manage towards test plans with clients and carriers, testing the data exchange process end-to-end
  • Build import files from various data sources and execute the data import process end-to-end
  • Develop XML configuration files from Businessolver to carrier and payroll systems; coordinate and test ETL processes or EDI feeds with external vendors
  • Manage towards project plans and timelines based on assigned priorities
  • Communicate with all internal and external partners in a pleasant, professional manner and with an attitude that promotes Business partner’s goals and core objectives
  • Be a self-starter who has the ability to prioritize and execute.
  • Critical thinking skills and ability to solve problems; detail-oriented with a high degree of accuracy and follow through
  • Expertise with Excel; experience with Access, XML, JavaScript, ETL and text files a significant plus
     


Required/Desired Skills

Skill

Required / Desired

Amount

of Experience

Solid experience with Microsoft SQL Server 2008 R2 and above

Required

8

Years

Developing packages with SSIS

Required

8

Years

Strong knowledge of XML, schemas

Required

8

Years

T-SQL language (queries, views, procedures)

Required

8

Years

SQL Reporting Services

Required

8

Years

Strong analytical/mathematical and reasoning skills.

Required

8

Years

Ability to work in a team environment

Required

8

Years

Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision

Required

8

Years

Strong written and verbal communication skills

Required

8

Years

Large-scale data migration experience

Required

8

Years

Data warehousing concepts

Required

5

Years

Agile Methodology

Desired

 

 

Understanding of RDBMS and Data Warehouse designs

Desired

 

 

SQL Server database troubleshooting and query optimization

Desired

 

 

SQL Server Database Design

Desired

 

 

 

About Peer Solutions Group, Inc.

Peer Solutions Group, a full-service, Minority Certified (MBE) IT Services company founded by professionals with hands on experience in Staffing, Recruiting, Project Management, Technology and Consulting. Since the past 10+ years, we have helped our customers strengthen their competitive advantage, reduce operational costs, and improve efficiency by providing our Personalized Effective Efficient Reliable services with integrity, intellectual growth, quality, respect and positive thinking. Our core capabilities include but are not limited to:

  • Robotic Process Automation (RPA)
  • Business Process Analysis, Re-engineering and Automation
  • Cyber Security Consulting
  • Project Management Consulting
  • Custom Application Development/Programming
  • IT Staffing - Contract & Permanent

Peer Solutions Group is an Equal Opportunity Employer and is committed to providing the right opportunities for the right people. We have a culture of entrepreneurship and innovation where our employees can make a difference. We are looking for like-minded, dynamic individuals to come and join our rapidly expanding team
.

Perform an action:

IMAGE: Apply to Position




Powered by: CATS - Applicant Tracking System