Data Warehouse Developer Jobs
Business Intelligence Developer
Position type: Full time, permanent, 37.5 hours per week
Responsible to: IT Business Analysis Manager
Direct reports: None
Location: Truro, Cornwall (hybrid – mixture of office and home working) or remote working (UK only) may be considered (with regular travel to Truro at least 4x per year).
About the Role
As a Business Intelligence (BI) Developer, you will collaborate with our Business Analyst (BA) Manager to design, develop, implement, document, and maintain robust data modelling and reporting solutions. Your role will involve hands-on work, including prototyping solutions, testing ideas, and collaborating with organisational colleagues. Working closely with our Data Manager and Data Technician, you will also contribute to our data warehousing solution and the development of data pipelines and be responsible for data preparation, modelling, and utilising DAX. You will also work closely with our fundraising Insight team, creating analytic solutions to support our fundraising efforts.
Who are we looking for?
We are seeking an individual who is passionate about data and analytics and possesses meticulous attention to detail. You should be driven to produce high-quality solutions. Excellent written and verbal communication skills and the ability to prioritise tasks and efficiently manage multiple responsibilities are essential. Furthermore, you should have experience with the following technologies and a solid understanding of querying, query optimisation, dimensional modelling design, and data visualisation techniques:
- BigQuery
- SQL
- Power BI
- DAX
- Google Analytics
What you will be doing in the role:
- Working with people across the organisation to understand their analytical requirements.
- Developing, testing, and implementing analytical solutions and data visualisations that empower teams to gain valuable insights from their data.
- Taking ownership of new and existing data models.
- Managing the lifecycle of data models and reporting solutions.
- Working with the BA Manager to define best practices and facilitate knowledge sharing for Power BI development, governance, and deployment across the organisation.
- Ensuring that development aligns with the overall BI strategy and adheres to best practices.
- Responding to incidents and change requests related to existing solutions via our AutoTask helpdesk solution.
- Updating and managing tickets appropriately and timely as the Service Desk Manager sets out, ensuring good communication and customer satisfaction.
- Composing technical and team documentation as required.
- Collaborating and demonstrating analytical solutions to the broader team before roll-out.
- Offering input and advice on processes and practices to improve the team's efficiency and effectiveness.
- Assisting with implementing new solutions, as necessary, with the Business Systems Transformation project.
- To undertake any other duties as requested by the IT management team per the scope and responsibilities of the role.
The client requests no contact from agencies or media sales.
Actively Interviewing
This organisation is scheduling interviews as the applications come in. Don’t miss your opportunity, apply now!
At the core of RABI’s mission is the commitment to address the individual needs of farming people. We offer one-to-one, expert support, advice and guidance, tailored to the individual circumstances of the farming person.
You will be part of a wider Finance and Operations team responsible for the planning, implementation, and execution of Microsoft Dynamics and related projects within our charity, to support the long-term delivery of services across the farming community within England, Wales & Northern Ireland.
You will possess strong leadership skills, extensive knowledge of Microsoft Dynamics along with integration into 3rd party software solutions, our social and wider digital platforms for delivery of access to our farming community and partner organisations. You will understand integration of reporting tools, ideally based on social impact reporting, along with delivery via data warehouses and Microsoft reporting technology such as Power BI.
In addition, you will be responsible for the scoping and integration of our Microsoft Dynamics solution into digital platforms, such as the RABI website and associated portals for our service users, volunteers and partner organisations.
Key responsibilities:
- Project Leadership: Drive planning, execution, and delivery of Microsoft Dynamics CRM projects within set timelines and budgets, employing Agile methodologies and delivery sprints.
- Project Management: Develop comprehensive project plans, schedules, and budgets to track progress, ensuring adherence to milestones.
- Resource Allocation: Efficiently allocate resources, including personnel, equipment, and materials, to support project activities and meet requirements.
- Risk Management: Monitor project progress, identify risks and issues, and implement strategies to minimize disruptions and delays.
- Cross-functional Collaboration: Coordinate with cross-functional teams and third-party partners to ensure alignment and collaboration throughout the project lifecycle.
- Stakeholder Communication: Regularly communicate project status, updates, and issues to stakeholders and executive leadership through meetings, reports, and presentations.
- Post-project Evaluation: Conduct post-project reviews to evaluate outcomes, identify lessons learned, and implement process improvements.
- Project Management Framework: Provide guidance and leadership in developing and implementing a project management framework to support the charity’s strategic objectives.
- Social Impact Reporting Integration: Collaborate with the RABI Service Delivery team and third-party consultants to project manage the integration of social impact reporting into Microsoft Dynamics. Support will be given to Project Manager to develop knowledge in this area.
- Digital Platform Integration: Lead the relationship with stakeholders and digital delivery partners for scoping, planning, and delivering integrated portals and digital platforms into Microsoft Dynamics.
Person Specification:
Essential:
- Experience in Microsoft Dynamics CRM.
- Proven track record of at least three full lifecycles of CRM implementations.
- Integration experience with third-party applications and digital platforms.
- Proficiency in integrating reporting platforms, particularly with Microsoft Power BI.
- Successful track record in delivering large-scale projects on time and within budget.
- Strong leadership skills to motivate cross-functional teams.
- Excellent communication skills to convey technical concepts to non-technical stakeholders.
- Exceptional problem-solving abilities with a focus on driving results.
- Familiarity with Agile or other iterative project management methodologies.
- Experience in managing organizational change during large-scale IT projects.
Desirable:
- Experience in the UK charity sector.
- Familiarity with Microsoft Dynamics Fundraising & Engagement and Microsoft Cloud for Non-Profit.
- Industry-recognized project management qualifications (e.g., AgilePM or PRINCE2 Agile).
- Full UK driving license.
The client requests no contact from agencies or media sales.