Senior Snowflake Data Engineer

Itero Group • Boston, MA

19h

About The Position

Itero Group is seeking an experienced Senior Snowflake Data Engineer to support enterprise data modernization initiatives for leading Financial Services clients. This individual will design, develop, and optimize cloud-based data platforms using Snowflake while partnering with business stakeholders, architects, and analytics teams to deliver scalable, secure, and high-performing data solutions. The ideal candidate has deep experience building enterprise data pipelines, implementing cloud data warehouses, and supporting regulatory and financial reporting initiatives within banking, insurance, capital markets, or asset management organizations.

Requirements

• 7+ years of Data Engineering experience.
• 4+ years of hands-on Snowflake development.
• Strong SQL expertise including query optimization.
• Strong Python development experience.
• Experience building enterprise ELT/ETL pipelines.
• Experience with cloud platforms: Azure, AWS
• Experience with: dbt, Airflow, Git, CI/CD
• Experience working with structured and semi-structured data.
• Knowledge of data modeling (Star Schema, Snowflake Schema, Kimball).
• Experience with REST APIs and data integration.
• Strong troubleshooting and performance tuning skills
• Financial Services Experience Required
• Candidates should possess experience supporting one or more of the following: Banking, Commercial Banking, Investment Banking, Capital Markets, Asset Management, Wealth Management, Insurance, FinTech
• Consulting Experience
• Experience working in consulting environments such as PwC, Deloitte, EY, KPMG, Accenture, Slalom, or similar.
• Ability to gather requirements directly from business stakeholders.
• Experience leading client workshops and solution design sessions.
• Excellent verbal and written communication skills.
• Strong presentation and stakeholder management abilities.

Nice To Haves

• GCP (preferred)
• Terraform (preferred)

Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake.
• Build and optimize ELT/ETL processes to ingest data from multiple enterprise systems.
• Develop dimensional data models, data marts, and curated analytical datasets.
• Optimize Snowflake performance through clustering, partitioning, workload management, and cost optimization.
• Implement data quality, lineage, governance, and security best practices.
• Develop solutions utilizing Snowpark, stored procedures, streams, tasks, and dynamic tables where appropriate.
• Partner with business stakeholders to understand reporting and analytical requirements.
• Build reusable data frameworks supporting Finance, Risk, Compliance, Treasury, and Regulatory Reporting.
• Develop automated orchestration using Airflow, Azure Data Factory, AWS Glue, or similar technologies.
• Participate in Agile ceremonies including sprint planning, backlog grooming, and code reviews.
• Mentor junior engineers and promote engineering best practices.

Benefits

• Medical (BC-BS), dental, and vision plans
• Generous PTO, paid holidays, and increasing PTO based on years of service.
• 401(k) plan with company match and auto-enrollment.
• Short-term and long-term disability, life insurance, and AD&D insurance.
• Voluntary benefits including pet insurance and student loan assistance up to $1,000 annually.
• FSAs, HSAs, wellness programs

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed