______________________
_____________________
__________________________
___________________
______________________
______________________
_________________________
___________________
__________________
____________________
Data Developer opportunity - Newcastle Under Lyme I am currently working with the UK's largest distributor of decorative surfaces specialising in flooring, worktops, laminates, compact, panel products, solid surfaces and wall panelling who are actively seeking a Data Developer to join the team. With an annual turnover of over £135 million, they take the business of fulfilling their customer's needs very seriously. To this end, their regional branches offer the benefits of nationwide coverage, whilst being especially responsive to needs at a local level. The business is 100% committed to distribution, investing constantly in a best-in-class nationwide network that can cope with the dynamics of its industry; delivering products on a Just-in-Time basis. Their 90,000 sq. ft. central distribution hub is linked to their regional branches, which total over 500,000 sq. ft. of warehousing across the UK. They make more than 2,000 daily deliveries using their fleet of over 100 vehicles achieving a 99% on-time, in-full service. The business has recently undertaken a large transformation project which will see various areas of the business implement new technologies and processes in order to maintain their market share and further grow. A key area of change is within their IT department, where they are now looking to implement the use of Power BI in order to help the business become more data driven through the analysis of key performance indicators and metrics in addition to having real time data at their disposal in order to paint a picture of the general performance of the business and identification of areas of growth. The Data Developer will also be responsible for the further development of the business's data function - mainly responsible for gaining insight from the organisations data of which can be used by the wider team to spot trends and opportunities - working with Power BI and T-SQL. The organisation are also in the process of building a DWH in Azure Data Factory, and so the Data Developer will also have the opportunity to aid in its development, ETL packages and more. The Data Developer will have the following responsibilities: Liaise with various internal stakeholders to gather requirements and identify keys areas of insight Deliver insight and grow a self-service capability across the business through the roll out of Power BI Build trusted data models to support reporting projects including understanding data sources, writing SQL data pipelines and creating and populating data models Design and build sophistication Power BI reports through end-to-end development Aid in the development of internal datawarehouse - utilsing Azure Data Factory Successful candidates will have the following experience: A minimum of 2 year's experience working in an analytical role Strong SQL skills Experience in end-to-end Power BI development Exposure to back-end data engineering / development - ideally experience with cloud tech Strong communication skills Self-starter The role is offering a salary of circa £55,000 however this is open depending on candidate skillset. This comes in addition to an excellent benefits package that boasts a 6% pension contribution, bonus and more. The role will be based in their Newcastle-Under-Lyme office, however offers a hybrid working pattern of 2-3 days in the office per week (discretionary). Interviews will be taking place ASAP - apply today to register your interest. Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates
Concept IT is thrilled to be supporting an established global company that has been at the forefront of revolutionising the mobility industry, pushing boundaries, and driving innovation. You will be working for a company that is recognised as a global leader in designing, manufacturing, and distributing mobility solutions. Data Warehouse Engineer - Design, Developing and Testing Location: West Midlands - Hybrid 2 days on site a week Start Date: ASAP Salary: Up to £70,000 Our client is seeking a Data Engineer to play a pivotal role in designing, building, testing, and deploying Data Warehouse environment and solutions. This role encompasses the entire lifecycle, from planning to data consolidation and aggregation. The Data Engineer will ensure all data products and solutions within the business insights ecosystem meet high standards of resilience, robustness, and reliability, while maintaining thorough documentation. Principal Job Duties & Responsibilities: Design, build, test, and document ETL and ELT solutions. Maintain accurate documentation, including lineage, for all productionised solutions. Monitor and evaluate solution performance and suitability. Ensure the planned architecture of the Data Warehouse environment is delivered. Maintain data models, schemas, and metadata repositories. Monitor and maintain operational data warehouse builds, resolving issues promptly. Identify and escalate potential quality issues or performance risks during monitoring. Assure that developed solutions adhere to agreed standards and controls. Guarantee the release and promotion of newly developed solutions to enhance user functionality and productivity. Provide and improve templates, forms, and processes to standardise the Data Warehouse environment and solutions. Required Skills, Knowledge, and Experience: Experience designing, developing, and testing Azure Data Factory / Fabric pipelines, including PySpark Notebooks and Dataflow Gen2 workflows. Previous experience with Informatica Power Centre is desired. Significant experience in designing, writing, editing, debugging, and testing SQL code, stored procedures, and database schemas, preferably for Microsoft SQL Server and Oracle. Working as part of a data warehouse or data engineering team. Experience with both Cloud (Azure) and On-premise configurations. Proficiency in using Azure DevOps and CI/CD pipelines for automated deployments. Good understanding of data modelling concepts and working within an end-to-end BI lifecycle. Experience working within challenging and complex environments. Competencies: Proficiency in data warehouse management best practices, controls, and standards. Ability to design and code ETL solutions for dimensional, OLAP, and relational-based systems. Experience with Kimball and Inmon architectures for solution design. Knowledge of designing data quality and master data management processes. Forward Thinking Results Orientation Business Acumen Building Collaborative Relationships Personal Credibility Requirements: The role requires various cognitive abilities and effective communication skills, both verbal and written. Additionally, problem-solving skills and the ability to focus on tasks are essential. Reasonable accommodations can be provided for individuals with disabilities. If you possess the required skills and experience and are interested in joining our team, please apply now by clicking APPLY.
Concept IT is thrilled to be supporting an established global company that has been at the forefront of revolutionising the mobility industry, pushing boundaries, and driving innovation. You will be working for a company that is recognised as a global leader in designing, manufacturing, and distributing mobility solutions. Senior Data Warehouse Engineer - Design, Developing and Testing Location: West Midlands - Hybrid 2 days on site a week Start Date: ASAP Salary: Up to £70,000 Our client is seeking a Data Engineer to play a pivotal role in designing, building, testing, and deploying Data Warehouse environment and solutions. This role encompasses the entire lifecycle, from planning to data consolidation and aggregation. The Data Engineer will ensure all data products and solutions within the business insights ecosystem meet high standards of resilience, robustness, and reliability, while maintaining thorough documentation. Principal Job Duties & Responsibilities: Design, build, test, and document ETL and ELT solutions. Maintain accurate documentation, including lineage, for all productionised solutions. Monitor and evaluate solution performance and suitability. Ensure the planned architecture of the Data Warehouse environment is delivered. Maintain data models, schemas, and metadata repositories. Monitor and maintain operational data warehouse builds, resolving issues promptly. Identify and escalate potential quality issues or performance risks during monitoring. Assure that developed solutions adhere to agreed standards and controls. Guarantee the release and promotion of newly developed solutions to enhance user functionality and productivity. Provide and improve templates, forms, and processes to standardise the Data Warehouse environment and solutions. Required Skills, Knowledge, and Experience: Experience designing, developing, and testing Azure Data Factory / Fabric pipelines, including PySpark Notebooks and Dataflow Gen2 workflows. Previous experience with Informatica Power Centre is desired. Significant experience in designing, writing, editing, debugging, and testing SQL code, stored procedures, and database schemas, preferably for Microsoft SQL Server and Oracle. Working as part of a data warehouse or data engineering team. Experience with both Cloud (Azure) and On-premise configurations. Proficiency in using Azure DevOps and CI/CD pipelines for automated deployments. Good understanding of data modelling concepts and working within an end-to-end BI lifecycle. Experience working within challenging and complex environments. Competencies: Proficiency in data warehouse management best practices, controls, and standards. Ability to design and code ETL solutions for dimensional, OLAP, and relational-based systems. Experience with Kimball and Inmon architectures for solution design. Knowledge of designing data quality and master data management processes. Forward Thinking Results Orientation Business Acumen Building Collaborative Relationships Personal Credibility Requirements: The role requires various cognitive abilities and effective communication skills, both verbal and written. Additionally, problem-solving skills and the ability to focus on tasks are essential. Reasonable accommodations can be provided for individuals with disabilities. If you possess the required skills and experience and are interested in joining our team, please apply now by clicking APPLY.