Data Analyst
| Posting date: | 23 May 2024 |
|---|---|
| Salary: | £30,000 to £35,000 per year |
| Hours: | Full time |
| Closing date: | 20 June 2024 |
| Location: | Milton Keynes, Buckinghamshire |
| Remote working: | Fully remote |
| Company: | Spectr Infotech Ltd. |
| Job type: | Permanent |
| Job reference: |
Summary
Spectr Infotech Ltd. is recruiting for a 2 X Data Analyst. The position of Data Analyst is pivotal within the company and your overall remit will be to analyse activity data, investigate trends and make recommendations to support the business operations across the board.
Responsibilities will include:
• Using SQL to build, maintain and optimise complex data sets and associated reports
• Managing ETL process, including adapting and troubleshooting as required to ensure data consistency
• Carrying on data quality assessments, identifying gaps and performing remediation actions
• Communicating with stakeholders to understand data content and business requirements
• Preparing reports and create data dashboards, graphs, and visualisations for varying audiences within the business
• Producing and tracking key performance indicators
• Refining, updating, and timely distributing existing reports, ensuring they remain accurate and are fit-for-purpose as the business evolves
• Using statistical tools to analyse data and forecast trends with actionable business insights
• Processing and delivering solutions to the internal customer requests and queries in an efficiently and timely manner
• Helping to deliver a continuously improve strategy by proactively identifying data issues, investigating errors, fixing root cause issues, and recognizing improvement opportunities
• Promoting processes automation and self-serve solutions
• Training end-users about new reports and dashboards
• Maintaining awareness of technology changes within the BI industry
Technical Skills:
• Proven working experience in data analysis
• Proficient in MS SQL
• Experience with Azure and other data tools
• Strong knowledge of Power BI (plus DAX)
Soft Skills:
• An amiable, approachable nature
• A collaborative, team orientated approach
• Problem-solving skills and ability for critical thinking
• A desire to contribute, grow and develop with the business
Bonus, desirable bits:
• Proficient in Excel, including VBA experience
• Strong mathematical and statistical knowledge and skills
• Experience in using one or more statistical software packages (R, SPSS, SaS, Stata)
• Good understanding of Python, or other relevant coding languages
• PowerShell knowledge
• SharePoint experience
• Data Warehousing experience
• Degree in software engineering / computer science /Business Intelligence/ Data Science / Advanced Analytics or a data related field
Responsibilities will include:
• Using SQL to build, maintain and optimise complex data sets and associated reports
• Managing ETL process, including adapting and troubleshooting as required to ensure data consistency
• Carrying on data quality assessments, identifying gaps and performing remediation actions
• Communicating with stakeholders to understand data content and business requirements
• Preparing reports and create data dashboards, graphs, and visualisations for varying audiences within the business
• Producing and tracking key performance indicators
• Refining, updating, and timely distributing existing reports, ensuring they remain accurate and are fit-for-purpose as the business evolves
• Using statistical tools to analyse data and forecast trends with actionable business insights
• Processing and delivering solutions to the internal customer requests and queries in an efficiently and timely manner
• Helping to deliver a continuously improve strategy by proactively identifying data issues, investigating errors, fixing root cause issues, and recognizing improvement opportunities
• Promoting processes automation and self-serve solutions
• Training end-users about new reports and dashboards
• Maintaining awareness of technology changes within the BI industry
Technical Skills:
• Proven working experience in data analysis
• Proficient in MS SQL
• Experience with Azure and other data tools
• Strong knowledge of Power BI (plus DAX)
Soft Skills:
• An amiable, approachable nature
• A collaborative, team orientated approach
• Problem-solving skills and ability for critical thinking
• A desire to contribute, grow and develop with the business
Bonus, desirable bits:
• Proficient in Excel, including VBA experience
• Strong mathematical and statistical knowledge and skills
• Experience in using one or more statistical software packages (R, SPSS, SaS, Stata)
• Good understanding of Python, or other relevant coding languages
• PowerShell knowledge
• SharePoint experience
• Data Warehousing experience
• Degree in software engineering / computer science /Business Intelligence/ Data Science / Advanced Analytics or a data related field