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 17, 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.
Pricing BI/SQL/Data Warehouse/ETL Developer required to work on a Hybrid model and to work at my clients HQ in North London. You must be able to commute to North London to be considered. Job purpose: To design, develop, trial, and maintain my client's Business Intelligence solutions, with a specific focus on Pricing/Actuarial deliverables. This will involve working closely with their Pricing teams to understand the requirements, then building new data structures within their existing SQL Server data warehouse platform, in such a way as to be easily integrated into robust and efficient daily ETL processes. You will need to be happy to work in an Agile environment, where throwaway proofs-of-concept need to be created, followed by iterative incremental development before arriving at solution designs ready for industrialisation, within a Microsoft SQL Server stack (currently on-premise, soon to be Azure). Skills required: Experience of Building new data structures within an existing SQL Server data warehouse platform Experience of integration into robust and efficient daily ETL processes. Experience working within an Agile environment. Maintain, design and build within existing ETL architecture using MS stack: eg SQL Server 2022, T-SQL, Power BI Report Server, SSIS, Azure Dev Ops, Git. Ensure business-led efficient Power BI dashboards can be created from the developed data structures to support pricing risk monitoring and modelling. This position comes with excellent benefits; pension, good holidays and some working from home. Please send in your CV if you have the above skills and you are easily commutable to and from North London.
Apr 16, 2024
Full time
Pricing BI/SQL/Data Warehouse/ETL Developer required to work on a Hybrid model and to work at my clients HQ in North London. You must be able to commute to North London to be considered. Job purpose: To design, develop, trial, and maintain my client's Business Intelligence solutions, with a specific focus on Pricing/Actuarial deliverables. This will involve working closely with their Pricing teams to understand the requirements, then building new data structures within their existing SQL Server data warehouse platform, in such a way as to be easily integrated into robust and efficient daily ETL processes. You will need to be happy to work in an Agile environment, where throwaway proofs-of-concept need to be created, followed by iterative incremental development before arriving at solution designs ready for industrialisation, within a Microsoft SQL Server stack (currently on-premise, soon to be Azure). Skills required: Experience of Building new data structures within an existing SQL Server data warehouse platform Experience of integration into robust and efficient daily ETL processes. Experience working within an Agile environment. Maintain, design and build within existing ETL architecture using MS stack: eg SQL Server 2022, T-SQL, Power BI Report Server, SSIS, Azure Dev Ops, Git. Ensure business-led efficient Power BI dashboards can be created from the developed data structures to support pricing risk monitoring and modelling. This position comes with excellent benefits; pension, good holidays and some working from home. Please send in your CV if you have the above skills and you are easily commutable to and from North London.
BI Developer Insurance Firm Essex My 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 15, 2024
Full time
BI Developer Insurance Firm Essex My 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.
BI Developer/T-SQL/SSIS required to work in North London on a Hybrid model. This is a 6 month contract inside/outside IR35 to be confirmed and day rates also TBC, which I will know more on Monday. Key requirement for this role is to prepare the Company's SQL Server based data warehouse (DWH) ETL processes for an imminent large increase in data volumes. This will involve examining the end-to-end DWH ETL process (both SSIS and native T-SQL) and optimising wherever possible. There will also be a requirement to assist with the design, development and support of a number of new ETL/MI/BI requests from the business due to recent business growth. Skills required: To be considered for this role you must have excellent knowledge of T-SQL and SSIS skills. Good understanding of Data Warehouse experience. Experience with migration, plus detailed knowledge of the MS SQL Azure (initially IaaS, then PaaS) platform is also required. Please send in your CV if you have the above skills - if your CV looks good, I will then be in touch. If you do not hear back from me, this will be due to a high volume of CVs and I cannot get back to you all - sorry.
Apr 14, 2024
Contractor
BI Developer/T-SQL/SSIS required to work in North London on a Hybrid model. This is a 6 month contract inside/outside IR35 to be confirmed and day rates also TBC, which I will know more on Monday. Key requirement for this role is to prepare the Company's SQL Server based data warehouse (DWH) ETL processes for an imminent large increase in data volumes. This will involve examining the end-to-end DWH ETL process (both SSIS and native T-SQL) and optimising wherever possible. There will also be a requirement to assist with the design, development and support of a number of new ETL/MI/BI requests from the business due to recent business growth. Skills required: To be considered for this role you must have excellent knowledge of T-SQL and SSIS skills. Good understanding of Data Warehouse experience. Experience with migration, plus detailed knowledge of the MS SQL Azure (initially IaaS, then PaaS) platform is also required. Please send in your CV if you have the above skills - if your CV looks good, I will then be in touch. If you do not hear back from me, this will be due to a high volume of CVs and I cannot get back to you all - sorry.
Database Developer Location: London, UK - Hybrid Working Salary Offering: £40K - £50K PA Permanent opportunity My client is a leading Regulatory Body professional services organisation, who are looking for an experienced BI Developer to join their growing Data & Analytics team. In this role, you will be responsible for the design, development, and management of their data warehouse and data lake environments, supporting critical reporting and analytics capabilities. Key responsibilities include: Working closely with the data and BI analysis team to design, develop and maintain reporting and analytical solutions Identifying and resolving data issues, managing the database aspects of the reporting and analytics platforms Collaborating with database administrators to ensure optimal data warehouse performance Developing and refining reporting and analytical requirements with business analysts and project managers Ensuring data warehouse designs align with IT strategies and architectural frameworks The ideal candidate will have: Experience as a Database Developer or BI Developer, with a strong focus on data platform support and analytics Proficiency in query languages like T-SQL, XML, DAX, MDX, PowerShell, and PL/SQL Proven expertise with Microsoft SQL Server Integration Services and BI tools like Power BI, Power Pivot, and SSRS Experience in data warehousing, ETL, data modelling, and data orchestration Excellent stakeholder management and communication skills A degree in Computer Science, IT, or a related STEM subject Morgan Hunt is a multi-award-winning recruitment business for interim, contract and temporary recruitment and acts as an Employment Agency in relation to permanent vacancies. Morgan Hunt is an equal opportunities employer. Job suitability is assessed on merit in accordance with the individual's skills, qualifications and abilities to perform the relevant duties required in a particular role.
Apr 13, 2024
Full time
Database Developer Location: London, UK - Hybrid Working Salary Offering: £40K - £50K PA Permanent opportunity My client is a leading Regulatory Body professional services organisation, who are looking for an experienced BI Developer to join their growing Data & Analytics team. In this role, you will be responsible for the design, development, and management of their data warehouse and data lake environments, supporting critical reporting and analytics capabilities. Key responsibilities include: Working closely with the data and BI analysis team to design, develop and maintain reporting and analytical solutions Identifying and resolving data issues, managing the database aspects of the reporting and analytics platforms Collaborating with database administrators to ensure optimal data warehouse performance Developing and refining reporting and analytical requirements with business analysts and project managers Ensuring data warehouse designs align with IT strategies and architectural frameworks The ideal candidate will have: Experience as a Database Developer or BI Developer, with a strong focus on data platform support and analytics Proficiency in query languages like T-SQL, XML, DAX, MDX, PowerShell, and PL/SQL Proven expertise with Microsoft SQL Server Integration Services and BI tools like Power BI, Power Pivot, and SSRS Experience in data warehousing, ETL, data modelling, and data orchestration Excellent stakeholder management and communication skills A degree in Computer Science, IT, or a related STEM subject Morgan Hunt is a multi-award-winning recruitment business for interim, contract and temporary recruitment and acts as an Employment Agency in relation to permanent vacancies. Morgan Hunt is an equal opportunities employer. Job suitability is assessed on merit in accordance with the individual's skills, qualifications and abilities to perform the relevant duties required in a particular role.
BI Developer Location: London, UK - Hybrid Working Salary offering: £50K - £60K Per Annum Fixed Term Contract: 12 - 18 Months My client is a leading Regulatory Body professional services organisation, who are looking for an experienced BI Developer to join their growing Data & Analytics team. In this role, you will be responsible for developing and enhancing their data warehouse and BI capabilities, delivering critical reporting and analytics to support the business. Key responsibilities include: Integrating new data sources and enabling reporting on the client's data Performing source-to-target mappings and aligning data structures to enterprise data models Designing and implementing data warehouse solutions, including data flows, ETL processes, and data models Developing interactive dashboards and reports using tools like Power BI Ensuring data quality, governance, and security standards are met Collaborating with business analysts and stakeholders to understand requirements The ideal candidate will have: Extensive experience as a BI Developer or equivalent, with a strong focus on data engineering and analytics In-depth knowledge of the Microsoft BI stack, including SSIS, SQL Server, and Power BI Proven skills in data warehousing, ETL, data modelling, and data analysis Hands-on experience with modern BI tools and Azure data technologies Combined deep technical expertise in data engineering and BI development, along with strong business acumen and stakeholder management skills to deliver high-impact data and analytics solutions. Lead the integration of new data sources, enhance the data warehouse, and drive the delivery of critical business intelligence and reporting. Experience in migrating to Dynamics 365 is advantageous Morgan Hunt is a multi-award-winning recruitment business for interim, contract and temporary recruitment and acts as an Employment Agency in relation to permanent vacancies. Morgan Hunt is an equal opportunities employer. Job suitability is assessed on merit in accordance with the individual's skills, qualifications and abilities to perform the relevant duties required in a particular role.
Apr 12, 2024
Full time
BI Developer Location: London, UK - Hybrid Working Salary offering: £50K - £60K Per Annum Fixed Term Contract: 12 - 18 Months My client is a leading Regulatory Body professional services organisation, who are looking for an experienced BI Developer to join their growing Data & Analytics team. In this role, you will be responsible for developing and enhancing their data warehouse and BI capabilities, delivering critical reporting and analytics to support the business. Key responsibilities include: Integrating new data sources and enabling reporting on the client's data Performing source-to-target mappings and aligning data structures to enterprise data models Designing and implementing data warehouse solutions, including data flows, ETL processes, and data models Developing interactive dashboards and reports using tools like Power BI Ensuring data quality, governance, and security standards are met Collaborating with business analysts and stakeholders to understand requirements The ideal candidate will have: Extensive experience as a BI Developer or equivalent, with a strong focus on data engineering and analytics In-depth knowledge of the Microsoft BI stack, including SSIS, SQL Server, and Power BI Proven skills in data warehousing, ETL, data modelling, and data analysis Hands-on experience with modern BI tools and Azure data technologies Combined deep technical expertise in data engineering and BI development, along with strong business acumen and stakeholder management skills to deliver high-impact data and analytics solutions. Lead the integration of new data sources, enhance the data warehouse, and drive the delivery of critical business intelligence and reporting. Experience in migrating to Dynamics 365 is advantageous Morgan Hunt is a multi-award-winning recruitment business for interim, contract and temporary recruitment and acts as an Employment Agency in relation to permanent vacancies. Morgan Hunt is an equal opportunities employer. Job suitability is assessed on merit in accordance with the individual's skills, qualifications and abilities to perform the relevant duties required in a particular role.
SQL Developer - PowerBI, ETL, T-SQL, SSIS, SSRS, Data Warehouse - £70K per annum My client, a leader in their field are on the lookout for a SQL Developer to join their expanding team. This organisation are looking for a talented developer with a strong T-SQL programming background to join a greenfield project. The successful individual will have excellent data analysis capabilities and a solid foundation in Scripting and ETL processes. Responsibilities: Develop data analysis automation in SQL Server Collaborate with senior members throughout business whilst acting as project lead Support data requests and Tableau-based analytics solutions Data warehouse activities including ETL, troubleshooting, bug fixing and enhancements Requirements: Solid experience in a Microsoft SQL Server environment (SSIS, SSRS, SSMS) PowerBI reporting Excellent T-SQL Scripting ability Knowledge of data warehousing ETL best practice Data visualisation in PowerBI or similar technology An understanding of APIs will be a significant advantage SQL Developer - PowerBI, ETL, T-SQL, SSIS, SSRS, Data Warehouse - £70k per annum
Sep 22, 2022
Full time
SQL Developer - PowerBI, ETL, T-SQL, SSIS, SSRS, Data Warehouse - £70K per annum My client, a leader in their field are on the lookout for a SQL Developer to join their expanding team. This organisation are looking for a talented developer with a strong T-SQL programming background to join a greenfield project. The successful individual will have excellent data analysis capabilities and a solid foundation in Scripting and ETL processes. Responsibilities: Develop data analysis automation in SQL Server Collaborate with senior members throughout business whilst acting as project lead Support data requests and Tableau-based analytics solutions Data warehouse activities including ETL, troubleshooting, bug fixing and enhancements Requirements: Solid experience in a Microsoft SQL Server environment (SSIS, SSRS, SSMS) PowerBI reporting Excellent T-SQL Scripting ability Knowledge of data warehousing ETL best practice Data visualisation in PowerBI or similar technology An understanding of APIs will be a significant advantage SQL Developer - PowerBI, ETL, T-SQL, SSIS, SSRS, Data Warehouse - £70k per annum
My consumer electronics distributor is seeking a skilled developer with strong data warehouse and ETL processing, Microsoft SQL and Azure Data Platform experience and data development environment with Microsoft SQL and Azure Data Platform including Power BI service and Machine learning knowledge. The position is fully remote and is Outside IR35 for all UK-based candidates, offering a 6-month contract. All EU candidates are welcome. Able to transform conceptual designs into reliable and scalable processes by design, development, and maintenance of Cloud Database services. Able to transform conceptual design and implement end to end builds into the Azure SQL Database. Collaborate with team to identify and document analytic needs and requirements and works with team to design, develop, test, implement and support DW build outs. Will collaborate with team members to ensure functional and technical solutions and look for innovative and next generation solutions for solving data challenges. Will play an active role in quality assurance for data and solution initiatives by attending team meetings and providing necessary expertise for BI team. Technical Skills: Strong and SQL Server management system, Azure Data Platform and Power BI experience Strong understanding of relational and dimensional modelling, with experience using various tooling (Azure, On-Premises, Power BI) Should have experience in cloud migration and integration Ability to manage deployments and take on technical leadership responsibilities of database projects Create data transformations and build simple to complex data pipelines & data flows Strong experience in Azure ecosystem such as ETL Jobs, Azure Data Factory (ADF), Azure Synapse Analytics, Azure Data Pipeline, Data Flows & Data Bricks, Azure SQL Database Knowledge of other Azure Services like Azure Functions, Logical Apps, APIs or ETL Technologies Strong experience in SQL writing, T-SQL tuning/optimization, and analytics Microsoft Power BI is associated with reports, datasets, dashboards, KPI, visualizations, apps, workspaces and security Could provide advice on Power BI architecture for size, speed and functionality of reports Experience in connecting to data sources, importing data and transforming data Perform data manipulation and cleansing to prepare datasets for visualization Proficient with developing Power BI dataset and structures, based on data from SQL Server and other data sources, Data Lake, API calls Proficient with DAX code including aggregations, calculations, classifications, and hierarchies Recommend additional options for reporting and analytics and continuously improve performance Design effective layouts using Data Visualizations best practices Deploy Power BI scripts, perform detailed analytics and facilitate the needs analysis through implementation Experience with automation using a Scripting language (Python, Perl) Functions as a primary contributor in designing, coding, testing, debugging, documenting and supporting established specifications and business requirements to deliver business value Ability to perform and lead code reviews and re-enforce standards and consistency Performs problem resolutions and root cause analysis along with recommending and implementing preventive techniques If you're interested, please forward your CV to (see below) All recommendations are welcome. Lawrence Harvey is acting as an Employment Business in regards to this position.
Nov 06, 2021
Contractor
My consumer electronics distributor is seeking a skilled developer with strong data warehouse and ETL processing, Microsoft SQL and Azure Data Platform experience and data development environment with Microsoft SQL and Azure Data Platform including Power BI service and Machine learning knowledge. The position is fully remote and is Outside IR35 for all UK-based candidates, offering a 6-month contract. All EU candidates are welcome. Able to transform conceptual designs into reliable and scalable processes by design, development, and maintenance of Cloud Database services. Able to transform conceptual design and implement end to end builds into the Azure SQL Database. Collaborate with team to identify and document analytic needs and requirements and works with team to design, develop, test, implement and support DW build outs. Will collaborate with team members to ensure functional and technical solutions and look for innovative and next generation solutions for solving data challenges. Will play an active role in quality assurance for data and solution initiatives by attending team meetings and providing necessary expertise for BI team. Technical Skills: Strong and SQL Server management system, Azure Data Platform and Power BI experience Strong understanding of relational and dimensional modelling, with experience using various tooling (Azure, On-Premises, Power BI) Should have experience in cloud migration and integration Ability to manage deployments and take on technical leadership responsibilities of database projects Create data transformations and build simple to complex data pipelines & data flows Strong experience in Azure ecosystem such as ETL Jobs, Azure Data Factory (ADF), Azure Synapse Analytics, Azure Data Pipeline, Data Flows & Data Bricks, Azure SQL Database Knowledge of other Azure Services like Azure Functions, Logical Apps, APIs or ETL Technologies Strong experience in SQL writing, T-SQL tuning/optimization, and analytics Microsoft Power BI is associated with reports, datasets, dashboards, KPI, visualizations, apps, workspaces and security Could provide advice on Power BI architecture for size, speed and functionality of reports Experience in connecting to data sources, importing data and transforming data Perform data manipulation and cleansing to prepare datasets for visualization Proficient with developing Power BI dataset and structures, based on data from SQL Server and other data sources, Data Lake, API calls Proficient with DAX code including aggregations, calculations, classifications, and hierarchies Recommend additional options for reporting and analytics and continuously improve performance Design effective layouts using Data Visualizations best practices Deploy Power BI scripts, perform detailed analytics and facilitate the needs analysis through implementation Experience with automation using a Scripting language (Python, Perl) Functions as a primary contributor in designing, coding, testing, debugging, documenting and supporting established specifications and business requirements to deliver business value Ability to perform and lead code reviews and re-enforce standards and consistency Performs problem resolutions and root cause analysis along with recommending and implementing preventive techniques If you're interested, please forward your CV to (see below) All recommendations are welcome. Lawrence Harvey is acting as an Employment Business in regards to this position.
Business Intelligence (BI) Developer - Qliksense; Qlikview, Dashboards, Reports, Data analysis, Netezza Datamarts, Oracle, SQL Server. Stakeholder Engagement. c.65k +Excellent Benefits. City of London/Hybrid (3 days per week). BI Developer (Qliksense, Qlikview, Netezza Datamarts) required to work with a multi-national Insurance Corporation focussing on the production of Management Information and Business Intelligence output from enterprise level finance underwriting and claims systems. Ultimately this requires an experienced BI Developer to use a range of skills in Qliksense, Qlikview, Netezza, Oracle, SQL Server to manage data within multiple repositories with a view to improving BI output. To achieve this you will identify and discuss Business Intelligence (BI) and management reporting requirements with senior business users of all disciplines, analyse those requirements before delivering through enhancements to Qlik using a range of techniques applicable to your background and the environment. The position will focus on movement of data as well as the development of Data Analytics related BI Reports and Dashboards (Qliksense/Qlikview); it is a role within the Management Information (MI) team which is responsible for the production and delivery of reporting, business intelligence, and data solutions for overseas markets. The strategic product offered by the MIS department is a data warehouse fronted by fully functional Business Intelligence tools (ranging from Qliksense incorporating Qilkview with some Cognos Legacy systems in production) offering informational support for managing all aspects of business activities. A major part of the BI Developer role will be to engage stakeholders to gather requirements for enhancements to the enterprise systems being enhanced at any given point and document business reporting requirements. Ideally, you will be well versed in implementing project/data controls and overseeing reconciliation based on finance data MI output. We are searching for a BI Developer/MI Developer/ETL Developer who possesses experience gained within Management Information Systems and/or Business Intelligence project delivery fields. The successful candidate will be able to confidently communicate with business users to elicit and translate requirements prior to creating reports and dashboards in Qliksense/Qlikview. You will have experience of working with data warehouses and ideally be able to build robust systems employing UX/UI design principles and working closely with these teams. In addition to your Qlikview/Qliksense experience you will be proficient in ETL techniques with tools such as Netezza, Informatica and SSIS (or other similar tools) along with solid SQL experience. Excellent communication skills are pre-requisite. Excellent opportunity to work within a stable, multi-national environment within a key role enabling the enhancement of enterprise level systems on a global basis. Located in the City of London with excellent benefits and career progression prospects. Please note that this is an initial 12 month FTC contract complete with a full range of benefits but with the opportunity to permanent in due course. Hybrid working with 3 days per week required in the City of London.
Nov 05, 2021
Business Intelligence (BI) Developer - Qliksense; Qlikview, Dashboards, Reports, Data analysis, Netezza Datamarts, Oracle, SQL Server. Stakeholder Engagement. c.65k +Excellent Benefits. City of London/Hybrid (3 days per week). BI Developer (Qliksense, Qlikview, Netezza Datamarts) required to work with a multi-national Insurance Corporation focussing on the production of Management Information and Business Intelligence output from enterprise level finance underwriting and claims systems. Ultimately this requires an experienced BI Developer to use a range of skills in Qliksense, Qlikview, Netezza, Oracle, SQL Server to manage data within multiple repositories with a view to improving BI output. To achieve this you will identify and discuss Business Intelligence (BI) and management reporting requirements with senior business users of all disciplines, analyse those requirements before delivering through enhancements to Qlik using a range of techniques applicable to your background and the environment. The position will focus on movement of data as well as the development of Data Analytics related BI Reports and Dashboards (Qliksense/Qlikview); it is a role within the Management Information (MI) team which is responsible for the production and delivery of reporting, business intelligence, and data solutions for overseas markets. The strategic product offered by the MIS department is a data warehouse fronted by fully functional Business Intelligence tools (ranging from Qliksense incorporating Qilkview with some Cognos Legacy systems in production) offering informational support for managing all aspects of business activities. A major part of the BI Developer role will be to engage stakeholders to gather requirements for enhancements to the enterprise systems being enhanced at any given point and document business reporting requirements. Ideally, you will be well versed in implementing project/data controls and overseeing reconciliation based on finance data MI output. We are searching for a BI Developer/MI Developer/ETL Developer who possesses experience gained within Management Information Systems and/or Business Intelligence project delivery fields. The successful candidate will be able to confidently communicate with business users to elicit and translate requirements prior to creating reports and dashboards in Qliksense/Qlikview. You will have experience of working with data warehouses and ideally be able to build robust systems employing UX/UI design principles and working closely with these teams. In addition to your Qlikview/Qliksense experience you will be proficient in ETL techniques with tools such as Netezza, Informatica and SSIS (or other similar tools) along with solid SQL experience. Excellent communication skills are pre-requisite. Excellent opportunity to work within a stable, multi-national environment within a key role enabling the enhancement of enterprise level systems on a global basis. Located in the City of London with excellent benefits and career progression prospects. Please note that this is an initial 12 month FTC contract complete with a full range of benefits but with the opportunity to permanent in due course. Hybrid working with 3 days per week required in the City of London.
Nigel Frank International
Newcastle Upon Tyne, Tyne And Wear
Data Warehouse Developer - Newcastle Are you talented Data Warehouse Developer looking for a new exciting opportunity to join global, results-driven team of passionate IT professionals? You will have an opportunity to work in an innovative and growing company with more than 20 offices around the world. The Role ETL and Data Warehouse development an maintenance on SQL Server Bringing in data from various sources to enable reporting for stakeholders Set up report and notification system, which measures and monitors business KPIs Scope, plan and manage business projects Identify and implement improvements to data systems Technical Skill-Set SSIS SSRS SSA ETL Data Warehouse QlikSense/QlikView Salesforce Culture Flexible Technology- driven Diverse team Passionate People orientated Fast-paced Benefits Package Base salary - £40,000 to £45,000 p/a Bonus (5-10%) Pension - standard Holidays - 25 day's holiday + Bank Holidays + Christmas shutdown Incentives and Nights Out Plus much more Other Flexible working hours 3 days in the Newcastle office This is the brief description of the role, for the full information, simply apply to the role and I will call you to discuss. This is an exclusive client to Nigel Frank International. My client is looking to begin the interview process ASAP, so don't miss out, APPLY now! If this wasn't exactly the role you were looking for, please apply to this role anyway, just highlight what you are looking for, apply with your CV with a brief overview of what you are looking for (The role, top 3 techs, location, salary). I will call you to discuss your skill-set further, there may be other roles I am working on that you may be suited for. I specialise in Microsoft BI, SQL Server and Azure Analytics recruitment here at Nigel Frank International, specialising in the placement of highly-skilled candidates in various IT positions (Engineers, Analysts, Architects, Consultants, Project Managers, Management etc.). 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. Twitter: LinkedIn: https://in/gabi-witas-a/ Email: Phone: Please Note: This is a permanent role. This role is for UK residents only. This role does not offer Sponsorship. You must have the right to work in the UK with no restrictions. Some of our roles may be subject to successful background checks including a DBS and Credit Check.
Oct 07, 2021
Full time
Data Warehouse Developer - Newcastle Are you talented Data Warehouse Developer looking for a new exciting opportunity to join global, results-driven team of passionate IT professionals? You will have an opportunity to work in an innovative and growing company with more than 20 offices around the world. The Role ETL and Data Warehouse development an maintenance on SQL Server Bringing in data from various sources to enable reporting for stakeholders Set up report and notification system, which measures and monitors business KPIs Scope, plan and manage business projects Identify and implement improvements to data systems Technical Skill-Set SSIS SSRS SSA ETL Data Warehouse QlikSense/QlikView Salesforce Culture Flexible Technology- driven Diverse team Passionate People orientated Fast-paced Benefits Package Base salary - £40,000 to £45,000 p/a Bonus (5-10%) Pension - standard Holidays - 25 day's holiday + Bank Holidays + Christmas shutdown Incentives and Nights Out Plus much more Other Flexible working hours 3 days in the Newcastle office This is the brief description of the role, for the full information, simply apply to the role and I will call you to discuss. This is an exclusive client to Nigel Frank International. My client is looking to begin the interview process ASAP, so don't miss out, APPLY now! If this wasn't exactly the role you were looking for, please apply to this role anyway, just highlight what you are looking for, apply with your CV with a brief overview of what you are looking for (The role, top 3 techs, location, salary). I will call you to discuss your skill-set further, there may be other roles I am working on that you may be suited for. I specialise in Microsoft BI, SQL Server and Azure Analytics recruitment here at Nigel Frank International, specialising in the placement of highly-skilled candidates in various IT positions (Engineers, Analysts, Architects, Consultants, Project Managers, Management etc.). 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. Twitter: LinkedIn: https://in/gabi-witas-a/ Email: Phone: Please Note: This is a permanent role. This role is for UK residents only. This role does not offer Sponsorship. You must have the right to work in the UK with no restrictions. Some of our roles may be subject to successful background checks including a DBS and Credit Check.
Nigel Frank International
Newcastle Upon Tyne, Tyne And Wear
BI Developer - Newcastle Are you talented BI Developer looking for a new exciting opportunity to join global, results-driven team of passionate IT professionals? You will have an opportunity to work in an innovative and growing company with more than 20 offices around the world. The Role ETL and Data Warehouse development an maintenance on SQL Server Bringing in data from various sources to enable reporting for stakeholders Set up report and notification system, which measures and monitors business KPIs Scope, plan and manage business projects Identify and implement improvements to data systems Technical Skill-Set SSIS SSRS SSA ETL Data Warehouse QlikSense/QlikView Salesforce Culture Flexible Technology- driven Diverse team Passionate People orientated Fast-paced Benefits Package Base salary - £40,000 to £45,000 p/a Bonus (5-10%) Pension - standard Holidays - 25 day's holiday + Bank Holidays + Christmas shutdown Incentives and Nights Out Plus much more Other Flexible working hours 3 days in the Newcastle office This is the brief description of the role, for the full information, simply apply to the role and I will call you to discuss. This is an exclusive client to Nigel Frank International. My client is looking to begin the interview process ASAP, so don't miss out, APPLY now! If this wasn't exactly the role you were looking for, please apply to this role anyway, just highlight what you are looking for, apply with your CV with a brief overview of what you are looking for (The role, top 3 techs, location, salary). I will call you to discuss your skill-set further, there may be other roles I am working on that you may be suited for. I specialise in Microsoft BI, SQL Server and Azure Analytics recruitment here at Nigel Frank International, specialising in the placement of highly-skilled candidates in various IT positions (Engineers, Analysts, Architects, Consultants, Project Managers, Management etc.). 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. Twitter: LinkedIn: https://in/gabi-witas-a/ Email: Phone: Please Note: This is a permanent role. This role is for UK residents only. This role does not offer Sponsorship. You must have the right to work in the UK with no restrictions. Some of our roles may be subject to successful background checks including a DBS and Credit Check.
Oct 07, 2021
Full time
BI Developer - Newcastle Are you talented BI Developer looking for a new exciting opportunity to join global, results-driven team of passionate IT professionals? You will have an opportunity to work in an innovative and growing company with more than 20 offices around the world. The Role ETL and Data Warehouse development an maintenance on SQL Server Bringing in data from various sources to enable reporting for stakeholders Set up report and notification system, which measures and monitors business KPIs Scope, plan and manage business projects Identify and implement improvements to data systems Technical Skill-Set SSIS SSRS SSA ETL Data Warehouse QlikSense/QlikView Salesforce Culture Flexible Technology- driven Diverse team Passionate People orientated Fast-paced Benefits Package Base salary - £40,000 to £45,000 p/a Bonus (5-10%) Pension - standard Holidays - 25 day's holiday + Bank Holidays + Christmas shutdown Incentives and Nights Out Plus much more Other Flexible working hours 3 days in the Newcastle office This is the brief description of the role, for the full information, simply apply to the role and I will call you to discuss. This is an exclusive client to Nigel Frank International. My client is looking to begin the interview process ASAP, so don't miss out, APPLY now! If this wasn't exactly the role you were looking for, please apply to this role anyway, just highlight what you are looking for, apply with your CV with a brief overview of what you are looking for (The role, top 3 techs, location, salary). I will call you to discuss your skill-set further, there may be other roles I am working on that you may be suited for. I specialise in Microsoft BI, SQL Server and Azure Analytics recruitment here at Nigel Frank International, specialising in the placement of highly-skilled candidates in various IT positions (Engineers, Analysts, Architects, Consultants, Project Managers, Management etc.). 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. Twitter: LinkedIn: https://in/gabi-witas-a/ Email: Phone: Please Note: This is a permanent role. This role is for UK residents only. This role does not offer Sponsorship. You must have the right to work in the UK with no restrictions. Some of our roles may be subject to successful background checks including a DBS and Credit Check.
Nigel Frank International
Newcastle Upon Tyne, Tyne And Wear
Data Warehouse Developer - Newcastle Are you talented Data Warehouse Developer looking for a new exciting opportunity to join global, results-driven team of passionate IT professionals? You will have an opportunity to work in an innovative and growing company with more than 20 offices around the world. The Role ETL and Data Warehouse development an maintenance on SQL Server Bringing in data from various sources to enable reporting for stakeholders Set up report and notification system, which measures and monitors business KPIs Scope, plan and manage business projects Identify and implement improvements to data systems Technical Skill-Set SSIS SSRS SSA ETL Data Warehouse QlikSense/QlikView Salesforce Culture Flexible Technology- driven Diverse team Passionate People orientated Fast-paced Benefits Package Base salary - £40,000 to £45,000 p/a Bonus (5-10%) Pension - standard Holidays - 25 day's holiday + Bank Holidays + Christmas shutdown Incentives and Nights Out Plus much more Other Flexible working hours 3 days in the Newcastle office This is the brief description of the role, for the full information, simply apply to the role and I will call you to discuss. This is an exclusive client to Nigel Frank International. My client is looking to begin the interview process ASAP, so don't miss out, APPLY now! If this wasn't exactly the role you were looking for, please apply to this role anyway, just highlight what you are looking for, apply with your CV with a brief overview of what you are looking for (The role, top 3 techs, location, salary). I will call you to discuss your skill-set further, there may be other roles I am working on that you may be suited for. I specialise in Microsoft BI, SQL Server and Azure Analytics recruitment here at Nigel Frank International, specialising in the placement of highly-skilled candidates in various IT positions (Engineers, Analysts, Architects, Consultants, Project Managers, Management etc.). 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. Twitter: LinkedIn: https://in/gabi-witas-a/ Email: Phone: Please Note: This is a permanent role. This role is for UK residents only. This role does not offer Sponsorship. You must have the right to work in the UK with no restrictions. Some of our roles may be subject to successful background checks including a DBS and Credit Check.
Oct 07, 2021
Full time
Data Warehouse Developer - Newcastle Are you talented Data Warehouse Developer looking for a new exciting opportunity to join global, results-driven team of passionate IT professionals? You will have an opportunity to work in an innovative and growing company with more than 20 offices around the world. The Role ETL and Data Warehouse development an maintenance on SQL Server Bringing in data from various sources to enable reporting for stakeholders Set up report and notification system, which measures and monitors business KPIs Scope, plan and manage business projects Identify and implement improvements to data systems Technical Skill-Set SSIS SSRS SSA ETL Data Warehouse QlikSense/QlikView Salesforce Culture Flexible Technology- driven Diverse team Passionate People orientated Fast-paced Benefits Package Base salary - £40,000 to £45,000 p/a Bonus (5-10%) Pension - standard Holidays - 25 day's holiday + Bank Holidays + Christmas shutdown Incentives and Nights Out Plus much more Other Flexible working hours 3 days in the Newcastle office This is the brief description of the role, for the full information, simply apply to the role and I will call you to discuss. This is an exclusive client to Nigel Frank International. My client is looking to begin the interview process ASAP, so don't miss out, APPLY now! If this wasn't exactly the role you were looking for, please apply to this role anyway, just highlight what you are looking for, apply with your CV with a brief overview of what you are looking for (The role, top 3 techs, location, salary). I will call you to discuss your skill-set further, there may be other roles I am working on that you may be suited for. I specialise in Microsoft BI, SQL Server and Azure Analytics recruitment here at Nigel Frank International, specialising in the placement of highly-skilled candidates in various IT positions (Engineers, Analysts, Architects, Consultants, Project Managers, Management etc.). 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. Twitter: LinkedIn: https://in/gabi-witas-a/ Email: Phone: Please Note: This is a permanent role. This role is for UK residents only. This role does not offer Sponsorship. You must have the right to work in the UK with no restrictions. Some of our roles may be subject to successful background checks including a DBS and Credit Check.
BI Analyst - Alteryx City of London/Remote £65,000 - £70,000 per annum + Annual discretionary bonus On behalf of a Leading financial services organisation, I am seeking an experienced BI Analyst to Design, develop, implement, and maintain ETL pipelines/workflows, MI dashboards and data models to be used as part of solutions to internal and external customers. There is a bias in this role to support the regulatory activities of the organisation, yet the role does support solutions to all functions of the business. The organisation operate a hybrid working model, therefore you are expected to be based out of their City office for three days per week. Responsibilities: Analysing complex data from multiple sources using APIs, SQL queries etc., you'll be responsible for collating data from multiple business lines and technology stacks and combining into views that satisfy the MI objective(s). Understand the varying levels of client/audience, identify key reporting needs and pain points; then lead efforts from concept to final deliverable. Analyse system data to identify data quality issues and propose ways to cleanse, normalize, or prevent bad data from entering source systems and/or data warehouse. Work on diverse data projects across the business, including data visualisation, ETL development, business controls and regulatory reporting. Responsible for the development, implementation, production support, and tuning of the Business Intelligence reporting environments. Support the administration and optimisation of the Alteryx Servers and end users of the gallery as well as sharing best practice with in-house Alteryx developers Ensure that you are fully aware of and adhere to internal policies that relate to you, your role or any other activities for which you have any level of responsibility. Report any breaches of policy to Compliance and/or your supervisor as described in the policy. Escalate risk events immediately and log them within 24 hours using the risk event capture form on the Intranet. Provide input if requested to the Risk and Control Self-Assessment process, scenario analysis, Deep Dive' reviews and any other risk management processes, as required. Skills/Experience required: Subject matter expert and previous experience in areas related to Business Intelligence and Data Analytics SQL experience desired Experience in Alteryx or similar ETL tool (eg Talend, Informatica). Extremely passionate about data and analytics Understanding of database and Datamodelling concepts Significant experience in MI and Information Management in Financial Services Experience in developing dashboards and reports for top level management Strong MS Excel skills Visualisation software - preferably Qlik Knowledge of at least one modern Scripting language (Python, R, etc.) is an advantage.
Sep 10, 2021
Full time
BI Analyst - Alteryx City of London/Remote £65,000 - £70,000 per annum + Annual discretionary bonus On behalf of a Leading financial services organisation, I am seeking an experienced BI Analyst to Design, develop, implement, and maintain ETL pipelines/workflows, MI dashboards and data models to be used as part of solutions to internal and external customers. There is a bias in this role to support the regulatory activities of the organisation, yet the role does support solutions to all functions of the business. The organisation operate a hybrid working model, therefore you are expected to be based out of their City office for three days per week. Responsibilities: Analysing complex data from multiple sources using APIs, SQL queries etc., you'll be responsible for collating data from multiple business lines and technology stacks and combining into views that satisfy the MI objective(s). Understand the varying levels of client/audience, identify key reporting needs and pain points; then lead efforts from concept to final deliverable. Analyse system data to identify data quality issues and propose ways to cleanse, normalize, or prevent bad data from entering source systems and/or data warehouse. Work on diverse data projects across the business, including data visualisation, ETL development, business controls and regulatory reporting. Responsible for the development, implementation, production support, and tuning of the Business Intelligence reporting environments. Support the administration and optimisation of the Alteryx Servers and end users of the gallery as well as sharing best practice with in-house Alteryx developers Ensure that you are fully aware of and adhere to internal policies that relate to you, your role or any other activities for which you have any level of responsibility. Report any breaches of policy to Compliance and/or your supervisor as described in the policy. Escalate risk events immediately and log them within 24 hours using the risk event capture form on the Intranet. Provide input if requested to the Risk and Control Self-Assessment process, scenario analysis, Deep Dive' reviews and any other risk management processes, as required. Skills/Experience required: Subject matter expert and previous experience in areas related to Business Intelligence and Data Analytics SQL experience desired Experience in Alteryx or similar ETL tool (eg Talend, Informatica). Extremely passionate about data and analytics Understanding of database and Datamodelling concepts Significant experience in MI and Information Management in Financial Services Experience in developing dashboards and reports for top level management Strong MS Excel skills Visualisation software - preferably Qlik Knowledge of at least one modern Scripting language (Python, R, etc.) is an advantage.
Data Warehouse Developer | London | Flexible | Music | Record Label | SQL Server | SSIS | Tableau | Snowflake | Mulesoft | ETL | £45,000 - £55,000 Are you on the lookout for a new opportunity to work within one of the most exciting and creative industries out there? Do you want the opportunity to work with one of the music industry's leading distribution companies who have access to masses of data from some of the most successful artists over the past 20 years? Method Resourcing are currently working exclusively with one of the most well established music distribution companies within today's music industry. This family of independent record labels are home to some of the most commercially successful artists from the last 20 years and are using their data to help shape the future careers of today's up and coming talent. This organisation of music lovers are built on data and they're looking for somebody to come in and help develop their existing data warehouse. You'll be working on pulling data from the SQL Server database using ETL tools such as SSIS and Mulesoft in order to research trends within the market for both artists and listeners. You'll also be working on undertaking programming tasks of analysis and implementing reporting solutions on large data sets in SQL server. Some of your key responsibilities will be: Maintaining the SQL Server database Pulling data using ETL tools such as SSIS and Mulesoft SQL Server scripting with T-SQL Working with large datasets within a data warehouse environment Creating reports and dashboards within Tableau You'll also gain some exposure to technologies such as Snowflake, Mulesoft, Python and Matillion as a cloud migration project is currently ongoing so there will be plenty of opportunities to work with some of the industry's most cutting-edge technologies and databases. This is a flexible position based in London with a starting salary of around £45,000 - £55,000 along with a compatible benefits package. If you're interested in applying please get in contact with myself (Rich) at Method Resourcing. Data Warehouse Developer | London | Flexible | Music | Record Label | SQL Server | SSIS | Tableau | Snowflake | Mulesoft | ETL | £45,000 - £55,000
Sep 10, 2021
Full time
Data Warehouse Developer | London | Flexible | Music | Record Label | SQL Server | SSIS | Tableau | Snowflake | Mulesoft | ETL | £45,000 - £55,000 Are you on the lookout for a new opportunity to work within one of the most exciting and creative industries out there? Do you want the opportunity to work with one of the music industry's leading distribution companies who have access to masses of data from some of the most successful artists over the past 20 years? Method Resourcing are currently working exclusively with one of the most well established music distribution companies within today's music industry. This family of independent record labels are home to some of the most commercially successful artists from the last 20 years and are using their data to help shape the future careers of today's up and coming talent. This organisation of music lovers are built on data and they're looking for somebody to come in and help develop their existing data warehouse. You'll be working on pulling data from the SQL Server database using ETL tools such as SSIS and Mulesoft in order to research trends within the market for both artists and listeners. You'll also be working on undertaking programming tasks of analysis and implementing reporting solutions on large data sets in SQL server. Some of your key responsibilities will be: Maintaining the SQL Server database Pulling data using ETL tools such as SSIS and Mulesoft SQL Server scripting with T-SQL Working with large datasets within a data warehouse environment Creating reports and dashboards within Tableau You'll also gain some exposure to technologies such as Snowflake, Mulesoft, Python and Matillion as a cloud migration project is currently ongoing so there will be plenty of opportunities to work with some of the industry's most cutting-edge technologies and databases. This is a flexible position based in London with a starting salary of around £45,000 - £55,000 along with a compatible benefits package. If you're interested in applying please get in contact with myself (Rich) at Method Resourcing. Data Warehouse Developer | London | Flexible | Music | Record Label | SQL Server | SSIS | Tableau | Snowflake | Mulesoft | ETL | £45,000 - £55,000
Data Engineer £45,000 - £55,000 ETL | GCP | AWS | Azure | SQL An accelerating digital company who've become the #1 in UK and Europe are embarking on a transformation to become the global #1. You'll be an ideal fit if you've been a BI Developer or Data Engineer working with data pipelines / ETL processes and want to progress your career either into cloud technologies. Essential SSIS SSAS Cloud experience For You Bonus up to 20% Remote working Flexible hours Free parking Great benefits This vacancy will be closing application on August 20th 2021. If you have any questions or fancy a chat about the opportunity feel free to give George Bone a call on or apply for the advert and George will be in contact. Business Intelligence | BI | Developer | Data Warehouse | Data | Engineer | Google Platform | GCP | Big Query | Airflow | Apache | Composer | ETL | SQL Server | SSIS | SSRS | SSAS | £45,000 - £55,000
Sep 10, 2021
Full time
Data Engineer £45,000 - £55,000 ETL | GCP | AWS | Azure | SQL An accelerating digital company who've become the #1 in UK and Europe are embarking on a transformation to become the global #1. You'll be an ideal fit if you've been a BI Developer or Data Engineer working with data pipelines / ETL processes and want to progress your career either into cloud technologies. Essential SSIS SSAS Cloud experience For You Bonus up to 20% Remote working Flexible hours Free parking Great benefits This vacancy will be closing application on August 20th 2021. If you have any questions or fancy a chat about the opportunity feel free to give George Bone a call on or apply for the advert and George will be in contact. Business Intelligence | BI | Developer | Data Warehouse | Data | Engineer | Google Platform | GCP | Big Query | Airflow | Apache | Composer | ETL | SQL Server | SSIS | SSRS | SSAS | £45,000 - £55,000
SQL Developer Permanent Location- London (Office based) Salary- Up to £40,000 You will be working for a data driven sports marketing agency. With the goal of helping world renowned sports teams and organisations( PSG, Liverpool FC, UEFA and NFL) to improve customer experience, increase revenue and growth directly through the club and its fans online. This role will be part of the DataOps & Engineering Team. Your main duties & responsibilities: Create and maintain in-house data warehouses and associated ETL processes using the Microsoft stack (SSIS & SQL DB) SQL development tasks related to the maintenance and investigation into data, including querying, building stored procedures, tables and views Working closing with the client team and clients to deliver technical solutions Protecting the data entrusted to us by our clients at all times Internal mentoring and helping define learning pathways within the team Technology- End to end Data Warehousing(SSIS & SQL DB) SQL server including T-SQL Excel Delimited files XML JSON Databases APIs Or reach me via Email with you CV Attached-
Sep 09, 2021
Full time
SQL Developer Permanent Location- London (Office based) Salary- Up to £40,000 You will be working for a data driven sports marketing agency. With the goal of helping world renowned sports teams and organisations( PSG, Liverpool FC, UEFA and NFL) to improve customer experience, increase revenue and growth directly through the club and its fans online. This role will be part of the DataOps & Engineering Team. Your main duties & responsibilities: Create and maintain in-house data warehouses and associated ETL processes using the Microsoft stack (SSIS & SQL DB) SQL development tasks related to the maintenance and investigation into data, including querying, building stored procedures, tables and views Working closing with the client team and clients to deliver technical solutions Protecting the data entrusted to us by our clients at all times Internal mentoring and helping define learning pathways within the team Technology- End to end Data Warehousing(SSIS & SQL DB) SQL server including T-SQL Excel Delimited files XML JSON Databases APIs Or reach me via Email with you CV Attached-
Business Intelligence Developer £40,000 - £45,000 ETL | GCP | AWS | Azure | SQL An accelerating digital company who've become the #1 in UK and Europe are embarking on a transformation to become the global #1. You'll be an ideal fit if you've been a BI Developer or Data Engineer working with data pipelines / ETL processes and want to progress your career either into cloud technologies. Essential SSIS SSAS Desirable Python Cloud experience For You Bonus up to 20% Remote working Flexible hours Free parking Great benefits This vacancy will be closing application on August 20th 2021. If you have any questions or fancy a chat about the opportunity feel free to give George Bone a call on or apply for the advert and George will be in contact. Business Intelligence | BI | Developer | Data Warehouse | Data | Engineer | Google Platform | GCP | Big Query | Airflow | Apache | Composer | ETL | SQL Server | SSIS | SSRS | SSAS | £40,000 - £45,000
Sep 09, 2021
Full time
Business Intelligence Developer £40,000 - £45,000 ETL | GCP | AWS | Azure | SQL An accelerating digital company who've become the #1 in UK and Europe are embarking on a transformation to become the global #1. You'll be an ideal fit if you've been a BI Developer or Data Engineer working with data pipelines / ETL processes and want to progress your career either into cloud technologies. Essential SSIS SSAS Desirable Python Cloud experience For You Bonus up to 20% Remote working Flexible hours Free parking Great benefits This vacancy will be closing application on August 20th 2021. If you have any questions or fancy a chat about the opportunity feel free to give George Bone a call on or apply for the advert and George will be in contact. Business Intelligence | BI | Developer | Data Warehouse | Data | Engineer | Google Platform | GCP | Big Query | Airflow | Apache | Composer | ETL | SQL Server | SSIS | SSRS | SSAS | £40,000 - £45,000
An overview of the role We have seen a strong growth in our Microsoft team within the Insights and Data Global Practice where we are seeking candidates with strong BI and Data management technologies, particularly within Microsoft and Tableau. As a Microsoft Azure & Power Platform Consultant, you may be asked to help define a client's data visualisation transformation roadmap, other times you may be rolling your sleeves up and creating an innovative BI solution for a complex business problem or even assisting in responding to client bid responses. You will get the opportunity to demonstrate a broad range of skills across the Microsoft Azure stack, including building and delivering OLTP and data warehouse workloads across traditional on-premises and cloud platforms. Using your knowledge of the Microsoft data platform, Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) paradigms, you will deliver exciting and ground breaking solutions to end-clients. You will have the opportunity to: Build and deliver MSBI solutions across on-premises and cloud platforms Build relationships with client stakeholders to establish a high-level of MSBI expertise Work with clients, local teams and offshore resources to deliver modern BI products Work effectively on client sites, Capgemini offices and from home Assisting in Proof of Concepts Internally, you will help identify improved ways of working, contribute to the I&D practice and mentor juniors and be part of a knowledge management initiative. Why you? Broad range of development skills across the Microsoft stack e.g. SQL Server, Integration Services (SSIS), Analysis Services, Reporting Services (SSRS) from versions 2005 to 2016. Some experience with the Azure stack and Microsoft PaaS offerings - Azure SQL Database and Azure SQL Data Warehouse plus orchestration products like Azure Data Factory and Enterprise Service Bus Familiarity with other cloud providers e.g. Amazon, Google Visualisation and data exploration tools such as Power BI, Tableau, Qlik, r, Python etc. Familiarity with modern developer methods and techniques eg Agile, DevOps, continuous integration, automated testing Why us? While we're a global consultancy, we're made up of supportive, close-knit communities. Everyone wants to get the best solutions for our customers and create the best working environment. We have a world class software engineering community; we invest in doing things right and have plenty to say on the subject. We're active on social media and for those that want to find out more, take a look at our blogs - written by engineers, for engineers: Upskilling Potential is just as important to us as having the required skills. If you have the right mindset, we might be able to provide you with bespoke training. So, if you're not sure you have all the skills you need, but you're still passionate about the role, please apply and we'll see if we can support you.
Mar 23, 2021
Full time
An overview of the role We have seen a strong growth in our Microsoft team within the Insights and Data Global Practice where we are seeking candidates with strong BI and Data management technologies, particularly within Microsoft and Tableau. As a Microsoft Azure & Power Platform Consultant, you may be asked to help define a client's data visualisation transformation roadmap, other times you may be rolling your sleeves up and creating an innovative BI solution for a complex business problem or even assisting in responding to client bid responses. You will get the opportunity to demonstrate a broad range of skills across the Microsoft Azure stack, including building and delivering OLTP and data warehouse workloads across traditional on-premises and cloud platforms. Using your knowledge of the Microsoft data platform, Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) paradigms, you will deliver exciting and ground breaking solutions to end-clients. You will have the opportunity to: Build and deliver MSBI solutions across on-premises and cloud platforms Build relationships with client stakeholders to establish a high-level of MSBI expertise Work with clients, local teams and offshore resources to deliver modern BI products Work effectively on client sites, Capgemini offices and from home Assisting in Proof of Concepts Internally, you will help identify improved ways of working, contribute to the I&D practice and mentor juniors and be part of a knowledge management initiative. Why you? Broad range of development skills across the Microsoft stack e.g. SQL Server, Integration Services (SSIS), Analysis Services, Reporting Services (SSRS) from versions 2005 to 2016. Some experience with the Azure stack and Microsoft PaaS offerings - Azure SQL Database and Azure SQL Data Warehouse plus orchestration products like Azure Data Factory and Enterprise Service Bus Familiarity with other cloud providers e.g. Amazon, Google Visualisation and data exploration tools such as Power BI, Tableau, Qlik, r, Python etc. Familiarity with modern developer methods and techniques eg Agile, DevOps, continuous integration, automated testing Why us? While we're a global consultancy, we're made up of supportive, close-knit communities. Everyone wants to get the best solutions for our customers and create the best working environment. We have a world class software engineering community; we invest in doing things right and have plenty to say on the subject. We're active on social media and for those that want to find out more, take a look at our blogs - written by engineers, for engineers: Upskilling Potential is just as important to us as having the required skills. If you have the right mindset, we might be able to provide you with bespoke training. So, if you're not sure you have all the skills you need, but you're still passionate about the role, please apply and we'll see if we can support you.
PowerBi Developer - Bromley - Permanent - £40,000 - £55,000 My client is looking for someone who is a PowerBI focused professional to work within a team leading and delivering client facing reporting solutions as well as looking after the structures they already have in place. If you have a love for PowerBI and experience with high performing dashboards & reports within the PowerBI application as well as strong data modelling skills this might the job for you. Job requirements ·Proficient in writing advanced SQL to pull the data into the models. ·Good visualisation skills to produce high quality reports using a large array of the visuals available within the PowerBI application. ·Maintenance of existing & new reporting solutions. ·Maintain confidence in the data as a single source of truth by ensuring data are up to date, reliable, consistent and coherent. ·Use advanced analytics and statistical techniques to provide excellent analytics. ·Coordinate and prioritise multiple work streams across the business. ·Assist with data architecture. Skills & Experience: ·Minimum of 3 years developing reporting solutions in a busy production environment(s) using the Microsoft Power Platform. ·Experience of PowerBI Performance Tuning & Problem Solving. ·Advanced knowledge with DAX / Data Modelling, Power Query & SQL Server ·Experience with Big Data, Data Warehouse, and Data Lake...... click apply for full job details
Sep 28, 2020
Full time
PowerBi Developer - Bromley - Permanent - £40,000 - £55,000 My client is looking for someone who is a PowerBI focused professional to work within a team leading and delivering client facing reporting solutions as well as looking after the structures they already have in place. If you have a love for PowerBI and experience with high performing dashboards & reports within the PowerBI application as well as strong data modelling skills this might the job for you. Job requirements ·Proficient in writing advanced SQL to pull the data into the models. ·Good visualisation skills to produce high quality reports using a large array of the visuals available within the PowerBI application. ·Maintenance of existing & new reporting solutions. ·Maintain confidence in the data as a single source of truth by ensuring data are up to date, reliable, consistent and coherent. ·Use advanced analytics and statistical techniques to provide excellent analytics. ·Coordinate and prioritise multiple work streams across the business. ·Assist with data architecture. Skills & Experience: ·Minimum of 3 years developing reporting solutions in a busy production environment(s) using the Microsoft Power Platform. ·Experience of PowerBI Performance Tuning & Problem Solving. ·Advanced knowledge with DAX / Data Modelling, Power Query & SQL Server ·Experience with Big Data, Data Warehouse, and Data Lake...... click apply for full job details
Odin has an exciting opportunity for a Full Stack Developer to join the team based in London. You will work on a full time permanent basis and will receive a highly competitive salary.
ODIN is a strategy-focused technology consultancy. We architect and implement award-winning technical solutions that support our clients’ commercial objectives and future vision.
In just over 4 years ODIN has grown from a boutique consultancy to a 20+ strong team, with an impressive roster of clients including some of Europe’s largest media organisations and brands ranging from Which? to Discovery, Hearst to Honda.
With our expanding client roster and ambitions to consolidate our spot as one of Europe’s leading Technology Consultancies, this is a great time to join. We still offer the flexibility, growth and atmosphere of a start-up whilst providing the security and established processes of a larger organisation.
We’re hiring a full stack developer to work on client projects ranging from consumer websites to data warehouses, reporting directly to the Development Manager.
Your day to day job will be mainly coding, attending scrum ceremonies, contributing to architectural discussions and mentoring more junior members of the team.
As a more senior member of the team you will be expected to actively contribute to continual improvement of practices and standards used. For example presenting at Lunch & Learn Fridays.
Qualities needed as our Full Stack Developer:
- Perfect written and spoken English.
- Passion for technology.
- Strong technical background (degree or otherwise proven) is required.
- Be client facing and customer service focused.
- Good problem solving skills.
- Adaptable, agile mindset.
Responsibilities needed as our Full Stack Developer:
- Develop software to meet user needs.
- Follow best practice guidelines and help to improve those guidelines.
- Write clean, secure and well-tested code.
- Plan and lead development on sets of related stories.
- Have an understanding of whole systems and take responsibility for teaching this to others.
- Work with other disciplines to understand what needs to be built.
- Coach and mentor more junior colleagues.
- Consider the operation and support of the production services.
- Find ways to improve system robustness, resilience and stability.
Skills & Experience needed as our Full Stack Developer:
- Server side coding, preferably Javascript, Node.
- AWS services specifically including: Cloudwatch, EC2, RDS, S3.
- Database technologies (MySQL, Oracle, PostgreSQL, DynamoDB).
- HTML, CSS, JavaScript, JQuery.
- Working knowledge of front end frameworks such as React and Angular.
- Good understanding of system/application performance and performance tuning.
- Build tools - Gradle, NPM.
- Git - Command line, Bitbucket, GitHub, GitLab, Stash.
- TDD and BDD.
- Testing tools and techniques - Cucumber, Mocha.
- Web Services - REST, SOAP.
- CI servers (Jenkins, Hudson, Bamboo).
- Developing on Linux/UNIX.
- Continuous Integration and Continuous Deployment principles.
- JIRA and Confluence.
- Software development principles Scrum & KanBan.
Desirable
- Developed SaaS web applications and/or Data Warehousing.
- AWS Certifications.
- Docker, Kubernetes, Ansible.
What we can offer you as our Full Stack Developer:
- A friendly supportive environment.
- Exposure to leading cloud technologies.
- Free online training and exams for relevant certification.
- A dynamic working environment in central London.
Jan 02, 2019
Full time
Odin has an exciting opportunity for a Full Stack Developer to join the team based in London. You will work on a full time permanent basis and will receive a highly competitive salary.
ODIN is a strategy-focused technology consultancy. We architect and implement award-winning technical solutions that support our clients’ commercial objectives and future vision.
In just over 4 years ODIN has grown from a boutique consultancy to a 20+ strong team, with an impressive roster of clients including some of Europe’s largest media organisations and brands ranging from Which? to Discovery, Hearst to Honda.
With our expanding client roster and ambitions to consolidate our spot as one of Europe’s leading Technology Consultancies, this is a great time to join. We still offer the flexibility, growth and atmosphere of a start-up whilst providing the security and established processes of a larger organisation.
We’re hiring a full stack developer to work on client projects ranging from consumer websites to data warehouses, reporting directly to the Development Manager.
Your day to day job will be mainly coding, attending scrum ceremonies, contributing to architectural discussions and mentoring more junior members of the team.
As a more senior member of the team you will be expected to actively contribute to continual improvement of practices and standards used. For example presenting at Lunch & Learn Fridays.
Qualities needed as our Full Stack Developer:
- Perfect written and spoken English.
- Passion for technology.
- Strong technical background (degree or otherwise proven) is required.
- Be client facing and customer service focused.
- Good problem solving skills.
- Adaptable, agile mindset.
Responsibilities needed as our Full Stack Developer:
- Develop software to meet user needs.
- Follow best practice guidelines and help to improve those guidelines.
- Write clean, secure and well-tested code.
- Plan and lead development on sets of related stories.
- Have an understanding of whole systems and take responsibility for teaching this to others.
- Work with other disciplines to understand what needs to be built.
- Coach and mentor more junior colleagues.
- Consider the operation and support of the production services.
- Find ways to improve system robustness, resilience and stability.
Skills & Experience needed as our Full Stack Developer:
- Server side coding, preferably Javascript, Node.
- AWS services specifically including: Cloudwatch, EC2, RDS, S3.
- Database technologies (MySQL, Oracle, PostgreSQL, DynamoDB).
- HTML, CSS, JavaScript, JQuery.
- Working knowledge of front end frameworks such as React and Angular.
- Good understanding of system/application performance and performance tuning.
- Build tools - Gradle, NPM.
- Git - Command line, Bitbucket, GitHub, GitLab, Stash.
- TDD and BDD.
- Testing tools and techniques - Cucumber, Mocha.
- Web Services - REST, SOAP.
- CI servers (Jenkins, Hudson, Bamboo).
- Developing on Linux/UNIX.
- Continuous Integration and Continuous Deployment principles.
- JIRA and Confluence.
- Software development principles Scrum & KanBan.
Desirable
- Developed SaaS web applications and/or Data Warehousing.
- AWS Certifications.
- Docker, Kubernetes, Ansible.
What we can offer you as our Full Stack Developer:
- A friendly supportive environment.
- Exposure to leading cloud technologies.
- Free online training and exams for relevant certification.
- A dynamic working environment in central London.