Database Developer
Apex Systems is a Global IT Services Firm and our Staffing practice is looking for an Data Engineer to place at our client, a Big Five Bank. You will be joining a highly collaborative, fast paced and high performing team.
Client: Big Five Bank
Length of Contract:6 months contract with potential perm conversion
Working Location: Hybrid, downtown Toronto
Working Hours: 37.5 hours per week
Skills
- Database Developer with 5 years of experience in any Database -- Snowflake, MS SQL, Oracle, Sybase
- Snowflake Expertise -- Nice to have / Preferred.
- Strong Experience in SQL Database Development
- Strong Query Tuning \& Optimization skills
- Good Python Scripting knowledge
- Knowledge of software development practices, concepts, and technology
- Asset Management / Wealth Management knowledge (Data) -- Nice to Have
- Excellent Team Player
Responsibilities
- Development with Snowflake features such as Snow SQL, Python
- Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
- Developing EL pipelines in and out of data warehouse using combination of Python and Snow SQL.
- Design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.
- Developing scripts PowerShell, Python etc. to Extract, Load and Transform data, as well as other utility functions.
- Provide production support for Data Warehouse issues such data load problems, transformation, translation problems.
- Translate mapping specifications to data transformation design and development strategies and code, incorporating standards and best practices for optimal execution.
- Understanding data pipelines and modern ways of automating data pipeline and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
- Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.
