DBA/Data Analyst
Venesky-Brown’s client, a public sector organisation in Tweedbank, is currently looking to recruit a Database Admin / Data Analyst for an initial 10 month contract with potential to extend on a rate of £450-£500/day (Inside IR35). This role may require on site working initially, with potential for remote with occasional working from offices in Tweedbank.
Responsibilities:
– Make the current project data repository accessible to the project team and add required queries / screens that will allow the team to interrogate / view the data.
– Provide Excel outputs in preparation for sharing with NHS partner organisations.
– Extend the data structure to support import, separation, and comparison of data returned from partner organisations (e.g. categorising as matching / non-matching and indicating differences).
– Create reports (financial liability / variance, member and contract stats, and data validation outcomes).
– Advise on limitations and risk for the project data repository (currently Access DB) and manage the move to an alternative data tool where deemed necessary.
– Work closely with the Project Manager and Business Analyst on data requirements and specifications required.
– Engage positively and professionally with the project team, internal and external subject matter experts and stakeholder groups.
Essential Skills:
– Expertise in Access DB
– Experience in database management (maintenance, manipulation, access and querying) using SQL.
– Expertise in data modelling, reporting, analysis, presentation and visualisation.
– Engage positively and professionally with the project team, internal and external subject matter experts and stakeholder groups.
– Experience in, and ability to, apply a range of tools and techniques to collate and analyse data.
– Experience conceiving, designing and building dashboards using tools such as Excel and enterprise BI solutions such as Caseware Idea, Tableau, Power BI, or similar.
– Experience of working with stakeholders to define and implement reporting requirements.
– Experience working on large projects
– Must be a self-starter, able to work under own initiative and direction.
– Must be able to work independently on MS Access
– Ability to organise, prioritise and schedule work within an agreed set of priorities or work programme.
– Ability to lead on data initiatives, develop a plan and influence and negotiate with colleagues and stakeholders to implement the plan
– Excellent stakeholder management skills.
– Must be able to support moving to Apex Oracle after Excel.
Desirable Skills:
– Data analysis qualification
– 5 plus years acting as a data analyst
If you would like to hear more about this opportunity please get in touch.
Responsibilities:
– Make the current project data repository accessible to the project team and add required queries / screens that will allow the team to interrogate / view the data.
– Provide Excel outputs in preparation for sharing with NHS partner organisations.
– Extend the data structure to support import, separation, and comparison of data returned from partner organisations (e.g. categorising as matching / non-matching and indicating differences).
– Create reports (financial liability / variance, member and contract stats, and data validation outcomes).
– Advise on limitations and risk for the project data repository (currently Access DB) and manage the move to an alternative data tool where deemed necessary.
– Work closely with the Project Manager and Business Analyst on data requirements and specifications required.
– Engage positively and professionally with the project team, internal and external subject matter experts and stakeholder groups.
Essential Skills:
– Expertise in Access DB
– Experience in database management (maintenance, manipulation, access and querying) using SQL.
– Expertise in data modelling, reporting, analysis, presentation and visualisation.
– Engage positively and professionally with the project team, internal and external subject matter experts and stakeholder groups.
– Experience in, and ability to, apply a range of tools and techniques to collate and analyse data.
– Experience conceiving, designing and building dashboards using tools such as Excel and enterprise BI solutions such as Caseware Idea, Tableau, Power BI, or similar.
– Experience of working with stakeholders to define and implement reporting requirements.
– Experience working on large projects
– Must be a self-starter, able to work under own initiative and direction.
– Must be able to work independently on MS Access
– Ability to organise, prioritise and schedule work within an agreed set of priorities or work programme.
– Ability to lead on data initiatives, develop a plan and influence and negotiate with colleagues and stakeholders to implement the plan
– Excellent stakeholder management skills.
– Must be able to support moving to Apex Oracle after Excel.
Desirable Skills:
– Data analysis qualification
– 5 plus years acting as a data analyst
If you would like to hear more about this opportunity please get in touch.
