At a Glance
- Tasks: Analyse data and create impactful reports using Microsoft tools and cloud technologies.
- Company: Join a forward-thinking IT consultancy in Swindon with a vibrant team culture.
- Benefits: Attractive salary, full-time hours, and opportunities for professional growth.
- Other info: Dynamic work environment with a focus on collaboration and innovation.
- Why this job: Make a difference by transforming data into insights that drive business decisions.
- Qualifications: Experience with SQL, Excel, and data visualisation tools is essential.
The predicted salary is between 32155 - 42598 £ per year.
Vacancies: 2
Job type: Permanent
Work Hours: Monday – Friday Full-Time (37.5 hours per week)
Salary: £32,155-£42,598 /Per Year
Job Work Location: Swindon (SN2)
Skills Required
- Microsoft SQL Server
- Oracle 10g/11g
- Operational knowledge of Unix / Linux for file transfers (FTP/SFTP)
- Working knowledge of Microsoft Azure Cloud
- SQL Loader
- Hands on skills on Microsoft Excel VLOOKUPs/Data Graphs
- Microsoft SSIS / ETL Packages
- JIRA / Confluence/Bugzilla
- Microsoft Visio
- Microsoft Office (Excel, PowerPoint, Word, Visio, Outlook)
Responsibilities
- Comparing reports data from legacy systems to newly migrating systems
- Experience in design, development, implementation, and ongoing support of existing reports and changes to the Microsoft reports
- Experience in creating business Intelligence reports in Power BI and Excel dashboard reports
- Experience with Business Intelligence reports and their data calculations
- Expert in using Microsoft Excel with VLOOKUps and compare the reports data
- Expert in creating datasets from databases systems with SQL Server & Oracle databases
- Participating in change control meetings
- Liasoning with other customer business departments like Sales teams and HR teams
- Gathering and analysing customer new reports requirements
- Reviewing customer and functional / technical specifications
- Meeting the clients for technical discussions
- Ability to work under pressure
- Data analysis using Microsoft Excel
- Working knowledge of Agile environment
- Working knowledge of Microsoft Project
- Working experience with Data visualizations tools like QlikView, Tableau
- Good interpersonal and organisational skills
- Good client facing skills
If you are interested, please apply on or before 10/10/2025.
Microsoft Data Analyst (IT Consultant) in Swindon employer: pcscs
Join our dynamic team as a Microsoft Data Analyst in Swindon, where we foster a collaborative work culture that prioritises employee growth and development. With competitive salaries and a commitment to work-life balance, we offer unique opportunities for professional advancement in a supportive environment, making us an excellent employer for those seeking meaningful and rewarding careers in IT consulting.
StudySmarter Expert Advice🤫
We think this is how you could land Microsoft Data Analyst (IT Consultant) in Swindon
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or even in person. Let them know you're on the hunt for a Microsoft Data Analyst role. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Prepare for interviews by brushing up on your technical skills. Make sure you can confidently discuss SQL Server, Power BI, and Excel VLOOKUPs. We recommend doing some mock interviews with friends or using online platforms to get comfortable.
✨Tip Number 3
Showcase your projects! If you've worked on any relevant data analysis projects, create a portfolio or a GitHub repository. This will give potential employers a taste of your skills and what you can bring to the table.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take that extra step to connect directly with us.
We think you need these skills to ace Microsoft Data Analyst (IT Consultant) in Swindon
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights the skills and experiences that match the job description. We want to see how your background in Microsoft SQL Server, Excel, and data analysis fits with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about the role and how your experience aligns with our needs. Don’t forget to mention your familiarity with tools like Power BI and JIRA.
Showcase Your Technical Skills:Since this role involves a lot of technical work, be sure to list your hands-on experience with SQL, Oracle, and any data visualisation tools you've used. We love seeing practical examples of your skills in action!
Apply Through Our Website:To make sure your application gets to us, apply directly through our website. It’s the best way to ensure we see your application and can consider you for the Microsoft Data Analyst position!
How to prepare for a job interview at pcscs
✨Know Your Tech Inside Out
Make sure you brush up on your skills with Microsoft SQL Server, Oracle, and Azure Cloud. Be ready to discuss specific projects where you've used these technologies, as well as any challenges you faced and how you overcame them.
✨Showcase Your Data Skills
Prepare to demonstrate your expertise in Excel, especially with VLOOKUPs and data visualisations. Bring examples of reports or dashboards you've created, and be ready to explain the thought process behind your designs.
✨Understand the Business Context
Familiarise yourself with how data analysis impacts business decisions. Be prepared to discuss how your work can support teams like Sales and HR, and think about how you can add value to their operations.
✨Practice Your Communication Skills
Since this role involves liaising with clients and other departments, practice explaining complex technical concepts in simple terms. Role-play potential interview questions with a friend to build your confidence.
