Matthew Trought

Data Insights Analyst (Python, SQL, Marketing) Location: Alcester (Warwickshire) / Hybrid Salary: Up to £45,000 Keywords in the role: Data Analyst / Insights / Marketing / Digital Agency / SQL / Python / Data Visualisation  Career Opportunity An exciting opportunity has come up to work for a truly innovative organisation located in Alcester (Warwickshire), as they plan to grow the Data and Insights team. They have the motto of “We back everything we do through insights and data”, so you will be an essential part of the team in driving the analytical thinking that our teams require to help validate their hypotheses. You will be instrumental in consulting informed insights that will therefore guide our client's strategy for ongoing digital transformation. Over time this is likely to open up a further opportunity for you to build a supporting team to assist you in your expertise and ensure data is at the forefront of all our client’s road maps xpertise and ensure data is at the forefront of all our client’s roadmaps We're looking for a talented Marketing Data Analyst, who leads the development of data models and execution of visual reports that drive fact and define opportunities to enhance decision-making. Your role will be integral in helping to deliver the product roadmap for marketing data analysis across all of our client partners. This will require you to be a strategic thinker, defining right-fit solutions and opportunities. As well as a senior voice, being able to confidently showcase your knowledge and passion to your colleagues & clients. Day-to-day Responsibilities ● Analysing and interpreting data: apply statistical techniques and data visualisation tools to analyse the collected data, uncovering patterns, trends, and insights ● Communicating data-driven insights: effectively communicate findings to the output teams, product managers, and stakeholders.Development of data visualisations/dashboards: Present data in a clear, concise, and visually appealing manner● Gathering and cleaning data: responsible for collecting relevant data from various sources, such as user behaviour analytics, customer feedback, and product usage metrics ● Define and develop: implement frameworks for measuring, reporting, analysing, and benchmarking marketing results to enhance decision-making ● Measuring and tracking progress: establish key performance indicators (KPIs) or OKRs to measure the impact of product changes and track progress towards goals ● Providing data-driven recommendations: use insights to provide recommendations for product improvements, feature prioritisation, and user experience enhancements ● Supporting data-driven decision-making: play a crucial role in fostering a data-driven culture within the iterative output teamsFuture planning: Incorporate AI and ML models into data streams to create predictive analysis models, informing business decisions ahead of time Experience required for the opportunity: ● Ability to read and analyse data to make informed decisions - Strong knowledge and understanding of analytics software and user behaviour tools ● Confident working background with data lakes such as BigQuery or Snowflake ● Experience visualising data through tools such as PowerBI, Looker Studio, Tableau Proven experience with presenting comprehensive reports on data analysis findings and recommendations ● Experience in Python / SQL ● Past experience of handling large complex data sets ● Strong analytical skills with the ability to unify/collate data and analyse/interpret to ultimately define actions ● Experience in Python / SQL to manage, transform and overlay models onto our data Preferred Previous Experience ● 4+ years of experience in a Data Analyst role - working with marketing data ● Agency & client-facing background ● Working experience with performance, development and user experience teams ● Experience managing and mentoring other members of the team ● Past working experience within an Agile environment with exposure to Agile frameworks such as Scrum/Kanban ● Experience using agile / project management tools in Jira and Confluence ● Great communication skills ● Successful team collaboration Applying for the opportunity: If you feel you have the required skills to be considered for this opportunity and wish to apply, please forward an up-to-date version of your CV, and someone will contact you back within 48 hours.

