3 of 3 Spreadsheet Jobs in Lincolnshire

to facilitate accurate analysis and visualisation of complex datasets, ensuring alignment with the reporting framework's objectives. Report Integration: Integrate data from various internal and external sources, including databases, spreadsheets, and ERP systems (TROPOS), to create comprehensive datasets for reporting purposes within the operational, tactical, and strategic layers. Data Analysis: Continuously monitor report performance metrics across operational, tactical, and strategic More ❯

Responsibilities Build interactive Power BI dashboards and reports using Power BI Desktop Develop clear and consistent data models and DAX formulas for actionable insight Integrate data from ERP (TROPOS), spreadsheets, and SQL databases Create report frameworks that support operational, strategic and tactical decisions Optimise performance of dashboards through query tuning and data shaping Apply robust data security rules to ensure More ❯

thebusinessfostersaculturebuiltaroundsharedsuccessandcontinuousimprovement. AbouttheRole Asa PowerBIReportDeveloper ,youwillassumeapivotalvitalroleinpromotingadatadrivenculturewithinourorganisationfacilitatinginformeddecision-makingandoperationalexcellence. YourprimaryobjectivewillbetoharnessthecapabilitiesofPowerBItechnologytoconvertrawdataintoactionableinsights,empoweringstakeholdersthroughouttheorganisationtomakeoperational,strategicandtacticaldecisionsguidedbycomprehensiveandvisuallyengagingreportsanddashboards. The PowerBIReportDeveloper willbecollaboratingcloselywithkeystakeholders,youwilldecipherdatarequirements,manipulatedatasets,andcraftinteractivevisualisationsthatenhancethedecisionmakingprocess. KeyResponsibilities PowerBIDesign: UtilisePowerBIDesktoptodesignanddevelopinteractivereportsanddashboardstoprovideinsightsintokeyperformanceindicators(KPIs),operationalmetrics,andtrendsrelevanttoouroperations. Employbestpracticesindatavisualisationtocreateintuitiveandvisuallyappealingreportsthatcatertothespecificneedsofkeystakeholders. DeveloprobustdatamodelsandrelationshipswithinPowerBItofacilitateaccurateanalysisandvisualisationofcomplexdatasets,ensuringalignmentwiththereportingframework'sobjectives. ReportIntegration: Integratedatafromvariousinternalandexternalsources,including databases,spreadsheets,andERPsystems(TROPOS),tocreatecomprehensivedatasetsfor reportingpurposeswithintheoperational,tactical,andstrategiclayers. DataAnalysis: Continuouslymonitorreportperformancemetricsacrossoperational,tactical,andstrategiclevels,identifyingopportunitiesforimprovementsuchasqueryoptimisationordatacachingtomaintainefficiencyandreliability. DataSecurity: Defineandenforcerole-basedaccesscontrolstorestrictaccesstoconfidentialinformation,maintainingdataintegrityandconfidentiality. WhatWe'reLookingFor FormalEducation: BachelorsormastersdegreeorequivalentexperienceinComputerScience,InformationSystemsTechnology,orarelatedfield. MicrosoftPowerBIcertification. Experience; Minimumof1yearofexperiencedevelopingPowerBIreportsanddashboards. ExperienceofBIbasedprojectsworkingonowninitiativeandinvolvingthefulldevelopmentlifecycle. Recordofdesigningandimplementingcomplexreportstomeetbusinessrequirements. Experienceworkingwithlargedatasetsandoptimisingqueryperformance. Experienceindatapreparationincludingdataextractionandtransformation,ERPsystems. Skills More ❯