Design and implement scalable Snowflake-based data architectures on cloud (Azure/AWS). Build and optimize ETL using SnowSQL and Spark, tune performance, migrate data systems, document designs, collaborate with stakeholders, and mentor engineers while incorporating agentic AI into the data engineering SDLC.
We are hiring a Snowflake Architect with our Client in Boston, MA (Onsite)
Job Details:
Job Title: Snowflake Architect
Location: Boston, MA
Note: Need a snowflake data architect with Azure Cloud Experience and Agentic AI,
Senior Data Architect who can shape the Azure snowflake roadmap, Migration, Agents for Data Eng SDLC.
Job Summary:
We are seeking a highly skilled Snowflake Architect with extensive experience in SnowSQL, Spark, and Snowflake to join our software development team. The ideal candidate will have a strong background in data architecture and cloud-based data solutions, with a proven track record of designing and implementing scalable data systems. This role requires a deep understanding of Snowflake's capabilities and best practices, as well as the ability to collaborate with cross functional teams to deliver high quality data solutions.
Responsibilities:
• Design and implement data architecture solutions using Snowflake, ensuring optimal performance and scalability.
• Develop and maintain ETL processes using SnowSQL and Spark to facilitate data ingestion and transformation.
• Collaborate with data engineers, analysts, and other stakeholders to gather requirements and translate them into technical specifications.
• Optimize existing data pipelines and workflows for efficiency and reliability.
• Conduct performance tuning and troubleshooting of Snowflake environments.
• Stay updated with the latest Snowflake features and best practices, and provide recommendations for improvements.
• Document architecture designs, processes, and procedures for future reference and training.
• Participate in code reviews and provide mentorship to junior team members.
Mandatory Skills:
• Proven experience as a Snowflake Architect with a strong focus on SnowSQL.
• Expertise in Spark for data processing and transformation.
• In depth knowledge of Snowflake architecture, features, and best practices.
• Strong programming skills in SQL and experience with data modeling.
• Experience with cloud platforms, particularly AWS or Azure.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
Preferred Skills:
• Experience with data visualization tools such as Tableau or Power BI.
• Familiarity with data governance and security best practices.
• Knowledge of machine learning concepts and tools.
• Experience with Agile methodologies and project management tools.
Qualifications:
• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 15 years of experience in software development, with a focus on data architecture and cloud solutions.
• Relevant certifications in Snowflake or cloud technologies are a plus.
Similar Jobs
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handle inbound and warm insurance sales leads, consult with customers to match coverages, convert leads to policyholders, complete paid licensing and remote training, work scheduled shifts including weekends, and maintain required work-from-home technology and space.
Top Skills:
Dsl)FiberHigh-Speed Internet (CablePc
Fintech • Financial Services
Provide independent credit oversight and approval for complex asset-based lending portfolios. Monitor and mitigate portfolio risk, lead approval discussions, design risk controls, advise senior leaders, resolve challenged credits, and mentor credit professionals to ensure prudent underwriting and consistent risk-based decisions across the organization.
Fintech • Financial Services
Lead external visibility for Corporate & Investment Banking through media relations, executive positioning, conference and awards strategy. Advise and media-train senior leaders, secure speaking opportunities, develop briefing materials and LinkedIn content, build media relationships, produce weekly media reports, and measure coverage outcomes to advance CIB thought leadership and reputation.
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
