Login | Register

Intermediate Data Analyst to help consolidate and prepare data models for internal data warehouses

Job Type: Contract
Positions to fill: 1
Start Date: Oct 17, 2022
Job End Date: Mar 31, 2023
Pay Rate: Hourly: Negotiable
Job ID: 123643
Location: Calgary
Apply
Our client has an immediate need for an Intermediate Data Analyst to help consolidate and prepare data models for internal data warehouses

Required Skills: 
  • 5 + years working with internal data warehouses.
  • Experience maintaining and optimizing existing data models (SSAS, Data wareshouse, SQL)
  • Experience working with SQL Server programming and development tools 
  • Experience using: SSAS, SSIS, SSRS
  • ETL and data warehousing tools and architecture

Nice to Have: 
  • Familiarity with Microsoft Power BI 
  • Experience in ITIL Change Management/Quality Assurance practices
  • R, Python, Kubeflow
  • AWS, Microsoft Azure
  • Experience using APIs

Responsibilities
  • Source data and build relationships from a variety of sources inclucing: internal data warehouse, operational applications, third party application thru API, other industry sources
  • Maintaining and optimizing existing data models (SSAS, Data wareshouse, SQL)
  • Support the broader Business intelligence team with data management, data governance and data flow activities
  • Use available data to develop reports that provide management insight into operations, safety or financial matters