JerseyCityRecruiter Since 2001
the smart solution for Jersey City jobs

Data Modeler/Analyst

Company: Idexcel
Location: Jersey City
Posted on: January 11, 2022

Job Description:

Role: - - - - - - - - - - - - - - Data Modeler/AnalystLocation: - - - - - - Jersey City, NJDuration: Long TermDescription: We are looking for a Data Modeler/Analyst to join our project team. - This position is based in Jersey City, NJ.Fidelity Brokerage Technology has an opportunity for a Senior Data Analyst/Modeler. The Senior Data Analyst/Modeler will provide data analysis leadership on complex data analysis projects, often across systems and companies. They will be responsible for gathering data requirements and translating those requirements into business solutions which ensure integrated, accurate data within the organization. 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.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-Fidelity systems projects.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 queriesEducation and Experience:Degree required10 years' 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 - - 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).Type: ContractCategory: Database

Keywords: Idexcel, Jersey City , Data Modeler/Analyst, Professions , Jersey City, New Jersey

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest New Jersey jobs by following @recnetNJ on Twitter!

Jersey City RSS job feeds