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
Our client has an immediate need for an Intermediate Data Analyst to help consolidate and prepare data models for internal data warehouses
Required Skills:
Nice to Have:
Responsibilities:
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
