Job Specifications
About Us:
AmpsTek - a global technology leader since 2013 - is transforming how businesses approach technology and staffing solutions. Founded by seasoned technology leaders across the UK, Europe, APAC, North America, and LATAM, and with registered offices in 30+ countries, we deliver exceptional service, scalable solutions, and measurable impact.
With a portfolio of 200+ clients and millions of users across web and mobile platforms, we empower businesses to innovate, grow, and succeed.
Join our team and be part of a dynamic, growth-oriented organization that values talent, creativity, and results.
Position: Snowflake Engineer
Location: Canada (Remote)
Contract: Long Term
Enterprise Snowflake Engineer
We are seeking an experienced Enterprise Snowflake Engineer to lead the design, development, and optimization of scalable data solutions using the Snowflake Data Cloud. This role involves working across teams to build robust data pipelines, ensure data integrity and security, and support enterprise-wide analytics and reporting initiatives.
Required Skills:
Bachelor's Degree or foreign equivalent, will consider work experience in lieu of a degree
Overall, 18+ years of experience 10+ years of experience in data engineering or cloud data solutions on Azure, GCP etc.
Role requires deep expertise in Snowflake architecture, SQL optimization, and data modeling, as well as hands-on experience with GCP BigQuery schemas, UDFs, and partitioning strategies.
Engineer will be responsible for translating query logic, optimizing performance, and ensuring data integrity throughout the migration.
Familiarity with orchestration tools (e.g., Airflow, dbt), secure data sharing, and compliance with financial data governance standards is essential.
Design scalable data models optimized for Snowflake's cloud-native architecture, including use of virtual warehouses, clustering keys, and materialized views.
Collaborate with data engineers and architects to implement models that support real-time analytics, fraud detection, and risk management.
Ensure data quality and consistency across diverse financial systems such as trading platforms, customer onboarding, and compliance tools.
Integrate structured and semi-structured data (e.g., JSON, XML) using Snowflake's native capabilities to support complex financial reporting.
Document data lineage and metadata to support auditability and transparency for internal and external stakeholders.
Optimize data storage and query performance using Snowflake-specific features like automatic clustering and query profiling.
Support data governance initiatives by aligning models with enterprise data catalogs, stewardship policies, and access controls.
Collaborate with business analysts and compliance teams to translate financial reporting needs into robust data structures.
Continuously refine models based on evolving financial products, market conditions, and regulatory changes.
Preferred Skills:
Certified SnowPro Advanced: Architect
Proficiency in Python or .NET for data manipulation and automation.
Experience with Snowflake features like Snowpipe, Streams, Tasks, and Time Travel.
Understanding of data governance frameworks and compliance standards.
Strong understanding of financial services workflows, including Collateral Management and Corporate Action.
Excellent communication and stakeholder engagement skills
About the Company
Ampstek supplies thousands of tech and digital professionals annually to a range of clients through its offices which spread across in 42 countries. From simple beginnings in 2014, Ampstek has always been on a journey to reinvent the world of recruitment through creating amazing customer and candidate experiences driven by a genuine desire to build long term relationships and outcomes. This motivation to break from the pack is stronger than ever as we roll out Ampstek Power globally, an innovative life hub platform for freel...
Know more