Job Description :
TRN Systems Inc. has an immediate requirement for a Data Analyst for a state client in MD.

Position Responsibilities:

Perform data analysis of legacy data systems using complex SQL queries and data profiling tools.
Create and maintain data models.
Develop data dictionaries based on legacy system documents, data analysis and interaction with technical and business SMEs and other resources.
Facilitation of group meetings and documentation of outputs.
Develop data flow diagrams specifying how/what data is exchanged between databases and external parties.
Create charts, graphs and flowcharts and specifications
Identify data quality issues using SQL queries and data profiling tool and propose remediation options.
Log data quality issues and track them.
Participate in testing activities
Create staging databases using backups of production databases.
Position Requirements:

Minimum 10 years experience

Experience working with State or Federal Governments
Demonstrated Experience using the following tools:
Erwin Data modeler
Microsoft Visio
Experience using data quality assessment/evaluation tools like:
iWay Data Quality Suite including Data Profiler and Data Quality Server (Preferred)
Ataccama Data Quality Analyzer
Informatica Data Quality
Other similar tools
Experience with SQL Server RDBMS
Ability to analyze existing artifacts, rules and provide solutions to meet future needs of the agency
Demonstrated proficiency in using Microsoft-based office applications
Demonstrated initiative and ability to work in a self-directed manner to accomplish objectives
Demonstrated ability to be organized and multi-task; establish and follow priorities
Experience with Oracle and Mainframe DB2 is a plus
Experience working with State Motor Vehicle operations is a plus
Demonstrated proficiency in using Microsoft SharePoint is a plus
Demonstrated experience on enterprise data migration and conversion projects and teams is a plus