Data Modeler

Peaple Talent have partnered with a leading technology consultancy who are specialist within the UK financial services market who are currently recruiting a Data Modeler on a permeant basis out of their offices in central Birmingham. You will work as part of a larger team where you will be responsible for the development, design and implementation of logical and physical data models, reporting and analytics solutions using tools such as Tableau, PowerBI, looker or Qlik.

You will have 7+ years of experience in data modeling, database design, and data architecture, experience with data modeling tools such as Erwin, ER Studio, Lucidchart, or PowerDesigner along with Strong expertise in SQL, relational and NoSQL databases (e.g., Oracle, SQL Server, PostgreSQL, MongoDB).

Key Responsibilities:

Design, develop, and maintain logical and physical data models to support audit and risk assessment processes.
Develop and implement reporting and analytics solutions using tools such as Tableau, Power BI, Looker, or Qlik
Design and develop interactive dashboards that effectively communicate audit insights and risk assessments.
Collaborate with auditors, business stakeholders, and IT teams to understand data requirements and ensure alignment with audit objectives.
Develop and maintain data dictionaries, metadata management, and schema documentation.
Perform data validation, integrity checks, and governance to ensure consistency and compliance with regulatory requirements.
Optimize and maintain data pipelines and data warehousing solutions for structured and unstructured data.
Utilize SQL, data modeling tools (e.g., Erwin, Visio), and scripting languages to define and implement database solutions.
Optimize dashboard performance and usability by implementing best practices in data visualization
Document data structures, business logic, and workflows to ensure transparency and knowledge sharing within the team.

Required Qualifications:

Bachelor’s or Master’s degree in Data Science, Computer Science, Information Systems, or a related field.
7+ years of experience in data modeling, database design, and data architecture.
Experience with data modeling tools such as Erwin, ER Studio, Lucidchart, or PowerDesigner
Strong expertise in SQL, relational and NoSQL databases (e.g., Oracle, SQL Server, PostgreSQL, MongoDB).
Hands-on experience working with reporting and analytics tools such as Tableau, Power BI, Looker, or Qlik.
Proven expertise in dashboard design and data visualization best practices.
Knowledge of internal audit processes, risk management, and compliance frameworks is highly desirable.
Familiarity with cloud platforms (AWS, Azure, or GCP) and big data technologies (Hadoop, Snowflake, Databricks) is a plus.
Strong problem-solving, analytical, and critical-thinking skills.
Excellent communication and collaboration skills to work effectively with cross-functional teams.
Ability to work in a fast-paced, dynamic environment and handle multiple priorities.