Powershell-Need GC and USC

USM; St. Louis (MO); On-site; USD 55,000 - 83,000; Full time

Job summary

USM Business Systems in St. Louis, MO seeks a Power Shell Consultant for a 6+ month engagement. The role focuses on analyzing and structuring data, automating processes, and building database solutions from Excel data sources.

Candidates should have PowerShell, VBScript and SQL skills, with GC/USC eligibility. The assignment supports the implementation group with data-driven reporting and automation tasks.

Qualifications

• 6+ months engagement in a PowerShell-focused role.
• Strong PowerShell and VBScript capabilities.
• Intermediate SQL skills and Excel familiarity.

Responsibilities

• Analyze unstructured data and structure it into databases.
• Create forms and automate processes within the database.
• Extract data from multiple sources and upload it to the database.
• Develop and run data reporting to verify accuracy.

Skills

PowerShell

VB Script

SQL

Job description

Businesses face challenges every day building responsive and agile IT capabilities to grow and stay ahead. Since everyone has access to the same tools, your competitive advantage directly depends on how you apply technology – on the people leading, supporting and optimizing your IT initiatives. USM Business Systems, established in 1999, is an industry-leading private talent management firm, specializing in providing unique IT turnkey solutions, IT staffing solutions, andTalent managementinsights, enabling you to sustain a truly competitive advantage in this fast-moving environment. USM has offices throughout the US and offshore delivery centers in India. USM is a certified Minority Business Enterprise and is a CMMi Level 3 Organization.

USM is recognized as one of the fastest growing IT Temporary Staffing firms in the US and most recently was ranked #3 on the list of the Top Temporary Staffing firms in the DC Metro Area – Washington Business Journal (2016).

Job Description

Power Shell Consultant

6+ Months

St. Louis, MO

Need GC and USC

Top Three Skills:

1. Powershell - this tool is utilized to help automate the process.

2. Visual Basic Scripting

3. SQL (intermediate skills are needed in this area).

Job Description:

Right now they are supporting the implementation group. The Implementation is gathering lots of unstructured data. Right now there data is in excel spreadsheets and they need someone to look at the data, analyze and put in reasonable structure and put in databases. Also, this person needs to do reporting. They will be assessing - is the data correct or incorrect? Then they will be updating the data and the database. It’s not application development.

This team just hired on a candidate with strong SQL development skills and now they need someone that is strong in Powershell and VB Scripting. This person will be taking data and creating forms to creative an interactive form (automating in the database). They will be extracting data from different sources, putting it into a format and uploading it into the database.

They will need intermediate SQL skills and knowing around Excel because data is in Excel. What can we do to automate this as much as possible?