Title: Senior Data Modeler
Location: San Jose, CA
Duration: 12+ months
JOB DESCRIPTION:
The "data modeler" needs to be well versed in "ER Modeling" and have a good understanding of business process. A candidate with knowledge on "Information Engineering" will be suitable.
- Work include: Data Analysis/profiling, reverse engineering of data, obtain business meaning of data attributes.
- Tools: Data modeling tool (ER/Studio Data Architect or ERwin preferred)
Responsibilities:
- The Data Modeler will provide Client with services to create and maintain enhancements to the Clients Enterprise Logical Data Model and modeling efforts associated with the Enterprise Reporting and Business Intelligence initiative based on an Enterprise Data Warehouse (EDW).
- Data Analysis/profiling, reverse engineering of data, obtain business meaning of data attributes.
Data Modeling
- Working with EA-Data & Information Architecture team to create Enterprise Logical Data Model in alignment to modified logical models, with emphasis to abstracted enterprise level view and normalized logical data model (detailed).
- Logical data modeling and metadata collection will be captured in ER/Studio Data Architect in the form of Entity Relationship Diagrams (ERD)
EA -Modeling Activities
- Create logical models for EDW with implementation model conforming to 6 layered architecture
- Enhance Enterprise logical data model consisting of enterprise shareable entities & their relationships, (Normalized ERD). The work product shall include necessary metadata as defined in the logical modeling standards
- Bookings model enhancements to conform to 6 layered architecture
- Assist and advise, if deemed necessary, on enhancing standards and propagating the usage of standards across the organization
DESIRED EXPERIENCE:
- 10+ years of overall IT experience
- 5+ years of experience creating detailed Logical Data Models
- Models in 3rd normal form, fully attributed, suitable for use in creation of a separate Physical Data Model especially desirable if for Data Warehouse
- Use of facilitated workshops (JAD sessions) with SMEs (Subject Matter Experts) to gather information and conduct analysis for Logical Data Modeling
- Experience in other types of Logical Data Modeling is desirable as well, including Conceptual Data Model, Subject Area Data Model, and Enterprise Data Model
- Understanding of the overall Software Development Life Cycle and different development methodologies
- Strong communication skills and ability to work effectively in multi-cultural environment as well as to gain consensus in working with a group of people
- Strong analytical skills in depth experience in the analysis process that underlies creation of a Logical Data Model
- Determining the meaning of data through the analytical process
- Giving the data a meaningful name base on the meaning
- Writing a useful, articulate definition of the data
- Ability to train other participants in data modeling workshops as required
- Some ability to write simple SQL code is desirable
- Experience modeling for Data Warehouse and understanding of Data Warehouse architectures is desirable
- Experience with ER/Studio Data Architect or Erwin is desired
- Well versed in Conceptual & Logical Data Modeling (3NF)
- Must have worked with ER/Studio or ERwin data modeling tool
- Well versed with "Enterprise Data Warehouse" Inmon/Kimball hybrid architecture (CIF)
- Experience with IDEF1X methodology for logical data modeling
- Work experience with Teradata environment is a plus.
- Familiarity with Dimensional Modeling is a plus
-- Location: San Jose, CA
Duration: 12+ months
JOB DESCRIPTION:
The "data modeler" needs to be well versed in "ER Modeling" and have a good understanding of business process. A candidate with knowledge on "Information Engineering" will be suitable.
- Work include: Data Analysis/profiling, reverse engineering of data, obtain business meaning of data attributes.
- Tools: Data modeling tool (ER/Studio Data Architect or ERwin preferred)
Responsibilities:
- The Data Modeler will provide Client with services to create and maintain enhancements to the Clients Enterprise Logical Data Model and modeling efforts associated with the Enterprise Reporting and Business Intelligence initiative based on an Enterprise Data Warehouse (EDW).
- Data Analysis/profiling, reverse engineering of data, obtain business meaning of data attributes.
Data Modeling
- Working with EA-Data & Information Architecture team to create Enterprise Logical Data Model in alignment to modified logical models, with emphasis to abstracted enterprise level view and normalized logical data model (detailed).
- Logical data modeling and metadata collection will be captured in ER/Studio Data Architect in the form of Entity Relationship Diagrams (ERD)
EA -Modeling Activities
- Create logical models for EDW with implementation model conforming to 6 layered architecture
- Enhance Enterprise logical data model consisting of enterprise shareable entities & their relationships, (Normalized ERD). The work product shall include necessary metadata as defined in the logical modeling standards
- Bookings model enhancements to conform to 6 layered architecture
- Assist and advise, if deemed necessary, on enhancing standards and propagating the usage of standards across the organization
DESIRED EXPERIENCE:
- 10+ years of overall IT experience
- 5+ years of experience creating detailed Logical Data Models
- Models in 3rd normal form, fully attributed, suitable for use in creation of a separate Physical Data Model especially desirable if for Data Warehouse
- Use of facilitated workshops (JAD sessions) with SMEs (Subject Matter Experts) to gather information and conduct analysis for Logical Data Modeling
- Experience in other types of Logical Data Modeling is desirable as well, including Conceptual Data Model, Subject Area Data Model, and Enterprise Data Model
- Understanding of the overall Software Development Life Cycle and different development methodologies
- Strong communication skills and ability to work effectively in multi-cultural environment as well as to gain consensus in working with a group of people
- Strong analytical skills in depth experience in the analysis process that underlies creation of a Logical Data Model
- Determining the meaning of data through the analytical process
- Giving the data a meaningful name base on the meaning
- Writing a useful, articulate definition of the data
- Ability to train other participants in data modeling workshops as required
- Some ability to write simple SQL code is desirable
- Experience modeling for Data Warehouse and understanding of Data Warehouse architectures is desirable
- Experience with ER/Studio Data Architect or Erwin is desired
- Well versed in Conceptual & Logical Data Modeling (3NF)
- Must have worked with ER/Studio or ERwin data modeling tool
- Well versed with "Enterprise Data Warehouse" Inmon/Kimball hybrid architecture (CIF)
- Experience with IDEF1X methodology for logical data modeling
- Work experience with Teradata environment is a plus.
- Familiarity with Dimensional Modeling is a plus
Thanks
Shailesh
Swarky Solutions, MN
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at http://groups.google.com/group/it-jobs-in-usa?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment