Database Analyst in Bloomington, IL at Volt

Date Posted: 9/12/2018

Job Snapshot

Job Description

Volt Workforce Solutions is looking for a Database Analyst for one of the top 3 graphics communications companies in North America. After reading the job info below, if interested, email an updated resume (in Word format).
Job Title: Database Analyst
Location: Bloomington, IL
 Position Summary:
 A Database Analyst 2 may assist in business systems design, analysis and programming services to modify existing programs, write new programs or processes that import, export, transform and/or visualize data. Possesses and applies a broad knowledge of principles, practices, and procedures related to IT data processing and transformation and visualization of data for completion of moderately complex assignments. A Database Analyst 2 will work with account managers, sales staff, and technology staff to successfully execute customer solutions. 
Responsibilities:
• Reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. 
• Well versed with MS SQL. Ability to write and understand complex SQL query. 
• Imports data from a variety of sources and media and converts received data into usable formats that can be used with variable print software to produce customize print pieces. 
• Writes codes for database access, modifications, and constructions including stored procedures. 
• Creates new or transformed data and identifies data relationships through various processes and algorithms. 
• Creates and maintain business logic for multiple data sets including direct mail address processing and standardization: merge / purge, ACE and grouping multiple addresses into a single household and so forth 
• Works with DBAs to design, correct and/or modify database schemas including creating tables and defining proper indexes and primary keys based on their entities, relations (normalization), expected volume and distribution of data. 
• Collects specifications from project managers, sales staff, business analysts and account executives that support the overall customer program. 
• Develops production schedules for use by production personnel. 
• Develops applications that provide information to Pii’s internal departments. 
• Develops queries, retrieves, manipulates and displays data from relational databases for the purpose of ad hoc reporting as requested by clients, account executives and other associated staff. 
• Ability to maintain/write C# / .NET applications is a plus. 
• Follow test scripts to test programs and processes to ensure they work properly and meet client requirements. Correct any problems encountered during testing. 
• Provide technical documentation of applications including flow charts, specifications and end user documentation. 
• Knowledge of any data platform especially Talend is a preferred 
• Perform code reviews and ability to identify performance issues with SQL query and stored procedure. 
Qualifications: (Required to perform essential functions) 
The requirements listed below are representative of the knowledge, skills, and/or abilities required to successfully perform this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.
• Bachelor’s Degree in Computer Science, related field or equivalent experience preferred
• 3 – 5 years of related/relevant professional industry experience including direct marketing, e-commerce, print, graphic design and insurance and financial services or 3– 5 years in the rank of Database Analyst 1
Other Abilities: (to include technical/equipment skill capabilities, regulatory and/or licensing requirements)
• Microsoft Office product suite (Word, Excel, Outlook, Visio, PowerPoint).Microsoft SQL Server 2012 or greater
• Scripting client/server stored procedures
• Knowledge of any data processing platform is a plus
• Familiarity with Visual Studio 2015 or greater
• Knowledge of C#, .NET Framework and or Java is a plus
• Remain current on new technologies and best practices in information technology industry
• Any knowledge of windows Azure is beneficial.
Work Schedule:
1st shift
As a Volt employee, you can expect the highest level of support.  We have a long-standing tradition of developing lasting and mutually beneficial relationships with our employees.  Contact a Volt representative by applying to this posting online for immediate consideration. Submit your resume today! To learn more about Volt, please visit: http://www.volt.com and to see more of our job postings, please visit: http://jobs.volt.com
Volt is an Equal Opportunity Employer.
Pay Rate is based on experience.    

CHECK OUT OUR SIMILAR JOBS

  1. Business Analyst Jobs
  2. Systems Analyst Jobs