Job Description :
Job Title: Data Modeler
Location: Durham, NC
Duration: 6+ months
Description:
We are seeking a candidate that will provide data analysis leadership on complex data analysis projects, often across systems and companies.
They will be responsible for translating and gathering data requirements those requirements into business solutions which ensure coordinated, accurate data within the organization.
Data modeling work will include design documentation, logical and physical models, including OLTP, dimensional and object models, data strategies, standards and procedures and data definition language (DDL)! Are you ready to take your career to the next level?
Primary Responsibilities:
Capture 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 and act as mentor and provide guidance and leadership to junior members of team.
Perform research into emerging technologies, define data solution standards and guidelines, and drive technical approaches at a tactical level, serving as the data engineering member on FI and cross-Client systems projects.
Provide data warehousing / dimensional modeling and OLTP modeling expertise as well as write and maintain the business rules, logic and SQL queries
Education and Experience
Degree required along with 10 years’ of experience in a technical field (analysis, development, database administration, report development
6 years’ experience in relational data modeling preferred & Data Analysis.
Skills and Knowledge:
Knowledge of financial services business 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
Excellent presentation and negotiation skills; Expert knowledge of systems development methodologies, specifically Agile.
Dexterity in using data modeling tools such as PowerDesigner or Erwin. Prefer experience with PowerDesigner.
Knowledge and 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