Whether you are an experienced professional or a recent graduate, Ebix provides an environment that allows you to explore a dynamic career path to achieve your personal goals.

  • Job Location:
    (United States)
  • Job Division:
    Ebix Consulting
  • Job Type:
    Data Architect

The Reporting Architect will be responsible for the design and maintenance of data marts, reporting and other data provisioning involving General Investment Account and related investment data. This is a newly created position supporting both the Investment Data Optimization Program as well as the ongoing requirements of MassMutual groups consuming this data. As this is a new team, development and institution of procedures to ensure consistency of approach and high quality delivery will be important initial activities. The relevant user community includes the Investment Management, Accounting, Treasury, Enterprise Risk Management and various operations teams. Emphasis will be on the reporting tools embedded in the Eagle Investment Systems solutions including Eagle canned reports (STAR, RDC, Pricing Center, etc) and Data Marts, as well as Cognos as a reporting tool to access the Eagle data. There is potential for the introduction of additional solutions in the future.

The reporting function will leverage an onshore/offshore model for delivery. In addition to the Reporting Architect and the Reporting Manager, initial staffing will consist of a Metadata Analyst, Reporting Analyst, and onshore/offshore outsourced developers. This model allows a scalable function to better meet demand for report development and maintenance, which is expected to be heavy during the initial go-live period of the Eagle PACE and STAR solutions.

US Citizens and Green Card Holders may apply.

Job Responsibilities and Requirements:

  • Serve as a point of contact for investment data provisioning and reporting. This includes the triage of issues and new requests from the end user population.
  • Work with data consumers to develop and document new data requirements.
  • Oversee the data mart and Cognos framework design to ensure efficiency, best practices, and consistency of approach.
  • Support the development and maintenance of data marts, Cognos framework, extract queries, and reporting utilizing MIDOT suite of tools including Eagle, Cognos, Tableau, and SQL Developer.
  • Work with the Reporting Manager to determine optimal workflow for mart/report development including developing locally and outsourcing.
  • Serve as a key point of contact for outsourced development resources.
  • Work with data consumers, MassMutual Technology Architects, and strategic partners to determine and execute optimal data distribution strategies including selecting from available report, query and data mart solutions and participating in selection of additional tools as needed.
  • Partner with Reporting Analyst to ensure best practices are followed and governed in the distributed report development model.

Basic Qualifications:

  • 5-plus years of reporting/data distribution experience.
  • Understanding of the investment data domain and the related reporting requirements.
  • Experience with a range of data mart and reporting solutions.
  • Expert in SQL (writing queries, complex scripts, extracting data etc).
  • Expert in Excel (pivot Tables, data comparison, data manipulation etc).
  • Ability to handle ambiguity and constantly evolving requirements.
  • Comfortable taking initiative and working independently but knows when to involve others.
  • Comfortable working with stakeholders from a wide range of functions and seniority levels.
  • Strong collaboration skills and the ability to work in a team based environment.
  • Familiarity with release management processes and experience managing the migration of development components.
  • Bachelor’s degree in a Computer or Finance related major.

Preferred Qualifications:

  • Experience with Eagle Investment Systems reporting tools is a major plus.
    1. Data Marts
    2. Eagle canned reports
  • Experience with Cognos is a plus.
  • Experience with large scale data management/business intelligence projects including data warehousing solutions.
  • Understanding of the Investment Management process and the related data flows.


Apply Now

Share This Job:

In addition to the current job openings listed, we keep looking for candidates, for all our worldwide locations, with expertise in areas like -

  • Marketing/Sales/Business Development
  • Software Development
  • RCS
  • Business Analysis and Domain consulting within:
    • P&C Insurance
    • Life and Annuity
    • Employee and Health benefits
  • Enterprise Application Architecture

To join Ebix, you can register with us to upload your resume.

Register Now