
Business Intelligence Developer
- Manchester
- Permanent
- Full-time
- Transform raw data into user-friendly and insightful dashboards and reports. This will include designing and implementing automated reporting solutions in Power BI
- Support the operation of the business’s applications which support the distribution of data to external customers
- Extract, transform, and load data from a variety of sources into Power BI and develop and maintain data models which support data analysis and reporting requirements
- Work closely with stakeholders to understand their data needs and provide analytical support such as in the design of appropriate metrics or in identifying opportunities to automate and streamline reporting processes that improve efficiency and accuracy
- Working with data engineering colleagues to ensure our analytics architecture aligns with reporting needs
- Optimise SQL queries and Power BI models and reports for improved performance and efficiency
- Follow processes that ensure the accuracy and reliability of data and reports
- Support monitoring and maintaining data quality, and addressing technical issues
- Adhere to data governance and security policies, ensuring appropriate handling of sensitive or confidential data
- Proven experience within a similar BI or Data role.
- Proven ability to create insightful and impactful dashboards and reports using Power BI and a good understanding of DAX
- Experience of using Power Query to extract, transform and load data from a variety of sources into Power BI and Excel e.g. Microsoft Fabric, SQL Server, Excel, API
- Experience building scalable data models using the star schema design
- Strong Excel skills e.g. pivot tables, Power Pivot
- Understanding of relational databases, data warehousing and proficiency in writing SQL queries to extract data
- A good grasp of statistical methods to enhance data analysis and interpretation
- Knowledge and experience of SSRS/Power BI Paginated Reports and SSIS would be advantageous
- Strong analytical thinking and problem-solving skills
- Strong communication skills to share insights and collaborate with the wider business on analytics projects
- High level of accuracy and attention to detail
- At Conferma we understand that our people are what make us great. We have set out to provide a comprehensive benefits package that includes everything you would expect, as well as providing flexibility for you and your family.
- A salary sacrifice pension to maximise your contributions
- Life Assurance cover to provide peace of mind
- Enhanced Company sick pay to put your mind at rest
- Single cover private medical scheme, with the flexibility to add family members at your own cost
- 33 days paid annual leave to allow you to focus on what's important to you outside of work
- The ability to purchase up to 10 additional days holiday each year to enable additional time off
- Additional paid time off for life events, such as moving house or getting married
- An additional days leave on or around your birthday
- Enhanced paid parental leave on the birth or adoption of your child
- A confidential Employee Assistance program (EAP) available to all 24/7
- Access a range of fantastic additional rewards, such as Cycle 2Work, Gym Membership, Tech Scheme and discounted shopping and Cinema tickets, via Conferma Rewards