_______________________
_____________________
____________________
___________________
_________________________
_____________________
_____________________
_________________________
___________________
________________________
Our client is looking for an expert SQL/SSRS Developer to assist with reporting across the current business and existing acquisitions of additional organisations. Client Details A global manufacturer, distributor and supporter of the innovation of products for their customers. Description Ownership of the key databases with the support of a current Business Analyst and consultant Lead technical aspects of new software integration's to the current ERP system Build solutions for specific business areas, depending on the client's requirements Data driven efficiency improvements, designing and implementing solutions as required, both inside the ERP and outside of it as required Create and maintain complex SQL queries to extract data efficiently from relevant databases Work closely with the ERP team and business to gain an understanding of the data and to consolidate databases wherever possible Develop and maintain processes to load, cleanse and validate data Contribute to the testing and release of processes, providing support and escalation of the issues Actively identify improvement opportunities and process improvements in development delivery; designing and implementing data solutions to increase efficiency and reduce manual effort Supporting and providing cover for the wider team, managing departmental workloads and individual project deliverable Reviewing data and reporting framework, recommending more effective ways to present information and creating new reports to assist the management decision Maintain full technical documentation of the work done using different tools Responsibility for the creation, development and maintenance of a data dictionary Performing analysis of company data including KPIs and Sales Reports Profile Strong SQL Development & Reporting knowledge and experience Strong analytical & problem solving skills; particularly investigation and resolution of data related problems Knowledge of SQL queries and SQL Server Reporting Services (SSRS) Good understanding of data integrity and customer data matching Migration of data/large data volumes Advance Excel knowledge (e.g. pivot tables, vlookup) Able to clearly communicate with business and technology stakeholders Solid understanding of end to end data processing Power BI experience VB Script experience In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework Job Offer £50,000-£60,000 basic salary Remote (requested on site for training/workshops) potentially 1x per month Full time permanent position
Are you a Power BI Specialist in search for an exciting new job opportunity? If so, one of the largest public sector organisations based in London are looking to recruit a Power BI Developer on a 3-month contract (with possibility of an extensions), starting immediately, to join their growing team. It is a full-time role, Mon-Friday, 35 hours per week and hybrid work (2 days a week in the office), office is walking distance from Southwark/London Bridge stations. THE ROLE: As a Power BI Creator your primary responsibility will be to develop and maintain interactive and insightful data visualizations using Power BI. You will collaborate with stakeholders to understand their reporting needs, gather data from various sources, transform and clean the data, and create engaging dashboards and reports that facilitate data-driven decision-making. KEY RESPONSIBILITIES: Collaborating with Stakeholders: Engage with stakeholders to understand their reporting requirements and objectives. Translate business needs into technical specifications for Power BI dashboards and reports. Communicate and present data insights effectively to stakeholders. Data Gathering and Preparation: Collect data from multiple sources, including databases, spreadsheets, and APIs. Clean and transform data to ensure accuracy, consistency, and relevance. Perform data modelling and create relationships between different data sources. Developing Interactive Dashboards, Apps, and Reports: Design and develop interactive and visually appealing dashboards using Power BI. Create compelling visualisations, including charts, graphs, tables, and maps. Incorporate filters, slicers, and drill-through functionalities to enhance data exploration. Data Analysis and Interpretation: Perform in-depth data analysis to uncover trends, patterns, and insights. Identify key metrics and KPIs to track performance and monitor data quality. Collaborate with data analysts and domain experts to ensure data accuracy and relevance. Report Automation and Distribution: Automate the data refresh process to ensure real-time or scheduled updates of reports. Set up data-driven alerts and notifications to inform stakeholders of critical changes. Develop efficient report distribution mechanisms to ensure the right information reaches the right audience. Troubleshooting and Maintenance: Monitor and troubleshoot issues related to data connections, data refresh, and report performance. Perform regular maintenance and updates to keep the Power BI ecosystem running smoothly. Stay up-to-date with new features and functionalities of Power BI and explore ways to leverage them effectively. Due to the nature of the role, applicants must have experience using Power BI to be able to carry out the role. If you have the required experience and skillset apply now for immediate consideration.
I'm partnering with a technology focused Global Supply Chain business who are seeking a graduate to join their BI function as a Graduate BI Developer. This role would suit an ambitious graduate who is looking to develop technically and gain exposure in a fast-paced global business. Responsibilities: Designing, implementing, developing and maintaining a reporting system using Microsoft Power BI Cooperation with the management and staff indicated by the Principal in order to determine the scope of reporting, and then design and implement reports in individual functional and business areas Development of data models, transformations, measures and visualisations based on source data Authorisation rights management with regards to individual reporting modules, taking into account the scope of responsibility of users Cooperation with members of the Data team to ensure high quality source data and extend the range of available information Cooperation with report users, implementing modifications and reacting to reported errors on an ongoing basis Adjusting reporting to changes and expectations of the organisation. What we're looking for: Numeric degree background e. Physics, Maths, Computer Science etc (min 2:1) Experience in a similar position would be beneficial e. placement year Experience in working with Power BI and Excel programs (pivot tables, Power Query, VBA, macros, etc.) Experience working with large amounts of data from multiple sources Ability to model and interpret data, including designing dynamic charts and presentations Ability to develop relationships with senior management and external stakeholders If this role is of interest, please apply directly with an updated copy of your CV.