SomervilleRecruiter Since 2001
the smart solution for Somerville jobs

Senior Data Analyst - 1702704

Company: Fidelity Investments
Location: Smithfield, RI
Posted on: March 24, 2017

Job Description:

Duties: Gathers and documents data and meta-data requirements to create

conceptual, logical, and physical data models using Power Designer.

Develops design documentation, data strategies, procedures, and Data

Definition Language (DDL). Leverages technologies and tools to perform data

analysis, including WebFOCUS, Oracle Designer, PowerDesigner, Erwin, IBM

mainframe, SQL, DB2, DBMS, Netezza, Exadata, Informatica, and Agile

methodologies.

Primary Responsibilities:

• Gathers requirements from business and technical staff.

• Analyzes and translates data requirements in order to recommend

appropriate solutions.

• Presents solutions to project teams, data engineering team, and

architecture review boards.

• Integrates data into existing enterprise logical model and physical

data stores to avoid data redundancy.

• Ensures technical database decisions result in coherent system

designs.

• Uses modeling tool to capture clear definitions of data elements

and produces code to implement database changes.

• Implements data solutions to satisfy business requirements.

• Writes and maintains business rules, logic, and SQL queries.

Requirements: Bachelor’s degree (or foreign education equivalent) in

Computer Science, Engineering, Information Technology, Information Systems,

Mathematics, Physics, or a closely related field and three (3) years of

experience in the job offered or three (3) years of experience in data

warehouse and database application development; or, alternatively, Master’s

degree (or foreign education equivalent) in Computer Science, Engineering,

Information Technology, Information Systems, Mathematics, Physics, or a

closely related field and one (1) year of experience in the job offered or

one (1) year of experience in data warehouse and database application

development. Candidate must also possess: Demonstrated Expertise (“DE”)

performing relational and dimensional data modeling and analysis of

datasets for financial services; DE writing SQL queries and scripts to

extract data from large data sets within a relational database environment,

including mainframe environment and databases -- Sybase, Oracle, SQL

server, and DB2; DE analyzing datasets to create data models for reporting

and analytics applications; DE presenting business and system requirements

data solutions to stakeholders and end users.

To apply, visit http://jobs.fidelity.com and search for Job Number 1702704.

Keywords: Fidelity Investments, Somerville , Senior Data Analyst - 1702704, Finance , Smithfield, RI, Massachusetts


Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Massachusetts jobs by following @recnetMA on Twitter!

Somerville RSS job feeds