Data Modeler

Ascendion
Nottingham
1 month ago
Applications closed

Related Jobs

View all jobs

Data Modeler

Data Modeler

Quantitative Analyst

Data Scientist

Data Modeller

Data Engineer

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.

Get the latest insights and jobs direct. Sign up for our newsletter.

By subscribing you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

10 Essential Books to Read to Nail Your Data Science Career in the UK

Data science continues to be one of the most exciting and rapidly evolving fields in tech. With industries across the UK—ranging from finance and healthcare to e-commerce and government—embracing data-driven decision-making, the demand for skilled data scientists has soared. Whether you're a recent graduate looking for your first role or a professional aiming to advance your career, staying updated through books is crucial. In this article, we explore ten essential books every data science job seeker in the UK should read. Each book provides valuable insights into core concepts, practical applications, and industry-standard tools, helping you build skills employers are actively looking for.

Navigating Data Science Career Fairs Like a Pro: Preparing Your Pitch, Questions to Ask, and Follow-Up Strategies to Stand Out

Data science has taken centre stage in the modern workplace. Organisations rely on data-driven insights to shape everything from product innovation and customer experience to operational efficiency and strategic planning. As a result, there is a growing need for skilled data scientists who can analyse large volumes of data, build predictive models, communicate findings effectively, and collaborate cross-functionally. If you are looking to accelerate your data science career—or even land your first role—attending data science career fairs can be a game-changer. Unlike traditional online applications, face-to-face interactions let you showcase your personality, passion, and communication skills in addition to your technical expertise. However, to stand out in a busy environment, you need a clear strategy: from polishing your personal pitch and asking thoughtful questions to following up with a memorable message. In this article, we’ll guide you through every step of making a strong impression at data science career fairs in the UK and beyond.

Common Pitfalls Data Science Job Seekers Face and How to Avoid Them

Data science has become a linchpin for decision-making and innovation across countless industries, from finance and healthcare to tech and retail. The demand for data scientists in the UK continues to climb, with businesses seeking professionals who can interpret complex datasets, build predictive models, and communicate actionable insights. Despite this high demand, the job market can be extremely competitive—and many applicants unknowingly fall into avoidable traps. Whether you’re an aspiring data scientist fresh out of university, a professional transitioning from a quantitative role, or a seasoned analyst looking to expand your skill set, it’s crucial to navigate your job search effectively. In this article, we explore the most common pitfalls data science job seekers face and provide pragmatic advice to help you stand out. By refining your CV, portfolio, interview strategies, and communication skills, you can significantly increase your chances of landing a rewarding data science role. If you’re looking for your next data science job in the UK, don’t forget to explore the listings at Data Science Jobs. Read on to discover how to avoid critical mistakes and position yourself for success.