Job Title: Solutions Developer  Salary: £45,000 - £48,000 Location: Birmingham / Hybrid (3 days a week on-site) Tech Required for the role: SQL, C#, Web API A fantastic opportunity has come up to join a truly innovative and exciting organisation located in central Birmingham, as they look to expand their team again due to continued progression. This organisation is listed on the AIM market with an ambition for growth and success; focussed on becoming the No.1 within their professional services business in the UK (Currently 10th).  They currently have over 1,450 people in their team, across 22 offices, servicing some 25,000+ clients across the full spectrum of legal and professional services. They believe that everyone has an important role to play in the success of the company, with the inclusive culture, as well as their collaborative, flexible and friendly environment, making it a great place to work.   They are now seeking a talented individual to join their busy IT Team.  The successful candidate will be an experienced Solutions Developer who can hit the ground running and take on a variety of projects. Main Duties: Responsibilities include, but are not limited to: Competencies: Responsible for the development and improvement of our Practice Management SystemsBuild browser based web solutions that meet the changing needs of the business and drive efficiency as part of our ongoing automation programEnsure that industry standards and best practices are applied across the development and database environments, leading to systems that are secure, robust and optimisedProduce and maintain documentation contributing towards the wider development infrastructureProduce estimates (high-level and detailed) for development workBalance work on multiple projects at one timeIntegrate with third party providers by consuming API’s. This could extend building out API wrappersMaintain databases and objects such as tables, stored procedures, views, triggers, IndexesHandle common database procedures such as upgrade, backup, recovery, migrationProfile server resource usage, and optimise as necessaryMaintain interfaces with other systems both internal and external Collaborate within a cross functional team to help shape technical solutions and directionWork well with ever-changing processes to meet our company needs and requests Experience and Skills:.NET framework / .NET Core (C#)ASP.NET MVC, Web API, FunctionsExcellent understanding of Microsoft SQL Server Expert-level T-SQL skillsAbility to write clean, efficient, readable and well documented codeProven experience of creating and implementing effective testing plansExperience of using code repositoriesThe ability to prioritise high volumes of responsibilities without delays in deliverablesCapable of troubleshooting common databases issues and debugging stored proceduresSkilled at optimising large, complicated SQL statementsFamiliar with tools that can aid with profiling server resource usage and optimizationSense of ownership and pride in your performance and its impact on company’s successPrevious experience of helping to deliver projects accurately and on timeCritical thinker and strong problem-solving skillsA proven team player, who can support others and who can adapt to changing and conflicting prioritiesA confident and effective communicator who is proactive, self-motivated with a can-do attitudeStrong attention to detail and willing to expand your skill set to overcome existing challengesAdditional Desirable Skills:Experience of Legal SectorAgile development principlesExperience of using Continuous IntegrationAzure Stack; Power Automate, Microsoft Power AppsAzure DevOps pipelinesMicroservice ArchitectureHTML, JavaScriptKNIME If you feel you have the required skills and experience and are interested in the opportunity, please apply by forwarding an up-to-date version of your CV, and if we feel you meet the requirements, someone will contact you back within 24 hours.

Senior BI Programmer / Data EngineerLocation: Spain / Fully remoteSalary €60,000Role DescriptionA market-leading and innovative organisation in Spain is looking for an experienced Senior BI Programmer / Data Engineer to play a key role in the design, development, and maintenance of their business intelligence (BI) solutions and data infrastructure. The ideal candidate will have a strong background in data engineering, ETL processes, data modelling, and programming, along with excellent communication and problem-solving skills.The clients has defined a strategic 12 – 18-month BI development roadmap. The successful candidate will be focusing primarily on the development required to deliver such defined features and functions in hybrid agile/waterfall method.The successful candidate will report to the Head of Proprietary IT Development.Role ResponsibilitiesImplement best practices for data quality, data governance, and data security across all BI solutions.Work closely with data analysts, IT stakeholders and other team members to support their analytical and reporting needs.Collaborate with stakeholders to understand business requirements and translate them into technical specifications for BI solutions.Design, develop, and maintain robust data pipelines and ETL processes to extract, transform, and load data from various sources into our data warehouse.Build and optimize data models and schemas to support reporting, analytics, and data visualization needs.Troubleshoot and resolve issues related to data integrity, performance, and scalability.Stay updated on emerging technologies and industry trends in BI, data engineering, and analytics.Play a key role in defining QA and UAT success.QualificationsBachelor's degree or higher in Computer Science, Engineering, or a related field.Proven experience as a Data Engineer, BI Developer, or similar role, with at least 3 years of experience in data engineering and BI development.Proficiency in at least one programming language for data manipulation and scripting (e.g., Python, Java, Scala).Experience with data warehousing concepts and technologies (knowledge of Azure functions a plus).Familiarity with data modeling techniques and tools.Excellent analytical and problem-solving skills, with a keen attention to detail.Strong communication and collaboration skills, with the ability to effectively interact with both technical and non-technical stakeholders.Very strong proficiency in SQL and experience with relational databases.Proven experience using Microsoft SQL Server with advanced knowledge of SSIS, SSAS, SSRS.Strong knowledge of ETL methodology.Experience working in an Agile development environment.Knowledge of BI and data visualization tools (e.g., Tableau, Power BI, Looker) is desirable.Languages: English is a must and Spanish is desirable.If you feel you have the required skills and wish to be considered for this opportunity, please apply and someone will contact you back within 48 hours if we feel your application is suitable.

