Senior Snowflake Data Engineer / Architect

Company Overview: Business Integration Partners (BIP) is Europe’s fastest growing digital consulting company and are on track to reach the Top 20 by 2030, with an expanding global footprint in the US (New York, Charlotte, Chicago, and Houston). Operating at the intersection of business and technology we design, develop, and deliver sustainable solutions at pace and scale creating greater value for our customers, employees, shareholders, and society. BIP specializes in high-impact consulting services across multiple industries with 6,000 employees worldwide. Our domains include Financial Services (Banking and Capital Markets), Insurance and Payments verticals, Life Sciences, and Retail supplemented with Data & AI, Cybersecurity, Risk & Compliance, Change Management and Digital Transformation practices. We integrate deep industry expertise with business, technology, and quantitative disciplines to deliver high-impact results for our clients. BIP is actively expanding its presence in the United States, with a strategic focus on scaling its Digital eCommerce Transformation practices. Our teams work at the intersection of business strategy, technology, and data to help clients make smarter decisions, manage risk more effectively, and stay competitive in a rapidly evolving market. Overview: We are seeking a highly technical Snowflake Data Expert to support a global consumer enterprise in modernizing and scaling its data architecture across multiple portfolio companies. This role will focus on designing, optimizing, and governing enterprise-grade Snowflake environments that support analytics, reporting, operational insights, and future AI/ML initiatives. The ideal candidate brings strong data warehousing architecture experience, hands-on Snowflake expertise, and the ability to work across complex, multi-entity global environments. Key Responsibilities: Snowflake Architecture & Design: • Design and optimize scalable Snowflake data warehouse solutions • Implement best practices around data modeling (Star/Snowflake schema, Data Vault, etc.) • Architect multi-environment structures (Dev, Test, Prod) • Configure role-based access control (RBAC) and governance frameworks • Optimize warehouse sizing, clustering, and cost management strategies Data Integration & Pipelines: • Build and manage ETL/ELT pipelines into Snowflake • Integrate data from ERP, CRM, supply chain, and operational systems • Work with tools such as: • Fivetran • Matillion • dbt • Informatica • Azure Data Factory / AWS Glue (as applicable) • Develop automated ingestion pipelines (batch and near real-time) Performance & Optimization: • Tune queries and optimize compute/storage performance • Implement partitioning and clustering strategies • Monitor warehouse consumption and cost efficiency • Implement performance benchmarking standards Governance & Security: • Implement data governance policies and security best practices • Manage data masking, encryption, and compliance standards • Establish metadata management and lineage tracking • Ensure multi-entity data segmentation where required Global Environment Collaboration: • Support multiple international business units under a centralized ownership structure • Standardize data models and reporting structures across entities • Collaborate with BI, Finance, Supply Chain, and Operations stakeholders Required Skills & Experience: • 5+ years of hands-on Snowflake experience • 8+ years in data engineering or data architecture roles preferred • Strong SQL expertise (advanced query optimization) • Experience building enterprise-scale data warehouses • Experience with: • Cloud platforms (AWS, Azure, or GCP) • Data pipeline/orchestration tools (dbt, Airflow, etc.) • BI tools (Power BI, Tableau, Looker) Preferred Qualifications: • Snowflake certification (SnowPro Core or Advanced) • Experience in consumer goods, retail, or manufacturing environments • Experience integrating ERP systems (SAP, Oracle, etc.) • Familiarity with data lake architectures and hybrid cloud environments • Experience enabling AI/ML use cases within Snowflake ecosystem • • The role compensation will be $80-$120/hour • • For more information about BIP US, visit https://www.bip-group.com/en-us/. Equal Employment Opportunity: It is BIP US Consulting policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship, or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these grounds.