Previous Job
Previous
Data Modeler / Architect
Ref No.: 18-67444
Location: Plymouth Meeting, Pennsylvania
Position Type:Full Time/Contract
Start Date: 09/13/2018
JD

RR Number 112917
Job Location (with City & State) Plymouth-Meeting, PA
Project Duration Long Term
Project Start date ASAP
Buy Rate Rate: $75 to $80 per hour on C2C
Salary: $120-$130k per annum + benefits
No of openings/positions 2
Job Title/Role Data Modeler / Architect
Mandatory Skills
  • Experience with data modeling tools, specifically ERwin
Hiring Mode – (TP / FTE / W2) C2H OR FTE Only
Preference on Work Authorization
  • This position is only for candidates who do not require sponsorship now or in future. We are unable to sponsor for this role.
  • We would require candidates who can join within 1 to 2 weeks' time.
Third Party is allowed
Client Interview Needed for Selection (Yes / No) Yes
Detailed JD (Pl share the Detailed Description, 1 liner JD will not work)
  • Contribute to Data Architecture by providing ongoing analysis of
enterprise data stores to ensure the overall architecture remains
appropriate and optimal for current and planned usage.
  • Participate in requirements gathering, technical specifications,
architectural design and support development as it relate to database
design, access and utilization.
  • Contribute to the overall direction relative to systems of record and how
data compliance and regulations affect the handling of data among
applications and the overall design recommendations.
  • Serve as a resource to less experienced team members on escalated
issues and as a training resource on understanding and handling the
company's data.
  • Receive complex work problems/questions, develop accurate estimates
and create project and component work based on specifications.
  • Develop SQL code of medium to high complexity in support of these
activities and provide direction to others on how to handle the question
going forward.
  • Data Warehouse Modeling using Erwin, Develop technical standards and specifications for database models and data warehouse performance.
  • Provide guidance and direction on data warehouse modeling best practices and procedures.
  • Provide direction and definition of data modeling strategy and delivery


Skill Set
  • Experience with data modeling tools, specifically ERwin Strong native SQL skills.
  • Strong experience in database and data warehousing concepts and techniques.
  • Must understand: relational and dimensional modeling, star/snowflake schema design, BI, Data Warehouse operating environments and related technologies, and ETL, MDM, and data governance practices.
  • Some experience with Data Virtualization team
Comments NA