We are looking to hire **Data Warehouse Specialist** with a financial background. Who will play a crucial role in leveraging a cloud-based data warehousing platform, to manage and analyze financial data.
• *Basic Qualifications**:
- Overall 10+ years of experience is required.
- Minimum 3 years of experience in design and implementation of large-scale data solution on Azure/AWS Data Warehouse
- Good experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling
- Experience in writing scripts (UNIX, Python) and SQL Queries
- Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
• *Good to Have**:
Experience in Finance / Banking industry - some understanding of Securities and Banking products
• *Job Type**: Fixed term contract
Contract length: 12 months
• *Salary**: $54,953.89-$97,567.27 per year
Schedule:
- Monday to Friday
Ability to commute/relocate:
- Montréal, QC: reliably commute or plan to relocate before starting work (required)
• *Education**:
- Secondary School (preferred)
• *Experience**:
- warehouse: 4 years (required)
- AWS and Azure: 4 years (required)
- OLTP: 3 years (required)
- Data modeling: 3 years (required)
Licence/Certification:
- Class 5 Licence (preferred)