Data Warehouse Consultant

Data Warehouse Analyst

Hybrid / onsite

6+ months Contract
• Responsible for partnering with internal and external business clients and IT to fulfil information needs and support business decisions.
• Primary duties may include, but are not limited to: Guides and advises less experienced data warehouse analysts.
• Maintains information policies and procedures to support current and future data information needs and ensures proper data definitions, ownership, use and integrity of data. Analyses complex business user needs, documents information requirements.
• Facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed.
• Collaborates with IT resources on the creation and maintenance of the content of the data warehouse, establishes and maintains strong knowledge of data warehouse data structure design, definitions, capabilities, SQL, and data integrity issues, completes metadata assessment and reviews feedback to determine changes, ensures that data definitions are clear and current, and communicates changes to data definitions to all users.
• Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule. Requires a BA/BS degree in related field and a minimum of 2 years’ experience in data analysis, data modelling, and working with automated data warehouse systems; or any combination of education and experience which would provide an equivalent background.
• Experience in SQL, GQL, SAS, Business Objects preferred. Strong PC skills, analytical, problem-solving ability, and communication skills strongly preferred. Demonstrated ability to lead and plan projects strongly preferred. Primary Skill SQL, GQL, SAS, Business Objects