Database Analyst/ Programmer

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 84 Month(s)

Skills

Database analyst
Data Analysis
Data Cleansing
Data Conversion
Data Profiling
Data Structure
db2
sql

Job Details

Title : Database Analyst/ Programmer
Location : Raleigh, NC
Duration : 12 + Months

In-Person Interview

Job Type : C

Description : Under the direction of a data architect, this position will conduct data profiling, data analysis, data cleansing, database design, database implementation, data conversion, and data governance for the State's DMV data.

Typical Experience: 84+ months

Role Types: Database Analyst, Database Programmer

Expected Skills: Able to work in a team environment as well as without assistance; can provide input and feedback to others; able to manage highly complex work efforts; may have advanced education; may have extensive industry experience.

Description (including, but not limited to):
1. Data analysis and database management
2. Designing of data dictionaries, physical and logical database models, and performance tuning
3. Creation of requirements for database, database schema, data maps, ERDs, application objects (i.e., tables, indexes, views, etc.)
4. Creation of data rules to identify areas for data cleansing
5. Conducting data profiling, data analysis, data cleansing, database design, database implementation, data conversion, and data governance for the State's DMV data

Skills :

Skill

Required / Desired

Amount

of Experience

Understand data structures and schemas, and implementing appropriate indexes

Required

3

Years

Able to create logical and physical models of data to represent relationships and ensure data integrity

Required

5

Years

Working knowledge of DB2 and SQL Server database management systems (DBMS)

Required

3

Years

Understanding of the process of extracting data from various sources, transforming it, and loading it into a database

Required

5

Years

Use of at least one data cleansing tool

Required

2

Years

Able to create and execute test cases

Required

5

Years

Able to identify and resolve issues within the data cleansing process

Highly desired

3

Years

Able to clearly communicate technical information to both technical and non-technical audiences

Highly desired

3

Years

Must meet deadlines and manage multiple streams of work

Required

5

Years

Able to dissect complex problems and derive insights from large datasets

Highly desired

3

Years

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.