Data Modeler with expertise in Snowflake and SQLdbm
16 hours 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
-
Business Intelligence Data Engineer
2 weeks ago
Larnaca Municipality, Larnaka, Cyprus HFM Full time €60,000 - €80,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 strategicBusiness Intelligence Data Engineerto join our team.The BI Data...
-
Data Engineer
2 weeks 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 Data Engineer to join our team. The Data Engineer's primary...
-
Senior .NET Developer with Braze expertise
1 week ago
Larnaca, Larnaka, Cyprus DataArt Full time €60,000 - €120,000 per yearClientOur client is a leading U.S. healthtech company that is transforming how people access and experience medical care. Their platform serves millions of patients across thousands of cities and powers tens of millions of appointments each year. The engineering organization values strong technical standards, transparency, and collaboration, working on...
-
Senior EDM Software Engineer
4 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
3 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...
-
Marketing Data Analyst
2 weeks ago
Larnaca, Larnaka, Cyprus HFM Full time €40,000 - €80,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 strategicMarketing Data Analystto join our team.The successful candidate...
-
EDM Software Engineer
4 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...
-
EU Project Manager/Researcher
2 weeks ago
Larnaca, Larnaka, Cyprus C.I.P Citizens In Power Full time €35,000 - €70,000 per yearDo you have a passion for European projects, research, and innovation?C.I.P. Citizens in Power (CIP), one of the leading organizations in Cyprus in the field of digital education, social innovation, and STEM, is looking for a dynamicEU Project Manager/Researcherto join our team in Nicosia-Larnaca.What you'll be doing:You'll be involved in writing proposals...
-
FP&A reporting manager, Larnaca – FPA/11/25
16 hours 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
4 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...