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, Waltham , Senior Data Analyst - 1702704, Finance , Smithfield, RI, Massachusetts