At a Glance
- Tasks: Analyse data, build ETL processes, and create insightful reports using SQL and SSIS.
- Company: Join a growing analytics team in a supportive and collaborative environment.
- Benefits: Enjoy hybrid working flexibility and opportunities for professional growth.
- Other info: Perfect 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 in Lisburn employer: Ocho
Join a dynamic and growing analytics team in Lisburn, Northern Ireland, where you will thrive in a supportive and collaborative environment. With hybrid working options and a culture that encourages innovation, you'll have the chance to tackle complex data challenges while developing your skills in SQL, ETL, and reporting tools. This role not only offers meaningful work but also ample opportunities for professional growth and contribution to exciting data-driven projects.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst - SQL, SSIS 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 practical tests. Practice explaining your thought process when solving data challenges, as this will demonstrate your analytical skills and problem-solving abilities.
✨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 in Lisburn
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL and SSIS experience. We want to see how your skills match the job description, so don’t be shy about showcasing your relevant projects and achievements!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about data analysis and how you can contribute to our team. Keep it concise but engaging – we love a good story!
Show Off Your Technical Skills:Don’t forget to mention your experience with ETL processes and reporting tools like SSRS or Tableau. We’re looking for someone who can hit the ground running, so highlight any relevant projects or tools you’ve used.
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 Expertise
Since the role involves building and maintaining SSIS data integration processes, be ready to talk about your experience with ETL. Prepare examples of past projects where you've successfully implemented ETL processes and how they improved data handling.
✨Demonstrate Problem-Solving Skills
The job requires strong analytical and problem-solving abilities. Think of specific challenges you've faced in previous roles and how you overcame them. This will show your potential employer that you can tackle complex data issues effectively.
✨Familiarise Yourself with Reporting Tools
As the role involves using tools like SSRS, Tableau, or Power BI, make sure you know your way around at least one of these platforms. Be prepared to discuss any dashboards or reports you've created and how they contributed to decision-making in your previous roles.
