Data Modeler/Data Analyst

ZapArrow - Montréal, QC (il y a 30+ jours)

Postuler dès maintenant

Position: Senior Data Modeller

Location: Montreal, QC

Duration: 12+ months(contract)

Job Description: -

· Interact with users to gather business requirements for BI projects and enhancements

· Design data architecture for BI projects and enhancements

· Create EDW business data models and business rules for all EDW environments

· Create data definitions, models and access views

· Create BO Universe Structures

· Definition of data synchronization and acquisition rules

· Definition of data quality and validation rules

· Define Extract/Transform/Load (ETL) processes

· Ensure data access optimization

· Experience in Data Profiling

· Supply high level and detail estimates for enhancements/projects

· Provide data modeling services to BI Development & Support Team

· Specific job experience in business intelligence or data warehouse environment an asset

· Strong written and interpersonal skills, English and French

· Experience in Business Objects Universe Design & Report Construction

· Knowledge of Data dimensional and relational modeling techniques and tools (Erwin)

· Knowledge of DB2, ORACLE, UDB, Netezza or other database management systems

· Excellent communication of both written and spoken English.

Tools and landscape: -

· Toad

· ERWin

· General knowledge with ETL tools

· Netezza DB

· DB2 DB

· Oracle DB

· MSSQL DB

Job Type: Contract

Salary: $50.00 to $60.00 /hour

Experience:

  • DATA MODELING: 4 years (Preferred)
  • Data Warehousing: 5 years (Preferred)
  • Business Object: 2 years (Preferred)
  • Business Intelligence: 2 years (Preferred)