(Senior) DWH Developer Snowflake (f/m)

About The Role Join our team building and scaling a financial controlling data warehouse that powers decision-making across the organization. Our Snowflake-based platform processes data from multiple ERP systems, integrates 45+ downstream applications, and serves financial reporting and analytics teams worldwide.

• 1,700+ SQL objects across 95+ schemas
• 40+ fact tables, 100+ dimensional models
• Daily processing of millions of financial transactions

You'll work on slowly changing dimensions, multi-currency consolidation, and data quality monitoring — architecting a data platform at enterprise scale.

Work Model: Hybrid (4 days remote, 1 day on-site)

Your responsibilities:

• Design dimensional models: Star schemas with SCD Type 2 dimensions, fact tables
• Develop ETL pipelines: Stored procedures with transaction management, hash-based upserts, multi-source consolidation, and data quality checks
• Optimize performance: Query tuning with CTEs, window functions, incremental loading strategies
• CI/CD & automation: Git/GitLab version control, automated deployment, schema migrations, code reviews
• Integrate data sources: SAP extractors, REST APIs, Blob Storage; document data lineage
• Collaborate: Work with business and BI teams, participate in architecture discussions, mentor junior developers
• Travel to Germany 1-2x/year for team workshops.

Our requirements: Must have:

• 2+ years with Snowflake or similar cloud DWH (Redshift, BigQuery, Synapse) or large SQL projects in enterprise environment
• Advanced SQL: CTEs, window functions, stored procedures, performance tuning
• Star schema design: fact/dimension tables, SCD Type 1 & 2, upsert logic
• Git/GitLab collaboration
• Polish: Fluent | English: Communicative
• CV in English language

An additional advantage will be:

• Azure (Blob Storage, Data Factory), Snowflake administration
• BI tools: Power BI, MicroStrategy, Tableau
• CI/CD tools (TeamCity, Azure DevOps) or scripting (PowerShell, Bash)
• Python or Snowflake Scripting
• SAP BW / S/4HANA domain knowledge (CO-PA, FI, MM)