Data Modeler Lead (Snowflake)
Fusion Consulting · Kuala Lumpur
Job description
About the role
Fusion Consulting, a global Life Sciences consultancy, is looking for a Data Modeler (Snowflake) to support the integration of regional data warehouses into a centralized Snowflake-based data platform for its pharmaceutical clients. This mid-level role suits candidates with a strong foundation in physical data modeling and implementation in Snowflake, working across data engineering, architecture and governance teams.
Key responsibilities
- Design and implement physical data models in Snowflake, focusing on scalability, performance and maintainability.
- Translate conceptual and logical models into Snowflake-ready schemas, tables and views.
- Collaborate with data engineers to refine ETL/ELT processes and data integration patterns.
- Align models and metadata with governance standards and tools, including Collibra.
- Document modeling and transformation logic for traceability and compliance.
- Support performance tuning and optimization of data pipelines.
- Work in a distributed, global environment with technical and business stakeholders.
Required profile
- 7+ years of experience as a Data Modeler with proven leadership experience.
- Proven expertise in Snowflake physical data modeling and SQL.
- Understanding of data integration and ETL/ELT principles.
- Ability to work independently in a remote, cross-functional environment, with excellent communication and documentation skills.
Required skills
- Snowflake physical data modeling and SQL (must)
- Data Vault 2.0 (must)
- Metadata and data governance platforms, ideally Collibra (must)
- Preferred: dbt, Matillion or Fivetran; AWS S3; pharmaceutical/life sciences data and regulatory frameworks; data quality tools such as Ataccama
What we offer
- Up to 25 days per year of remote work from any global location.
- Flexible time off beyond standard holiday allowances.
- CHF 1,500 annually for professional development, plus workshops and training.
- Competitive salary and benefits, with a referral programme and loyalty benefits from the third year.
- Financial assistance for relocation, visa and permit support for international assignments.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in Malaysia.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 4 days ago
Expires 1 month from now
14 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
Fusion Consulting
Kuala Lumpur
Related job offers
-
Product Ops & Data Specialist
Delivery Hero Kuala Lumpur -
Consulting Engineer - Collaboration (Japanese Speaking)
cisco Kuala Lumpur -
Technical Consulting Engineer - Web Applications (Japanese Speaker)
cisco Kuala Lumpur -
Intern IT Governance
prudential Kuala Lumpur (Takaful) -
Junior IT Developer - HR & Payroll Application
Western Digital Bayan Lepas