Job Description :
Interview: phone + onsite (no skype)
Title: Data Modeler with Erwin experience
Location: Springfield, MA
Duration: 12+ months contract
Description:
As the complexity in the world continues to increase, it’s getting harder to get simple. Our vision is to help people secure their future and protect the ones they love. Within our 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 us. 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
Experience as Data Modeler on data warehouse projects
Experience with ERWin or other data modeling software
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
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