PKF Smith Cooper Systems is a leading Sage Business Partner with UK wide coverage. We’re proud to be “Good Sage Guys to Deal With” – meaning we’ll always take the time to get to know a business and the solution that fits it best.
Our people are our biggest asset. Over the last three years, we have undergone a period of significant positive growth. The key pillar to this success has undoubtedly been the hard work and commitment of our dedicated and talented team, along with the great ethos and great working environment we have created.
As the fastest growing Sage partner in the UK, we are always on the lookout for talented, ambitious, and driven individuals to join our team.
Overview
We're seeking a Power BI/Business Intelligence Developer to join our team. As a leader in providing Sage ERP solutions we're committed to providing data-driven insights to meet our clients requirements. Our ideal candidate will have experience in Power BI, SQL Server, and Sage 200 (or Similar ERP Solutions).
Job Summary
As a Junior Reporting Analyst, you'll play a key role in designing, developing, and implementing data visualization solutions using Microsoft Power BI, leveraging SQL Server as the primary data source and reporting from Sage 200. You'll work closely with the existing team to identify business needs, develop data models, and create interactive dashboards that provide clients with the insights they need. The existing team will also provide the support and guidance that you need in your development.
As Sage 200 is primarily a SQL based platform, our main focus Is on SQL side development rather than data transformation within PowerBI. Therefore SQL server skills would be an advantage.
The role will suit someone from a Sage background who wants to focus on reporting and analytics or someone with a reporting background who wants to apply their skills to a new ERP suite.
Responsibilities:
- Design, develop, and deploy Power BI reports and dashboards to meet business requirements
- Write efficient SQL queries to extract and transform data from SQL Server
- Integrate Power BI with Sage 200 to provide real-time insights and reporting
- Troubleshoot and resolve technical issues related to Power BI development and deployment
- Create reports using the tools provided by Sage (Report designer, API, etc)
- Stay up-to-date with the latest Power BI features, best practices, and industry trends
Ideal Candidate:
- Experience or Knowledge in Power BI development, data analysis, or a related field
- Experience or Knowledge of SQL Server, query writing would be desirable
- Experience with Sage 200, including data interrogation and reporting
- Strong problem-solving skills, with the ability to troubleshoot technical issues
- Excellent communicator with a strong work ethic
Why us:
We can offer, a great company with a clear growth plan and the appetite to execute it, a great working environment/team ethos plus lots of great projects to get stuck into immediately.
The opportunity to develop your career with our company will be significant for anyone who can contribute to our positive, forward-thinking environment. We also have a proven track record of internal promotion.
We operate a flexible working policy and the majority of our team now work in a hybrid manner split between the office and home to suit the tasks at hand, as such all geographies will be considered.
