Job Specification: Data Modeler
Location: Glasgow (Hybrid - Two Days Onsite) Salary: Up to £72,000 per annum Employment Type: Full-Time, Permanent
Role Overview: My client is seeking a highly skilled and experienced Data Modeler to their consultancy team. This role involves designing, developing, and maintaining data models that support various business domains, ensuring data consistency, integrity, and scalability. The successful candidate will collaborate with multiple stakeholders to define data requirements and implement robust data architectures.
Key Responsibilities:
Design, develop, and maintain conceptual, logical, and physical data models to support business needs.
Work closely with business analysts, data architects, and application developers to gather and define data requirements.
Create and optimize database schemas and structures to ensure efficiency and data integrity.
Apply best practices for data modeling, including normalization, de-normalization, and dimensional modeling.
Lead the design and implementation of complex data architectures for enterprise-level systems.
Develop and maintain data dictionaries, lineage documentation, and metadata repositories.
Perform data mapping and profiling to ensure quality and consistency across systems.
Collaborate with ETL developers to design data integration strategies for seamless data flow.
Utilize data modeling tools such as Erwin, PowerDesigner, or similar to create and maintain data models.
Provide mentorship and guidance to junior data modelers and engineers.
Ensure compliance with data governance policies, industry standards, and regulatory requirements.
Support data migration efforts by defining mapping and transformation rules.
Model data for various databases, including relational (SQL Server, Oracle, MySQL) and NoSQL (MongoDB, Cassandra) systems.
Work closely with BI and reporting teams to align data models with analytics and visualization needs.
Analyze and optimize existing data models and database performance.
Maintain comprehensive documentation of data models and schemas.
Key Skills & Experience:
Proven experience as a Data Modeler or in a similar role.
Expertise in data modeling methodologies and best practices.
Strong knowledge of database management systems (SQL and NoSQL).
Experience with data modeling tools such as Erwin, PowerDesigner, or equivalent.
Solid understanding of data governance, quality, and security principles.
Hands-on experience with ETL processes and data integration strategies.
Ability to work collaboratively with cross-functional teams.
Excellent problem-solving and analytical skills.
Strong communication skills, both written and verbal.
Preferred Qualifications:
Bachelor's or Masters degree in Computer Science, Data Science, Information Systems, or a related field.
Experience in cloud-based data solutions (AWS, Azure, GCP) is a plus.
Familiarity with Agile methodologies and DevOps practices.
TPBN1_UKTJ