Massachusetts Information Technology Jobs

Search for Jobs in Information Technology
MassHire JobQuest Logo

Job Information

MassMutual Data Modeler in Springfield, Massachusetts

As the complexity in the world continues to increase, it’s getting harder to get simple. At MassMutual, our vision is to help people secure their future and protect the ones they love. Within MassMutual Technology, we have undergone some recent changes to simplify our organization to deliver on this vision. We will be a dependable partner to our businesses by providing high quality IT services on time and within budget. We will do so by simplifying our architecture to focus on strategically valuable technologies, investing in our people to equip them with skills of the future, and promoting a culture of ownership and delivery.

If this vision excites you, we are seeking a Data Modeler to support our Data Integration agile team. In this role, you will translate and transform business requirements into data models, be responsible for logical and physical modeling in ERWin, and drive conversations with business and development to optimize the schema structure. This is a great opportunity to be a part of a transformational journey at MassMutual. You will work closely with technology team members, communicate with Scrum Masters and Product Owners, and be a trustworthy partner with the business. The job will be varied and challenging, but it comes with a lot of growth and learning opportunities and the opportunity to work with fun-filled, knowledgeable team members.

RESPONSIBILITIES:

  • Translates and transforms business requirements into data models (conceptual, logical and physical)

  • Analyze source system data using profiling tools

  • Evaluates database and data and develop the data model appropriately

  • Design data models in data modeling tools (e.g. ERWin)

  • Communicate with key stakeholders to facilitate discussions about data modeling

  • Data mapping and data discovery

  • Develop Logical/Physical models as needed

  • Develop DDLs and execute those as needed

BASIC QUALIFICATIONS:

  • Bachelor’s degree

  • 7+ years of experience as Data Modeler on data warehouse projects

  • 7+ years of experience with ERWin or other data modeling software

  • 7+ years of experience developing service and ad hoc oriented data models

  • Strong written and verbal communication skills

  • Familiar with ETL tools such as Informatica, Talend

  • Experience working with data mapping template

  • Strong data analysis skills

  • Authorized to work in the United States without sponsorship now or in the future.

  • Significant financial or retirement services background

  • Experience with ETL

  • Experience with SQL and No-SQL

  • Experience with Agile terminologies and Agile Tools (e.g. Jira)

  • Comfortable working in ambiguity

DirectEmployers