This site uses cookies. To find out more, see our Cookies Policy

Database Analyst I in Bloomington, IL at Vaco

Date Posted: 1/24/2019

Job Snapshot

Job Description


SUMMARY:

A Database Analyst 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. A Database Analyst will work with account managers and technology staff to successfully execute customer solutions. Relies on instructions and pre-established guidelines to perform the functions of the job. 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.

ESSENTIAL FUNCTIONS & RESPONSIBLITIES:

The below statements are intended to describe the general nature and scope of work being performed by this position. This is not a complete listing of all responsibilities, duties and/or skills required. Other duties may be assigned

  • Reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams.
  • Well versed with MS SQL. Ability to write and understand 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 Bloomington TC SCS 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.
  • 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.
  • Ability to maintain C# / .NET applications is a plus.
  • Java experience is a plus
  • Knowledge of any data platform (ETL) especially Talend is a plus

Job Requirements

sql, data decomposition diagrams, data sources, etc

CHECK OUT OUR SIMILAR JOBS

  1. Business Analyst Jobs
  2. Systems Analyst Jobs