Data Modeler

Position Details: Job Title: Data Modeler Role type: Perm Location: Chester (3 Days a week in Office) Job Description: Candidates need to have Power Designer/Erwin experience Key Responsibilities:

• Data Modeling: Design and implement enterprise-level data models, ensuring adherence to best practices in data modeling methodologies, including 3NF, dimensional modeling, and data vault techniques.
• Data Architecture: Collaborate with data architects, business analysts, and developers to define and design data architecture solutions, including data warehouses, data marts, and operational data stores (ODS).
• Database Design: Create and maintain relational and NoSQL database designs for a variety of platforms, such as SQL Server, Oracle, Netezza, Teradata, DB2, MongoDB, and Elasticsearch.
• Tool Expertise: Utilize advanced data modeling tools like Power Designer and Erwin to develop, analyze, and optimize data models.
• Collaboration: Work closely with business stakeholders to gather requirements and translate them into scalable data models that meet analytical and operational needs.
• ETL Integration: Support ETL processes by ensuring data models align with extraction, transformation, and load (ETL) requirements.
• Data Analysis: Conduct in-depth data analysis to ensure the accuracy, consistency, and integrity of data within the models.
• Documentation: Maintain comprehensive documentation of data models, database designs, and data architecture processes.
• Optimization: Continuously assess and improve data models to enhance performance, scalability, and maintainability.

• Experience:
• hands-on experience in data modeling and database design.
• Expertise in data modeling methodologies such as 3NF, dimensional, and data vault modeling.
• Strong understanding of data architecture concepts, including data warehousing, data marts, ODS, ETL processes, and analytics/reporting.
• Proven experience with relational databases (SQL Server, Oracle, Teradata, etc.) and NoSQL databases (MongoDB, Elasticsearch, etc.).
• Technical Skills:
• Proficiency in data modeling tools such as Power Designer, Erwin, or equivalent.
• Strong SQL skills for data analysis and validation.
• Familiarity with modern data platforms and cloud environments (AWS, Azure, or GCP) is a plus.
• Soft Skills:
• Excellent communication and presentation skills, with the ability to explain technical concepts to non-technical audiences.
• Strong problem-solving skills and attention to detail.
• Ability to work both independently and collaboratively in a fast-paced environment.