Job Description :
Title:Data Modeler/Analyst
Location: Merrimack, NH
Duration:6 Months
Primary Responsibilities
Gather requirements from business and technical staff to analyze data requirements and recommend appropriate solutions.
Document database solutions and present solutions to project teams, Data Engineering team and architecture review boards.
Integrate data into existing enterprise logical model and physical data stores to avoid data redundancy.
Ensure all technical database decisions result in coherent system designs which use the most effective methods and tools.
Use modeling tool to capture clear definitions of data elements and produce code to effect database changes.
Implement data solutions to satisfy business requirements.
Act as mentor and provide guidance and leadership to junior members of team.
Provide data warehousing / dimensional modeling and OLTP modeling expertise.
Write and maintain the business rules, logic and SQL queries
Education and Experience
Experience in a technical field (analysis, development, database administration, report development
Experience in relational data modeling preferred & Data Analysis.
Skills and Knowledge
Knowledge of financial services business In depth knowledge of institutional brokerage business preferred.
Excellent requirements gathering and written and verbal communication skills.
Ability to manage workload across multiple projects and balance deadlines and deliverables.
Excellent presentation and negotiation skills.
Expert knowledge of systems development methodologies, specifically Agile.
Dexterity in using data modeling tools such as Oracle Designer, PowerDesigner, Erwin. Prefer experience with PowerDesigner.
Knowledge understanding of different database platforms, such as, Oracle, Postgres, Hadoop, Snowflake, Netezza, DB2.
Advanced ability to use SQL to query data on any of the above DBMS’s.
Knowledge and in depth exposure to modeling strategies, such as relational (logical, physical), star, snowflake, unstructured, to support OLTP, Warehousing and Data Marts, Data Lakes, MDM