___________________
______________________
______________________
__________________
______________________
_______________________
__________________
__________________
__________________
_________________________
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.
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 Manager - Building a Modern Warehouse Location: West Midlands Start Date: ASAP Salary: Up to £83,000 Hybrid: 2 days on site ideal We are seeking a skilled Data Warehouse Manager to lead the design, development, and delivery of a new data hub, while also managing the existing legacy data warehouse. This role is crucial for ensuring that the data infrastructure meets the highest standards and supports the business needs effectively. The successful candidate will oversee a talented team and work within our client's IT function. Principal Job Duties & Responsibilities: Design, build, and test corporate data warehouse. Develop, test, and document ETL and ELT solutions. Ensure accurate documentation, including lineage, for all solutions. Monitor and assess solution performance and suitability. Maintain data models, schemas, and metadata repositories. Address operational data warehouse issues promptly. Ensure compliance with standards and controls. Enhance user functionality and productivity with new solutions. Improve processes to standardise their data warehouse environment. Required Skills, Knowledge, and Experience: Extensive experience with SQL, preferably with Microsoft SQL Server and Oracle. Expertise in data warehousing, data modeling, data science, and cloud solutions. Experience with ETL development using Azure Data Factory and Informatica. Previous management experience in data warehousing or data engineering. Familiarity with both Cloud (Azure) and On-prem data platforms. Proficiency in the end-to-end BI lifecycle and complex environments. Experience with Azure DevOps and CI/CD pipelines. Competencies: Strong knowledge of data warehouse management best practices. Proficiency in solution design, build, and testing. Skilled in ETL design and dimensional, OLAP, and relational-based solutions. Experience with Kimball and Inmon architectures. Ability to design data quality and master data management processes. Forward Thinking Results Orientation Business Acumen Building Collaborative Relationships Personal Credibility Requirements: This role requires various cognitive abilities and effective communication skills, both verbal and written. Additionally, the ability to focus on tasks and problem-solving skills 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.