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.
Qualifications:
* 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.