(Senior) DWH Developer Snowflake
PHOENIX CONTACT BUSINESS SERVICES SPÓŁKA Z OGRANICZONĄ ODPOWIEDZIALNOŚCIĄ
⚲ Poznań, Wilda
Do uzgodnienia
Wymagania
- Snowflake
- Azure SQL
- GitLab
Opis stanowiska
Nasze wymagania:
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
Mile widziane:
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)
Zakres obowiązków:
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.
Oferujemy:
A challenging work in an innovative Shared Services Center in Poznan
Stability and long-term growth opportunities within a global organization
Participation in interesting projects
Development opportunities and a wide range of training, including subsidised language courses
Close cooperation with colleagues from Germany and other international teams
Private medical care
A multisport card
Housing loans and a loan and assistance fund
Annual bonus
A flexible hybrid work model with 4 remote days and 1 team day in the office each week
Flexible start times between 7:00 AM and 9:00 AM
Subsidies for commuting more than 30 km from PxC BS
A referral bonus
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
Mile widziane:
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)
Zakres obowiązków:
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.
Oferujemy:
A challenging work in an innovative Shared Services Center in Poznan
Stability and long-term growth opportunities within a global organization
Participation in interesting projects
Development opportunities and a wide range of training, including subsidised language courses
Close cooperation with colleagues from Germany and other international teams
Private medical care
A multisport card
Housing loans and a loan and assistance fund
Annual bonus
A flexible hybrid work model with 4 remote days and 1 team day in the office each week
Flexible start times between 7:00 AM and 9:00 AM
Subsidies for commuting more than 30 km from PxC BS
A referral bonus
🔍 Dekoder Ogłoszenia
🔴
2+ years with Snowflake or similar cloud DWH (Redshift, BigQuery, Synapse) or large SQL projects in enterprise environment
Może oznaczać, że doświadczenie w Snowflake jest preferowane, ale równie dobrze akceptowane jest doświadczenie w innych technologiach lub nawet "duże projekty SQL" bez konkretnego narzędzia.
🟡
Advanced SQL: CTEs, window functions, stored procedures, performance tuning
Podkreśla zaawansowane umiejętności SQL, ale nie precyzuje poziomu "zaawansowania", co może być subiektywne.
🟡
Star schema design: fact/dimension tables, SCD Type 1 & 2, upsert logic
Wymaga znajomości konkretnych koncepcji modelowania danych, co jest standardem w tej dziedzinie.
🔴
Polish: Fluent | English: Communicative
Komunikatywna znajomość angielskiego może oznaczać potrzebę rozumienia dokumentacji lub podstawowej komunikacji, a nie swobodnego prowadzenia rozmów.
🔴
Participate in architecture discussions
Może oznaczać rzeczywisty wpływ na architekturę lub jedynie udział w spotkaniach, gdzie decyzje są już podjęte.