Dreams Technologies, UK & India
Website:
dreamstechnologies.com
Job details:
Data Modeller — Senior LevelLocation: Remote (Open to Global Applicants) Work Type: Remote | Full-Time Permanent Experience Required: 7–10 Years
About the RoleWe are seeking a highly skilled and detail-oriented Senior Data Modeller to join a forward-thinking data engineering team. This is a fully remote, permanent opportunity suited for a professional who brings deep expertise in enterprise data modelling, data architecture, and database design.
In this role, you will be responsible for designing, developing, and maintaining robust data models that support business intelligence, analytics, and enterprise data management initiatives. You will work closely with data architects, business analysts, and engineering teams to translate complex business requirements into scalable, high-performance data structures.
The ideal candidate operates with precision, communicates clearly across technical and non-technical stakeholders, and brings a strong track record of delivering enterprise-grade data models in complex environments.
Key Responsibilities- Design and develop conceptual, logical, and physical data models aligned with business and technical requirements
- Build and maintain ER diagrams using ErWin and ER Studio to document data structures across enterprise systems
- Apply 3rd Normal Form (3NF) and dimensional modelling techniques to ensure data integrity and optimal query performance
- Develop and manage data models within MS SQL Server, including stored procedures, views, and indexing strategies
- Lead and contribute to Data Cataloging initiatives — defining metadata standards, data lineage, and business glossary documentation
- Collaborate with data governance teams to enforce data quality standards and modelling best practices
- Perform impact analysis and data model versioning for system migrations and enhancements
- Review and validate data models produced by junior team members, providing technical guidance and mentorship
- Translate complex business requirements into structured, scalable data architecture solutions
- Participate in data architecture reviews and contribute to the development of modelling standards and conventions
Required Skills & Qualifications- 7–10 years of hands-on experience in data modelling and data architecture roles
- Proficiency in ErWin Data Modeler — building and managing enterprise-level ER diagrams
- Proficiency in ER Studio — logical and physical data model design
- Strong experience with Data Cataloging tools and practices — metadata management, data lineage, and business glossary
- Advanced proficiency in MS SQL Server — schema design, query optimization, and performance tuning
- Deep understanding and practical application of 3rd Normal Form (3NF) and normalization principles
- Experience with both OLTP and OLAP data model design
- Ability to work independently in a fully remote environment with minimal supervision
- Strong documentation and communication skills — ability to present data models to non-technical stakeholders
Preferred / Nice-to-Have Skills- Experience with dimensional modelling (Star Schema, Snowflake Schema)
- Exposure to cloud data platforms such as Azure, AWS, or GCP
- Familiarity with data governance frameworks (DAMA, TOGAF)
- Experience with data warehousing and ETL pipeline design
- Knowledge of dbt, Apache Atlas, or Collibra for cataloging and lineage
- Prior experience in Agile / Scrum delivery environments
What You Bring- A structured, methodical approach to solving complex data challenges
- Strong ownership mindset — you take accountability for quality and delivery
- Ability to manage multiple concurrent data modelling workstreams
- Collaborative approach to working across cross-functional teams
- Passion for clean, well-documented, and maintainable data architecture
Click on Apply to know more.