US - IT - Data Modeler III
At a glance
Mid-level Data Architecture & Governance role at Procom Services. Mount Laurel · contract.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Design physical data models for data warehouses and data marts using dimensional modeling
- Use Oracle database design skills to assess how changes to data structures affect related work
- Create data dictionaries, data mappings and detailed design documents
- Apply ANSI SQL, ERWIN, OLTP, RUP and MS Office in data modeling work
What you bring
- At least six years with ANSI SQL, OLTP, Oracle, RUP, MS Office and ERWIN
- Six years of dimensional modeling, data warehousing, data marts and data administration experience
- Strong written and verbal communication skills for producing clear data design materials
Who this fits
This contract role suits a data modeler with hands-on dimensional modeling experience; that experience is essential. You’ll work on site in Mount Laurel, New Jersey, and the initial contract is six months, with a possible extension.
From the employer
TD Bank is a member of TD Bank Group and a subsidiary of The Toronto-Dominion Bank of Toronto, Canada, a top 10 financial services company in North America. The Toronto-Dominion Bank trades on the New York and Toronto stock exchanges under the ticker symbol "TD". For more information visit www.td.com
1 Position - Data Modeler III ANSI SQL/ W2 basis + Benefit coverage| ASAP
6 Month Contract (possible extension up to 2 yrs.)
Location: On site - Mount Laurel NJ
Interview: 1 Phone and 1 in person with hiring manager
This data modeler position requires strong ANSI SQL skills (preferably experience with Oracle), working dimensional data modeling experience and strong language and written skills to support creation of dictionaries, data mappings, and detailed design documentation. Dimensional data modeling experience is a must for this position; candidates without this experience should not apply.
MUST HAVE:
ERWIN * 6 yrs
ANSI SQL * 6 yrs
OLTP * 6 yrs
Oracle * 6 yrs
RUP * 6 yrs
MS Office * 6 yrs
SQL * 6 yrs
Dimensional Modeling experience * 6 yrs
Data Warehousing * 6 yrs
Data Marts * 6 yrs
Data Administration * 6 yrs
NICE TO HAVE:
Power Designer
Financial/Banking industry experience
Teradata FSLDM
Logical Data Models
SKILLS:
Experience in designing physical models for data warehouses and data marts.
Expertise in dimensional modeling; working knowledge of the Teradata or IBM Financial Services
Logical Data Models is a plus.
Experience in Oracle database design including the ability to perform impact analysis of data structure changes. Expertise in ERWIN, OLTP, SQL, RUP, Oracle and MS Office Tools is required;
Power Designer experience is also helpful but not required.
Strong ANSI SQL skills are required for this position.
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.