Database Developer; Snowflake

Toronto 27 days agoFull-time External
205 - 256 / hr
Position: Database Developer (Snowflake) Get AI-powered advice on this job and more exclusive features. This range is provided by Apex Systems. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range CA $40.00/hr - CA $50.00/hr Apex Systems is a large staffing and consulting firm and we are looking for a Database Developer with Snowflake experience, Python and Shell Scripting, and strong SQL skills to place at our client, a top 5 Financial Institution. • Contract: 6-months contract (potential for extension or conversion to FTE) • Location: Toronto, Downtown Core (2 days/week) Key Qualifications: • Database Developer with 5+ years of experience in Snowflake • 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 • Ideally some exposure to AI functions, or experience building AI based-tools 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 Power Shell, 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. Seniority level • Mid-Senior level Employment type • Contract Job function • Information Technology Industries • IT Services and IT Consulting and Banking #J-18808-Ljbffr