Paul Mitchell Associates
Leicester, Leicestershire
Power BI Developer Location: Leicester Salary £40k - £50k (depending on experience) Description This role would suit an efficient and robust developer looking to work in house for a fast-paced European fashion business. Join our team as a Power BI Developer! We're looking for a skilled individual to create dynamic data visualizations and insightful reports using Power BI. If you have experience with data modelling, dashboard design, and a passion for analytics, we want to hear from you Design, develop, and deploy analytical products in Power BI using multiple data sources Develop Power BI Premium models with dimensional modelling techniques Cultivate strong relationships with business units and key stakeholders to ensure that analytics support aligns with business needs Translate business requirements into technical specifications and implement them through reports supporting decision-making. Requirements: . developed in a Microsoft Dynamics BC environment is essential . Office 365 competence - essential . Microsoft certified Power BI data analyst associate - essential . Proficiency in Power BI Desktop and DAX Strong data visualization and dashboard design skills Experience with SQL databases Excellent problem-solving abilities Effective communication skills 1-2 years' experience in office environment - working on data migration/ data analysis/ system redesign / system design or project management. Desirable. Preferred Qualifications: . Expert in the Azure Data tech stack, specifically delivering solutions in Power BI. Essential Proficient in database design, including relational and dimensional modelling. Essential Expert in MS SQL Server, T-SQL, Power Query, MDX, DAX, and the Power Platform. Essential Previous Power BI Developer experience with a successful project delivery track record. Essential Proficient in creating Power Apps Experience with Azure Data Services (Azure SQL Database, Azure Data Lake, etc.) Knowledge of ETL processes and tools (e.g., Azure Data Factory, SSIS) Familiarity with other BI and analytics tools (Tableau, QlikView, etc.). Package Appointment Type: Permanent Monday to Friday 8.30am - 5pm Salary: £40k - £50k (depending on experience) Holiday 20 Days (rise to 25) + Bank Holidays Pension On-site Parking Full time office-based role 5 days per week If you - or someone you might know - are interested & think this opportunity may be suitable, APPLY ONLINE or call Paul Mitchell Associates (quoting ref: 12975) on .
Apr 25, 2024
Full time
Power BI Developer Location: Leicester Salary £40k - £50k (depending on experience) Description This role would suit an efficient and robust developer looking to work in house for a fast-paced European fashion business. Join our team as a Power BI Developer! We're looking for a skilled individual to create dynamic data visualizations and insightful reports using Power BI. If you have experience with data modelling, dashboard design, and a passion for analytics, we want to hear from you Design, develop, and deploy analytical products in Power BI using multiple data sources Develop Power BI Premium models with dimensional modelling techniques Cultivate strong relationships with business units and key stakeholders to ensure that analytics support aligns with business needs Translate business requirements into technical specifications and implement them through reports supporting decision-making. Requirements: . developed in a Microsoft Dynamics BC environment is essential . Office 365 competence - essential . Microsoft certified Power BI data analyst associate - essential . Proficiency in Power BI Desktop and DAX Strong data visualization and dashboard design skills Experience with SQL databases Excellent problem-solving abilities Effective communication skills 1-2 years' experience in office environment - working on data migration/ data analysis/ system redesign / system design or project management. Desirable. Preferred Qualifications: . Expert in the Azure Data tech stack, specifically delivering solutions in Power BI. Essential Proficient in database design, including relational and dimensional modelling. Essential Expert in MS SQL Server, T-SQL, Power Query, MDX, DAX, and the Power Platform. Essential Previous Power BI Developer experience with a successful project delivery track record. Essential Proficient in creating Power Apps Experience with Azure Data Services (Azure SQL Database, Azure Data Lake, etc.) Knowledge of ETL processes and tools (e.g., Azure Data Factory, SSIS) Familiarity with other BI and analytics tools (Tableau, QlikView, etc.). Package Appointment Type: Permanent Monday to Friday 8.30am - 5pm Salary: £40k - £50k (depending on experience) Holiday 20 Days (rise to 25) + Bank Holidays Pension On-site Parking Full time office-based role 5 days per week If you - or someone you might know - are interested & think this opportunity may be suitable, APPLY ONLINE or call Paul Mitchell Associates (quoting ref: 12975) on .
Nigel Frank International
Leicester, Leicestershire
Senior BI Developer - Derby - £50,000 I am working with a well-established organisation within the healthcare industry who are growing their team and are looking for a Senior BI Developer to join them. The company are going through a period of significant growth and this is a new role within their IT team. The organisation have multiple exciting projects within the pipeline including the implementation of an Azure BI platform and changes to their ERP/CRM systems which will require the re-development of the SQL datawarehouse. In this role you will take responsibility for designing and developing ETL processes and stored procedures in order to automate business processes. You will also have responsibility for modifying the companies suite of SSRS reports. This is an exciting time to join a growing organisation at a time of significant investment in their tech function! As part of this role, you will be responsible for some of the following areas Design and develop ETL processes and stored procedures Maintain and develop the companies SSRS reporting suite Create robust SQL code and troubleshoot any errors that may occur This is a salaried role paying up to £50,000 per annum depending on experience and a company benefits package. This is a hybrid role based out of the organisations office in Derby where you will work closely with a close-knit, collaborative team. To be successful in the role you will have Strong T-SQL development experience including query writing, developing stored procedures, functions, views and triggers Excellent knowledge of SSRS Performance tuning experience would be beneficial Azure knowledge would be beneficial Excellent communication skills This is just a brief overview of the role. For the full information, simply apply to the role with your CV, and I will call you to discuss further. My client is looking to begin the interview process ASAP , so don't miss out, APPLY now! To do so please email me at or call me on . Nigel Frank International are the go-to recruiter for Power BI and Azure Data Platform roles in the UK offering more opportunities across the country than any other recruitment agency. We're the proud sponsor and supporter of SQLBits, Power Platform World Tour, the London Power BI User Group, Newcastle Power BI User Group and Newcastle Data Platform and Cloud User Group. We are the global leaders in Microsoft recruitment.
Apr 25, 2024
Full time
Senior BI Developer - Derby - £50,000 I am working with a well-established organisation within the healthcare industry who are growing their team and are looking for a Senior BI Developer to join them. The company are going through a period of significant growth and this is a new role within their IT team. The organisation have multiple exciting projects within the pipeline including the implementation of an Azure BI platform and changes to their ERP/CRM systems which will require the re-development of the SQL datawarehouse. In this role you will take responsibility for designing and developing ETL processes and stored procedures in order to automate business processes. You will also have responsibility for modifying the companies suite of SSRS reports. This is an exciting time to join a growing organisation at a time of significant investment in their tech function! As part of this role, you will be responsible for some of the following areas Design and develop ETL processes and stored procedures Maintain and develop the companies SSRS reporting suite Create robust SQL code and troubleshoot any errors that may occur This is a salaried role paying up to £50,000 per annum depending on experience and a company benefits package. This is a hybrid role based out of the organisations office in Derby where you will work closely with a close-knit, collaborative team. To be successful in the role you will have Strong T-SQL development experience including query writing, developing stored procedures, functions, views and triggers Excellent knowledge of SSRS Performance tuning experience would be beneficial Azure knowledge would be beneficial Excellent communication skills This is just a brief overview of the role. For the full information, simply apply to the role with your CV, and I will call you to discuss further. My client is looking to begin the interview process ASAP , so don't miss out, APPLY now! To do so please email me at or call me on . Nigel Frank International are the go-to recruiter for Power BI and Azure Data Platform roles in the UK offering more opportunities across the country than any other recruitment agency. We're the proud sponsor and supporter of SQLBits, Power Platform World Tour, the London Power BI User Group, Newcastle Power BI User Group and Newcastle Data Platform and Cloud User Group. We are the global leaders in Microsoft recruitment.
We are looking for a SQL Server developer who can join our client's development team. This is a Home-Based role. We are looking for someone with experience in T-SQL development. Your time will be spent, working on development projects for our customers, supporting technical enquiries from our service desk and proactive DBA activities to keep the platforms running smoothly. Key skills: T-SQL SSRS SSIS Ideally some knowledge of .Net (C# OR VB). The position offers a great opportunity to develop within an established business. We believe in empowering our team to look after their assignments throughout the entire lifecycle which gives exposure to more than just development, you could be asked to talk to customers about their requirements, support testing and UAT activities and deploy your work into production - the role is varied. The role is remote and your normal place of work will be your home address with the possibility of occasional travel to client sites, across the UK. What kind of person are we looking for? It's a busy environment where requirements change daily, and we are looking for someone who enjoys working at pace and embraces change. Logical problem solving is a key attribute along with the confidence to ask questions as required. Attention to detail is key. A good team player is a must. Key responsibilities T-SQL development Report development in SSRS ETL development using SSIS Following development processes including keeping source control updated Basic asp.net web development Supporting system testing and resolving defects Putting together test documentation, deployment plans Resolving support incidents Keep up-to-date on the latest technologies Skills You are a highly motivated individual with good technical skills. The role requires the following specific skills: Experience of MS SQL Server Writing complex T-SQL Report development (ideally in SSRS, or in a Business Intelligence Environment) ETL development (ideally in SSIS) Previous experience of using ASP.net (VB.net) Experience of Source control and DevOps would be a bonus Any knowledge of Power BI would be useful. Your normal working hours will be 35 per week between 9am - 5 pm Monday to Friday excluding English Bank Holidays. This is a varied and interesting role offering good career development, suitable for a developer keen to further their career. To £38,000 + benefits including 4% contributory pension, 25 days holiday. Pension benefit starts after completion of 6 month probation period. Interested? Send your CV now!
Apr 25, 2024
Full time
We are looking for a SQL Server developer who can join our client's development team. This is a Home-Based role. We are looking for someone with experience in T-SQL development. Your time will be spent, working on development projects for our customers, supporting technical enquiries from our service desk and proactive DBA activities to keep the platforms running smoothly. Key skills: T-SQL SSRS SSIS Ideally some knowledge of .Net (C# OR VB). The position offers a great opportunity to develop within an established business. We believe in empowering our team to look after their assignments throughout the entire lifecycle which gives exposure to more than just development, you could be asked to talk to customers about their requirements, support testing and UAT activities and deploy your work into production - the role is varied. The role is remote and your normal place of work will be your home address with the possibility of occasional travel to client sites, across the UK. What kind of person are we looking for? It's a busy environment where requirements change daily, and we are looking for someone who enjoys working at pace and embraces change. Logical problem solving is a key attribute along with the confidence to ask questions as required. Attention to detail is key. A good team player is a must. Key responsibilities T-SQL development Report development in SSRS ETL development using SSIS Following development processes including keeping source control updated Basic asp.net web development Supporting system testing and resolving defects Putting together test documentation, deployment plans Resolving support incidents Keep up-to-date on the latest technologies Skills You are a highly motivated individual with good technical skills. The role requires the following specific skills: Experience of MS SQL Server Writing complex T-SQL Report development (ideally in SSRS, or in a Business Intelligence Environment) ETL development (ideally in SSIS) Previous experience of using ASP.net (VB.net) Experience of Source control and DevOps would be a bonus Any knowledge of Power BI would be useful. Your normal working hours will be 35 per week between 9am - 5 pm Monday to Friday excluding English Bank Holidays. This is a varied and interesting role offering good career development, suitable for a developer keen to further their career. To £38,000 + benefits including 4% contributory pension, 25 days holiday. Pension benefit starts after completion of 6 month probation period. Interested? Send your CV now!
Software Developer Job Type: Flexible (Home, Office, Hybrid) Location: Staffordshire (with remote working options) Up to £45,000 Due to continued success my Midlands based client are seeking a experienced Software Developer with a passion for creating innovative solutions in demand planning and operational support. This role offers a high degree of autonomy and the flexibility to work from home, office, or a hybrid arrangement. The opportunity will allow the right person contribute to the development of new capabilities for a globally recognised brand in my client's field. Day to Day of the Role: Design, develop, test, and support new modules within our demand planning and logistics solution. Engage in both client and server-side coding, ensuring high-quality outcomes. Perform ETL tasks with customer data to integrate with existing systems. Collaborate with the team to refine specifications and challenge existing processes to improve functionality. Take ownership of the project lifecycle, from initial design to deployment, ensuring that project milestones are met. Maintain and support existing modules, expanding your knowledge of the wider solution. Required Skills & Qualifications: Demonstrable skills in Microsoft .NET C# WinForms. Previous or current experience with Delphi. Solid experience with Microsoft SQL Server. Excellent communication and strong analytical skills. Ability to work independently with a high degree of responsibility. Experience in developing multi-tier applications in a multi-user environment is advantageous. Proficiency in Git source code management. Benefits: Flexible working arrangements with the option to work from home. Autonomy in your role with the support of a collaborative team. Opportunity to work on projects for globally recognised brands. Company-provided equipment for your dedicated home office space. To apply for this Software Developer position, please submit your updated CV
Apr 25, 2024
Full time
Software Developer Job Type: Flexible (Home, Office, Hybrid) Location: Staffordshire (with remote working options) Up to £45,000 Due to continued success my Midlands based client are seeking a experienced Software Developer with a passion for creating innovative solutions in demand planning and operational support. This role offers a high degree of autonomy and the flexibility to work from home, office, or a hybrid arrangement. The opportunity will allow the right person contribute to the development of new capabilities for a globally recognised brand in my client's field. Day to Day of the Role: Design, develop, test, and support new modules within our demand planning and logistics solution. Engage in both client and server-side coding, ensuring high-quality outcomes. Perform ETL tasks with customer data to integrate with existing systems. Collaborate with the team to refine specifications and challenge existing processes to improve functionality. Take ownership of the project lifecycle, from initial design to deployment, ensuring that project milestones are met. Maintain and support existing modules, expanding your knowledge of the wider solution. Required Skills & Qualifications: Demonstrable skills in Microsoft .NET C# WinForms. Previous or current experience with Delphi. Solid experience with Microsoft SQL Server. Excellent communication and strong analytical skills. Ability to work independently with a high degree of responsibility. Experience in developing multi-tier applications in a multi-user environment is advantageous. Proficiency in Git source code management. Benefits: Flexible working arrangements with the option to work from home. Autonomy in your role with the support of a collaborative team. Opportunity to work on projects for globally recognised brands. Company-provided equipment for your dedicated home office space. To apply for this Software Developer position, please submit your updated CV
Role: Senior SQL Developer Location: Blackburn, BB1 2FA Contract: Full Time / Permanent Salary: Up to £42,000 Dependant on experience & Bonus scheme Company: EG Group About the role Our IT Team is expanding and we have an opportunity available for a Senior SQL Developer! In this role you will suggest, create and maintain SQL objects. You will also coach & mentor Junior SQL Developers within the team, helping them develop and flourish within their roles. Duties and Responsibilities Check, troubleshoot and correct data import and export activities daily Communicate to the team and business on any issues and delays Suggest/Maintain/Create SQL objects such as tables, views, stored procedures, scripts, functions, triggers Suggest/Maintain/Create SSIS packages according to the business needs Maintain/Create documentation Work with the BI team and other teams to provide accurate and complete Data and to maintain Data quality/integrity Mentor Junior SQL developers Open and able to adapt to new technologies related to Data storage and Data transfers This list is not exhaustive and may be added to or amended from time to time. Candidate Requirements Experience of working with transactional databases and data warehouses Experience of designing and developing database schema/ objects whilst following good practices (such as normalisation) Excellent knowledge of the SQL Database Engine Strong T-SQL knowledge Strong experience using SSIS for diverse ETL processes (import/export data through files, emails, SFTP, APIs etc) Excellent performance tuning skills (experience of Query Tuning, Index Optimisation, Locking etc.) Experience with SSRS and PowerBI Excellent communication and documentation skills for technical audience Ability to work in a team environment with people of different skills and share knowledge with juniors Benefits & Rewards Performance Based Bonus Scheme. Employee Life Assurance. EG Group Discounts - up to 15% off at our stores and food to go restaurants. ASDA Discount Card - 10% off all ASDA stores. EG Cares Benefits - exclusive discounts across 900 retailers. Smart Health - 24/7 online GP access, health checks and health and wellbeing support. Employee Assistance Programme - access to our Wellbeing Centre which offers emotional & practical support including free financial advice. Learning & Development - access to our Learning Hub, the most extensive online course library in the world to support you with every step of your career at EG Group. Waterside Café - freshly prepared meals at affordable prices. Free Secure Car Parking. Dress Down Fridays. Flexi-Time. Prayer and Ablution Facilities. Sit / Stand Desk Facilities. Work Anniversary Rewards. Free Eye Test. Who are EG Group? EG Group is one of the world's leading independent convenience retailers with an extensive network of sites across international markets in the United Kingdom & Ireland, Continental Europe, Australia and the United States of America. Founded in 2001 by the Issa family with the acquisition of a single site in the UK, today the company is at the forefront of delivering an innovative approach to forecourt convenience retail. At EG Group, we pride ourselves on being recognised for our investment model, trading performance and more importantly, providing a best-in-class customer experience in Grocery & Merchandise, Foodservice and Fuel. Our transformational convenience retail business model has been built upon excellent relationships with an extensive portfolio of leading retail brands, and through strategic network acquisitions supported by a program of new-to-industry developments. Every day, our committed workforce tirelessly delivers our products and services to millions of customers alongside supporting the local communities in which we operate. Please note - the successful applicant will be subject to a DBS check which will be funded by EG Group.
Apr 25, 2024
Full time
Role: Senior SQL Developer Location: Blackburn, BB1 2FA Contract: Full Time / Permanent Salary: Up to £42,000 Dependant on experience & Bonus scheme Company: EG Group About the role Our IT Team is expanding and we have an opportunity available for a Senior SQL Developer! In this role you will suggest, create and maintain SQL objects. You will also coach & mentor Junior SQL Developers within the team, helping them develop and flourish within their roles. Duties and Responsibilities Check, troubleshoot and correct data import and export activities daily Communicate to the team and business on any issues and delays Suggest/Maintain/Create SQL objects such as tables, views, stored procedures, scripts, functions, triggers Suggest/Maintain/Create SSIS packages according to the business needs Maintain/Create documentation Work with the BI team and other teams to provide accurate and complete Data and to maintain Data quality/integrity Mentor Junior SQL developers Open and able to adapt to new technologies related to Data storage and Data transfers This list is not exhaustive and may be added to or amended from time to time. Candidate Requirements Experience of working with transactional databases and data warehouses Experience of designing and developing database schema/ objects whilst following good practices (such as normalisation) Excellent knowledge of the SQL Database Engine Strong T-SQL knowledge Strong experience using SSIS for diverse ETL processes (import/export data through files, emails, SFTP, APIs etc) Excellent performance tuning skills (experience of Query Tuning, Index Optimisation, Locking etc.) Experience with SSRS and PowerBI Excellent communication and documentation skills for technical audience Ability to work in a team environment with people of different skills and share knowledge with juniors Benefits & Rewards Performance Based Bonus Scheme. Employee Life Assurance. EG Group Discounts - up to 15% off at our stores and food to go restaurants. ASDA Discount Card - 10% off all ASDA stores. EG Cares Benefits - exclusive discounts across 900 retailers. Smart Health - 24/7 online GP access, health checks and health and wellbeing support. Employee Assistance Programme - access to our Wellbeing Centre which offers emotional & practical support including free financial advice. Learning & Development - access to our Learning Hub, the most extensive online course library in the world to support you with every step of your career at EG Group. Waterside Café - freshly prepared meals at affordable prices. Free Secure Car Parking. Dress Down Fridays. Flexi-Time. Prayer and Ablution Facilities. Sit / Stand Desk Facilities. Work Anniversary Rewards. Free Eye Test. Who are EG Group? EG Group is one of the world's leading independent convenience retailers with an extensive network of sites across international markets in the United Kingdom & Ireland, Continental Europe, Australia and the United States of America. Founded in 2001 by the Issa family with the acquisition of a single site in the UK, today the company is at the forefront of delivering an innovative approach to forecourt convenience retail. At EG Group, we pride ourselves on being recognised for our investment model, trading performance and more importantly, providing a best-in-class customer experience in Grocery & Merchandise, Foodservice and Fuel. Our transformational convenience retail business model has been built upon excellent relationships with an extensive portfolio of leading retail brands, and through strategic network acquisitions supported by a program of new-to-industry developments. Every day, our committed workforce tirelessly delivers our products and services to millions of customers alongside supporting the local communities in which we operate. Please note - the successful applicant will be subject to a DBS check which will be funded by EG Group.
ETL/Data warehouse Developer Informatica Oracle ETL Staffordshire office 2 days per week £50,000-£60,000 Method Resourcing have partnered with an IT consultancy specialising in digital transformation for medium to large-scale businesses. Their experienced team of IT consultants provides expert guidance and support to help clients stay ahead of the curve in the fast-paced digital landscape. The role: You will demonstrate in-depth technical knowledge of Informatica PowerCentre, Oracle SQL, PL/SQL and data warehouse design and build. It would be advantageous if you had experience in Business Objects and basic Java development. You will have strong analytical skills and be good at problem-solving. The skills and experience we are looking for: Experience developing Extract, Transformation, and Load (ETL) processes using Informatica PowerCenter Experience working with Oracle databases in a development environment Experience using SQL Developer, SQL Loader, and TOAD tools in a development environment Experience with Oracle SQL & PL/SQL Experience in solution estimating Full life cycle implementation exposure of data warehouses Working arrangements: 2 days in Stafford and the other 3 days WFH. NO SPONSORSHIP can be offered for this. If you meet the above requirements then please apply for immediate consideration ETL/Data warehouse Developer Informatica Oracle ETL Staffordshire office 2 days per week £55,000-£60,000
Apr 24, 2024
Full time
ETL/Data warehouse Developer Informatica Oracle ETL Staffordshire office 2 days per week £50,000-£60,000 Method Resourcing have partnered with an IT consultancy specialising in digital transformation for medium to large-scale businesses. Their experienced team of IT consultants provides expert guidance and support to help clients stay ahead of the curve in the fast-paced digital landscape. The role: You will demonstrate in-depth technical knowledge of Informatica PowerCentre, Oracle SQL, PL/SQL and data warehouse design and build. It would be advantageous if you had experience in Business Objects and basic Java development. You will have strong analytical skills and be good at problem-solving. The skills and experience we are looking for: Experience developing Extract, Transformation, and Load (ETL) processes using Informatica PowerCenter Experience working with Oracle databases in a development environment Experience using SQL Developer, SQL Loader, and TOAD tools in a development environment Experience with Oracle SQL & PL/SQL Experience in solution estimating Full life cycle implementation exposure of data warehouses Working arrangements: 2 days in Stafford and the other 3 days WFH. NO SPONSORSHIP can be offered for this. If you meet the above requirements then please apply for immediate consideration ETL/Data warehouse Developer Informatica Oracle ETL Staffordshire office 2 days per week £55,000-£60,000
Data Development Manage deployment of changes, upgrades and bug fixes to databases, data lake and data warehouse Development of new AWS Data Lake Migrate customer orchestration solution to AWS Airflow Refine and extend system and ETL designs to improve accuracy, timeliness, completeness, and consistency Manage integration and maintenance of new data sources. Design, build and maintain data pipelines Code management, review and reversion using GitHub Data Administration Monitoring, diagnosis and troubleshooting orchestration including SSIS, Airflow, Spark, Scala, Kubernetes, AWS Orchestration, Python and Glue Security, key management, DR, performance, and cost monitoring of AWS solution including S3 and Athena Disaster Recovery planning, maintenance, and execution Design, develop and maintain non-production environments Design, develop and adhere to change control processes Administration of MSSQL Server RDS environment Upgrade of existing MSSQL Server environment including SSIS, SSAS, MDS Establish the needs of users, monitor user access and security, control access permissions and privileges Ensure that storage and archiving procedures are functioning correctly Develop, manage, and test back-up and recovery plans Manage the security and disaster recovery aspects of Databases and Data Lake Data Governance Align existing and new processes to defined design patterns and coding standards Maintain data standards, including adherence to the Data Protection Act Investigation, design and implementation of QA processes and reporting Protection of Personally Identifiable Information Design and develop GDPR processes Collation and maintenance of meta data about the Hearst Data Estate. Create and maintain documentation, including data standards, procedures, and definitions for the data dictionary (metadata) Maximise data value to the business Application Support Commission and install new applications and customise existing applications to make them fit for purpose SSRS, PowerBI, Tableau and Looker report editing and origination Data Warehouse (DW) maintenance and support. SSIS, SSAS, SQL Server for analysis on existing DW Design and development of replacement for existing MSSQL Data Warehouse and Cube Advice on back-end standards for new and existing applications and ETL Creation and maintenance of GDPR Compliant Development and Testing environments Design, implementation and monitoring of deployments along with co ordinating code, data and schema reversions when required. Stakeholder Management Liaise with developers, application owners and SMEs around DR, Security and Operational Requirements (including ETL timings) Liaise with data architect to move data estate to consolidate, simplify and document operational landscape Define and enforce standards for data quality Define and enforce code standards Liaise with 3rd party data suppliers to understand data structures / formats etc. Monitor performance and manage parameters to provide fast responses to front-end users Manage and respond to alerts and notifications around feeds to our Databases and Data Lake Communicate regularly with technical, applications and operational staff to ensure database integrity and security Team Positive contributor to the wider Data & Technology team Training and mentoring of junior team members Provide wider business user support by responding to system issues within agreed SLAs Leading from the front To be an ambassador of Hearst and its values. You may be required to undertake such further duties as your skills, qualifications and experience allow and/or as may be assigned to you from time to time.
Apr 24, 2024
Full time
Data Development Manage deployment of changes, upgrades and bug fixes to databases, data lake and data warehouse Development of new AWS Data Lake Migrate customer orchestration solution to AWS Airflow Refine and extend system and ETL designs to improve accuracy, timeliness, completeness, and consistency Manage integration and maintenance of new data sources. Design, build and maintain data pipelines Code management, review and reversion using GitHub Data Administration Monitoring, diagnosis and troubleshooting orchestration including SSIS, Airflow, Spark, Scala, Kubernetes, AWS Orchestration, Python and Glue Security, key management, DR, performance, and cost monitoring of AWS solution including S3 and Athena Disaster Recovery planning, maintenance, and execution Design, develop and maintain non-production environments Design, develop and adhere to change control processes Administration of MSSQL Server RDS environment Upgrade of existing MSSQL Server environment including SSIS, SSAS, MDS Establish the needs of users, monitor user access and security, control access permissions and privileges Ensure that storage and archiving procedures are functioning correctly Develop, manage, and test back-up and recovery plans Manage the security and disaster recovery aspects of Databases and Data Lake Data Governance Align existing and new processes to defined design patterns and coding standards Maintain data standards, including adherence to the Data Protection Act Investigation, design and implementation of QA processes and reporting Protection of Personally Identifiable Information Design and develop GDPR processes Collation and maintenance of meta data about the Hearst Data Estate. Create and maintain documentation, including data standards, procedures, and definitions for the data dictionary (metadata) Maximise data value to the business Application Support Commission and install new applications and customise existing applications to make them fit for purpose SSRS, PowerBI, Tableau and Looker report editing and origination Data Warehouse (DW) maintenance and support. SSIS, SSAS, SQL Server for analysis on existing DW Design and development of replacement for existing MSSQL Data Warehouse and Cube Advice on back-end standards for new and existing applications and ETL Creation and maintenance of GDPR Compliant Development and Testing environments Design, implementation and monitoring of deployments along with co ordinating code, data and schema reversions when required. Stakeholder Management Liaise with developers, application owners and SMEs around DR, Security and Operational Requirements (including ETL timings) Liaise with data architect to move data estate to consolidate, simplify and document operational landscape Define and enforce standards for data quality Define and enforce code standards Liaise with 3rd party data suppliers to understand data structures / formats etc. Monitor performance and manage parameters to provide fast responses to front-end users Manage and respond to alerts and notifications around feeds to our Databases and Data Lake Communicate regularly with technical, applications and operational staff to ensure database integrity and security Team Positive contributor to the wider Data & Technology team Training and mentoring of junior team members Provide wider business user support by responding to system issues within agreed SLAs Leading from the front To be an ambassador of Hearst and its values. You may be required to undertake such further duties as your skills, qualifications and experience allow and/or as may be assigned to you from time to time.
BI Developer Informatica Azure ERP ETL SSIS Power BI 3 month contract Midlands Client Details Leading medical services provider Description Collaborate with cross-functional teams to design and implement data solutions for ERP migration programs. Utilize your expertise in Informatica to develop robust ETL processes for seamless data migration. Harness the power of Azure services to architect scalable and efficient data pipelines. Ensure data quality and integrity throughout the migration process, implementing best practices for data governance. Troubleshoot and optimize data workflows to meet project deadlines and performance targets. Profile Proven experience in data development, particularly with Informatica and Azure technologies. Strong understanding of ERP systems and experience with migration projects. Proficiency in SQL and data modeling concepts. Excellent communication skills and the ability to collaborate effectively with stakeholders at all levels. Job Offer 3 to 6 month contract £400 per day (Outside IR35) Based in Birmingham (hybrid working/ required to be onsite 2 days a week)
Apr 24, 2024
Full time
BI Developer Informatica Azure ERP ETL SSIS Power BI 3 month contract Midlands Client Details Leading medical services provider Description Collaborate with cross-functional teams to design and implement data solutions for ERP migration programs. Utilize your expertise in Informatica to develop robust ETL processes for seamless data migration. Harness the power of Azure services to architect scalable and efficient data pipelines. Ensure data quality and integrity throughout the migration process, implementing best practices for data governance. Troubleshoot and optimize data workflows to meet project deadlines and performance targets. Profile Proven experience in data development, particularly with Informatica and Azure technologies. Strong understanding of ERP systems and experience with migration projects. Proficiency in SQL and data modeling concepts. Excellent communication skills and the ability to collaborate effectively with stakeholders at all levels. Job Offer 3 to 6 month contract £400 per day (Outside IR35) Based in Birmingham (hybrid working/ required to be onsite 2 days a week)
Position Overview Are you seeking a challenging and exciting role upgrading complex database systems? Our client is looking for a talented and experienced DBA/Developer to lead the transition of databases from SQL Server 2012 to SQL Server 2019. If you are passionate about data warehouse design, ETL methods, and Agile projects, we have the perfect opportunity for you to showcase your skills and contribute to our ongoing success. Our client are a prominent advisory network distinguished by over two decades of dedication to excellence in the financial services industry. At the core of their business is a mission that is both simple and powerful: to place our their members and valued customers at the forefront of every initiative and decision. Essential Qualifications & Skills Extensive Experience: Proven track record of successfully upgrading complex databases to SQL Server 2019, with a thorough understanding of new installation and migration patterns. SQL Server Proficiency: In-depth knowledge in install, backup, data migration, replication, access control, SSIS, database performance, scheduling, releases, monitoring, and alerting. Agile Methodology: Competence in managing workloads using Azure DevOps with an Agile project approach. Documentation: Ability to create detailed design documentation, support procedures, and handover information. Desirable Qualifications & Skills Familiarity with Team Foundation Server (TFS). Experience with SQL Server 2016. Proficiency in Power BI and Power Platform is highly favorable. Why Join? Be part of a forward-thinking company that values innovation and expertise. Enjoy a collaborative environment where your skills will make a significant impact. Engage in complex and rewarding projects with a dedicated and passionate team.
Apr 24, 2024
Contractor
Position Overview Are you seeking a challenging and exciting role upgrading complex database systems? Our client is looking for a talented and experienced DBA/Developer to lead the transition of databases from SQL Server 2012 to SQL Server 2019. If you are passionate about data warehouse design, ETL methods, and Agile projects, we have the perfect opportunity for you to showcase your skills and contribute to our ongoing success. Our client are a prominent advisory network distinguished by over two decades of dedication to excellence in the financial services industry. At the core of their business is a mission that is both simple and powerful: to place our their members and valued customers at the forefront of every initiative and decision. Essential Qualifications & Skills Extensive Experience: Proven track record of successfully upgrading complex databases to SQL Server 2019, with a thorough understanding of new installation and migration patterns. SQL Server Proficiency: In-depth knowledge in install, backup, data migration, replication, access control, SSIS, database performance, scheduling, releases, monitoring, and alerting. Agile Methodology: Competence in managing workloads using Azure DevOps with an Agile project approach. Documentation: Ability to create detailed design documentation, support procedures, and handover information. Desirable Qualifications & Skills Familiarity with Team Foundation Server (TFS). Experience with SQL Server 2016. Proficiency in Power BI and Power Platform is highly favorable. Why Join? Be part of a forward-thinking company that values innovation and expertise. Enjoy a collaborative environment where your skills will make a significant impact. Engage in complex and rewarding projects with a dedicated and passionate team.
Main Purpose of the Role We have a fantastic opportunity for a Business Intelligence (BI) Developer to join us, based from our Head Office in Doncaster with agile/hybrid working. The successful candidate will work closely with the BI Manager to to deliver and maintain end-to-end business intelligence solutions for Keepmoat., from data ingestion to analysis and visualisation through reports and dashboards that drive insights and improve decision-making across the organisation. Duties will include working with stakeholders to identify and develop solutions to business problems and challenges, translating business needs to technical specifications, as well as the hands-on development of metrics, reports, and dashboards. Responsibilities will also include the maintenance and optimisation of the Power BI service and championing data quality throughout the business. The ideal candidate will have 2-3+ years of proven professional experience in Business Intelligence/Analytics (Power BI). They will have experience with Microsoft BI stack, relational database and SQL experience alongside experience working with ETL and/or data integration tools (preferably Informatica). Experience working in an agile environment (preferably with Azure DevOps) is also essential. Experience within the housebuilding industry, as well as the COINS ERP system and python, would be desirable. Skills, knowledge & experience We are looking for someone who fits with our core values here at Keepmoat; they will be passionate about Business Intelligence and data strategy. They will be collaborative with the ability to work cross functionally to contribute to business goals. They will have the ability to be creative and innovative in their approach and use their business acumen and problem-solving skills . They will use their communication skills in a straightforward way to translate business needs into practical technical specifications Education & qualifications If this sounds like you, please apply now. As the above is not an exhaustive list of responsibilities, for more information including a full job description and person specification, please contact us.
Apr 24, 2024
Full time
Main Purpose of the Role We have a fantastic opportunity for a Business Intelligence (BI) Developer to join us, based from our Head Office in Doncaster with agile/hybrid working. The successful candidate will work closely with the BI Manager to to deliver and maintain end-to-end business intelligence solutions for Keepmoat., from data ingestion to analysis and visualisation through reports and dashboards that drive insights and improve decision-making across the organisation. Duties will include working with stakeholders to identify and develop solutions to business problems and challenges, translating business needs to technical specifications, as well as the hands-on development of metrics, reports, and dashboards. Responsibilities will also include the maintenance and optimisation of the Power BI service and championing data quality throughout the business. The ideal candidate will have 2-3+ years of proven professional experience in Business Intelligence/Analytics (Power BI). They will have experience with Microsoft BI stack, relational database and SQL experience alongside experience working with ETL and/or data integration tools (preferably Informatica). Experience working in an agile environment (preferably with Azure DevOps) is also essential. Experience within the housebuilding industry, as well as the COINS ERP system and python, would be desirable. Skills, knowledge & experience We are looking for someone who fits with our core values here at Keepmoat; they will be passionate about Business Intelligence and data strategy. They will be collaborative with the ability to work cross functionally to contribute to business goals. They will have the ability to be creative and innovative in their approach and use their business acumen and problem-solving skills . They will use their communication skills in a straightforward way to translate business needs into practical technical specifications Education & qualifications If this sounds like you, please apply now. As the above is not an exhaustive list of responsibilities, for more information including a full job description and person specification, please contact us.
Software Developer Telford (Hybrid) 6 months contract Up to 378 p/d Umbrella Active SC Clearance required ROLE INFO: Software development activity across the full range of development lifecycle; requirements gathering, analysis, design, coding/development, testing, implementation and live support. This may be within new systems development projects or enhancements and fixes to existing applications. Carrying out development in accordance with the agreed requirements and development standards Testing of products in accordance with the test strategy to ensure that they are fit for purpose Assisting the team in examining packages of work and giving realistic timescales for completion Completion of work allocated within agreed time, cost and quality criteria and providing progress reports on assigned work as required Management and control of problems and change within their area of responsibility, including negotiation with other team members Problem analysis, investigation and resolution Playing an active part in Process improvement, awareness of and compliance with all relevant quality processes and procedures, including completion of all the specified quality records Mandatory Skills: Will be used across Live Support systems wherever required: Technologies - Denodo/Talend/PDI/Git/MySQL/Redshift/Grafana Dashboard creation/consolidation Gathering requirements, understanding the service and delivery alerts to suit Should have experience in Grafana monitoring: Dashboard creation/consolidation A software engineering background with proven ability to rapidly learn and apply application development process, tools and programming/scripting languages. Awareness of key SE engineering concepts and governance (design, development, config management and version control, quality control, continuous integration, release/deployment, documentation, built in supportability, built in maintainability, re-use and extensibility) Specific experience of data solutions development addressing data extraction, transformation and load (ETL) processing and data analytics and reporting requirements. Familiar with Agile software development principles and practices and experience of delivery as a member of an Agile Scrum team utilising Scrum methodology. If you think you have the experience and are interested in this position, please do not hesitate to apply! Either apply direct or reach out at
Apr 24, 2024
Contractor
Software Developer Telford (Hybrid) 6 months contract Up to 378 p/d Umbrella Active SC Clearance required ROLE INFO: Software development activity across the full range of development lifecycle; requirements gathering, analysis, design, coding/development, testing, implementation and live support. This may be within new systems development projects or enhancements and fixes to existing applications. Carrying out development in accordance with the agreed requirements and development standards Testing of products in accordance with the test strategy to ensure that they are fit for purpose Assisting the team in examining packages of work and giving realistic timescales for completion Completion of work allocated within agreed time, cost and quality criteria and providing progress reports on assigned work as required Management and control of problems and change within their area of responsibility, including negotiation with other team members Problem analysis, investigation and resolution Playing an active part in Process improvement, awareness of and compliance with all relevant quality processes and procedures, including completion of all the specified quality records Mandatory Skills: Will be used across Live Support systems wherever required: Technologies - Denodo/Talend/PDI/Git/MySQL/Redshift/Grafana Dashboard creation/consolidation Gathering requirements, understanding the service and delivery alerts to suit Should have experience in Grafana monitoring: Dashboard creation/consolidation A software engineering background with proven ability to rapidly learn and apply application development process, tools and programming/scripting languages. Awareness of key SE engineering concepts and governance (design, development, config management and version control, quality control, continuous integration, release/deployment, documentation, built in supportability, built in maintainability, re-use and extensibility) Specific experience of data solutions development addressing data extraction, transformation and load (ETL) processing and data analytics and reporting requirements. Familiar with Agile software development principles and practices and experience of delivery as a member of an Agile Scrum team utilising Scrum methodology. If you think you have the experience and are interested in this position, please do not hesitate to apply! Either apply direct or reach out at
£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 23, 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.
You might have thought that as "Technology Partner of the Year 2023" our team would now be cruising along enjoying all the glory and mentally living on a deserted beach somewhere but you'd be wrong. Yes, we are all incredibly proud of our achievements, BUT we're insanely ambitious, full of new ideas, and we're ONLY JUST getting started. We want YOU to come and join the team as we innovate. Are you ready for your next mission? If so, we'd love to hear from you Role Info: SQL Implementation DeveloperRemote WorkingUp to £50,000 Plus Benefits Package Including Pension, Life Assurance, Employee Assistance Programme, Discounted Gym Memberships and More Company: Leading Provider on HR Tech, Consulting and AdvicePedigree: British HR Awards - Technology Partner of the Year 2023Clients Include: Currys, Wickes, Virgin Atlantic, Network Rail, BT Group, Sainsbury's, Post Office, Pret and More Your Background / Skills: SQL, T-SQL, .NET Core, Azure, Applications Development and Maintenance, Data Imports, Configuration Technical Support, Excellent Communication About us: We are the UK's leading provider of Award-Winning HR cloud technology, consulting and advisory services. We help build a positive culture where people can give their best to drive business success. We do this by taking the complexity out of the HR experience, making it simple, easy to access and agile. By combining cloud technology, data insight and expert guidance, we help our clients empower their leaders, engage their people and drive efficiency. We're not just another tech company or consulting business pretending to understand HR. We do know HR; we live and breathe it. Our Tech: Our award-winning employee relations case management system, empower , is designed to transform how HR leaders and line managers manage people matters. Supported by HR experts and robust HR analytics, we simplify employee relations case management, enabling organisations to drive a positive culture, improve employee experiences, and empower HR leaders to drive an agile, thriving business. Empower is a SaaS cloud platform that enables managers to own 90% of people matters and delivers 8 digit Annual Recurring Revenue. This is what leading retailer Iceland has to say: "It's so intuitive. It's built around how HR advice is actually provided. We're not fitting around the software; the software fits around us". The Opportunity: We are seeking a skilled SQL Developer with proficiency in SQL (Microsoft SQL Server) and experience with .NET Core and Azure to join our implementations team. You will be instrumental in setting up and configuring our award winning product for new clients, primarily focusing on writing, and maintaining SQL scripts for data import. Where you'll add value: + Developing, optimising, and maintaining complex T-SQL scripts for client data import+ Configuring and setting up our product suite for new clients, ensuring seamless integration+ Working with .NET Core for application development and maintenance as needed+ Utilising Azure services and tools to enhance product performance and scalability+ Collaborating with cross-functional teams to understand client requirements and deliver tailored solutions+ Providing technical support and troubleshooting for SQL-related issues+ Documenting all processes and maintaining a high standard of code quality About you: Essential: + Strong expertise in T-SQL with a proven track record of handling large datasets+ Familiarity with .NET Core framework and C# programming+ Experience with Azure cloud services and deployment+ Excellent problem-solving abilities and attention to detail+ Strong communication skills and ability to work effectively in a remote setting+ Ability to work in the UK without restrictions Nice to Haves: + Experience with SQL Server Integration Services (SSIS) or similar ETL tools+ Understanding of Authentication via SSO+ Experience with Infrastructure as Code (Azure ARM / Bicep) What's on Offer: + A fully remote work environment+ A collaborative culture with a rapidly growing team+ Opportunities for professional growth and development+ Life assurance+ Pension+ Holiday purchase scheme+ Volunteering days+ Long service awards+ Contribution towards professional qualifications+ Contribution towards membership fees+ Employee assistance programme+ Health cashback plan+ And more . Sounds like a good fit? Apply here for a fast-track path to our Development Leadership Team. Application notice We take your privacy seriously. When you apply, we shall process your details and pass your application to our client for review for this vacancy only. As you might expect you may be contacted by email, text or telephone. Your data is processed on the basis of our legitimate interests in fulfilling the recruitment process. Please refer to our Data Privacy Policy & Notice on our website for further details. If you have any pre-application questions please contact us first quoting the job title & ref. Good luck, Team RR.
Apr 23, 2024
Full time
You might have thought that as "Technology Partner of the Year 2023" our team would now be cruising along enjoying all the glory and mentally living on a deserted beach somewhere but you'd be wrong. Yes, we are all incredibly proud of our achievements, BUT we're insanely ambitious, full of new ideas, and we're ONLY JUST getting started. We want YOU to come and join the team as we innovate. Are you ready for your next mission? If so, we'd love to hear from you Role Info: SQL Implementation DeveloperRemote WorkingUp to £50,000 Plus Benefits Package Including Pension, Life Assurance, Employee Assistance Programme, Discounted Gym Memberships and More Company: Leading Provider on HR Tech, Consulting and AdvicePedigree: British HR Awards - Technology Partner of the Year 2023Clients Include: Currys, Wickes, Virgin Atlantic, Network Rail, BT Group, Sainsbury's, Post Office, Pret and More Your Background / Skills: SQL, T-SQL, .NET Core, Azure, Applications Development and Maintenance, Data Imports, Configuration Technical Support, Excellent Communication About us: We are the UK's leading provider of Award-Winning HR cloud technology, consulting and advisory services. We help build a positive culture where people can give their best to drive business success. We do this by taking the complexity out of the HR experience, making it simple, easy to access and agile. By combining cloud technology, data insight and expert guidance, we help our clients empower their leaders, engage their people and drive efficiency. We're not just another tech company or consulting business pretending to understand HR. We do know HR; we live and breathe it. Our Tech: Our award-winning employee relations case management system, empower , is designed to transform how HR leaders and line managers manage people matters. Supported by HR experts and robust HR analytics, we simplify employee relations case management, enabling organisations to drive a positive culture, improve employee experiences, and empower HR leaders to drive an agile, thriving business. Empower is a SaaS cloud platform that enables managers to own 90% of people matters and delivers 8 digit Annual Recurring Revenue. This is what leading retailer Iceland has to say: "It's so intuitive. It's built around how HR advice is actually provided. We're not fitting around the software; the software fits around us". The Opportunity: We are seeking a skilled SQL Developer with proficiency in SQL (Microsoft SQL Server) and experience with .NET Core and Azure to join our implementations team. You will be instrumental in setting up and configuring our award winning product for new clients, primarily focusing on writing, and maintaining SQL scripts for data import. Where you'll add value: + Developing, optimising, and maintaining complex T-SQL scripts for client data import+ Configuring and setting up our product suite for new clients, ensuring seamless integration+ Working with .NET Core for application development and maintenance as needed+ Utilising Azure services and tools to enhance product performance and scalability+ Collaborating with cross-functional teams to understand client requirements and deliver tailored solutions+ Providing technical support and troubleshooting for SQL-related issues+ Documenting all processes and maintaining a high standard of code quality About you: Essential: + Strong expertise in T-SQL with a proven track record of handling large datasets+ Familiarity with .NET Core framework and C# programming+ Experience with Azure cloud services and deployment+ Excellent problem-solving abilities and attention to detail+ Strong communication skills and ability to work effectively in a remote setting+ Ability to work in the UK without restrictions Nice to Haves: + Experience with SQL Server Integration Services (SSIS) or similar ETL tools+ Understanding of Authentication via SSO+ Experience with Infrastructure as Code (Azure ARM / Bicep) What's on Offer: + A fully remote work environment+ A collaborative culture with a rapidly growing team+ Opportunities for professional growth and development+ Life assurance+ Pension+ Holiday purchase scheme+ Volunteering days+ Long service awards+ Contribution towards professional qualifications+ Contribution towards membership fees+ Employee assistance programme+ Health cashback plan+ And more . Sounds like a good fit? Apply here for a fast-track path to our Development Leadership Team. Application notice We take your privacy seriously. When you apply, we shall process your details and pass your application to our client for review for this vacancy only. As you might expect you may be contacted by email, text or telephone. Your data is processed on the basis of our legitimate interests in fulfilling the recruitment process. Please refer to our Data Privacy Policy & Notice on our website for further details. If you have any pre-application questions please contact us first quoting the job title & ref. Good luck, Team RR.
ETL Developer (SSIS) x3 Months Outside of IR35 Daily Rate £NEG Hybrid - 1 day per week in the office I have an immediate start for a client I am working with based Nottingham, you will be an ETL Developer with advanced SSIS skills. Skills required: SSIS (advanced) Experience: ERP DM experience and ETL workflow (full end to end), knowledge transfer, implement DQ rules & validation, De-duplication, desirable M3. Duration: 12 weeks. Apply now - must be able start immediately
Apr 23, 2024
Full time
ETL Developer (SSIS) x3 Months Outside of IR35 Daily Rate £NEG Hybrid - 1 day per week in the office I have an immediate start for a client I am working with based Nottingham, you will be an ETL Developer with advanced SSIS skills. Skills required: SSIS (advanced) Experience: ERP DM experience and ETL workflow (full end to end), knowledge transfer, implement DQ rules & validation, De-duplication, desirable M3. Duration: 12 weeks. Apply now - must be able start immediately
BI Developer Insurance Firm EssexMy client is a IT based Insurance firm based in Essex who are looking to appoint a BI Developer to join their Data Services Team. They are currently in an innovation Journey where they are modernising their Data Platform, utilising MS Cloud Technologies, with the aim to provide data and reporting solutions to support their Insurance clients efficiently.Role: Develop and maintain ETL processes to bring data from various sources (internal systems, third-party APIs, databases, etc.) into the data warehouse. Design and implement data models for the data warehouse using tools like SQL Server Analysis Services (SSAS) or Azure Analysis Services (AAS). Build and maintain the data warehouse infrastructure, ensuring scalability, performance, and reliability. Create interactive reports, dashboards, and data visualisations using tools such as Power BI, ensuring the delivery of actionable insights to stakeholders. Optimise queries, data models, and ETL processes to improve performance and reduce processing time.Skills Needed: In-depth knowledge and hands-on experience with Microsoft BI tools such as SQL Server, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and Power BI. Strong skills in designing, developing, and optimising ETL processes using SQL Server Integration Services (SSIS) or similar tools for data extraction, transformation, and loading. Proficient in writing complex SQL queries, stored procedures, and functions for data manipulation, extraction, and analysis. Expertise in creating interactive and visually appealing reports, dashboards, and data visualisations using Power BI or similar BI visualisation tools. Knowledge of data warehouse design principles, including data modeling, indexing, partitioning, and optimisation for performance and scalability.If you are a self-motivated individual with a passion for the Technology within the Insurance industry and meet the qualifications outlined above, please submit your CV and cover letter.
Apr 23, 2024
Full time
BI Developer Insurance Firm EssexMy client is a IT based Insurance firm based in Essex who are looking to appoint a BI Developer to join their Data Services Team. They are currently in an innovation Journey where they are modernising their Data Platform, utilising MS Cloud Technologies, with the aim to provide data and reporting solutions to support their Insurance clients efficiently.Role: Develop and maintain ETL processes to bring data from various sources (internal systems, third-party APIs, databases, etc.) into the data warehouse. Design and implement data models for the data warehouse using tools like SQL Server Analysis Services (SSAS) or Azure Analysis Services (AAS). Build and maintain the data warehouse infrastructure, ensuring scalability, performance, and reliability. Create interactive reports, dashboards, and data visualisations using tools such as Power BI, ensuring the delivery of actionable insights to stakeholders. Optimise queries, data models, and ETL processes to improve performance and reduce processing time.Skills Needed: In-depth knowledge and hands-on experience with Microsoft BI tools such as SQL Server, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and Power BI. Strong skills in designing, developing, and optimising ETL processes using SQL Server Integration Services (SSIS) or similar tools for data extraction, transformation, and loading. Proficient in writing complex SQL queries, stored procedures, and functions for data manipulation, extraction, and analysis. Expertise in creating interactive and visually appealing reports, dashboards, and data visualisations using Power BI or similar BI visualisation tools. Knowledge of data warehouse design principles, including data modeling, indexing, partitioning, and optimisation for performance and scalability.If you are a self-motivated individual with a passion for the Technology within the Insurance industry and meet the qualifications outlined above, please submit your CV and cover letter.
You might have thought that as "Technology Partner of the Year 2023" our team would now be cruising along enjoying all the glory and mentally living on a deserted beach somewhere but you'd be wrong. Yes, we are all incredibly proud of our achievements, BUT we're insanely ambitious, full of new ideas, and we're ONLY JUST getting started. We want YOU to come and join the team as we innovate. Are you ready for your next mission? If so, we'd love to hear from you Role Info: SQL Implementation DeveloperRemote WorkingUp to £50,000 Plus Benefits Package Including Pension, Life Assurance, Employee Assistance Programme, Discounted Gym Memberships and More Company: Leading Provider on HR Tech, Consulting and AdvicePedigree: British HR Awards - Technology Partner of the Year 2023Clients Include: Currys, Wickes, Virgin Atlantic, Network Rail, BT Group, Sainsbury's, Post Office, Pret and More Your Background / Skills: SQL, T-SQL, .NET Core, Azure, Applications Development and Maintenance, Data Imports, Configuration Technical Support, Excellent Communication About us: We are the UK's leading provider of Award-Winning HR cloud technology, consulting and advisory services. We help build a positive culture where people can give their best to drive business success. We do this by taking the complexity out of the HR experience, making it simple, easy to access and agile. By combining cloud technology, data insight and expert guidance, we help our clients empower their leaders, engage their people and drive efficiency. We're not just another tech company or consulting business pretending to understand HR. We do know HR; we live and breathe it. Our Tech: Our award-winning employee relations case management system, empower , is designed to transform how HR leaders and line managers manage people matters. Supported by HR experts and robust HR analytics, we simplify employee relations case management, enabling organisations to drive a positive culture, improve employee experiences, and empower HR leaders to drive an agile, thriving business. Empower is a SaaS cloud platform that enables managers to own 90% of people matters and delivers 8 digit Annual Recurring Revenue. This is what leading retailer Iceland has to say: "It's so intuitive. It's built around how HR advice is actually provided. We're not fitting around the software; the software fits around us". The Opportunity: We are seeking a skilled SQL Developer with proficiency in SQL (Microsoft SQL Server) and experience with .NET Core and Azure to join our implementations team. You will be instrumental in setting up and configuring our award winning product for new clients, primarily focusing on writing, and maintaining SQL scripts for data import. Where you'll add value: + Developing, optimising, and maintaining complex T-SQL scripts for client data import+ Configuring and setting up our product suite for new clients, ensuring seamless integration+ Working with .NET Core for application development and maintenance as needed+ Utilising Azure services and tools to enhance product performance and scalability+ Collaborating with cross-functional teams to understand client requirements and deliver tailored solutions+ Providing technical support and troubleshooting for SQL-related issues+ Documenting all processes and maintaining a high standard of code quality About you: Essential: + Strong expertise in T-SQL with a proven track record of handling large datasets+ Familiarity with .NET Core framework and C# programming+ Experience with Azure cloud services and deployment+ Excellent problem-solving abilities and attention to detail+ Strong communication skills and ability to work effectively in a remote setting+ Ability to work in the UK without restrictions Nice to Haves: + Experience with SQL Server Integration Services (SSIS) or similar ETL tools+ Understanding of Authentication via SSO+ Experience with Infrastructure as Code (Azure ARM / Bicep) What's on Offer: + A fully remote work environment+ A collaborative culture with a rapidly growing team+ Opportunities for professional growth and development+ Life assurance+ Pension+ Holiday purchase scheme+ Volunteering days+ Long service awards+ Contribution towards professional qualifications+ Contribution towards membership fees+ Employee assistance programme+ Health cashback plan+ And more . Sounds like a good fit? Apply here for a fast-track path to our Development Leadership Team. Application notice We take your privacy seriously. When you apply, we shall process your details and pass your application to our client for review for this vacancy only. As you might expect you may be contacted by email, text or telephone. Your data is processed on the basis of our legitimate interests in fulfilling the recruitment process. Please refer to our Data Privacy Policy & Notice on our website for further details. If you have any pre-application questions please contact us first quoting the job title & ref. Good luck, Team RR.
Apr 23, 2024
Full time
You might have thought that as "Technology Partner of the Year 2023" our team would now be cruising along enjoying all the glory and mentally living on a deserted beach somewhere but you'd be wrong. Yes, we are all incredibly proud of our achievements, BUT we're insanely ambitious, full of new ideas, and we're ONLY JUST getting started. We want YOU to come and join the team as we innovate. Are you ready for your next mission? If so, we'd love to hear from you Role Info: SQL Implementation DeveloperRemote WorkingUp to £50,000 Plus Benefits Package Including Pension, Life Assurance, Employee Assistance Programme, Discounted Gym Memberships and More Company: Leading Provider on HR Tech, Consulting and AdvicePedigree: British HR Awards - Technology Partner of the Year 2023Clients Include: Currys, Wickes, Virgin Atlantic, Network Rail, BT Group, Sainsbury's, Post Office, Pret and More Your Background / Skills: SQL, T-SQL, .NET Core, Azure, Applications Development and Maintenance, Data Imports, Configuration Technical Support, Excellent Communication About us: We are the UK's leading provider of Award-Winning HR cloud technology, consulting and advisory services. We help build a positive culture where people can give their best to drive business success. We do this by taking the complexity out of the HR experience, making it simple, easy to access and agile. By combining cloud technology, data insight and expert guidance, we help our clients empower their leaders, engage their people and drive efficiency. We're not just another tech company or consulting business pretending to understand HR. We do know HR; we live and breathe it. Our Tech: Our award-winning employee relations case management system, empower , is designed to transform how HR leaders and line managers manage people matters. Supported by HR experts and robust HR analytics, we simplify employee relations case management, enabling organisations to drive a positive culture, improve employee experiences, and empower HR leaders to drive an agile, thriving business. Empower is a SaaS cloud platform that enables managers to own 90% of people matters and delivers 8 digit Annual Recurring Revenue. This is what leading retailer Iceland has to say: "It's so intuitive. It's built around how HR advice is actually provided. We're not fitting around the software; the software fits around us". The Opportunity: We are seeking a skilled SQL Developer with proficiency in SQL (Microsoft SQL Server) and experience with .NET Core and Azure to join our implementations team. You will be instrumental in setting up and configuring our award winning product for new clients, primarily focusing on writing, and maintaining SQL scripts for data import. Where you'll add value: + Developing, optimising, and maintaining complex T-SQL scripts for client data import+ Configuring and setting up our product suite for new clients, ensuring seamless integration+ Working with .NET Core for application development and maintenance as needed+ Utilising Azure services and tools to enhance product performance and scalability+ Collaborating with cross-functional teams to understand client requirements and deliver tailored solutions+ Providing technical support and troubleshooting for SQL-related issues+ Documenting all processes and maintaining a high standard of code quality About you: Essential: + Strong expertise in T-SQL with a proven track record of handling large datasets+ Familiarity with .NET Core framework and C# programming+ Experience with Azure cloud services and deployment+ Excellent problem-solving abilities and attention to detail+ Strong communication skills and ability to work effectively in a remote setting+ Ability to work in the UK without restrictions Nice to Haves: + Experience with SQL Server Integration Services (SSIS) or similar ETL tools+ Understanding of Authentication via SSO+ Experience with Infrastructure as Code (Azure ARM / Bicep) What's on Offer: + A fully remote work environment+ A collaborative culture with a rapidly growing team+ Opportunities for professional growth and development+ Life assurance+ Pension+ Holiday purchase scheme+ Volunteering days+ Long service awards+ Contribution towards professional qualifications+ Contribution towards membership fees+ Employee assistance programme+ Health cashback plan+ And more . Sounds like a good fit? Apply here for a fast-track path to our Development Leadership Team. Application notice We take your privacy seriously. When you apply, we shall process your details and pass your application to our client for review for this vacancy only. As you might expect you may be contacted by email, text or telephone. Your data is processed on the basis of our legitimate interests in fulfilling the recruitment process. Please refer to our Data Privacy Policy & Notice on our website for further details. If you have any pre-application questions please contact us first quoting the job title & ref. Good luck, Team RR.
You might have thought that as "Technology Partner of the Year 2023" our team would now be cruising along enjoying all the glory and mentally living on a deserted beach somewhere but you'd be wrong. Yes, we are all incredibly proud of our achievements, BUT we're insanely ambitious, full of new ideas, and we're ONLY JUST getting started. We want YOU to come and join the team as we innovate. Are you ready for your next mission? If so, we'd love to hear from you Role Info: SQL Implementation DeveloperRemote WorkingUp to £50,000 Plus Benefits Package Including Pension, Life Assurance, Employee Assistance Programme, Discounted Gym Memberships and More Company: Leading Provider on HR Tech, Consulting and AdvicePedigree: British HR Awards - Technology Partner of the Year 2023Clients Include: Currys, Wickes, Virgin Atlantic, Network Rail, BT Group, Sainsbury's, Post Office, Pret and More Your Background / Skills: SQL, T-SQL, .NET Core, Azure, Applications Development and Maintenance, Data Imports, Configuration Technical Support, Excellent Communication About us: We are the UK's leading provider of Award-Winning HR cloud technology, consulting and advisory services. We help build a positive culture where people can give their best to drive business success. We do this by taking the complexity out of the HR experience, making it simple, easy to access and agile. By combining cloud technology, data insight and expert guidance, we help our clients empower their leaders, engage their people and drive efficiency. We're not just another tech company or consulting business pretending to understand HR. We do know HR; we live and breathe it. Our Tech: Our award-winning employee relations case management system, empower , is designed to transform how HR leaders and line managers manage people matters. Supported by HR experts and robust HR analytics, we simplify employee relations case management, enabling organisations to drive a positive culture, improve employee experiences, and empower HR leaders to drive an agile, thriving business. Empower is a SaaS cloud platform that enables managers to own 90% of people matters and delivers 8 digit Annual Recurring Revenue. This is what leading retailer Iceland has to say: "It's so intuitive. It's built around how HR advice is actually provided. We're not fitting around the software; the software fits around us". The Opportunity: We are seeking a skilled SQL Developer with proficiency in SQL (Microsoft SQL Server) and experience with .NET Core and Azure to join our implementations team. You will be instrumental in setting up and configuring our award winning product for new clients, primarily focusing on writing, and maintaining SQL scripts for data import. Where you'll add value: + Developing, optimising, and maintaining complex T-SQL scripts for client data import+ Configuring and setting up our product suite for new clients, ensuring seamless integration+ Working with .NET Core for application development and maintenance as needed+ Utilising Azure services and tools to enhance product performance and scalability+ Collaborating with cross-functional teams to understand client requirements and deliver tailored solutions+ Providing technical support and troubleshooting for SQL-related issues+ Documenting all processes and maintaining a high standard of code quality About you: Essential: + Strong expertise in T-SQL with a proven track record of handling large datasets+ Familiarity with .NET Core framework and C# programming+ Experience with Azure cloud services and deployment+ Excellent problem-solving abilities and attention to detail+ Strong communication skills and ability to work effectively in a remote setting+ Ability to work in the UK without restrictions Nice to Haves: + Experience with SQL Server Integration Services (SSIS) or similar ETL tools+ Understanding of Authentication via SSO+ Experience with Infrastructure as Code (Azure ARM / Bicep) What's on Offer: + A fully remote work environment+ A collaborative culture with a rapidly growing team+ Opportunities for professional growth and development+ Life assurance+ Pension+ Holiday purchase scheme+ Volunteering days+ Long service awards+ Contribution towards professional qualifications+ Contribution towards membership fees+ Employee assistance programme+ Health cashback plan+ And more . Sounds like a good fit? Apply here for a fast-track path to our Development Leadership Team. Application notice We take your privacy seriously. When you apply, we shall process your details and pass your application to our client for review for this vacancy only. As you might expect you may be contacted by email, text or telephone. Your data is processed on the basis of our legitimate interests in fulfilling the recruitment process. Please refer to our Data Privacy Policy & Notice on our website for further details. If you have any pre-application questions please contact us first quoting the job title & ref. Good luck, Team RR.
Apr 23, 2024
Full time
You might have thought that as "Technology Partner of the Year 2023" our team would now be cruising along enjoying all the glory and mentally living on a deserted beach somewhere but you'd be wrong. Yes, we are all incredibly proud of our achievements, BUT we're insanely ambitious, full of new ideas, and we're ONLY JUST getting started. We want YOU to come and join the team as we innovate. Are you ready for your next mission? If so, we'd love to hear from you Role Info: SQL Implementation DeveloperRemote WorkingUp to £50,000 Plus Benefits Package Including Pension, Life Assurance, Employee Assistance Programme, Discounted Gym Memberships and More Company: Leading Provider on HR Tech, Consulting and AdvicePedigree: British HR Awards - Technology Partner of the Year 2023Clients Include: Currys, Wickes, Virgin Atlantic, Network Rail, BT Group, Sainsbury's, Post Office, Pret and More Your Background / Skills: SQL, T-SQL, .NET Core, Azure, Applications Development and Maintenance, Data Imports, Configuration Technical Support, Excellent Communication About us: We are the UK's leading provider of Award-Winning HR cloud technology, consulting and advisory services. We help build a positive culture where people can give their best to drive business success. We do this by taking the complexity out of the HR experience, making it simple, easy to access and agile. By combining cloud technology, data insight and expert guidance, we help our clients empower their leaders, engage their people and drive efficiency. We're not just another tech company or consulting business pretending to understand HR. We do know HR; we live and breathe it. Our Tech: Our award-winning employee relations case management system, empower , is designed to transform how HR leaders and line managers manage people matters. Supported by HR experts and robust HR analytics, we simplify employee relations case management, enabling organisations to drive a positive culture, improve employee experiences, and empower HR leaders to drive an agile, thriving business. Empower is a SaaS cloud platform that enables managers to own 90% of people matters and delivers 8 digit Annual Recurring Revenue. This is what leading retailer Iceland has to say: "It's so intuitive. It's built around how HR advice is actually provided. We're not fitting around the software; the software fits around us". The Opportunity: We are seeking a skilled SQL Developer with proficiency in SQL (Microsoft SQL Server) and experience with .NET Core and Azure to join our implementations team. You will be instrumental in setting up and configuring our award winning product for new clients, primarily focusing on writing, and maintaining SQL scripts for data import. Where you'll add value: + Developing, optimising, and maintaining complex T-SQL scripts for client data import+ Configuring and setting up our product suite for new clients, ensuring seamless integration+ Working with .NET Core for application development and maintenance as needed+ Utilising Azure services and tools to enhance product performance and scalability+ Collaborating with cross-functional teams to understand client requirements and deliver tailored solutions+ Providing technical support and troubleshooting for SQL-related issues+ Documenting all processes and maintaining a high standard of code quality About you: Essential: + Strong expertise in T-SQL with a proven track record of handling large datasets+ Familiarity with .NET Core framework and C# programming+ Experience with Azure cloud services and deployment+ Excellent problem-solving abilities and attention to detail+ Strong communication skills and ability to work effectively in a remote setting+ Ability to work in the UK without restrictions Nice to Haves: + Experience with SQL Server Integration Services (SSIS) or similar ETL tools+ Understanding of Authentication via SSO+ Experience with Infrastructure as Code (Azure ARM / Bicep) What's on Offer: + A fully remote work environment+ A collaborative culture with a rapidly growing team+ Opportunities for professional growth and development+ Life assurance+ Pension+ Holiday purchase scheme+ Volunteering days+ Long service awards+ Contribution towards professional qualifications+ Contribution towards membership fees+ Employee assistance programme+ Health cashback plan+ And more . Sounds like a good fit? Apply here for a fast-track path to our Development Leadership Team. Application notice We take your privacy seriously. When you apply, we shall process your details and pass your application to our client for review for this vacancy only. As you might expect you may be contacted by email, text or telephone. Your data is processed on the basis of our legitimate interests in fulfilling the recruitment process. Please refer to our Data Privacy Policy & Notice on our website for further details. If you have any pre-application questions please contact us first quoting the job title & ref. Good luck, Team RR.
Database Administrator Salary: up to £45,000 per annum Location: Flexible - Hybrid, expected to attend the Milton Keynes office at least once a month An exciting opportunity to join an innovative, highly successful organisation supplying leading edge technology to the NHS. Applications are invited for an experienced DBA to join the Database Team within the Operations Department to monitor, maintain and support databases in Managed Instances, big data in Azure SQL, as well as limited amount of on premise SQL databases on Virtual Machines. Technical Skills: Cloud Services (ideally Azure) experience is essential - including Azure Data Factory and Azure DevOps Excellent performance tuning skills (experience of Query Tuning, Indexing, Locking etc.) Strong T-SQL Experience (creating / administrating stored procedures, scripts, functions, triggers and other objects) Experience in the manipulation, transformation, and exploration of large multi-dimensional datasets Experience in database installation, backup, restore and maintenance BSC or equivalent in a software engineering / DB discipline and / or Professional qualifications appropriate to DB engineering roles is desirable. Experience of large transactional databases (100GB+) Excellent knowledge of the SQL Database Engine Experience of database release / upgrades with product releases Extensive experience of working with Microsoft SQL Server 2005/2008/2012/2014 Data Warehouse development, ETL and transformation into conformed design Knowledge of SSIS packages Excellent experience and knowledge of the Microsoft stack Understanding of relational database design & dimensional Data-modelling Some experience of using Visual Studio Knowledge of C# and .Net framework desirable Knowledge of NOSQL / Document DBs advantageous Knowledge of SSRS reports advantageous but not essential Knowledge of 3rd party toolkits e.g. RedGate desirable but not essential Experience of Source Control (BitBucket/Kiln / Mercurial) Strong SQL Skills (SQL server 2012/2016, T-SQL) and development skills in T-SQL, writing scripts, Log Shipping, producing reports (SSRS), performance tuning, automated back-ups, security Any experience with Bespoke Software Solutions, ITIL, Agile, Jira and ISO 27001 will be advantageous but not essential Domain or Product expertise in IT Healthcare would be advantageous but not essential Role Description The ideal person for this role will play an integral part of the service provision that we provide, working and assisting with junior team members, development colleagues and application support team to ensure the databases remain performant and quality of data integrity is high. Training of the product and database schema will be provided to bring you up to speed. This role will suit someone who has a few years' experience as a DBA or a Junior DBA looking to progress, has worked on Azure or other similar cloud platforms and is keen to contribute their efforts in a busy but rewarding environment. The key to success in this role is being organised, adaptable and alert. It is a fast paced environment with the requirement to service and support the live customer databases, deploying updates as required, along with support programme work including migrating data, loading in new datasets, and running scripts to update data. Main Responsibilities Database troubleshooting and maintenance to meet availability requirements and resolve service desk calls in accordance with SLAs (Service Level Agreements). Ensure that work on defect resolution does not impact on agreed product deliverables, escalating to development DBAs for code fixes. Monitor Database health and performance, ensuring high levels of performance, availability, sustainability, and security. Cleanse or translate (migrate) data so that it can be effectively moved between systems, apps, or software for programme work or to support incidents as required by use of SQL Scripting. Test the new system and data after the migration or data fix to find errors and/or points of corruption and produce quality reports to confirm success. Audit existing data systems and deployments and identify errors or areas for improvement. Ensure that all changes to the database follow the change management policy, ensuring high level of testing and risk management. Liaise with Database developers during handovers of projects, new features, or releases to ensure they are understood, deployed accurately as required through DACPAC deployments, scripts or Azure pipelines and delivered in a timely fashion. Maintain data integrity and security (manage roles and permissions of database users). Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them. Ensure reviews are conducted on a regular basis to improve / enhance the database, and that the improvements are consistent with the departmental guidelines (working closely with other members of the DB team). Where no formal guidelines exist, work with peers to formulate and enforce such guidelines. Provide technical guidance and support to your colleagues ensuring database products are optimised, follow best practice guidelines and Keep abreast of technology trends and how they apply to your area. Put forward suggestions for improvement to processes or tools where applicable. Develop a level of product expertise across the solution architecture. To be part of an On-Call rota as required Personal Skills: Confidence to communicate with customers in a professional manner, remotely or over the phone Must be ability to prioritise work with the ability to adapt to a fluid and varied workload Natural desire to investigate and diagnose issues and document processes as and when required Able to work in a logical and systematic fashion Demonstrate problem solving and troubleshooting skills Exhibit a flexible, can-do attitude to problem solving using own initiative. ATA Recruitment Solutions is working in the capacity of an Employment Agency for this position.
Apr 23, 2024
Full time
Database Administrator Salary: up to £45,000 per annum Location: Flexible - Hybrid, expected to attend the Milton Keynes office at least once a month An exciting opportunity to join an innovative, highly successful organisation supplying leading edge technology to the NHS. Applications are invited for an experienced DBA to join the Database Team within the Operations Department to monitor, maintain and support databases in Managed Instances, big data in Azure SQL, as well as limited amount of on premise SQL databases on Virtual Machines. Technical Skills: Cloud Services (ideally Azure) experience is essential - including Azure Data Factory and Azure DevOps Excellent performance tuning skills (experience of Query Tuning, Indexing, Locking etc.) Strong T-SQL Experience (creating / administrating stored procedures, scripts, functions, triggers and other objects) Experience in the manipulation, transformation, and exploration of large multi-dimensional datasets Experience in database installation, backup, restore and maintenance BSC or equivalent in a software engineering / DB discipline and / or Professional qualifications appropriate to DB engineering roles is desirable. Experience of large transactional databases (100GB+) Excellent knowledge of the SQL Database Engine Experience of database release / upgrades with product releases Extensive experience of working with Microsoft SQL Server 2005/2008/2012/2014 Data Warehouse development, ETL and transformation into conformed design Knowledge of SSIS packages Excellent experience and knowledge of the Microsoft stack Understanding of relational database design & dimensional Data-modelling Some experience of using Visual Studio Knowledge of C# and .Net framework desirable Knowledge of NOSQL / Document DBs advantageous Knowledge of SSRS reports advantageous but not essential Knowledge of 3rd party toolkits e.g. RedGate desirable but not essential Experience of Source Control (BitBucket/Kiln / Mercurial) Strong SQL Skills (SQL server 2012/2016, T-SQL) and development skills in T-SQL, writing scripts, Log Shipping, producing reports (SSRS), performance tuning, automated back-ups, security Any experience with Bespoke Software Solutions, ITIL, Agile, Jira and ISO 27001 will be advantageous but not essential Domain or Product expertise in IT Healthcare would be advantageous but not essential Role Description The ideal person for this role will play an integral part of the service provision that we provide, working and assisting with junior team members, development colleagues and application support team to ensure the databases remain performant and quality of data integrity is high. Training of the product and database schema will be provided to bring you up to speed. This role will suit someone who has a few years' experience as a DBA or a Junior DBA looking to progress, has worked on Azure or other similar cloud platforms and is keen to contribute their efforts in a busy but rewarding environment. The key to success in this role is being organised, adaptable and alert. It is a fast paced environment with the requirement to service and support the live customer databases, deploying updates as required, along with support programme work including migrating data, loading in new datasets, and running scripts to update data. Main Responsibilities Database troubleshooting and maintenance to meet availability requirements and resolve service desk calls in accordance with SLAs (Service Level Agreements). Ensure that work on defect resolution does not impact on agreed product deliverables, escalating to development DBAs for code fixes. Monitor Database health and performance, ensuring high levels of performance, availability, sustainability, and security. Cleanse or translate (migrate) data so that it can be effectively moved between systems, apps, or software for programme work or to support incidents as required by use of SQL Scripting. Test the new system and data after the migration or data fix to find errors and/or points of corruption and produce quality reports to confirm success. Audit existing data systems and deployments and identify errors or areas for improvement. Ensure that all changes to the database follow the change management policy, ensuring high level of testing and risk management. Liaise with Database developers during handovers of projects, new features, or releases to ensure they are understood, deployed accurately as required through DACPAC deployments, scripts or Azure pipelines and delivered in a timely fashion. Maintain data integrity and security (manage roles and permissions of database users). Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them. Ensure reviews are conducted on a regular basis to improve / enhance the database, and that the improvements are consistent with the departmental guidelines (working closely with other members of the DB team). Where no formal guidelines exist, work with peers to formulate and enforce such guidelines. Provide technical guidance and support to your colleagues ensuring database products are optimised, follow best practice guidelines and Keep abreast of technology trends and how they apply to your area. Put forward suggestions for improvement to processes or tools where applicable. Develop a level of product expertise across the solution architecture. To be part of an On-Call rota as required Personal Skills: Confidence to communicate with customers in a professional manner, remotely or over the phone Must be ability to prioritise work with the ability to adapt to a fluid and varied workload Natural desire to investigate and diagnose issues and document processes as and when required Able to work in a logical and systematic fashion Demonstrate problem solving and troubleshooting skills Exhibit a flexible, can-do attitude to problem solving using own initiative. ATA Recruitment Solutions is working in the capacity of an Employment Agency for this position.
Software Developer Telford (Hybrid) 6 months contract Up to £378 p/d Umbrella Active SC Clearance required ROLE INFO: Software development activity across the full range of development life cycle; requirements gathering, analysis, design, coding/development, testing, implementation and live support. This may be within new systems development projects or enhancements and fixes to existing applications. Carrying out development in accordance with the agreed requirements and development standards Testing of products in accordance with the test strategy to ensure that they are fit for purpose Assisting the team in examining packages of work and giving realistic timescales for completion Completion of work allocated within agreed time, cost and quality criteria and providing progress reports on assigned work as required Management and control of problems and change within their area of responsibility, including negotiation with other team members Problem analysis, investigation and resolution Playing an active part in Process improvement, awareness of and compliance with all relevant quality processes and procedures, including completion of all the specified quality records Mandatory Skills: Will be used across Live Support systems wherever required: Technologies - Denodo/Talend/PDI/Git/MySQL/Redshift/Grafana Dashboard creation/consolidation Gathering requirements, understanding the service and delivery alerts to suit Should have experience in Grafana monitoring: Dashboard creation/consolidation A software engineering background with proven ability to rapidly learn and apply application development process, tools and programming/Scripting languages. Awareness of key SE engineering concepts and governance (design, development, config management and version control, quality control, continuous integration, release/deployment, documentation, built in supportability, built in maintainability, re-use and extensibility) Specific experience of data solutions development addressing data extraction, transformation and load (ETL) processing and data analytics and reporting requirements. Familiar with Agile software development principles and practices and experience of delivery as a member of an Agile Scrum team utilising Scrum methodology. If you think you have the experience and are interested in this position, please do not hesitate to apply! Either apply direct or reach out
Apr 23, 2024
Contractor
Software Developer Telford (Hybrid) 6 months contract Up to £378 p/d Umbrella Active SC Clearance required ROLE INFO: Software development activity across the full range of development life cycle; requirements gathering, analysis, design, coding/development, testing, implementation and live support. This may be within new systems development projects or enhancements and fixes to existing applications. Carrying out development in accordance with the agreed requirements and development standards Testing of products in accordance with the test strategy to ensure that they are fit for purpose Assisting the team in examining packages of work and giving realistic timescales for completion Completion of work allocated within agreed time, cost and quality criteria and providing progress reports on assigned work as required Management and control of problems and change within their area of responsibility, including negotiation with other team members Problem analysis, investigation and resolution Playing an active part in Process improvement, awareness of and compliance with all relevant quality processes and procedures, including completion of all the specified quality records Mandatory Skills: Will be used across Live Support systems wherever required: Technologies - Denodo/Talend/PDI/Git/MySQL/Redshift/Grafana Dashboard creation/consolidation Gathering requirements, understanding the service and delivery alerts to suit Should have experience in Grafana monitoring: Dashboard creation/consolidation A software engineering background with proven ability to rapidly learn and apply application development process, tools and programming/Scripting languages. Awareness of key SE engineering concepts and governance (design, development, config management and version control, quality control, continuous integration, release/deployment, documentation, built in supportability, built in maintainability, re-use and extensibility) Specific experience of data solutions development addressing data extraction, transformation and load (ETL) processing and data analytics and reporting requirements. Familiar with Agile software development principles and practices and experience of delivery as a member of an Agile Scrum team utilising Scrum methodology. If you think you have the experience and are interested in this position, please do not hesitate to apply! Either apply direct or reach out
Hays is currently working in collaboration with a British private sector organisation, in expanding their technology team. Our client is looking for an experienced Senior SQL Developer to join their team based out of Blackburn! In this role you will suggest, create and maintain SQL objects. You will also coach & mentor Junior SQL Developers within the team, helping them develop and flourish within their roles.Duties and Responsibilities Check, troubleshoot and correct data import and export activities daily Communicate to the team and business on any issues and delays Suggest/Maintain/Create SQL objects such as tables, views, stored procedures, scripts, functions, triggers Suggest/Maintain/Create SSIS packages according to business needs Maintain/Create documentation Work with the BI team and other teams to provide accurate and complete Data and to maintain Data quality/integrity Mentor Junior SQL developers Open and able to adapt to new technologies related to Data storage and Data transfers What skills are required: Experience of working with transactional databases and data warehouses Experience of designing and developing database schema/ objects whilst following good practices (such as normalisation) Excellent knowledge of the SQL Database Engine Strong T-SQL knowledge Strong experience using SSIS for diverse ETL processes (import/export data through files, emails, SFTP, APIs etc) Excellent performance tuning skills (experience of Query Tuning, Index Optimisation, Locking etc.) Experience with SSRS and PowerBI Excellent communication and documentation skills for technical audience Ability to work in a team environment with people of different skills and share knowledge with juniors Please e-mail with any enquiries regarding the role. What you need to do now If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion on your career. Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk
Apr 23, 2024
Full time
Hays is currently working in collaboration with a British private sector organisation, in expanding their technology team. Our client is looking for an experienced Senior SQL Developer to join their team based out of Blackburn! In this role you will suggest, create and maintain SQL objects. You will also coach & mentor Junior SQL Developers within the team, helping them develop and flourish within their roles.Duties and Responsibilities Check, troubleshoot and correct data import and export activities daily Communicate to the team and business on any issues and delays Suggest/Maintain/Create SQL objects such as tables, views, stored procedures, scripts, functions, triggers Suggest/Maintain/Create SSIS packages according to business needs Maintain/Create documentation Work with the BI team and other teams to provide accurate and complete Data and to maintain Data quality/integrity Mentor Junior SQL developers Open and able to adapt to new technologies related to Data storage and Data transfers What skills are required: Experience of working with transactional databases and data warehouses Experience of designing and developing database schema/ objects whilst following good practices (such as normalisation) Excellent knowledge of the SQL Database Engine Strong T-SQL knowledge Strong experience using SSIS for diverse ETL processes (import/export data through files, emails, SFTP, APIs etc) Excellent performance tuning skills (experience of Query Tuning, Index Optimisation, Locking etc.) Experience with SSRS and PowerBI Excellent communication and documentation skills for technical audience Ability to work in a team environment with people of different skills and share knowledge with juniors Please e-mail with any enquiries regarding the role. What you need to do now If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion on your career. Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk