Job Description :
TRN Systems Inc. has an immediate need for a Data Analyst in New Jersey.

Role : The Data Analyst will work closely with requirements analysts and data architects to understand business needs and to translate the specific requirements into appropriate database designs. This role requires interaction with the various teams to bind together the gaps to culminate in a successful project.

Develop, design and test complex program logic in order to produce analytical reports and spreadsheets.
Providing support to analyze data requirements and data stored in a disparate set of systems and designing a robust relational structure for the future
Developing a solution to extract data out of the existing systems and store in the future system
Maintain proper documentation for projects and comply with audit requirements.
Conducting Business Requirements Analysis and educate the various project teams on the proper usage of data structures and data flows.
Conducting data profiling and data analysis on source and target systems
Excellent Oracle SQL skills with the ability to validate data model functionality and performance using SQL
Work closely with the project managers in coordinating the implementation of projects.
Must be detail oriented with the ability to pay close attention to detail and accuracy of work.
Must have good communication skills and ability to work in a fast-paced environment
Great communication and organizational skills.
Strong technical writing skills.

Participate in requirements gathering, project estimation and management
Review and creation of documents and diagrams: Data mapping, Data dictionaries, Metadata
Review and generate business rules for data
Research and document data flows
Research and document application integration solutions, ETL, SQL, etc.
Provide thought leadership regarding: Industry practices around collecting data, staging data, cleansing data, standardizing data, and publishing data into transactional systems and data marts.