BI AnalystSalary: £31,000Location: Coventry (On site 4 days a week)BI Analyst / Data Analyst / MI Analyst / Business Intelligence / SQL / T-SQL / Excel / CoventryA fantastic opportunity has come up to work for an exciting organisation located in Coventry as they look to expand their Data team.They are looking for a Junior BI Analyst to help support the business with resolving queries and issues that the teams are experiencing. In this challenging yet exciting role you will use your SQL skills to investigate and troubleshoot problems and resolve them. They are looking for a proactive person who is a self-starter.They are looking for a BI Analyst who has enthusiasm and commitment to excel in their IT department. A keen eye for detail, a highly structured approach, a personal drive to succeed and the ability to learn and grow are all key assets you will possess. They are a company that believes in their staff and will always back you in terms of support, personal development and progression.From a technical standpoint, you will be using an advanced and practical knowledge of SQL, as well as expert usage of Excel to deliver and present results (e.g. advanced formulas, pivot tables).Essential skills and experience:Knowledge of MS SQL Server; T-SQL is essentialWriting SQL queriesExcellent Microsoft Excel skillsGood problem identification and solving skillsExcellent attention to detail and analytical skillsAbility to manage time effectively, meet deadlines and prioritiseMinimum of 1 years’ experience in a similar roleStrong written and verbal communication skillsApplying for the opportunity:If you like the sound of this opportunity, and you feel you have the required skills requested for the role. Please apply, and someone will contact you within 24 hours if you meet the requirements of the opportunity.BI Analyst / Data Analyst / MI Analyst / Business Intelligence / SQL / T-SQL / Excel / CoventryBI Analyst / Data Analyst / MI Analyst / Business Intelligence / SQL / T-SQL / Excel / CoventryBI Analyst / Data Analyst / MI Analyst / Business Intelligence / SQL / T-SQL / Excel / CoventryBI Analyst / Data Analyst / MI Analyst / Business Intelligence / SQL / T-SQL / Excel / Coventry

SQL Developer£48,000Location: Hybrid / Sutton Coldfield (once every other Wednesday work in the office)A fantastic opportunity has come up to work for an organisation that has just received millions of pounds worth of investment and is going through an exciting 3-year Transformation project, and as a result, are looking for several Developers for the business, so if progression, and working on exciting project-based work is what you enjoy, then please carry on reading!They are looking for x3 SQL Developers to help with being responsible for the development and implementation of system applications that align with the strategic direction of the business. You will also help build scalable and efficient SQL to interact with the database servers, converting non-technical business requirements into technical requirements and solutions that you will develop, test, and deploy.This role will be responsible for producing a quality end-product that is fit for purpose, and also working closely with the team, resolving escalations and diagnosing issues or bugs.PERFORMANCE MEASURESTo meet the demand of the business needs assigned to you by your manager/delivery manager/product ownerRegular meetings/appraisals to measure performance will be heldKEY RESPONSIBILITIESDeveloping core systems in SQL Server Management StudioDeveloping SQL back end with minimal changes in MS Access, Front End SystemsWrite and optimise in-application SQL statementsProvide realistic estimate timescales of delivery against business requirementsProvide 3rd line support where applicable on current software applicationsMaintain excellent communication with IT colleagues, other teams, partners, customers and suppliersManage work items from allocation to completion within our application lifecycle tool (Azure DevOps – Desirable)KNOWLEDGE, SKILLS AND EXPERIENCE REQUIREDMultiple years of experience working as a developer with extensive use of SQLPrevious experience working within environments which use MS Office and MS AccessStrong proficiency of existing technologies and emerging technologies and capabilities as applicable to Core IT Systems (VBA, SQL, SSIS, MS Access, VB.Net, C#)Good understanding of Data Transformation Services, SSIS, VBA & SQL databases and data architecture.If you feel you have the required skills needed for this opportunity and want to be considered, please forward an up-to-date CV to the application link, and someone will contact you within 24 hours

Application Developer£48,000Location: Hybrid / Sutton Coldfield (once every other Wednesday work in the office)A fantastic opportunity has come up to work for an organisation that has just received millions of pounds worth of investment and is going through an exciting 3-year Transformation project, and as a result, are looking for several Developers for the business, so if progression, and working on exciting project-based work is what you enjoy, then please carry on reading!They are looking for x3 SQL Developers to help with being responsible for the development and implementation of system applications that align with the strategic direction of the business. You will also help build scalable and efficient SQL to interact with the database servers, converting non-technical business requirements into technical requirements and solutions that you will develop, test, and deploy.This role will be responsible for producing a quality end-product that is fit for purpose, and also working closely with the team, resolving escalations and diagnosing issues or bugs.PERFORMANCE MEASURESTo meet the demand of the business needs assigned to you by your manager/delivery manager/product ownerRegular meetings/appraisals to measure performance will be heldKEY RESPONSIBILITIESDeveloping core systems in SQL Server Management StudioDeveloping SQL back end with minimal changes in MS Access, Front End SystemsWrite and optimise in-application SQL statementsProvide realistic estimate timescales of delivery against business requirementsProvide 3rd line support where applicable on current software applicationsMaintain excellent communication with IT colleagues, other teams, partners, customers and suppliersManage work items from allocation to completion within our application lifecycle tool (Azure DevOps – Desirable)KNOWLEDGE, SKILLS AND EXPERIENCE REQUIREDMultiple years of experience working as a developer with extensive use of SQLPrevious experience working within environments which use MS Office and MS AccessStrong proficiency of existing technologies and emerging technologies and capabilities as applicable to Core IT Systems (VBA, SQL, SSIS, MS Access, VB.Net, C#)Good understanding of Data Transformation Services, SSIS, VBA & SQL databases and data architecture.If you feel you have the required skills needed for this opportunity and want to be considered, please forward an up-to-date CV to the application link, and someone will contact you within 24 hours