Senior BI DeveloperBristol (remote)£45,000 - £60,000Permanent I am currently parenting with a global supplier currently operating across numerous countries, making up a large portion of the world's industrial sales. They are seeking a Senior BI Developer to support three main business lines: supporting the global BI service, developing BI apps using Qlik Sense and the DWH using SQL Server and migrating to Microsoft Fabric/Azure/Power BI. Senior BI Developer - What will you be doing? Supporting the BI services, including incident resolutions. Working with internal customers, performing business analysis to discover requirements. Bringing data together with engineering and modelling techniques from multiple sources. Developing and testing the SQL based Data Warehouse. Support business users with self-service apps. Analysing and inspecting incoming data to ensure efficient data quality. Senior BI Developer - What will you need? A strong business intelligence background. Power BI, Azure, SQL and Excel experience. Understanding or experience within Qlik. Experience of analysing and diagnosing complex data issues. Experience of ETL development. Data engineering and data modelling experience. Robert Walters are proud to specialise in BI & Data recruitment across the UK, offering amazing opportunities on a permanent and interim basis. We are also proud to be heading up the PBI BRUM meetup group, bringing new and exciting networking opportunities to candidates and clients in the Midlands. If you would be interested in speaking about the role or having a general chat about your job search, please send your CV to . Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates
Apr 17, 2024
Full time
Senior BI DeveloperBristol (remote)£45,000 - £60,000Permanent I am currently parenting with a global supplier currently operating across numerous countries, making up a large portion of the world's industrial sales. They are seeking a Senior BI Developer to support three main business lines: supporting the global BI service, developing BI apps using Qlik Sense and the DWH using SQL Server and migrating to Microsoft Fabric/Azure/Power BI. Senior BI Developer - What will you be doing? Supporting the BI services, including incident resolutions. Working with internal customers, performing business analysis to discover requirements. Bringing data together with engineering and modelling techniques from multiple sources. Developing and testing the SQL based Data Warehouse. Support business users with self-service apps. Analysing and inspecting incoming data to ensure efficient data quality. Senior BI Developer - What will you need? A strong business intelligence background. Power BI, Azure, SQL and Excel experience. Understanding or experience within Qlik. Experience of analysing and diagnosing complex data issues. Experience of ETL development. Data engineering and data modelling experience. Robert Walters are proud to specialise in BI & Data recruitment across the UK, offering amazing opportunities on a permanent and interim basis. We are also proud to be heading up the PBI BRUM meetup group, bringing new and exciting networking opportunities to candidates and clients in the Midlands. If you would be interested in speaking about the role or having a general chat about your job search, please send your CV to . Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates
Pricing BI/SQL/Data Warehouse/ETL Developer required to work on a Hybrid model and to work at my clients HQ in North London. You must be able to commute to North London to be considered. Job purpose: To design, develop, trial, and maintain my client's Business Intelligence solutions, with a specific focus on Pricing/Actuarial deliverables. This will involve working closely with their Pricing teams to understand the requirements, then building new data structures within their existing SQL Server data warehouse platform, in such a way as to be easily integrated into robust and efficient daily ETL processes. You will need to be happy to work in an Agile environment, where throwaway proofs-of-concept need to be created, followed by iterative incremental development before arriving at solution designs ready for industrialisation, within a Microsoft SQL Server stack (currently on-premise, soon to be Azure). Skills required: Experience of Building new data structures within an existing SQL Server data warehouse platform Experience of integration into robust and efficient daily ETL processes. Experience working within an Agile environment. Maintain, design and build within existing ETL architecture using MS stack: eg SQL Server 2022, T-SQL, Power BI Report Server, SSIS, Azure Dev Ops, Git. Ensure business-led efficient Power BI dashboards can be created from the developed data structures to support pricing risk monitoring and modelling. This position comes with excellent benefits; pension, good holidays and some working from home. Please send in your CV if you have the above skills and you are easily commutable to and from North London.
Apr 16, 2024
Full time
Pricing BI/SQL/Data Warehouse/ETL Developer required to work on a Hybrid model and to work at my clients HQ in North London. You must be able to commute to North London to be considered. Job purpose: To design, develop, trial, and maintain my client's Business Intelligence solutions, with a specific focus on Pricing/Actuarial deliverables. This will involve working closely with their Pricing teams to understand the requirements, then building new data structures within their existing SQL Server data warehouse platform, in such a way as to be easily integrated into robust and efficient daily ETL processes. You will need to be happy to work in an Agile environment, where throwaway proofs-of-concept need to be created, followed by iterative incremental development before arriving at solution designs ready for industrialisation, within a Microsoft SQL Server stack (currently on-premise, soon to be Azure). Skills required: Experience of Building new data structures within an existing SQL Server data warehouse platform Experience of integration into robust and efficient daily ETL processes. Experience working within an Agile environment. Maintain, design and build within existing ETL architecture using MS stack: eg SQL Server 2022, T-SQL, Power BI Report Server, SSIS, Azure Dev Ops, Git. Ensure business-led efficient Power BI dashboards can be created from the developed data structures to support pricing risk monitoring and modelling. This position comes with excellent benefits; pension, good holidays and some working from home. Please send in your CV if you have the above skills and you are easily commutable to and from North London.
£43k - £50k, salary dependant on skills and experience Base location in either Lincoln or Huntingdon (depending on your location) and home working (expectation is 2 days in the office) Permanent Full time, 37 hours per week Do you have prior experience of Enterprise Data Engineering, dimensional modelling? Do you have experience of working within an Agile environment or are keen to work in one? Do you like to always explore, learn, challenge yourself and are a good team player? If you can answer yes to the above we have an exciting opportunity for you with our expanding team! The Data and Digital Services team will transform the way data and digital services are provided in Anglian Water, moving from an order-taker service to a trusted, informed partner. The data service will go beyond the traditional data warehouse to provide a modern business intelligence capability that supports distributed (crowd-sourced) reporting and analytics, allowing business SMEs and data and analytics SMEs to work hand in hand to deliver insight to drive business performance. The team will keep the BI service in step with emerging technologies and practices to ensure their activities continue to align to externally recognised best practices. What will my role involve? The Enterprise Data Engineer is a T-shaped professional (also referred to as a generalised specialist) with identifiable core skills yet with an ability to work across multiple disciplines (both technical and non-technical) as required. The Enterprise Data Engineer whilst having core skills to enable them to deliver data and analytical solutions on our analytics and big data platform, you will also act as a technical expert in all aspects of delivery and provide leadership and guidance to small project teams/resources in a collaborative way. You will be expected to work in Agile/Scrum environment in a squad model consisting of various other developers. You may be expected to work as lead on the squad and/or fulfil other roles within the squad. The Enterprise Data Engineer will have the core skills to be able to carry out following activities: Actively contribute to work estimation Adopt and embed agile development and continuous improvement into team ways of working Support the on boarding of new team members & coach other Data Engineers Actively contribute to drafting and updating our service policies, procedures, work instructions and guidance notes. As a BI Solution Architect/Dimensional Modeller, design robust, secure and supportable corporate data solutions to meet business requirements following dimensional modelling methodology, considering privacy by design and self-service capabilities by default. As an ETL Developer, develop, test and/or quality assure extracts of data from corporate systems into the Data Lake As a Semantic Layer Developer, develop, test and/or quality assure semantic models As a Report Developer, develop, test and/or quality assure reports, visualisations and dashboards, producing lo-fi and hi-fi wireframes and capturing purpose. As a Test Automation Specialist, responsible for building new automated test frameworks, for developing test harnesses for each component and be responsible for raising the overall test coverage across the project. would work with each squad to ensure the culture of automated testing is embraced and that any technical challenges are resolved. These processes are essential to building robust delivery pipelines if the solution is to adopt modern DevOps processes. What does it take to be a Data Engineer? Previous experience in data engineering ideally using Databricks, Azure Data Factory, Spark, Python, SQL, Cosmos DB, Microsoft Azure Analysis services, PowerBI Dimensional data modelling Experience in delivering end to end BI solution from requirements, design to delivery Experience of working within an Agile/Scrum environment Experience/understanding of Product lifecycle management Knowledge of Azure DevOps or similar tools As a valued employee, you'll be entitled to: Personal private health care 26 days annual leave - rising with length of service Flexible working Pension scheme - Anglian Water double-matches your contributions up to 6% Bonus scheme Flexible benefits to support your wellbeing and lifestyle. Inclusion at Anglian Water: Join us and make a difference. Our customers come from a wide range of backgrounds, and we think our workplace should reflect that. We are committed to making sure all our colleagues feel they belong and are supported to succeed. Together with our fellow water companies, we are committed to the Social Mobility Pledge; we are also a signatory to Business in the Community's Race at Work charter; we hold the Armed Forces Gold Covenant for Employers; we are an accredited Disability Confident employer and we play a leading part in the Women's Utility Network.
Apr 16, 2024
Full time
£43k - £50k, salary dependant on skills and experience Base location in either Lincoln or Huntingdon (depending on your location) and home working (expectation is 2 days in the office) Permanent Full time, 37 hours per week Do you have prior experience of Enterprise Data Engineering, dimensional modelling? Do you have experience of working within an Agile environment or are keen to work in one? Do you like to always explore, learn, challenge yourself and are a good team player? If you can answer yes to the above we have an exciting opportunity for you with our expanding team! The Data and Digital Services team will transform the way data and digital services are provided in Anglian Water, moving from an order-taker service to a trusted, informed partner. The data service will go beyond the traditional data warehouse to provide a modern business intelligence capability that supports distributed (crowd-sourced) reporting and analytics, allowing business SMEs and data and analytics SMEs to work hand in hand to deliver insight to drive business performance. The team will keep the BI service in step with emerging technologies and practices to ensure their activities continue to align to externally recognised best practices. What will my role involve? The Enterprise Data Engineer is a T-shaped professional (also referred to as a generalised specialist) with identifiable core skills yet with an ability to work across multiple disciplines (both technical and non-technical) as required. The Enterprise Data Engineer whilst having core skills to enable them to deliver data and analytical solutions on our analytics and big data platform, you will also act as a technical expert in all aspects of delivery and provide leadership and guidance to small project teams/resources in a collaborative way. You will be expected to work in Agile/Scrum environment in a squad model consisting of various other developers. You may be expected to work as lead on the squad and/or fulfil other roles within the squad. The Enterprise Data Engineer will have the core skills to be able to carry out following activities: Actively contribute to work estimation Adopt and embed agile development and continuous improvement into team ways of working Support the on boarding of new team members & coach other Data Engineers Actively contribute to drafting and updating our service policies, procedures, work instructions and guidance notes. As a BI Solution Architect/Dimensional Modeller, design robust, secure and supportable corporate data solutions to meet business requirements following dimensional modelling methodology, considering privacy by design and self-service capabilities by default. As an ETL Developer, develop, test and/or quality assure extracts of data from corporate systems into the Data Lake As a Semantic Layer Developer, develop, test and/or quality assure semantic models As a Report Developer, develop, test and/or quality assure reports, visualisations and dashboards, producing lo-fi and hi-fi wireframes and capturing purpose. As a Test Automation Specialist, responsible for building new automated test frameworks, for developing test harnesses for each component and be responsible for raising the overall test coverage across the project. would work with each squad to ensure the culture of automated testing is embraced and that any technical challenges are resolved. These processes are essential to building robust delivery pipelines if the solution is to adopt modern DevOps processes. What does it take to be a Data Engineer? Previous experience in data engineering ideally using Databricks, Azure Data Factory, Spark, Python, SQL, Cosmos DB, Microsoft Azure Analysis services, PowerBI Dimensional data modelling Experience in delivering end to end BI solution from requirements, design to delivery Experience of working within an Agile/Scrum environment Experience/understanding of Product lifecycle management Knowledge of Azure DevOps or similar tools As a valued employee, you'll be entitled to: Personal private health care 26 days annual leave - rising with length of service Flexible working Pension scheme - Anglian Water double-matches your contributions up to 6% Bonus scheme Flexible benefits to support your wellbeing and lifestyle. Inclusion at Anglian Water: Join us and make a difference. Our customers come from a wide range of backgrounds, and we think our workplace should reflect that. We are committed to making sure all our colleagues feel they belong and are supported to succeed. Together with our fellow water companies, we are committed to the Social Mobility Pledge; we are also a signatory to Business in the Community's Race at Work charter; we hold the Armed Forces Gold Covenant for Employers; we are an accredited Disability Confident employer and we play a leading part in the Women's Utility Network.
BI Developer Location: London, UK - Hybrid Working Salary offering: £50K - £60K Per Annum Fixed Term Contract: 12 - 18 Months My client is a leading Regulatory Body professional services organisation, who are looking for an experienced BI Developer to join their growing Data & Analytics team. In this role, you will be responsible for developing and enhancing their data warehouse and BI capabilities, delivering critical reporting and analytics to support the business. Key responsibilities include: Integrating new data sources and enabling reporting on the client's data Performing source-to-target mappings and aligning data structures to enterprise data models Designing and implementing data warehouse solutions, including data flows, ETL processes, and data models Developing interactive dashboards and reports using tools like Power BI Ensuring data quality, governance, and security standards are met Collaborating with business analysts and stakeholders to understand requirements The ideal candidate will have: Extensive experience as a BI Developer or equivalent, with a strong focus on data engineering and analytics In-depth knowledge of the Microsoft BI stack, including SSIS, SQL Server, and Power BI Proven skills in data warehousing, ETL, data modelling, and data analysis Hands-on experience with modern BI tools and Azure data technologies Combined deep technical expertise in data engineering and BI development, along with strong business acumen and stakeholder management skills to deliver high-impact data and analytics solutions. Lead the integration of new data sources, enhance the data warehouse, and drive the delivery of critical business intelligence and reporting. Experience in migrating to Dynamics 365 is advantageous Morgan Hunt is a multi-award-winning recruitment business for interim, contract and temporary recruitment and acts as an Employment Agency in relation to permanent vacancies. Morgan Hunt is an equal opportunities employer. Job suitability is assessed on merit in accordance with the individual's skills, qualifications and abilities to perform the relevant duties required in a particular role.
Apr 12, 2024
Full time
BI Developer Location: London, UK - Hybrid Working Salary offering: £50K - £60K Per Annum Fixed Term Contract: 12 - 18 Months My client is a leading Regulatory Body professional services organisation, who are looking for an experienced BI Developer to join their growing Data & Analytics team. In this role, you will be responsible for developing and enhancing their data warehouse and BI capabilities, delivering critical reporting and analytics to support the business. Key responsibilities include: Integrating new data sources and enabling reporting on the client's data Performing source-to-target mappings and aligning data structures to enterprise data models Designing and implementing data warehouse solutions, including data flows, ETL processes, and data models Developing interactive dashboards and reports using tools like Power BI Ensuring data quality, governance, and security standards are met Collaborating with business analysts and stakeholders to understand requirements The ideal candidate will have: Extensive experience as a BI Developer or equivalent, with a strong focus on data engineering and analytics In-depth knowledge of the Microsoft BI stack, including SSIS, SQL Server, and Power BI Proven skills in data warehousing, ETL, data modelling, and data analysis Hands-on experience with modern BI tools and Azure data technologies Combined deep technical expertise in data engineering and BI development, along with strong business acumen and stakeholder management skills to deliver high-impact data and analytics solutions. Lead the integration of new data sources, enhance the data warehouse, and drive the delivery of critical business intelligence and reporting. Experience in migrating to Dynamics 365 is advantageous Morgan Hunt is a multi-award-winning recruitment business for interim, contract and temporary recruitment and acts as an Employment Agency in relation to permanent vacancies. Morgan Hunt is an equal opportunities employer. Job suitability is assessed on merit in accordance with the individual's skills, qualifications and abilities to perform the relevant duties required in a particular role.
Power BI Developer - Woking - Hybrid - £75,000 DataBuzz are recruiting on behalf of a prestigious organisation who are currently seeking a Power BI Developer to collaborate with fellow team members to implement & continuously develop our Power BI reporting, training of Power BI to end users and lead the development Power BI reporting & dashboards for new products & services. As a Power BI Developer, you will be working in a business- critical team, well supported and developed, with the opportunity to work on some really exciting projects. As a Power BI Developer, you will be building dashboards to help commercial teams make decisions, gathering data requirements from colleagues, or helping to understand the performance of a particular brand within the Group. SKills : 3-5 years of relevant work experience (proven track record) in business intelligence/big data environments, driving data analytics, dashboard, and Power BI reporting development. 3-5 years of relevant work experience (proven track record) in leading the development & implementation of Power BI full life cycle reporting. Experienced with Power BI, DAX & MDX, Power BI Administration, Power BI User Security. Experience with Azure Strong understanding of Data Warehouse modelling and terminology Experience with full life cycle delivery of Power BI reports, dashboards, and data feeds. Excellent written and verbal communication, problem solving and analytical skills Experience of working as a member of an agile team and familiar with agile planning and estimation techniques. A good understanding of the fundamental rationale for employing an agile approach Experience of task management using Jira or similar ALM system Benefits : Hybrid Working Training Bonus Contributory Pension Health Care Plans Flexible Working Hours Laptop Mobile developer powerbi datamodelling dax mdx powerbidax powerbimdx azure datawarehouse starschema snowflakeschema agile jira
Sep 23, 2022
Full time
Power BI Developer - Woking - Hybrid - £75,000 DataBuzz are recruiting on behalf of a prestigious organisation who are currently seeking a Power BI Developer to collaborate with fellow team members to implement & continuously develop our Power BI reporting, training of Power BI to end users and lead the development Power BI reporting & dashboards for new products & services. As a Power BI Developer, you will be working in a business- critical team, well supported and developed, with the opportunity to work on some really exciting projects. As a Power BI Developer, you will be building dashboards to help commercial teams make decisions, gathering data requirements from colleagues, or helping to understand the performance of a particular brand within the Group. SKills : 3-5 years of relevant work experience (proven track record) in business intelligence/big data environments, driving data analytics, dashboard, and Power BI reporting development. 3-5 years of relevant work experience (proven track record) in leading the development & implementation of Power BI full life cycle reporting. Experienced with Power BI, DAX & MDX, Power BI Administration, Power BI User Security. Experience with Azure Strong understanding of Data Warehouse modelling and terminology Experience with full life cycle delivery of Power BI reports, dashboards, and data feeds. Excellent written and verbal communication, problem solving and analytical skills Experience of working as a member of an agile team and familiar with agile planning and estimation techniques. A good understanding of the fundamental rationale for employing an agile approach Experience of task management using Jira or similar ALM system Benefits : Hybrid Working Training Bonus Contributory Pension Health Care Plans Flexible Working Hours Laptop Mobile developer powerbi datamodelling dax mdx powerbidax powerbimdx azure datawarehouse starschema snowflakeschema agile jira
We are currently recruiting for a Data Architect to join our Digital Consulting Team. As a Data Architect, you will be responsible for designing and visualising data management frameworks describing the processes used to plan, define, acquire, maintain and control data, and providing guidance on data governance, integration, security, master and metadata management, data acquisition and migration, and data quality principles. As part of our team you will work with our Financial Services clients to create strategic solutions that optimise their digital strategy. Our team works with banks, building societies and other financial organisations to achieve digital transformations in a changing regulatory environment. We can offer great career progression opportunities, ability to be based anywhere across the UK, benefits which you can flex to meet your needs and training and development opportunities. You will be translating business requirements into technology requirements and defining data standards and principles. You will also be dealing with technical and non-technical stakeholders from board level down to technical specialists (DBAs, Data Modellers, and Database Developers etc.). What you will be doing: Responsible for the provision of data architecture and design for solutions for Sopra Steria customers ensuring alignment with IT strategy and target architecture for our customers' data platforms. Translating business requirements into technical specifications, roadmaps and deliverable data solutions, including data streams, integrations, transformations, databases, data warehouses, and business intelligence, reporting and analytical platforms. Defining the data architecture framework, standards and principles, including modelling, metadata, security, reference data such as product codes and client categories, and master data such as clients, vendors, materials, and employees. Defining reference architecture, which is a pattern that others can follow to create and improve data systems Defining data flows and data lineage, visualising which parts of the organization generate data, which require data to function, how data flows are managed, and how data changes in transition What you'll bring: Demonstrable experience in a Financial Services/Banking environment including; fraud, AML, redress and remediation. Proven work experience in data architecture and design. Understanding of conventional and emerging data technologies such as relational and NoSQL databases, data warehousing, business intelligence, descriptive and predictive analytics, data visualization, unstructured data and cloud platforms. An understanding of regulatory nuances involved with different areas within the financial sector. Experience gathering and analysing requirements and turning business problems into data design: designing data architecture by dealing with specific business problems and aligning it to enterprise-wide standards and principles Strong data modelling skills with ability to explain the concepts and principles of data modelling, and to produce, maintain and update relevant data models for specific business needs including reverse-engineering data models from a live system Strong analytical skills with ability to undertake data profiling and source system analysis, and to present clear insights to support the end use of the data It would be great if you had: Knowledge of the latest data regulation and standards - GDPR, ISO etc. Design and development of Single Customer View Experience of data virtualization platforms AWS Certified Solutions Architect (Associate) and/or Azure Certification If you are interested in this role but not sure if your skills and experience are exactly what we're looking for, please do apply, we'd love to hear from you! Employment Type: Full time permanent Location: UK Mobile Security Clearance Level: PES4 Internal Recruiter: Annecia Salary: up to £85,00 Benefits: 25 days annual leave with the option to buy additional days, private medical, life assurance, pension, and generous flexible benefits fund Although this role is advertised as full-time, we believe that flexibility at work can promote work/life balance, increase your motivation, reduce stress and improve performance and productivity. We support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible. Loved reading about this job and want to know more about our company? Our Specialist Private Sector team are experienced in a range of different markets including Banking, Insurance, Retail, Travel, Transport and Utilities. We help our customers develop, deliver and operationalise their digital transformation strategies. We work in true partnership with our customer, gaining a deep understanding of their business and technology issues. Our capabilities and credentials across Private Sector markets enable the design, delivery and management of business transformation programmes. We help our clients respond to changing customer demands, keep ahead of the competition, and safeguard their systems from evolving business and technology risks. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
Sep 21, 2022
Full time
We are currently recruiting for a Data Architect to join our Digital Consulting Team. As a Data Architect, you will be responsible for designing and visualising data management frameworks describing the processes used to plan, define, acquire, maintain and control data, and providing guidance on data governance, integration, security, master and metadata management, data acquisition and migration, and data quality principles. As part of our team you will work with our Financial Services clients to create strategic solutions that optimise their digital strategy. Our team works with banks, building societies and other financial organisations to achieve digital transformations in a changing regulatory environment. We can offer great career progression opportunities, ability to be based anywhere across the UK, benefits which you can flex to meet your needs and training and development opportunities. You will be translating business requirements into technology requirements and defining data standards and principles. You will also be dealing with technical and non-technical stakeholders from board level down to technical specialists (DBAs, Data Modellers, and Database Developers etc.). What you will be doing: Responsible for the provision of data architecture and design for solutions for Sopra Steria customers ensuring alignment with IT strategy and target architecture for our customers' data platforms. Translating business requirements into technical specifications, roadmaps and deliverable data solutions, including data streams, integrations, transformations, databases, data warehouses, and business intelligence, reporting and analytical platforms. Defining the data architecture framework, standards and principles, including modelling, metadata, security, reference data such as product codes and client categories, and master data such as clients, vendors, materials, and employees. Defining reference architecture, which is a pattern that others can follow to create and improve data systems Defining data flows and data lineage, visualising which parts of the organization generate data, which require data to function, how data flows are managed, and how data changes in transition What you'll bring: Demonstrable experience in a Financial Services/Banking environment including; fraud, AML, redress and remediation. Proven work experience in data architecture and design. Understanding of conventional and emerging data technologies such as relational and NoSQL databases, data warehousing, business intelligence, descriptive and predictive analytics, data visualization, unstructured data and cloud platforms. An understanding of regulatory nuances involved with different areas within the financial sector. Experience gathering and analysing requirements and turning business problems into data design: designing data architecture by dealing with specific business problems and aligning it to enterprise-wide standards and principles Strong data modelling skills with ability to explain the concepts and principles of data modelling, and to produce, maintain and update relevant data models for specific business needs including reverse-engineering data models from a live system Strong analytical skills with ability to undertake data profiling and source system analysis, and to present clear insights to support the end use of the data It would be great if you had: Knowledge of the latest data regulation and standards - GDPR, ISO etc. Design and development of Single Customer View Experience of data virtualization platforms AWS Certified Solutions Architect (Associate) and/or Azure Certification If you are interested in this role but not sure if your skills and experience are exactly what we're looking for, please do apply, we'd love to hear from you! Employment Type: Full time permanent Location: UK Mobile Security Clearance Level: PES4 Internal Recruiter: Annecia Salary: up to £85,00 Benefits: 25 days annual leave with the option to buy additional days, private medical, life assurance, pension, and generous flexible benefits fund Although this role is advertised as full-time, we believe that flexibility at work can promote work/life balance, increase your motivation, reduce stress and improve performance and productivity. We support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible. Loved reading about this job and want to know more about our company? Our Specialist Private Sector team are experienced in a range of different markets including Banking, Insurance, Retail, Travel, Transport and Utilities. We help our customers develop, deliver and operationalise their digital transformation strategies. We work in true partnership with our customer, gaining a deep understanding of their business and technology issues. Our capabilities and credentials across Private Sector markets enable the design, delivery and management of business transformation programmes. We help our clients respond to changing customer demands, keep ahead of the competition, and safeguard their systems from evolving business and technology risks. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
Power BI Developer £350 - £400/Day Inside IR35 Remote 5 Months We are seeking a Power BI Developer for our Public Sector client on a remote basis. This is an initial contract until March, paying between £350 - £400/Day Inside IR35. This role is inside IR35 - Due to the service of the role this will now be based on an Umbrella solution. Role Profile: Proven Power BI and data experience gained in previous roles * Experience of publishing Power BI reports on the web and external organisation distributions * Candidate has previously deployed Power BI reports externally * Demonstrates a high degree of proficiency in designing and developing complex, high quality dashboard solutions * Candidate demonstrates previous experience of developing their own dashboards * Previous experience of meeting the visualisation, reporting and analytics needs of reporting functions through development of presentation and data models * Candidate demonstrates experience of the development of visualisation of data and reporting products * Experience of working with large dataset and advance level calculations * Candidate demonstrates experience building reports based on large datasets using advance level calculations * Working closely with management teams to understand their requirements and develop dashboarding, reporting and analytic solutions through prototyping and requirements analysis. * Candidate demonstrates previous experience of developing Dashboards and Reports based on requirements * Excellent communication skills, ability to understand end user requirements and present reports to senior management audiences. * Candidate has strong experience of communicating with senior audiences and end users * Previous experience of working within Cloud Services, specifically within Azure environment including SQL Databases and Power BI Services. Knowledge of implementing row level security. * Candidate demonstrates knowledge and experience of working with these technological platforms and services - assisting other where required. * Experience developing using SQL, relational databases and data warehousing technologies. Primary skills required SQL, Power BI and Power Query & DAX. Desirable knowledge of R and Python. * Candidate demonstrates technical experience of developing data services using listed technologies and coding. * Experience building Data Models for use by multiple end users providing design methodology and project documentation. * Candidate demonstrates ability to collaboratively create a Data Model, specifically within Power BI, that includes development and maintenance of the service wrap (e.g. documentation / user support). * Experience in working within an Agile delivery setup * Candidate has evidence of previously working in an agile delivery environment * Understands relationships with Product Owners, Scrum Master, Design Leads, Platform Engineers & Solution Architects, demonstrates knowledge of these roles and experience of working with them * Candidate demonstrates strong experience of working in fast-paced environment * Public sector experience desirable If you are interested in the above role Do Not Call - Click the "Apply Now" button now for immediate review Power BI Developer, PowerBI Developer, Power BI, Developer, BI Developer, Business Intelligence Developer, BI, Business Intelligence, Reports, Reporting, SQL, Cloud, Azure, AWS, Power Query, PowerQuery, Model, Models, Modelling, R, Python, Data, DAX, Public Sector, Data Models, Data Modelling, Data Warehousing, Data Warehouse, Agile, Delivery Circle Recruitment is acting as an Employment Agency in relation to this vacancy. Earn yourself a referral bonus if you refer somebody else who fills the role! We also offer an iPad if you refer a new client to us and we recruit for them. Follow us on Facebook - Circle Recruitment , Twitter and LinkedIn - Circle Recruitment.
Oct 07, 2021
Contractor
Power BI Developer £350 - £400/Day Inside IR35 Remote 5 Months We are seeking a Power BI Developer for our Public Sector client on a remote basis. This is an initial contract until March, paying between £350 - £400/Day Inside IR35. This role is inside IR35 - Due to the service of the role this will now be based on an Umbrella solution. Role Profile: Proven Power BI and data experience gained in previous roles * Experience of publishing Power BI reports on the web and external organisation distributions * Candidate has previously deployed Power BI reports externally * Demonstrates a high degree of proficiency in designing and developing complex, high quality dashboard solutions * Candidate demonstrates previous experience of developing their own dashboards * Previous experience of meeting the visualisation, reporting and analytics needs of reporting functions through development of presentation and data models * Candidate demonstrates experience of the development of visualisation of data and reporting products * Experience of working with large dataset and advance level calculations * Candidate demonstrates experience building reports based on large datasets using advance level calculations * Working closely with management teams to understand their requirements and develop dashboarding, reporting and analytic solutions through prototyping and requirements analysis. * Candidate demonstrates previous experience of developing Dashboards and Reports based on requirements * Excellent communication skills, ability to understand end user requirements and present reports to senior management audiences. * Candidate has strong experience of communicating with senior audiences and end users * Previous experience of working within Cloud Services, specifically within Azure environment including SQL Databases and Power BI Services. Knowledge of implementing row level security. * Candidate demonstrates knowledge and experience of working with these technological platforms and services - assisting other where required. * Experience developing using SQL, relational databases and data warehousing technologies. Primary skills required SQL, Power BI and Power Query & DAX. Desirable knowledge of R and Python. * Candidate demonstrates technical experience of developing data services using listed technologies and coding. * Experience building Data Models for use by multiple end users providing design methodology and project documentation. * Candidate demonstrates ability to collaboratively create a Data Model, specifically within Power BI, that includes development and maintenance of the service wrap (e.g. documentation / user support). * Experience in working within an Agile delivery setup * Candidate has evidence of previously working in an agile delivery environment * Understands relationships with Product Owners, Scrum Master, Design Leads, Platform Engineers & Solution Architects, demonstrates knowledge of these roles and experience of working with them * Candidate demonstrates strong experience of working in fast-paced environment * Public sector experience desirable If you are interested in the above role Do Not Call - Click the "Apply Now" button now for immediate review Power BI Developer, PowerBI Developer, Power BI, Developer, BI Developer, Business Intelligence Developer, BI, Business Intelligence, Reports, Reporting, SQL, Cloud, Azure, AWS, Power Query, PowerQuery, Model, Models, Modelling, R, Python, Data, DAX, Public Sector, Data Models, Data Modelling, Data Warehousing, Data Warehouse, Agile, Delivery Circle Recruitment is acting as an Employment Agency in relation to this vacancy. Earn yourself a referral bonus if you refer somebody else who fills the role! We also offer an iPad if you refer a new client to us and we recruit for them. Follow us on Facebook - Circle Recruitment , Twitter and LinkedIn - Circle Recruitment.
JOB OVERVIEW : Technical Business Analyst ideally with financial services experience and experience of working with API's. Great opportunity to work with a diverse cutting-edge tech stack! REMOTE WORKING AVAILABLE! Contract type: Permanent employment contract with excellent comprehensive benefits package. Salary : Negotiable depending on experience c£40,000-c£45,000+ basic salary p.a plus excellent benefits package including up to 10% bonus, 26 days holiday, pension, health, ++ Location :- For those living within 60 miles of my clients central Bournemouth office up to 3 days per week home-working is permitted! For those further than 60 miles from my client's central Bournemouth up to 5 days per week remote-working is permitted! THE COMPANY:- My client based in Bournemouth, Dorset is an established, innovative technology company within the financial services sector. For years they have designed and built exceptional technology which has hugely increased efficiciencies within their market sector. My client has enjoyed strong growth year on year for the last 7 years. My client offers employees a truly exciting and rewarding place to work and lots of career development opportunities along with a commitment to learning new skills. You'll get to work with truely market leading software products built with a cutting edge technology stack. My client values the importance of a great company culture which contributes to them being a fantastic and rewarding company to work for! THE ROLE:- Due to growth, My client are now recruiting for a Technical Business Analyst to join their established team. You'll work closely with business stakeholders, the development team, and QA to ensure accurate implementation of the business' requests. You'll be an experienced Business Analyst who has worked within financial services, with strong technical analysis skills and experience of working with API's. You'll also be passionate about technology, a self-starter with strong problem-solving skills and be looking to join an award-winning technology company who are driving innovate change in their market space. Your responsibilities as Business Analyst will include: Conducting full lifecycle analysis to design solutions and write business requirements and technical specifications Communicate with internal colleagues to understand the needs of departments and the organisation as a whole Producing technical documents based on detailed analysis of multiple data sources Working with internal and external customers to determine business priorities, solution requirements and information needs Collect, organise and analyse large data sets with attention to detail and accuracy Use data modelling practices to analyse your findings and create suggestions for strategic and operational improvements and changes Writing and executing database queries About you: You'll have at least 3 years Business Analyst experience ideally including within financial services Experience working with Agile methodologies and processes Experience with reporting packages, reporting tools, data mapping and transformation, technical analysis, APIs and ETL frameworks Strong knowledge of data models, database design, and data mining The ability to understand complex web applications WHAT'S ON OFFER:- Along with the chance to work for a growing market leader who offers a superb working environment, company culture and very high staff retention ration my client offers; - A highly competitive rate / salary, continuing professional development and ongoing training! - A truely collaborative style of working and the opportunity to work with an extremely well-respected Lead BA keen to further develop your skill set. - remote working - An extremely pleasant and professional working environment with like-minded BA enthusiasts. IF you are a strong match to the specific requirements for this role then please apply with a CV as soon as possible. Candidates who are not a close match sadly cannot be considered. Keywords; Business Intelligence, Analyst, Data, Business, Systems, SQL Server, BI, SSRS, SSAS, SSIS, reports, reporting, Database, DBA, data warehouse, software developer, engineer, programmer, Microsoft SQL Server, T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS), Microsoft Power BI, Microsoft SharePoint, Performance Point, Excel and Power Pivot, MS Azure
Sep 09, 2021
Full time
JOB OVERVIEW : Technical Business Analyst ideally with financial services experience and experience of working with API's. Great opportunity to work with a diverse cutting-edge tech stack! REMOTE WORKING AVAILABLE! Contract type: Permanent employment contract with excellent comprehensive benefits package. Salary : Negotiable depending on experience c£40,000-c£45,000+ basic salary p.a plus excellent benefits package including up to 10% bonus, 26 days holiday, pension, health, ++ Location :- For those living within 60 miles of my clients central Bournemouth office up to 3 days per week home-working is permitted! For those further than 60 miles from my client's central Bournemouth up to 5 days per week remote-working is permitted! THE COMPANY:- My client based in Bournemouth, Dorset is an established, innovative technology company within the financial services sector. For years they have designed and built exceptional technology which has hugely increased efficiciencies within their market sector. My client has enjoyed strong growth year on year for the last 7 years. My client offers employees a truly exciting and rewarding place to work and lots of career development opportunities along with a commitment to learning new skills. You'll get to work with truely market leading software products built with a cutting edge technology stack. My client values the importance of a great company culture which contributes to them being a fantastic and rewarding company to work for! THE ROLE:- Due to growth, My client are now recruiting for a Technical Business Analyst to join their established team. You'll work closely with business stakeholders, the development team, and QA to ensure accurate implementation of the business' requests. You'll be an experienced Business Analyst who has worked within financial services, with strong technical analysis skills and experience of working with API's. You'll also be passionate about technology, a self-starter with strong problem-solving skills and be looking to join an award-winning technology company who are driving innovate change in their market space. Your responsibilities as Business Analyst will include: Conducting full lifecycle analysis to design solutions and write business requirements and technical specifications Communicate with internal colleagues to understand the needs of departments and the organisation as a whole Producing technical documents based on detailed analysis of multiple data sources Working with internal and external customers to determine business priorities, solution requirements and information needs Collect, organise and analyse large data sets with attention to detail and accuracy Use data modelling practices to analyse your findings and create suggestions for strategic and operational improvements and changes Writing and executing database queries About you: You'll have at least 3 years Business Analyst experience ideally including within financial services Experience working with Agile methodologies and processes Experience with reporting packages, reporting tools, data mapping and transformation, technical analysis, APIs and ETL frameworks Strong knowledge of data models, database design, and data mining The ability to understand complex web applications WHAT'S ON OFFER:- Along with the chance to work for a growing market leader who offers a superb working environment, company culture and very high staff retention ration my client offers; - A highly competitive rate / salary, continuing professional development and ongoing training! - A truely collaborative style of working and the opportunity to work with an extremely well-respected Lead BA keen to further develop your skill set. - remote working - An extremely pleasant and professional working environment with like-minded BA enthusiasts. IF you are a strong match to the specific requirements for this role then please apply with a CV as soon as possible. Candidates who are not a close match sadly cannot be considered. Keywords; Business Intelligence, Analyst, Data, Business, Systems, SQL Server, BI, SSRS, SSAS, SSIS, reports, reporting, Database, DBA, data warehouse, software developer, engineer, programmer, Microsoft SQL Server, T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS), Microsoft Power BI, Microsoft SharePoint, Performance Point, Excel and Power Pivot, MS Azure
Brewster Partners Recruitment Group
Doncaster, Yorkshire
THE COMPANY: Brewster Partners are supporting a building and construction company based in Doncaster with their Business Intelligence Developer role, this is required immediately. THE JOB: Experience/knowledge of general ETL (Extract, Transform, Load) concepts and best practices i.e. someone who can be hands on with the design and building of our data pipeline/loads into the DW from our source or ODS store. Someone who can think through the developing, testing, common patterns, issues, debugging and optimisation of data moving from source to target locations Experience/knowledge of general Data Modelling concepts and best practices i.e. they are familiar with how data is organised in to logical models (i.e. entities and the relationships between entities such as site, plot or sales transactions etc.), normalised data structure (they won't necessarily need to do it, but be familiar/comfortable working with it as ODS data will be source for datawarehouse and ODS data will probably be highly normalised etc.) Experience/knowledge of DW design patterns, concepts and best practices, i.e. dimensional modelling, that is, organised data into dimensions and fact tables in a data warehouse setup General knowledge of cloud storage and databases (Microsoft Stack preferred, i.e. Azure, SQL Server, etc.) Knowledge of construction industry, or Microsoft dynamics, etc. would be great/bonus THE PERSON: Technical Informatica - it would be ideal/necessary if this person has the hands-on knowledge/experience of the above point in an Informatica environment SQL - need to have good SQL coding skills (Microsoft's flavour of SQL would be preferred, i.e. T-SQL (Transact-SQL)) Dashboards/Reporting Knowledge General understanding of best practices in data visualisation, numeracy skills, creating calculations, metrics, kpi's etc. essentially how to turn raw data into useful/actionable information for an end user/consumer Technical Power BI SSRS (soon to be Power BI paginated) This role requires two days in the office and required immediately Brewster Partners Office Support & Technical Recruitment is a division of the Brewster Partners Recruitment Group focusing on the recruitment of talent in administration, business support, HR, sales, marketing and purchasing in South Yorkshire, West Yorkshire, East Yorkshire, North Yorkshire, Lincolnshire, Nottinghamshire and the Midlands. If you are interested in discussing this job in more detail or any other aspect of office support and technical recruitment we would really like to hear from you. Please visit our website at Brewster Partners for more information.
Sep 09, 2021
Full time
THE COMPANY: Brewster Partners are supporting a building and construction company based in Doncaster with their Business Intelligence Developer role, this is required immediately. THE JOB: Experience/knowledge of general ETL (Extract, Transform, Load) concepts and best practices i.e. someone who can be hands on with the design and building of our data pipeline/loads into the DW from our source or ODS store. Someone who can think through the developing, testing, common patterns, issues, debugging and optimisation of data moving from source to target locations Experience/knowledge of general Data Modelling concepts and best practices i.e. they are familiar with how data is organised in to logical models (i.e. entities and the relationships between entities such as site, plot or sales transactions etc.), normalised data structure (they won't necessarily need to do it, but be familiar/comfortable working with it as ODS data will be source for datawarehouse and ODS data will probably be highly normalised etc.) Experience/knowledge of DW design patterns, concepts and best practices, i.e. dimensional modelling, that is, organised data into dimensions and fact tables in a data warehouse setup General knowledge of cloud storage and databases (Microsoft Stack preferred, i.e. Azure, SQL Server, etc.) Knowledge of construction industry, or Microsoft dynamics, etc. would be great/bonus THE PERSON: Technical Informatica - it would be ideal/necessary if this person has the hands-on knowledge/experience of the above point in an Informatica environment SQL - need to have good SQL coding skills (Microsoft's flavour of SQL would be preferred, i.e. T-SQL (Transact-SQL)) Dashboards/Reporting Knowledge General understanding of best practices in data visualisation, numeracy skills, creating calculations, metrics, kpi's etc. essentially how to turn raw data into useful/actionable information for an end user/consumer Technical Power BI SSRS (soon to be Power BI paginated) This role requires two days in the office and required immediately Brewster Partners Office Support & Technical Recruitment is a division of the Brewster Partners Recruitment Group focusing on the recruitment of talent in administration, business support, HR, sales, marketing and purchasing in South Yorkshire, West Yorkshire, East Yorkshire, North Yorkshire, Lincolnshire, Nottinghamshire and the Midlands. If you are interested in discussing this job in more detail or any other aspect of office support and technical recruitment we would really like to hear from you. Please visit our website at Brewster Partners for more information.
Senior BI Developer Lancashire c £40,000
High growth, entrepreneurial business. Great opportunity to work with like minded indivuduals and be part of a fantastic team.
The Senior BI Developer will be responsible for designing, developing and maintaining Business Intelligence solutions.
Mentor juniors, deputise for the Head of function, liaise with board, investors and colleagues across the business.
Responsibilities
· Translate business needs to technical specifications
· Design, build and deploy BI solutions
· Evaluate and improve existing BI systems
· Collaborate with teams to integrate systems
· Develop and execute database queries and conduct analyses
· Create visualizations and reports for requested projects
· Develop and update technical documentation
Skills sought
Proven experience as a BI Developer
Proven experience developing and maintaining ETL processes
Ability to write complex queries in T-SQL
A working knowledge across the MS BI Stack (SSRS, SSIS, SSAS)
Analytical mind with good problem solving skills
Ability to work under own initiative
Ability to work as part of a team
Other things to you can get involved in -
Transitioning services to Cloud (Azure)
Dimensional Modelling (e.g. Kimbell)
Source control technologies (e.g. TFS, VSTS)
Programming (e.g. .Net, Python)
Key pointers – BI Development, Business Intelligence, BI Developer, T-SQL, TSQL, SSRS, SSIS, SSAS, Modelling, Azure, SQL Server, MI, Management Information, BI Reporting, database development, DBA, Kimbell, ETL
Oct 29, 2018
Senior BI Developer Lancashire c £40,000
High growth, entrepreneurial business. Great opportunity to work with like minded indivuduals and be part of a fantastic team.
The Senior BI Developer will be responsible for designing, developing and maintaining Business Intelligence solutions.
Mentor juniors, deputise for the Head of function, liaise with board, investors and colleagues across the business.
Responsibilities
· Translate business needs to technical specifications
· Design, build and deploy BI solutions
· Evaluate and improve existing BI systems
· Collaborate with teams to integrate systems
· Develop and execute database queries and conduct analyses
· Create visualizations and reports for requested projects
· Develop and update technical documentation
Skills sought
Proven experience as a BI Developer
Proven experience developing and maintaining ETL processes
Ability to write complex queries in T-SQL
A working knowledge across the MS BI Stack (SSRS, SSIS, SSAS)
Analytical mind with good problem solving skills
Ability to work under own initiative
Ability to work as part of a team
Other things to you can get involved in -
Transitioning services to Cloud (Azure)
Dimensional Modelling (e.g. Kimbell)
Source control technologies (e.g. TFS, VSTS)
Programming (e.g. .Net, Python)
Key pointers – BI Development, Business Intelligence, BI Developer, T-SQL, TSQL, SSRS, SSIS, SSAS, Modelling, Azure, SQL Server, MI, Management Information, BI Reporting, database development, DBA, Kimbell, ETL
BI Developer / Business Intelligence Developer
Leeds
Perm
Up to £40,000 - £45,000 + Benefits
SQL Server / SSIS / SSRS / SSAS / Data Modelling / Cube / Kimball / T-SQL
Overview:
I am currently seeking an experienced Microsoft Business Intelligence Developer to join one of the UK's best Software Development houses' based in Leeds City Centre.
You will be working as part of one of the most technically gifted SQL teams, to help to service 3 major clients for the business. Initially, you will be developing in SQL 2014 and 2016 on both local and cloud based solutions to develop an enterprise end-to-end Data Warehouse.
You will work closely with the end clients to ensure that your solution meets their requirements, so good communication skills is key.
In addition to developing in SQL, this software house will give you exposure to Big Data tools such as Hadoop, Hive, Splunk and also MySQL and Python scripting too!
As a working environment, you will have flexible working hours, Spotify on in the office, the very best tech to work on, access to the infamous "Beer Fridge" and a fantastic team around you.
Essential Skills:
* SQL Server Development using versions 2012 or more recent
* SSIS - Able to design and develop ETL packages
* SSRS - Design, develop and deploy reports
* SSAS - Cube design and development
* Expert T-SQL scripting
Desirable Skills:
* Experienced developing in SQL Server 2016
* Data Modelling experience: Kimball / Inmon
* Big Data tools: Hadoop, Hive, Splunk
* Experience developing to the cloud - Azure / AWS etc.
Why you won't want to miss out on this role!
* Working with SQL 2014 and 2016
* Full utilisation of the MS BI stack
* Access to Big Data tools
* Working with the very best in the business
* Huge, house-hold client names
* Brilliant working environment
This opportunity will not be available for long, so please do not hesitate to submit your CV for consideration!
SQL Server / SSIS / SSRS / SSAS / Data Modelling / Cube / Kimball / T-SQL
May 02, 2017
BI Developer / Business Intelligence Developer
Leeds
Perm
Up to £40,000 - £45,000 + Benefits
SQL Server / SSIS / SSRS / SSAS / Data Modelling / Cube / Kimball / T-SQL
Overview:
I am currently seeking an experienced Microsoft Business Intelligence Developer to join one of the UK's best Software Development houses' based in Leeds City Centre.
You will be working as part of one of the most technically gifted SQL teams, to help to service 3 major clients for the business. Initially, you will be developing in SQL 2014 and 2016 on both local and cloud based solutions to develop an enterprise end-to-end Data Warehouse.
You will work closely with the end clients to ensure that your solution meets their requirements, so good communication skills is key.
In addition to developing in SQL, this software house will give you exposure to Big Data tools such as Hadoop, Hive, Splunk and also MySQL and Python scripting too!
As a working environment, you will have flexible working hours, Spotify on in the office, the very best tech to work on, access to the infamous "Beer Fridge" and a fantastic team around you.
Essential Skills:
* SQL Server Development using versions 2012 or more recent
* SSIS - Able to design and develop ETL packages
* SSRS - Design, develop and deploy reports
* SSAS - Cube design and development
* Expert T-SQL scripting
Desirable Skills:
* Experienced developing in SQL Server 2016
* Data Modelling experience: Kimball / Inmon
* Big Data tools: Hadoop, Hive, Splunk
* Experience developing to the cloud - Azure / AWS etc.
Why you won't want to miss out on this role!
* Working with SQL 2014 and 2016
* Full utilisation of the MS BI stack
* Access to Big Data tools
* Working with the very best in the business
* Huge, house-hold client names
* Brilliant working environment
This opportunity will not be available for long, so please do not hesitate to submit your CV for consideration!
SQL Server / SSIS / SSRS / SSAS / Data Modelling / Cube / Kimball / T-SQL
Job Title: IT SQL Developer
Department:: IT
Location: Manchester
Reports to: IT Manager - Change
Grade: Staff Member (SM)
Job Description:
The Team
This role will report to the IT Manager - Change within the IT Department. You will provide SQL development support to the IT Department in an efficient and professional manner and in accordance with the agreed procedures and service standards. Your role will contribute to the overall success of the IT Department in achieving its objectives as part of overall Company Strategy.
Key Responsibilities:
1 Working with the IT Application Development Manager, support the project related change and development of the Enterprise Data Warehouse and Business Intelligence suite, including but not limited to the activities described below.
2 Development
* Carry out development for major system enhancements and project work across the Business Intelligence suite; responsible for building, deploying, system testing and configuration changes.
* Ensure that best practice source code controls are implemented and adhered to.
* Develop small-scale bespoke technical solutions as part of project delivery (e.g. PowerShell scripts, SQL queries).
3 Database Administration
* Ensure that a reliable and efficient database estate is maintained throughout project delivery, performing operational database configuration and ensuring that data integrity and security standards are upheld.
* Troubleshoot database related issues raised in user acceptance testing.
* Ensure adequate database monitoring is in place (performance, capacity).
* Define database access permissions and privileges.
* Develop database documentation, including release procedures, data quality and security standards.
4 Follow best practice change management principles, ensuring development quality meets agreed release standards for production deployment.
5 Working closely with the IT Run Team to assist in the smooth transition from project/enhancement to 'business as usual' production support.
6 Maintain a rich and concise documentation library to facilitate knowledge sharing and retention within the team.
7 Actively contribute to/participate in the IT transformation programme to enable IT to support the agreed business goals.
Person Specification:
1 Enthusiastic, hardworking and driven individual with a focus on providing the best possible service.
2 Can demonstrate ability to work in a busy office environment, prioritise and organise workload in order to meet tight deadlines.
3 Able to learn and take on new tasks quickly and use own initiative to explore possibilities before raising queries.
4 Demonstrates pride in delivering excellent, quality service and endeavours to exceed expectations.
5 Attention to detail in producing high quality output and able to maintain this when under pressure.
6 Excellent communication skills with confidence to ask questions to ensure job requirements are understood.
7 Commitment to identify opportunities to increase efficiency and quality of operational support evidenced through previous achievements.
8 Proactive, showing initiative when completing tasks by pre-empting issues and proposing solutions for them.
9 Confidence in building rapport and trust with a range of internal and external stakeholders.
10 Academic qualifications, A Level's preferred. GSCE Mathematics C grade upwards required.
11 Confidence in working unsupervised and as part of a team to achieve personal and team objectives.
12 Flexible approach to work with a strong desire to learn and study towards relevant industry qualifications.
Required Skills:
Hands on experience of the following:
1 SQL Server (Apply online only) (TSQL, Stored Procedures, database/query Optimization ) / SSIS,SSAS
2 In-depth understanding of data warehousing - ETL ,MDS,ODS, DDS
3 Dimensional Modelling (Kimball)
4 BI Tools (Qlikview, OLAP, SSRS)
5 Schema design (UML)
6 Source Code Control software (e.g. TFS, Git)
Desired Skills:
1 Familiarity with full software development lifecycle
2 ITIL Service Management
3 Windows PowerShell
4 Microsoft Azure or AWS
5 Infrastructure skills (server administration, backup procedures, networking etc.)
6 IBM iSeries platform
7 Advanced MS Office / Excel / VBA
Values:
Vision for 2017 has defined that one of the enablers to success is having a clear set of company values, which are as follows. We try to incorporate these values into everything we do.
1 Recruiting and developing high quality people.
2 Getting results - by working together and outperforming the competition.
3 Keeping our promises - on time, every time.
4 Doing our best to serve our market and the community.
5 Treating the company money as if our own.
6 Working smarter and pursuing innovation
May 02, 2017
Job Title: IT SQL Developer
Department:: IT
Location: Manchester
Reports to: IT Manager - Change
Grade: Staff Member (SM)
Job Description:
The Team
This role will report to the IT Manager - Change within the IT Department. You will provide SQL development support to the IT Department in an efficient and professional manner and in accordance with the agreed procedures and service standards. Your role will contribute to the overall success of the IT Department in achieving its objectives as part of overall Company Strategy.
Key Responsibilities:
1 Working with the IT Application Development Manager, support the project related change and development of the Enterprise Data Warehouse and Business Intelligence suite, including but not limited to the activities described below.
2 Development
* Carry out development for major system enhancements and project work across the Business Intelligence suite; responsible for building, deploying, system testing and configuration changes.
* Ensure that best practice source code controls are implemented and adhered to.
* Develop small-scale bespoke technical solutions as part of project delivery (e.g. PowerShell scripts, SQL queries).
3 Database Administration
* Ensure that a reliable and efficient database estate is maintained throughout project delivery, performing operational database configuration and ensuring that data integrity and security standards are upheld.
* Troubleshoot database related issues raised in user acceptance testing.
* Ensure adequate database monitoring is in place (performance, capacity).
* Define database access permissions and privileges.
* Develop database documentation, including release procedures, data quality and security standards.
4 Follow best practice change management principles, ensuring development quality meets agreed release standards for production deployment.
5 Working closely with the IT Run Team to assist in the smooth transition from project/enhancement to 'business as usual' production support.
6 Maintain a rich and concise documentation library to facilitate knowledge sharing and retention within the team.
7 Actively contribute to/participate in the IT transformation programme to enable IT to support the agreed business goals.
Person Specification:
1 Enthusiastic, hardworking and driven individual with a focus on providing the best possible service.
2 Can demonstrate ability to work in a busy office environment, prioritise and organise workload in order to meet tight deadlines.
3 Able to learn and take on new tasks quickly and use own initiative to explore possibilities before raising queries.
4 Demonstrates pride in delivering excellent, quality service and endeavours to exceed expectations.
5 Attention to detail in producing high quality output and able to maintain this when under pressure.
6 Excellent communication skills with confidence to ask questions to ensure job requirements are understood.
7 Commitment to identify opportunities to increase efficiency and quality of operational support evidenced through previous achievements.
8 Proactive, showing initiative when completing tasks by pre-empting issues and proposing solutions for them.
9 Confidence in building rapport and trust with a range of internal and external stakeholders.
10 Academic qualifications, A Level's preferred. GSCE Mathematics C grade upwards required.
11 Confidence in working unsupervised and as part of a team to achieve personal and team objectives.
12 Flexible approach to work with a strong desire to learn and study towards relevant industry qualifications.
Required Skills:
Hands on experience of the following:
1 SQL Server (Apply online only) (TSQL, Stored Procedures, database/query Optimization ) / SSIS,SSAS
2 In-depth understanding of data warehousing - ETL ,MDS,ODS, DDS
3 Dimensional Modelling (Kimball)
4 BI Tools (Qlikview, OLAP, SSRS)
5 Schema design (UML)
6 Source Code Control software (e.g. TFS, Git)
Desired Skills:
1 Familiarity with full software development lifecycle
2 ITIL Service Management
3 Windows PowerShell
4 Microsoft Azure or AWS
5 Infrastructure skills (server administration, backup procedures, networking etc.)
6 IBM iSeries platform
7 Advanced MS Office / Excel / VBA
Values:
Vision for 2017 has defined that one of the enablers to success is having a clear set of company values, which are as follows. We try to incorporate these values into everything we do.
1 Recruiting and developing high quality people.
2 Getting results - by working together and outperforming the competition.
3 Keeping our promises - on time, every time.
4 Doing our best to serve our market and the community.
5 Treating the company money as if our own.
6 Working smarter and pursuing innovation