AWS Snowflake Architect

AWS Snowflake Architect

All IT Solutions

United States · Markham ON

Workplace Type — Hybrid

Employment Type — Contract

We are currently seeking a qualified AWS Snowflake Architect to support this engagement. Please review the complete requirements, work location, employment type, and screening questions before applying. Candidates whose experience closely matches the position will be contacted directly by the AIS recruiting team.

Job Summary

All IT Solutions is seeking an AWS Snowflake Architect to join a client engagement.

Responsibilities

• OpenFlow and Apache Airflow for workflow automation, enabling seamless ingestion of different data from diverse sources
• Design Streamlit apps and define new capabilities and data products leveraging snowflake ML and LLOPS capabilities
• Develop robust data models and data pipelines to support data transformation, integrating multiple data sources and ensuring data quality and integrity
• Document architecture, data flows, and transformation logic to ensure transparency, maintainability, and knowledge sharing across teams

Required Qualifications

• Extensive experience (8 + years) in data architecture and engineering, with a proven track record in large – scale data transformation programs, ideally in insurance or financial services
• Expertise in design and orchestrating data acquisition pipelines using AWS Glue for ETL/ELT, Snowflake
• Exposure to enterprise Data Warehouse solution like Cloudera, AWS Redshift and Informatica tool sets - IDMC, PowerCenter, BDM
• Proficiency in SQL, data modeling, ETL/ELT processes, and scripting languages (Python/Java)
• Proven experience in architecting and implementing advanced data solutions using Snowflake on AWS,
• Proven experience in DBT to manage and automate complex data transformations within Snowflake, ensuring modular, testable, and version - controlled transformation logic
• Experience in implementing the lake house solution, Medallion architecture for financial or insurance carriers
• Experience in optimizing and tune Snowflake environments for performance, cost, and scalability, including query optimization and resource management,
• Experience in architecting/lead migration of workloads from Cloudera to Snowflake
• Experience in evaluating the data technology platform including da ta governance suites, data security products
• Strong knowledge of data lifecycle mgmt, data retention, data modelling and working knowledge of cloud computing, and modern development practices
• Experience with data governance, metadata management, and data quality frameworks (e.g, Collibra, Informatica)
• Experience in converting policy/data conversion from legacy to modern platform
• Hands - on experience with AWS Glue for ETL/ELT, Apache Airflow for orchestration, and dbt for transformation (preferably deployed on AWS ECS)

Preferred Qualifications

• Deep expertise in Snowflake (Snowpro advanced certification preferred), with hands - on experience delivering Snowflake as an enterprise capability

ABOUT ALL IT SOLUTIONS LLC

Headquartered in Mount Laurel, New Jersey, All IT Solutions LLC is a technology and workforce solutions company serving government and commercial organizations throughout the United States. AIS provides IT staffing and staff augmentation, cybersecurity, IT consulting, custom software development, cloud services, data engineering, artificial intelligence, application development, and related technology solutions.

AIS is an NMSDC/EMSDC-certified Minority Business Enterprise and an NYC Department of Small Business Services-certified M/WBE. We participate in E-Verify and are committed to maintaining professional, transparent, and compliant hiring practices.

EQUAL EMPLOYMENT OPPORTUNITY

All IT Solutions LLC is an equal opportunity employer. Employment decisions are made based on qualifications, merit, performance, and legitimate business requirements without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, military or veteran status, or any other characteristic protected by applicable federal, state, or local law.

Reasonable accommodations are available to qualified applicants with disabilities during the application and interview process.

RECRUITMENT NOTICE

All IT Solutions LLC is a staffing and technology services company and may receive fees or compensation from client organizations for recruiting, staffing, placement, or workforce services. Candidates are never charged an application, recruitment, placement, or interview fee by All IT Solutions LLC.

Any commercial rates, fees, or staffing arrangements are between All IT Solutions LLC and its clients and do not require payment from the candidate.

Official recruiting communications will come from an authorized All IT Solutions representative or an @allitsolutions.us email address.

Apply

Apply Now: