Our client is looking for an experienced Data Modeler to join an exciting project in Romania. This role is 100% remote for Romanian citizens.
This role has the responsibility to design and document data models (conceptual, logical and physical) belonging to multiple subject areas across multiple countries, being an expert in Data Modelling and being able to clearly articulate best practice aroud data modelling to the business.
Summary of the Role & Responsibilities:
Main responsibilities:
· Analysing and translating business needs into long-term solution data models
· Evaluating existing data systems
· Working with the development team to create conceptual data models and data flows
· Developing best practices for data coding to ensure consistency within the system
· Evaluate existing data models and physical databases for variances and discrepancies
· Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives – delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc.
· Create entity-relationship diagrams for relational systems and dimensional diagrams for the existing and proposed Data Warehouse, Data Marts, and data cubes
· Define ownership, obtain approvals, and communicate data models to Technology teams
· Ensure consistent enterprise view and usage of data assets across the global functions and standards
· Provide architectural expertise in Data warehouse construction and engineering, data source identification, engineering, and migration on latest DB technologies – Snowflake
· Provide feedback to Business Intelligence project and management team to improve data acquisition (structured and unstructured), warehousing methodologies and tools
Requirements | Skills, Knowledge and Abilities:
Must have:
· Data Modeling concepts (Advanced Level)
· ErWin, Snowflake, DB/MS SQLServer
· Modeling experience across large volume based (Tb/Petabytes) environments
· Over-All understanding of Database space (Databases, Data Warehouses, Reporting, Analytics)
· Well versed with Data Modeling platforms like Erwin, ER STUDIO
· Strong skills in Entity Relationship Modeling (ERWin modeling software preferred)
· Good knowledge about Database Designing / Administration, Advanced Data Modeling for Star Schema design
· Good understanding of Normalized / Denormalized / Star / Snowflake design concepts
· SQL query development for investigation and analysis
· Demonstrable experience using data modeling tools – e.g., ErWin, SQLDBM
Nice to have:
· Open to learn new technologies in-line with organizational needs / direction
· Experience with Data Profiling Tools and BI tools like MicroStrategy
· Experience with the technologies in the Hadoop ecosystem like Hadoop, HDFS, Spark, and Hive
· Experience in working with modern cloud data platforms in AWS (preferred)
· Experience in Agile development processes
· Experience in Cross industry / Quick service restaurant / Retail
Other details:
· Ability to independently learn new technologies and data related approaches
· Effective writing and presentation skills
· Excellent problem-solving skills, should possess a consulting mindset
· Experience with managing meta data for data models
· Demonstrable experience in developing, publishing, and maintaining all documentation for data models
· Significant proven experience in applying rigorous data management principles and industry standard development approach to model complex and high-volume data assets to build, maintain conceptual, logical, and physical data models
