Data Modeler

Avance Consulting
Coventry
2 months ago
Applications closed

Related Jobs

View all jobs

Energy Systems Data Scientist

Data Engineer

Senior Credit Risk Modeller- Data Scientist

Data Scientist, London

Data Scientist, London Geolytix

We are hiring: Data Scientist, London

Role description: (Please include a brief outline of the impact this role will have, including overview of customer industry and projects, access to cutting-edge technology etc.)

•The data modeler plays a crucial role in designing, developing, and maintaining data models to support efficient data management and analytics within the organization.

•This role is essential in optimizing data architecture, translating business initiatives into robust data models, and enhancing data integrity, availability, and performance.

•The data modeler is responsible for developing conceptual, logical, and physical data models.

Key responsibilities:

●Design, create, and implement logical and physical data models for both IT and business solutions to capture the structure, relationships, and constraints of relevant datasets

●Build and operationalize complex data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions

●Effectively collaborate and communicate with various stakeholders to understand data and business requirements and translate them into data models

●Create entity-relationship diagrams (ERDs), data flow diagrams, and other visualization tools to represent data models

●Collaborate with database administrators and software engineers to implement and maintain data models in databases, data warehouses, and data lakes

●Develop data modeling best practices, and use these standards to identify and resolve data modeling issues and conflicts

●Conduct performance tuning and optimization of data models for efficient data access and retrieval

●Incorporate core data management competencies, including data governance, data security and data quality.

Key skills/knowledge/experience:

•At least five years of experience in data modeling, database design, or related field

•Hands-on relational, dimensional, and analytical project experience using RDBMS, NoSQL data platform technologies, and ETL

•Expert knowledge of data modeling concepts, methodologies, and best practices

•Proficiency in data modeling tools such as Erwin or ER/Studio

•Knowledge of relational databases and database design principles

•Familiarity with dimensional modeling and data warehousing concepts

•Strong SQL skills for data querying, manipulation, and optimization, and knowledge of other data science languages, including JavaScript, Python, and R

•Ability to collaborate with cross-functional teams and stakeholders to gather requirements and align on data models

•Excellent analytical and problem-solving skills to identify and resolve data modeling issues

•Strong communication and documentation skills to effectively convey complex data modeling concepts to technical and business stakeholders.

Good to Have

•Domain knowledge. Understanding of the water industry.

Person specification: I.e., negotiating, client facing, communication, assertive, team leading/team member skills, supportive.

•Collaborate with customers and stakeholders.

•Grow your career, while being exposed to new technologies.

•Lead projects and inspire both colleagues and stakeholders.

•Mentor junior employees using your expertise

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.

Jobs Careers

AI Job Interview Warm‑Up: 30 Real Coding & System‑Design Questions

In today's competitive AI job market, nailing a technical interview can be the difference between landing your dream role and getting lost in the crowd. Whether you're looking to break into machine learning, deep learning, NLP (Natural Language Processing), or data science, your problem-solving skills and system design expertise are certain to be put to the test. AI‑related job interviews typically involve a range of coding challenges, algorithmic puzzles, and system design questions. You’ll often be asked to delve into the principles of machine learning pipelines, discuss how to optimise large-scale systems, and demonstrate your coding proficiency in languages like Python, C++, or Java. Adequate preparation not only boosts your confidence but also reduces the likelihood of fumbling through unfamiliar territory. If you’re actively seeking positions at major tech companies or innovative AI start-ups, then check out www.artificialintelligencejobs.co.uk for some of the latest vacancies in the UK. Meanwhile, this blog post will guide you through 30 real coding & system-design questions you’re likely to encounter during your AI job interview. This list is designed to help you practise, anticipate typical question patterns, and stay ahead of the competition. By reading through each question and thinking about the possible approaches, you’ll sharpen your problem-solving skills, time management, and critical thinking. Each question covers fundamental concepts that employers regularly test, ensuring you’re well-equipped for success. Let’s dive right in.

Jobs

Negotiating Your AI Job Offer: Equity, Bonuses & Perks Explained

Artificial intelligence (AI) has proven itself to be one of the most transformative forces in today’s business world. From smart chatbots in customer service to predictive analytics in finance, AI technologies are reshaping how organisations operate and innovate. As the demand for AI professionals grows, so does the complexity of compensation packages. If you’re a mid‑senior AI professional, you’ve likely seen job offers that include far more than just a base salary—think equity, bonuses, and a range of perks designed to entice you into joining or staying with a company. For many, the focus remains squarely on salary. While that’s understandable—after all, your monthly take‑home pay is what covers day-to-day expenses—limiting your negotiations to salary alone can leave considerable value on the table. From stock options in ambitious startups to sign‑on bonuses that ‘buy you out’ of your current contract, modern AI job offers often include elements that can significantly boost your long-term wealth and job satisfaction. This article aims to shed light on the full scope of AI compensation—specifically focusing on how equity, bonuses, and perks can enhance (or sometimes detract from) the overall value of your package. We’ll delve into how these elements work in practice, what to watch out for, and how to navigate the negotiation process effectively. Our goal is to provide mid‑senior AI professionals with the insights and tools to land a holistic compensation deal that accurately reflects their technical expertise, leadership potential, and strategic importance in this fast-moving field. Whether you’re eyeing a leadership role in machine learning at an established tech giant, or you’re considering a pioneering position at a disruptive AI startup, the knowledge in this guide will help you weigh the merits of base salary alongside the potential riches—and risks—of equity, bonuses, and other benefits. By the end, you’ll have a clearer sense of how to align your compensation with both your immediate lifestyle needs and long-term career aspirations.

Jobs

AI Jobs in the Public Sector: MOD, NHS & Gov Digital Service Opportunities

Artificial intelligence (AI) has rapidly evolved from a niche field of computer science into a transformative force reshaping industries across the globe. From healthcare to finance and from education to defence, AI-driven tools and techniques are revolutionising how we approach problems, improve efficiency, and make data-driven decisions. Nowhere is this transformation more apparent than in the United Kingdom’s public sector. Key government entities, including the Ministry of Defence (MOD), the National Health Service (NHS), and the Government Digital Service (GDS), are increasingly incorporating AI into their operations. Consequently, AI jobs within these bodies are growing both in number and strategic importance. In this comprehensive blog post, we will explore the landscape of AI jobs across the UK public sector, with a close look at the MOD, the NHS, and the Government Digital Service. We will delve into the reasons these organisations are investing heavily in AI, the types of roles available, the essential skills and qualifications required, as well as the salary ranges one might expect. Whether you are a new graduate keen to make a meaningful impact through your technical skills or a seasoned professional looking for your next career move, the public sector offers a wealth of opportunities in AI. By the end of this article, you will have a clearer understanding of why AI is so crucial to the public sector’s success, which roles are in demand, and how you can tailor your application to stand out in a competitive and rewarding job market.

🍪 We use cookies to enhance your browsing experience on our website. By continuing to use this site, you consent to the use of cookies as described in our Cookie Policy. You can review our Cookie Policy for more information.