Data Modeler with expertise in Snowflake and SQLdbm
7 days ago
Client
Our client revolutionizes the retail direct store delivery model by addressing key challenges like communication gaps, out-of-stocks, invoicing errors, and price inconsistencies to boost sales, profits, and customer loyalty with innovative technology and partnerships.
Position overview
We are seeking an experienced Data Modeler to lead logical and physical data modeling efforts across Raw, Conformed, and CDM layers within a medallion architecture. The ideal candidate will design dimensional (star/snowflake) and 3NF schemas where appropriate, implement and enforce modeling standards (naming conventions, data types, SCD strategies), and maintain thorough documentation using SqlDBM or equivalent tools.
Responsibilities
- Lead logical and physical data modeling across Raw, Conformed, and CDM layers following medallion architecture
- Design dimensional (star/snowflake) and 3NF schemas where appropriate
- Implement and enforce modeling standards, including naming conventions, data types, and SCD strategies
- Document models and processes using SqlDBM or equivalent tools
- Translate business requirements into canonical data models and source-to-target mappings
- Collaborate closely with engineers and analysts to ensure alignment and accuracy
- Design and optimize Snowflake schemas focusing on DDL, micro-partitions, clustering, RBAC, and cost-efficient patterns
- Manage Postgres schema design, perform tuning, and optimize queries
- Review and refactor PL/pgSQL code (bonus)
- Maintain strong data governance practices including version control, peer reviews, and data lineage tracking
Requirements
- Proven expertise in data modeling across multiple layers of medallion architecture
- Strong understanding of data modeling concepts (OLTP, Star Schema, Medallion architecture)
- Strong experience with dimensional modeling (star/snowflake) and 3NF design
- Skilled in Snowflake schema design, performance tuning, and security best practices
- Experience with Postgres schema design and query optimization
- Familiarity with data governance standards and tools
- Proficiency with SqlDBM/ERwin or equivalent modeling/documentation platforms
-
BI Data Engineer
1 day ago
Larnaca Municipality, Larnaka, Cyprus HFM Full timeHFM is an internationally acclaimed multi-asset broker, delivering cutting-edge trading tools, platforms, and conditions to traders worldwide. We are committed to innovation, transparency, and excellence in the financial markets. As we continue to expand, we are seeking a driven and strategicBusiness Intelligence Data Engineerto join our team.The BI Data...
-
BI Analytics Engineer
6 days ago
Larnaca, Larnaka, Cyprus HFM Full time €60,000 - €120,000 per yearHFM is an internationally acclaimed multi-asset broker, delivering cutting-edge trading tools, platforms, and conditions to traders worldwide. We are committed to innovation, transparency, and excellence in the financial markets. As we continue to expand, we are seeking a driven and strategic Business Intelligence Data Engineer to join our team.The Analytics...
-
Senior EDM Software Engineer
7 days ago
Larnaca, Larnaka, Cyprus Rimes Full time €90,000 - €120,000 per yearAbout RimesRimes provides enterprise data management solutions to the global investment community. Driven by our passion for solving the most complex data problems, we provide our clients with investment intelligence that powers more than US$75 trillion in assets under management annually. The world's leading institutional investors, asset managers and...
-
Junior Software Engineer
7 days ago
Larnaca, Larnaka, Cyprus Rimes Full time €40,000 - €60,000 per yearAbout RimesRimes provides enterprise data management solutions to the global investment community. Driven by our passion for solving the most complex data problems, we provide our clients with investment intelligence that powers more than US$75 trillion in assets under management annually. The world's leading institutional investors, asset managers and...
-
People Data Analyst
3 days ago
Larnaca, Larnaka, Cyprus HFM Full time €40,000 - €70,000 per yearHFM is an internationally acclaimed multi-asset broker, delivering cutting-edge trading tools, platforms, and conditions to traders worldwide. We are committed to innovation, transparency, and excellence in the financial markets.About The RoleWe are seeking a detail-oriented People Data Analyst to join our team and support data-driven decision-making across...
-
EDM Software Engineer
7 days ago
Larnaca, Larnaka, Cyprus Rimes Full time €40,000 - €60,000 per yearAbout RimesRimes provides enterprise data management solutions to the global investment community. Driven by our passion for solving the most complex data problems, we provide our clients with investment intelligence that powers more than US$75 trillion in assets under management annually. The world's leading institutional investors, asset managers and...
-
Operations Data Analyst
7 days ago
Larnaca, Larnaka, Cyprus Rimes Full time €40,000 - €80,000 per yearAbout RimesRimes provides enterprise data management solutions to the global investment community. Driven by our passion for solving the most complex data problems, we provide our clients with investment intelligence that powers more than US$75 trillion in assets under management annually. The world's leading institutional investors, asset managers and...
-
EU Project Manager
6 days ago
Larnaca Municipality, Larnaka, Cyprus C.I.P Citizens In Power Full time €25,000 - €60,000 per yearCompany DescriptionC.I.P. Citizens In Power (CIP) is a leading non-profit educational and research organization based in Cyprus, focusing on global education, social innovation, citizen engagement, entrepreneurship, STEM, AI, clean energy, and sustainable growth. CIP has successfully managed over 70 EU-funded projects spanning notable programs like KA3,...
-
FP&A reporting manager, Larnaca – FPA/11/25
7 days ago
Larnaca, Larnaka, Cyprus Human Asset Full time €40,000 - €60,000 per yearFP&A reporting manager, Larnaca – FPA/11/25We are looking for the Financial Planning, Analysis and Reporting Manager at a modern international family office.Role OverviewThe position reports to the CEO and focuses on cashflow forecasting, budgeting, and consolidated management reporting. The role combines analytical expertise with financial acumen and...
-
Product Owner
7 days ago
Larnaca, Larnaka, Cyprus CFI Financial Group Full time €50,000 - €100,000 per yearWho are we?CFI Financial Group is an award-winning trading provider, possessing more than 25 years of experience with multiple offices around the world including London, Larnaca, Beirut, Amman, Dubai, Kuwait, Port Louis, and others.Check out more about CFI here.CFI is hiring Make your mark in the online trading industry.Are you looking to pursue a career in...