BI Analyst - Cardiff - Business Intelligence Analyst

Job Description

A Broad role supporting the Group Data Strategy by liaising with stakeholders of all levels, internal and external, to drive process efficiency, improve customer understanding and predict future market trends.Client DetailsA family-owned, medical device Manufacturer & Supplier striving to provide innovative product toi enable the clients to live life as easily, happily and as fully as possible.Description

• Consulting with management and relevant stakeholders to define goals.
• Liaising with internal and external stakeholders to identify areas of the business that could benefit from analysis.
• Researching, developing and implementing data-gathering methods.
• Analyse business processes and requirements
• Building customer dashboards and reports in PowerBI, utilising DAX and Power Query.
• Work with SQL to query data sets and optimise solutions in SSIS and Azure Data Warehouse.
• Data merging from ERP System to existing data model.
• Data migration and integration from source to destination, which may be ERP.
• Creating and maintaining a SQL data Warehouse
• Identify opportunities to improve processes and strategies with technology solutions.
• Identify development needs in order to improve and streamline operations.
• Reviewing data collection processes and assessing the validity of the information stored.
• Conducting tests to ensure that intelligence is consistent with defined goals.
• Analysing competitive market strategies through analysis of a related product, market, or share trends.
• Create and maintain documentation including requirements, design and user manuals
• Understanding the laws surrounding the collecting and processing of data and ensuring that all policies reflect current legislation.
• Using, researching, and assessing data processing software.
• Identifying anomalous data, examining, and eliminating any processes or procedures that contribute to unreliable data being collected.
• Working closely with BA/ERP Analysts to analyse business processes and provide efficient solutions.
• Working closely with the IT department to ensure that the data collection and storage systems are secure and robust.
• Developing BI and data warehouse strategies alongside Group Data Architect.
• Develop and manage BI solutions.
• Presenting findings to all levels of management.
• Provide reports, processes and Excel VBA applications through the application life cycle.
• Maintaining or updating BI tools and databases.

Profile

• Substantial proven experience in a similar role.
• Experience with Data Visualisation - PowerBI is preferable.
• Working technical experience with designing SQL databases and capable of ensuring data capture and manipulation from other sources.
• SQL Server Integration Service (SSIS)
• Strong understanding of database structures, theories, principles, and practices.
• In-depth experience with data management and data processing flowcharting techniques.
• Broad knowledge of reporting and query tools and practices including Crystal Reports and Microsoft Power BI.
• Data manipulation and analysis skills using Excel and other tools.
• Ensuring that data is being correctly gathered, monitored, stored, and analysed.
• Strong reporting skills to present insights concisely.
• Able to work both alone to analyze findings as well as a member of a team to work with other departments, such as when implementing new data analysis software.
• Stakeholder management skills, with the ability concisely communicate findings.
• Writing data collection and processing procedures.
• Develop methodologies to improve data analysis.
• Good understanding of the organisations goals and objectives.
• Knowledge of applicable data privacy practices and laws.
• Good interpersonal, written, and oral communication skills.
• Strong technical documentation skills.
• Ability to present ideas in user-friendly language.
• Highly self-motivated and directed, with keen attention to detail.
• Proven analytical and problem-solving abilities.
• Able to prioritise and execute tasks in a high-pressure environment.
• Strong customer service orientation.
• Experience working in a team-oriented, collaborative environment.

Job Offer- Up to £40,000 DOE- 10% Annual performance bonus- 6% pension- Wellbeing Benefits- Holidays allowence inreasing with tenure

Keyskills :
AnalyticsDAXSQLSSISSSRSExcelSSASAzurePower BI