Data Modeler Job in Calgary, Alberta Canada
IT Consulting
Pursue Your Full Potential. Maximize your talents. Grow your professional skills. Fujitsu is where you can pursue your full career potential. A key ingredient to our company's success is our people and their personal development. Each person contributes unique talents and skills to our team effort while aspiring to their personal career objectives and life goals.
Fujitsu Calgary is committed to helping your career goals become achievable. We actively promote the skill development of every employee through continuous training and education. We enable our employees to grow as individuals, mature as industry professionals-and proudly succeed as key members of the Fujitsu team.
At Fujitsu, on-the-job training on actual projects give employees the real-life experience needed to handle future challenges in their career
You are vital to the success of Fujitsu, and your benefits are an important part of your overall compensation.
- Competitive salaries
- Incentive programs
- Group benefits including medical, dental, disability and life insurance
- Savings plan (RRSP)
- Reimbursement for professional membership dues in PMI, CMC and/or CIPS,
- Attractive employee referral program
- Peer based employee recognition and reward program
- Company-supported social committee and regularly sponsored employee events and activities
A key client of Fujitsu Consulting requires a Senior Data Modeler for a role in Calgary The candidate will:
Primary Responsibilities:
· Develops, manages, and updates data models, including physical and logical models of the data warehouse, data mart, and staging area, and sometimes the operational data store and source systems
· Ability to interview business users to obtain data requirements
· Designs conceptual and logical models for the data warehouse and data mart
· Communicates physical database designs to database administrator
· Evolves models to meet new and changing business requirements
· Develops process for capturing and maintaining metadata from all data warehousing components
Key Skills:
· Strong conceptual, communications, and technical skills
· Ability to translate business needs into technical solutions
· Strong relational and dimensional data modeling and database design skills
· Strong problem-solving and metadata skills
· Understanding of source and target data structures, ETL processes, and products
· Prior experience building data warehouses
· Data modeling, database administration, and performance tuning
· SQL, ETL, OLAP
· Use-case analysis
· Conceptual and analytic skills
Key Deliverables
· Source system recommendations
· Model management standards
· Logical and physical data models
· Meta model for metadata repository
Technologies:
· Sybase Power Designer
· Informatica 9.1
· Oracle 11i
Expectations:
· This role will work in a small BI team
· We would like a Senior resource who have knowledge in the other areas outside of their domain (e.g. Data Modeler but understands ETL and BoBj tools)