Specialist Data Analyst/Developer - Oracle/SQL - strong Database skills

  • Competitive with full benefits
  • Pittsburgh, PA, USA
  • Permanent, Full time
  • BNY Mellon
  • 22 Sep 17

Data Analyst: In need of a very strong Data Analyst/Developer. 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.

~Data Analyst:

In need of a very strong Data Analyst/Developer.

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.

 

Skills:

•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 in form of flowcharts and process/business models 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.

 

 

Responsibilities:

•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.

 

Experience:

•At least have a minimum of 7 years of experience using above skills.

•Should have interacted with QA testing teams in multiple projects.

•Preferably have worked in conjunction with onshore and offshore teams.

 

 

Qualifications

Bachelor's degree in computer science or a related discipline, or equivalent work experience required, 6-8 years of experience in data modeling, data warehousing, data entity analysis, logical and relational database design, or an equivalent combination of education and work experience required, experience in the securities or financial services industry is a plus.

 

 Preferred:

•At least have a minimum of 7 years of experience using above skills.

•Should have interacted with QA testing teams in multiple projects.

•Preferably have worked in conjunction with onshore and offshore teams.