Senior Snowflake Data Engineer

Posted 3 Days Ago
2 Locations
In-Office
Senior level
Information Technology • Consulting
Women-Owned Small Business that brings simplicity to complex transformations through consulting and delivery solutions.
The Role
Lead design, development, and optimization of Snowflake-based data platforms and scalable ELT/ETL pipelines. Build dimensional models, data marts, and curated analytical datasets; implement Snowpark, stored procedures, streams, tasks; enforce data quality, lineage, governance, and security; automate orchestration with Airflow/Azure Data Factory/AWS Glue; support finance, risk, compliance, and regulatory reporting; mentor junior engineers.
Summary Generated by Built In

About us

Itero Group is a Women-Owned Small Business focused on simplifying complex transformations. We empower clients in the private and government sectors to become more optimized, digitally enabled, and data-driven organizations through our comprehensive business consulting and innovative delivery solutions.
Itero Group's dedicated team members are experienced thought leaders, tenacious workers, and creative thinkers. We hire people who are passionate about being catalysts for change - in our company, for our clients, throughout our career- and we empower people to express their ideas, create better practices, innovate better products, and become better professionals.
We have been named a Great Place to Work for six years, and offer a competitive salary and benefits package. 

 

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.

Key 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.
Required Qualifications
  • 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
    • GCP (preferred)
  • Experience with:
    • dbt
    • Airflow
    • Git
    • CI/CD
    • Terraform (preferred)
  • 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.

 

 

If you are looking for a role where you will lead with integrity, create and innovate, inspire excellence, be a respected member of the team, drive results, and have fun, we look forward to connecting with you!

Benefits at Itero Group
At Itero Group, we’re proud to offer a comprehensive benefits package designed to support your health, financial well-being, and work-life balance:

  • Health & Wellness: Medical (BC-BS), dental, and vision plans to suit your needs. 
  • Paid Time Off: Generous PTO, paid holidays, and increasing PTO based on years of service.
  • Retirement Savings: 401(k) plan with company match and auto-enrollment.
  • Company-Paid Coverage: Short-term and long-term disability, life insurance, and AD&D insurance.
  • Additional Options: Voluntary benefits including pet insurance and student loan assistance up to $1,000 annually.
  • Perks: FSAs, HSAs, wellness programs, and more to enhance your work-life balance.

Join us and enjoy a benefits package designed with you in mind!

Itero Group is an equal opportunity employer and does not discriminate against any employee or applicant because of race, age, sex, color, physical or mental disability, religion, sexual orientation, marital status, national origin, veteran status or political affiliation.

Skills Required

  • 7+ years Data Engineering experience
  • 4+ years 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
  • Experience with cloud platforms: AWS
  • Experience with cloud platforms: GCP
  • Experience with dbt
  • Experience with Airflow
  • Experience with Git
  • Experience with CI/CD
  • Experience with Terraform
  • 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 (banking, capital markets, insurance, asset/wealth management, FinTech)
  • Consulting experience (PwC, Deloitte, EY, KPMG, Accenture, Slalom or similar)
  • Ability to gather requirements directly from business stakeholders
  • Excellent verbal and written communication skills
  • Strong presentation and stakeholder management abilities
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New Cumberland, PA
57 Employees
Year Founded: 2017

What We Do

Itero Group is a Women-Owned Small Business that brings simplicity to complex transformations. Our comprehensive delivery solutions – Artificial Intelligence, Agile, Program and Project Management, Process Improvement, Testing, and Innovation as a Service – and innovative business consulting services simplify how work is defined, done, delivered, and measured for private and government sector clients. As transformative delivery experts, we challenge the status quo and empower our clients to become digitally enabled and data-driven organizations. Our experienced thought leaders, dedicated team players, tenacious workers, and creative minds are the catalysts for change that drive our success. At Itero Group, we foster a vibrant corporate culture built on six key pillars: leading with integrity, creating and innovating, inspiring excellence, respecting the team, driving results, and having fun. We prioritize diversity and inclusion, regularly engage with our growing hybrid team, and offer enhanced benefits to ensure an excellent, exciting, and empowering experience for every employee. Founded in 2017, Itero Group has become a leader in our field and a trusted partner to our clients. Connect with Itero Group today to learn more about our solutions and dynamic career opportunities to simplify complex transformations and drive positive change in the world around us.

Similar Jobs

FourKites Logo FourKites

Specialist, Product Support

Artificial Intelligence • Big Data • Logistics • Machine Learning • Software • Transportation
Easy Apply
Hybrid
Chicago, IL, USA
475 Employees
70K-80K Annually

FourKites Logo FourKites

Sr. Manager, Customer Success

Artificial Intelligence • Big Data • Logistics • Machine Learning • Software • Transportation
Easy Apply
Remote or Hybrid
2 Locations
475 Employees
145K-175K Annually
In-Office or Remote
Chicago, IL, USA
1805 Employees
19-19 Hourly

PartySlate Logo PartySlate

Account Executive

Consumer Web • Events • Marketing Tech • Productivity • Software • Hospitality
Remote or Hybrid
Chicago, IL, USA
60 Employees
45K-55K Annually

Similar Companies Hiring

Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees
Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account