USA Jobs, Careers and Recuitements
Job Target Job Search

Contact Information

Company: ACROSTAFF Jobs
Contact Name: DAVE

Job Details: Data Modeler Consultant Date: Aug 22 2019

Job Reference: 10140
Job Category: IT Jobs [ View All IT Jobs Jobs ]
Company Type Employer
Employment type: Full Time, Contract
Salary: 75 USD / Contract
Degree: Masters
Experience: 3 years
Location: Boston, Massachusetts, 02103
Job Skills: Data Modeler Consultant
Share Job with Others

Job Tools

Job Description

Data Modeler Consultant

Main Responsibilities:

As part of the DW BI Redesign project the current Sales Reporting data warehouse will be redesigned and rebuilt.

The goals of this project are to rebuild the FMG Data Warehouse based on the business requirements and high technical standards, implement a more simplified, efficient and extensible Data Warehouse with minimum architectural complexity to provide better, higher quality reporting, data analysis and a consistent view of data across various source systems and provide FMG Sales managers and team members with easy access to high quality, consistent and timely sales reporting that is flexible enough to change as the business evolves.

 Understand DW, ETL and BI technical architecture
 Analyze business processes and reporting requirements
 Consume DW Bus Matrix for data modeling
 Participate in data model design pattern discussions within data modeling team
 Create conceptual/logical/physical Data Models with other data modelers for DW including ETL processing data structure by using ERwin
 Follow model management process, data naming standards, data modeling strategy and guidelines for using ERwin during data modeling
 Generate base DDL scripts from ERwin and maintain them through version control tool (Subversion)
 Communicate with the DBA team for physical database implementation and performance tuning
 Provide technical metadata for Source to Target data mapping
 Document data model change details and keep all the related documents up-to-date.


� 5+ years of experience modeling data, both relational and dimensional modeling in a Data Warehouse environment
� Strong communication skills, both oral and written in individual and group situations
� Experience using ERwin.

Minimum Qualification

� Demonstrated knowledge of Data Modeling methodologies in a warehouse environment
� Experienced in concurrent data modeling environment with other data modelers using ERwin Data Modeler Workgroup Edition R8.2

� Strong data warehouse analysis skills: reporting analysis, source data element analysis and system/business process analysis in a Data Warehouse environment
� Experienced in full lifecycle data warehouse development
� Familiar with Kimball data warehouse lifecycle approach, Bus Matrix and Metadata integration
� 5+ years of recent experience writing Structured Query Language (SQL)
� Excellent analytical and troubleshooting skills
� Ability to work independently, as well as collaboratively with data warehouse development team
� Worked with the DBA team for database, communication, and planning
� Used version control tool like Subversion

Preferred Qualifications
� Familiar with Informatica
� Familiar with Cognos
� Financial industry experience
� Experience with Subversion

Copyright © 2019 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.