Do you have demonstratable experience of using Power BI?
Are you experienced in the use of relational databases including SQL?
Consider the role of a Business Intelligence Analyst at Reed in Partnership!
We are on a mission to be the partner of choice for developing people and their communities. Reed in Partnership is a public service provider specialising in skills training for the long-term unemployed, increasing employment opportunities by working with employers and providing youth services.
What is the role about?
The Business Intelligence Analyst is responsible for?maintaining the data architecture and data pipelines that support business intelligence systems.?This includes ensuring that the data architecture is scalable, secure, and optimized for performance.?They also work closely with other teams to ensure that data is properly integrated and available for analysis.
The Business Intelligence Analyst will work closely with the analysts for reporting requirements and ensuring the correct data structure is in place for implementing newly awarded contracts.
The role will be responsible for designing processes and controls to ensure all data presented is tested, and accurate.
Just some of your day-to-day responsibilities will include
- Performing data manipulation and transformation within Azure/Snowflake/any other required data warehouses
- Designing and developing data solutions
- Governance of dataset access and controls
- Writing and testing processes
- Documenting and recording any structural changes to Azure/Snowflake
- Developing and maintaining data processes, new applications and new features
- Implementing and maintaining database objects
- Maintaining and improving tools for system analysis
- Building/maintaining Power BI data models with requirements from other teams
Work with existing contracts and implement newly awarded contracts by:
- Working with key stakeholders across the business
- Building and maintaining data warehouse, data flows, and pipelines
- Sourcing data from multiple sources and building logical models (dim/fact tables)
Working with BI Analysts to support internal and external reporting requirements of existing and newly awarded contracts including:
- Identifying and building KPI's, Milestones, etc
- Identifying financial thresholds
- Assessing the needs of supply chain
Other requirements for the Business Intelligence Analyst are;
- Develop and maintain strong professional working relationships with Operations colleagues
- Perform data manipulation and transformation in Power BI
- Understand and use DAX and SQL code within Power BI
- Use SQL and Power BI to create schemes that describe and track performance
- To provide cover for other roles in the Business Intelligence Team in times of annual leave / absence or workload fluctuations
- Provide daily preparation of the Performance reporting and other ad-hoc reports
- Provide commissioner returns
What's in it for you?
A generous base salary (pro-rata for part time), and great flexibility with your working schedule, we offer training, development and progression opportunities. You will have access to the range of Reed in Partnership benefits, which include:
- 25 days annual leave (pro-rata for part time) plus statutory bank holidays
- Reed Pension Scheme
- Award Winning Management & Leadership training
- Professional & Personal Development Funds
- Bi-annual pay reviews
- With the chance to dramatically make a difference to the local community, this role offers immense job satisfaction.
- At Reed in Partnership, we live and breathe our values in every decision and action taken, resulting in a collaborative and enjoyable culture within our offices. Our company values - we are fair open and honest; we take ownership, and we work together.
To be successful in this role, we are looking for someone with
Essential Criteria:
- Experienced in the use of relational databases including SQL.
- Demonstratable experience of using Power BI
- Demonstratable advanced excel spreadsheet skills with pivots, macros and look-ups.
- Demonstrable experience in dealing with high volumes of data with excellent attention to detail
- Ability to present complex Business Intelligence to all levels in the organisation.
- Ability to quickly understand and follow complex systems and procedures.
- Be able to work under pressure and work to strict reporting deadlines.
- Excellent organisational and time management skills.
- Technical skills: Data Manipulation, Data Validation, Data Cleaning, Row Level Security, Relational Databases Management, Dimensional Modelling.
- Soft skills: Stakeholder Management, Problem Solving, Communication, Logical Reasoning, Questioning Nature, Dataflows, Data Pipelines, Data Validation, Attention to Detail
- Programmes: Power BI, SQL, Microsoft Packages
Desirable Criteria:
- Experience of developing informative Business Intelligence that meets the needs of its target audience.
- Able to understand and process changing requirements in a fast-moving environment.
- Ability to build good, professional relationships, both internally and externally as a representative of Reed In Partnership.
- Technical skills: Snowflake Scheme Design, Kimball Methodology, Star Schemas
- Programmes: Snowflake
Diversity and Inclusion
We aim to ensure that no candidate or employee receives less favourable treatment on the grounds of gender, race, disability, sexual orientation, religion or belief, age, gender reassignment, marital or civil partnership status, pregnancy or maternity. We offer an interview to disabled candidates who meet the minimum criteria.