Senior Data Modeler, Snowflake

This is a fully remote position, open to applicants in Poland.

📋 Description

• Assist in the integration of regional data warehouses into a centralized data platform built on Snowflake for clients in the pharmaceutical sector.

• Design and deploy physical data models in Snowflake that prioritize scalability, performance, and maintainability.

• Convert conceptual and logical models into schemas, tables, and views that are optimized for Snowflake.

• Work in partnership with data engineers to enhance ETL/ELT processes and data integration methodologies.

• Ensure that models and metadata are in alignment with governance standards and tools, such as Collibra.

• Document modeling and transformation logic to ensure traceability and compliance.

• Assist in the performance tuning and optimization of data pipelines.

• Operate in a distributed, global setting alongside both technical and business stakeholders.

⛳️ Requirements

• 4–7 years of experience in a Data Modeler role or a comparable position.

• Demonstrated proficiency in physical data modeling within Snowflake and SQL.

• Knowledge of data integration as well as ETL/ELT methodologies.

• Experience with Data Vault 2.0 is essential.

• Familiarity with metadata and data governance platforms, preferably Collibra.

• Understanding of AWS services, particularly S3, is advantageous.

• Experience with tools such as dbt, Matillion, or Fivetran is a plus.

• Strong understanding of data modeling best practices, including star schema, normalization, and data vault techniques.

• Capability to work autonomously in a remote, cross-functional environment.

• Exceptional communication and documentation abilities.

• Experience in pharmaceutical/life sciences data and knowledge of regulatory frameworks is preferred.

• Familiarity with data quality tools like Ataccama is a plus.

🏝️ Benefits

• Employees have the option to work remotely.

• Up to 25 days of remote work per year from any global location.

• Flexible time off policies beyond the standard holiday allowances.

• Budget for team integration activities.

• Birthday gifts provided.

• CHF 1,500 annually allocated for professional development.

• Regular workshops and training sessions available.

• Competitive salary and comprehensive benefits package.

• Rewards for employee referrals.

• Loyalty-based benefits beginning in the third year through the Unity Scheme.

• Financial support offered for relocation for work.

• Assistance with visas, permits, and international assignments.

• Country-specific perks tailored to residents.

• A diverse and inclusive global work culture.