Previous Job
Previous
Senior Data Modeler
Ref No.: 18-00628
Location: Tempe, Arizona
Position Type:Contract
Start Date: 07/09/2018
Senior Data Modeler- Tempe, AZ Contract Opportunity

Position: Senior Data Modeler

Job Description:
The qualified and motivated candidate selected for this position will be responsible for building and refining data modelling solutions in a complex distributed data warehouse environment. Responsible for the analysis and design of this environment, focusing on and supporting data modeling and other related services.

Essential Functions:
  1. Partners with Business and IT groups to design and implement data and modeling solutions that meet or exceed organizational initiatives and are consistent with enterprise architectural standards.
  2. Ensures compliance with all architecture directions and standards through cross organization consulting and direct involvement in development efforts.
  3. Develops and documents artifacts and templates in the chosen tool repository.
  4. Understand the Project Proposal and assist the team in analyzing how the new system or functionality can be integrated in the environment, identifying existing systems, concepts, possible data sources and issues
  5. Develop, validate and communicate modeling solutions, including both relational and dimensional models
  6. Analyze data-related systems integration opportunities and challenges
  7. Ensure solution designs address performance requirements and reusability, availability, integrity and security challenges, and business functional requirements
  8. Partners with the Data Architects, Clients, ETL developers, Business Systems Analysts and other technical data warehouse team members and database administrators to design and develop high performing data models and maintain consistent data element definitions.
  9. Create Conceptual, Logical data models that need to be validated with Business Users for current projects as well as other impacted projects
Required Experience:
  1. 7-10 years' experience in a Data Modeler role with deep knowledge of Relational and Dimensional Modeling in a Complex Data warehouse environment.
  2. MUST have Erwin 9.5 Model Mart experience for developing the Data Models.
  3. MUST be Strong in Oracle Data Warehousing Design and Oracle SQL
  4. MUST be strong in Dimensional & 3NF Data modeling.
  5. Preferred to have Banking and Financial Services Experience.
  6. Experience in Master Data Management.
  7. Excellent Communication skills.
  8. Should have Good inter personals skills.
Required Skills:
  1. Expertise in Relational Data Models (conceptual, logical and physical data models), Dimensional Data Models, Data Dictionary, Metadata and Business glossary
  2. Expertise in implementing Data warehouse solutions, Operational data stores and real time data integration.
  3. Familiarity with Retail and Commercial banking, Consumer Banking, Mortgage and Dealer lending concepts desired.
  4. Experience with Development Methodologies, Databases Platforms (Teradata, Oracle/ SQLServer), including deep knowledge in SQL & PL/SQL.
  5. Expertise in Data Modeling tools (Erwin/Model Manager).
  6. Superior relationship management, consultative, presentation, and communications skills.
  7. Sound leadership, negotiation, critical thinking, and project/time management skills.
Education:
MS in Computer Science, Software Engineering, or Information Systems.