Sr.Systems BI Analyst | Apply Online

CEI is seeking a Sr.Systems BI Analyst for a Contract position in Boston, MA

Job Description

Senior Systems Analyst - BI/Ad Hoc Reporting

Applicant must meet have all required skills.

Individual will be responsible for developing requirements and testing criteria for a new data mart and for creating and testing reports based on that data mart. 

The initial focus of the data mart is Institutional Investment Management data including Fixed Income, Equity and Asset Allocation specific data.  The individual will work with business users and others to develop requirements and functional source to target data mapping for the new data mart.  Responsibilities also include design and execution of data test plans.

Additionally the individual will work on the requirements, design and implementation of reports within the Oracle BI platform including the Oracle Answers, Publisher and other modules to support the reporting workflow.  The individual must have experience with BI reporting and understand terms such as Fact, Dimension, Star Schema, Ragged Hierarchy and Inner and Outer Joins. 

The individual will optimally have a deep understanding of Investment Markets and related data.  Preference will be given to individuals who understand complex investment relationships, Fixed Income, Equity, and related Derivative instruments and how to report on them.  Ideally the individual would understand and be able to define terms such as Effective Duration, Convexity, Yield, Turnover, P/E Ratios, Beta and others.  Understanding these concepts and how to properly aggregate and report on them is highly desired.

Additional information:

Must have very strong and professional communication skills

Must be able to write clearly and communicate complex concepts through writing

Must be able to work in an agile, iterative environment

Must be able to break down complex workflow into repeatable, generic processes

Must be able to be productive as an individual or as part of a team

Must be able to grasp new concepts

Must be able to understand complex data relationships

Must be able to learn new systems quickly

Must be able to prioritize tasks to maximize impact

Must be able to reverse engineer complex processes from verbal or programmatic sources

Apply Online