At a Glance
- Tasks: Design and develop high-quality data models for analytics and reporting.
- Company: Public sector organisation in Glasgow with a focus on innovation.
- Benefits: Competitive rate of £526/day, hybrid working, and potential contract extension.
- Other info: Join a dynamic Agile team with opportunities for continuous improvement.
- Why this job: Make a real impact by optimising data for powerful insights in a collaborative team.
- Qualifications: 3-7+ years in data modelling and strong SQL skills required.
The predicted salary is between 63000 - 77000 £ per year.
Venesky-Brown’s client, a public sector organisation in Glasgow, is currently looking to recruit Data Modeller for initial 8 month contracts with potential to extend on a rate of £526/day (Inside IR35).
These roles will be hybrid working with a minimum of 2 days per week in their Glasgow office.
Responsibilities
- The Data Modeller will be responsible for designing, developing, and maintaining high-quality data models and datamarts that support analytical and reporting needs.
They will translate business requirements into scalable, performant, and well-structured data models that enable efficient consumption in Power BI and other reporting tools.
- Working as part of a multidisciplinary Agile delivery team, the Data Modeller will ensure that data structures are robust, governed, and aligned with organisational data standards and architecture principles.
Essential Skills
- Designing and developing dimensional data models and datamarts to support reporting and analytics use cases
- Translating business requirements and user stories into logical and physical data models aligned to reporting needs
- Applying best-practice dimensional modelling techniques to optimise usability and performance
- Collaborating with Data Engineers to ensure data pipelines and transformations deliver clean, reliable, and appropriately structured data
- Defining and maintaining data definitions, metadata, and data dictionaries to support consistent understanding and reuse
- Ensuring data models are optimised for Power BI consumption, including considerations for performance, aggregation, and usability
- Supporting the design of semantic layers and ensure alignment between data models and reporting models
- Working closely with Business Analysts and Power BI Developers to ensure data structures meet analytical requirements
- Implementing and uphold data governance standards, including naming conventions, lineage, and documentation
- Identifying opportunities to improve data quality, consistency, and reusability across datamarts
- Supporting testing and validation activities, ensuring data accuracy and integrity
- Contributing to continuous improvement in data modelling standards, patterns, and tools
- Solid understanding of how data modelling impacts report performance and usability
- Working with SQL and data transformation processes
- Working with modern data platforms (data warehouses, data lakes)
- Data governance, metadata management, and data quality principles
- Working in Agile delivery teams, collaborating with cross-functional roles
- Analytical thinking, attention to detail, and ability to communicate data concepts clearly
- 3-7+ years’ experience in data modelling, data warehousing, or analytics engineering roles is expected.
If you would like to hear more about this opportunity please get in touch.
Data Modeler in Scotland employer: Venesky Brown
Venesky-Brown is an exceptional employer, offering a dynamic work environment in the heart of London, where you can lead significant infrastructure projects that shape the future. With a strong focus on employee growth and development, we provide opportunities for continuous improvement and professional advancement, all while fostering a collaborative culture that values innovation and stakeholder engagement. Join us to be part of a major UK Infrastructure Programme, where your expertise will directly contribute to impactful change in a thriving city.
StudySmarter Expert Advice🤫
We think this is how you could land Data Modeler in Scotland
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Venesky Brown before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Venesky Brown.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Venesky Brown.
We think you need these skills to ace Data Modeler in Scotland
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Venesky Brown, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Venesky Brown, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Venesky Brown’s attention and show the tangible impact of your work.
How to prepare for a job interview at Venesky Brown
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Venesky Brown.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Venesky Brown.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Venesky Brown.
