Senior Data Modeler, Snowflake

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

📋 Description

• Create and execute physical data models within Snowflake.

• Prioritize model design for scalability, performance, and maintainability.

• Convert conceptual and logical models into schemas, tables, and views that are compatible with Snowflake.

• Work in tandem with data engineers to enhance ETL/ELT processes and data integration approaches.

• Ensure that models and metadata comply with governance standards and tools, such as Collibra.

• Maintain documentation of modeling and transformation logic to ensure traceability and compliance.

• Assist in performance tuning and optimizing data pipelines.

• Collaborate with both technical and business stakeholders in a distributed, global setting.

• Facilitate the integration of regional data warehouses into a centralized data platform based on Snowflake for clients in the pharmaceutical industry.

⛳️ Requirements

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

• Demonstrated proficiency in Snowflake physical data modeling and SQL.

• Understanding of principles related to data integration and ETL/ELT.

• Familiarity with tools like dbt, Matillion, or Fivetran is advantageous.

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

• Knowledge of AWS services, particularly S3, is beneficial.

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

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

• Exceptional communication and documentation skills.

• Preferred experience in pharmaceutical/life sciences data and understanding of regulatory frameworks.

• Familiarity with data quality tools, such as Ataccama, is a plus.

🏝️ Benefits

• Remote work options available for employees.

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

• Flexible time off policies surpassing standard holiday allowances.

• Budget allocated for team integration activities.

• Special birthday gifts provided.

• Annual allocation of CHF 1,500 for professional development initiatives.

• Regular workshops and training sessions offered.

• An inclusive workplace that values individuality and encourages employee feedback.

• Competitive salary along with a comprehensive benefits package.

• Rewards through a referral program.

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

• Financial support for relocation related to work.

• Assistance with visas, permits, and international assignments.

• Country-specific perks tailored to the employee's residence.

• A diverse and inclusive global culture.