At a Glance
- Tasks: Analyse data, build ETL processes, and create insightful reports using SQL and various tools.
- Company: Join a growing analytics team in a supportive and collaborative environment.
- Benefits: Enjoy hybrid working flexibility and opportunities for professional growth.
- Other info: Ideal for those passionate about data and looking to make an impact.
- Why this job: Tackle complex data challenges and drive innovation in data handling.
- Qualifications: Strong SQL skills and experience with data integration and reporting tools.
The predicted salary is between 30000 - 40000 € per year.
Location: Lisburn, Northern Ireland (Hybrid flexibility available)
Eligibility: UK work authorisation required (no sponsorship available)
We're working with a growing analytics and data team looking for a Data Analyst with strong SQL and data integration experience to support a range of high-volume, data-driven operational projects. This role offers a strong mix of SQL development, ETL, automation, reporting, and process improvement work, with the opportunity to contribute to technical innovation and smarter ways of handling data across the business.
- Varied role combining SQL, ETL, reporting, and automation
- Opportunity to work on complex, high-volume data challenges
- Supportive and collaborative team environment
- Hybrid working and flexible culture
What you'll be doing:
- Building and maintaining SSIS data integration and ETL processes
- Writing SQL scripts for data cleansing, reconciliation, reporting, and automation
- Integrating data from XML, Excel, flat files, and external systems
- Developing dashboards and MI reporting using SSRS, Tableau, or Power BI
- Supporting automated document handling and data quality initiatives
- Working closely with operational and client-facing teams on data-related projects
- Contributing to process improvements and technical innovation initiatives
What you'll bring:
- Strong SQL/T-SQL development skills
- Experience with SSIS and ETL/data integration processes
- Experience working with relational databases
- Exposure to reporting tools such as SSRS, Tableau, or Power BI
- Strong analytical and problem-solving skills
- Good communication skills and attention to detail
Nice to have:
- Experience with Python, R, C# and Cloud platforms
- Exposure to NLP, or AI-driven data extraction
- Experience within financial services or regulated environments
If you enjoy solving complex data challenges across SQL, automation, reporting, and integration work, get in touch with Justin Donaldson for a confidential conversation.
Data Analyst - SQL /SSIS/SSRS in Lisburn employer: Ocho
Join a dynamic and innovative analytics team in Lisburn, Northern Ireland, where your expertise as a Data Analyst will be valued and nurtured. With a strong focus on collaboration and flexibility, we offer a supportive work culture that encourages professional growth through challenging projects and technical innovation. Enjoy the benefits of hybrid working while tackling complex data challenges in a role that promises both meaningful impact and rewarding experiences.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst - SQL /SSIS/SSRS in Lisburn
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL scripts, ETL processes, and any dashboards you've developed. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common data-related questions and scenarios. Practice explaining your past projects and how you tackled complex data challenges – this is your chance to shine!
✨Tip Number 4
Don't forget to apply through our website! We love seeing candidates who are genuinely interested in joining our team. Plus, it makes it easier for us to keep track of your application and get back to you quickly.
We think you need these skills to ace Data Analyst - SQL /SSIS/SSRS in Lisburn
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL and data integration skills. We want to see how your experience aligns with the role, so don’t be shy about showcasing relevant projects or achievements!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re excited about the Data Analyst position and how your background makes you a perfect fit for our team at StudySmarter.
Showcase Your Technical Skills:Since this role involves SQL, SSIS, and reporting tools, make sure to mention any specific projects where you’ve used these technologies. We love seeing real-world applications of your skills!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Ocho
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss your experience with writing SQL scripts, data cleansing, and reporting. Practising common SQL queries and understanding how to optimise them can really set you apart.
✨Showcase Your ETL Experience
Since this role involves building and maintaining SSIS data integration processes, be ready to talk about your past projects involving ETL. Highlight specific challenges you faced and how you overcame them, as well as any automation techniques you've implemented.
✨Familiarise Yourself with Reporting Tools
The job mentions tools like SSRS, Tableau, and Power BI, so it’s a good idea to have a solid grasp of at least one of these. Prepare to discuss how you've used these tools in previous roles to create dashboards or reports that drove decision-making.
✨Communicate Clearly and Confidently
Good communication skills are essential for this role, especially when working with operational and client-facing teams. Practice explaining complex data concepts in simple terms, and be ready to demonstrate your analytical thinking during the interview.
