cover image
Ascendion

Data Modeler

On site

Chester, United Kingdom

£ 80,000 / year

Full Time

28-01-2025

Share this job:

Score my CV

Job Specifications

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.

About the Company

Ascendion is a leading provider of AI-first software engineering services. Our applied AI, software engineering, cloud, data, experience design, and talent transformation capabilities accelerate innovation for Global 2000 clients. Ascendion is headquartered in New Jersey. In addition to our remote/hybrid workforce, we have a presence in 12 countries and 40+ global offices across North America, Eurpoe, and APAC. We are committed to building technology powered by Generative AI with an inclusive workforce, service to our commun... Know more

Related Jobs

Company background Company brand
Company Name
Amdaris
Job Title
Data Analytics Lead
Job Description
WE ARE AMDARIS At Amdaris, we bring together exceptional talent to deliver custom software solutions and drive digital transformation. Our acquisition by Insight last year has only solidified our standing in the market to become the leading provider of software solutions and paving the way for an exciting growth trajectory with ambitious future goals. Our expertise spans software development, cloud computing, IT strategy, and digital innovation, helping businesses optimise their technology and achieve their strategic objectives. With cutting-edge projects and a dynamic team, there has never been a better time to join us and be part of our journey to shape the future of technology. DATA ANALYTICS LEAD RESPONSIBILITIES Good data comes from good systems and processes and we’re looking for someone who loves when all those numbers add up and mean something. Maintaining and developing our data is what provides us with such a competitive edge. This comes from data visualisation but also the processes and systems behind this collection. Key Responsibilities: Gather, analyse, prioritise and interpret data from multiple sources to help identify trends, patterns and insights. Develop and maintain interactive dashboards and reports to visualise data effectively. Collaborate cross-functionally to provide reports from and for multiple stakeholders in the business. Act as a BA/QA for the data analysts operating near-shore Assist with and identify internal projects to improve business processes and data outputs. Support company data integrity and governance. Support internal software development projects. Be seen as the go-to person for data. DATA ANALYTICS LEAD REQUIREMENTS Proven experience as a Business Intelligence, Business Operations Analyst, Data Analyst or similar role Contract management experience – understanding the order to cash process Proficiency in data visualization tools (e.g. Power BI) Excellent analytical skills, with the ability to interpret complex data sets Detail-oriented with strong problem-solving skills Strong communication skills to present data insights clearly and effectively to stakeholders Experience in finance is a plus Experience of CRM and ERP tools is a plus Experience developing bespoke software is a plus LIFE AT AMDARIS Private Medical Cover Your health is a priority and we’ve got you covered! Work from Anywhere Policy (EMEA) Flexibility to work from wherever inspires you! Flexible and Hybrid working A balance between office days and home comfort. Dog Friendly Office Bring your furry friends along for the ride. Competitive Employer Pension contributions We invest in your future, today. Cycle to work scheme, Electric car scheme, Gym discounts and many more flexible benefits to use at your leisure Health & Wellbeing app Access mindfulness tools, positivity boosts, and wellness support anytime Monthly social and charitable events Build connections and give back while having fun. Beer on Tap!! Raise a glass to celebrate the wins.
Bristol, United Kingdom
On site
Full Time
12-02-2025
Company background Company brand
Company Name
Saragossa
Job Title
Generative AI Lead - LLMs, GenAI and more - up to £150,000 Salary + Bonuses
Job Description
Revolutionise this investment manager by bringing AI into the business in all areas. This is an AI role with a combination of technical and strategic requirements. You'll be working with stakeholders to understand where they can implement various types of AI into the business and improve all workflows using AI to make everything more efficient. Your first few months will be focused on understanding the business and exploring all the opportunities where AI, specifically GenAI/LLMs, can be used within each business area. This could be in the investment systems themselves, the data warehouse, or even the day to day business systems like the CRM. Whilst you're going to be the first specific "AI" hire, you'll have the support of the technology team. If you need something to be built, then the data and software teams will be able to help you. That said, your background should be within AI and Machine Learning, ideally within finance. Given the salary on offer, up to £150,000, you'll need to be an expert in your field and to reach the top end you will definitely need financial services experience. You'll need to be able to show your experience in leading AI related projects and demonstrate where you've used and implemented AI into a business to improve efficiency. You'll also need to show your experience with specific AI/ML frameworks, like TensorFlow, AutoGen, Keras, etc. This is a investment manager with tens of billions under management and you'll be given plenty of autonomy to deliver a range of projects. On top of your salary you'll earn a performance related bonus and also have a range of benefits. Keen to use AI to make a huge difference in this global investment fund? Get in touch. No up-to-date CV required.
London, United Kingdom
On site
Full Time
12-02-2025
Company background Company brand
Company Name
TLP Consultancy Ltd
Job Title
Digital Data Analyst
Job Description
£40.000 - £43.500 Permanent Near Epsom, Surrey (location is most easily reached by own transport) Hybrid working (3 days a week in the office) Generous benefits package (Performance related bonus, Pension, access to their car scheme, Birthday voucher, Cycle Scheme, holiday purchase scheme, discounted onsite gym membership, subsidised Café and Canteen, 25 days holiday + all bank holidays) TLP have been working with Toyota (GB) PLC for over 25 years and are a trusted partner. This role will be employed by TLP (secondment to Toyota (GB) PLC) We have an exciting opportunity within the Performance and Optimization team, responsible for the data analysis, design and the development of digital platform reporting solutions within Customer Engagement and Marketing teams. The data will help the business by collecting, visualizing, analyzing and interpreting website and marketing data to inform key business decision from marketing investment, website improvement opportunities and platform development. This role will shape and implement new processes that provide insights to improve the digital experience and influencing business teams and commercial decisions at all levels. What you’ll be doing: Design & build reports and dashboards using Power BI Performing data analysis and profiling of key sources to evaluate quality and integrity Performing ad hoc / exploratory analysis of data sets to find insights, patterns or trends Collaborating with Data Engineering teams to define and test data sets / models for digital analytics Working with agency partners to manage the production and maintenance of performance dashboards delivered in other platforms (e.g. Adobe Analytics, Google Looker Studio) Maintaining consistency and quality in digital data by ensuring correct tagging and tracking of key platforms in collaboration with agency partners (GA4, GTM, Adobe Analytics) Leading the adoption and understanding of reports and data models across wider business teams Defining and documenting metrics and KPIs, working with internal teams to ensure new products and content is accurately tagged and KPIs are defined Collaborating with colleagues and business stakeholders to gather, analyse and document digital reporting and analytics requirements Monitoring and analysis of production issues, collaborating with wider teams in effective resolution Manage the design, development and maintenance of performance dashboards across several analytics tools, including Adobe Analytics, Power BI and Google Looker Studio. To enable better self-service across the Marketing Communications Team Identify the most effective techniques, data sets and tools to execute functional and non-functional test cases. Use advanced SQL to extract, clean and manipulate large datasets from various sources. Collaborate with data engineering teams to define data sets and models to support digital analytics Maintain digital data quality excellence working with. Toyota Europe and local agency teams to ensure tagging and technical requirements are implemented correctly across our analytics tools including GA4/Adobe Analytics/GTM Ensure digital tagging and tracking procedures are communicated and followed within all marketing activity to enable accurate reporting and analytics. Provide basic training and guidance to encourage wider stakeholders to use analytics tools and reports to self-serve data for their needs and foster a culture of data driven decision making across the business Qualifications and Experience Essential 3+ years of experience in Digital marketing data analytics and delivery or equivalent experience Experience using following Tech stacks - Power BI, SQL, Python, Azure, Snowflake, and Google Analytics Excellent communications skills, creative problem solver, critical thinking capabilities Strong organisational and time management skills Desirable Automotive industry experience Bachelor’s degree, level 4+ apprenticeship (or equivalent) in Data Analytics or a similar discipline. Relevant Microsoft & Azure certifications (e.g. Power BI Data Analyst Associate
Epsom, United Kingdom
Remote
Full Time
12-02-2025
Company background Company brand
Company Name
Paragon Alpha - Hedge Fund Talent Business
Job Title
Software Engineer (Data) - Systematic Trading
Job Description
Python - ETL - Systematic Trading - HFT - StatArb - SQL A $25BN AUM statarb/HFT equities focused hedge fund client are scaling their front office facing data team to support incoming portfolio manager/researcher hires. This Data/Software Engineer will be working on data ingestion, data management, application development and the extension of their state of the art research data platform. As well as working on ad hoc projects for the front office to help them use data correctly and augment their investment process. Ideally looking for 1-5 years experience, excellent STEM degree and competency in both data engineering and software engineer. STRONG Python a MUST. Tech: Python, Pandas, ETL, SQL, Spark, AWS Please apply for more infor.
London, United Kingdom
Hybrid
Full Time
12-02-2025