At a Glance
- Tasks: Create interactive dashboards and reports that drive business decisions.
- Company: Join a forward-thinking team at EcoOnline, focused on data-driven insights.
- Benefits: Enjoy competitive pay, flexible work options, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on innovation and data integrity.
- Why this job: Be part of a dynamic team shaping the future of data governance and analytics.
- Qualifications: 2+ years in Power BI, SQL, and advanced Excel skills required.
The predicted salary is between 35000 - 45000 € per year.
Requirements
- Proven track record building highly interactive, stakeholder‑driven dashboards — able to translate business needs into meaningful reports by challenging assumptions and aligning insights to the underlying data.
- 2+ years experience working with Power BI and DAX.
- 2+ years experience working with SQL, preferably T‑SQL.
- Advanced Excel skills (knowledgeable using formulas, pivot tables, troubleshooting formulas, and optimizing performance of workbooks).
- Salesforce Sales Cloud experience, preferably with CPQ.
- Microsoft ERP experience, preferably with Finance and Operations (F&O) or Microsoft Dynamics AX.
What the job involves
- As a relatively new, centralised team—bringing together talent from across the business—we’re building the foundations for how EcoOnline uses data to make decisions.
- Our ambition is to deliver a trusted, standardised suite of dashboards and reports that leaders and teams can confidently rely on, while also enabling a scalable self‑service reporting model that puts insights into more hands, faster.
- Crucially, we’re doing this with governance at the core: striking the right balance between speed and agility on the one hand, and accuracy, data quality, and security on the other.
- The result is a data ecosystem that empowers the business without compromising trust.
- Responsible for delivering and maintaining a portfolio of dashboards and key reports across multiple business areas, supporting several teams simultaneously in collaboration with the Business Intelligence Lead.
- Accountable for capturing and understanding requirements in a timely fashion.
- Communicating timelines and expectations for delivery on an ongoing basis with stakeholders.
- Communicating requirements to the engineering team for development of database tables/views.
- Ensure data integrity and quality by defining and applying validation checks, reconciling data issues, and implementing data governance practices.
- Stay up to date with BI and analytics trends, tools, and techniques to propose and drive improvements in best practices for BI, documentation, testing, and team processes.
Business Intelligence Analyst in Edinburgh employer: Deepstreamtech
At EcoOnline, we pride ourselves on being an excellent employer that fosters a collaborative and innovative work culture. As a Business Intelligence Analyst in our centralised team, you will have the opportunity to shape our data-driven decision-making processes while enjoying comprehensive employee growth opportunities and a commitment to work-life balance. Our location offers a vibrant environment that encourages creativity and teamwork, making it an ideal place for professionals looking to make a meaningful impact.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Analyst in Edinburgh
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with people 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 dashboards and reports. Use real data to demonstrate how you can turn insights into action. This will make you stand out when chatting with potential employers.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and Power BI skills. Be ready to discuss how you've tackled challenges in previous roles and how you can contribute to building that trusted suite of dashboards at EcoOnline.
✨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 are proactive about their job search!
We think you need these skills to ace Business Intelligence Analyst in Edinburgh
Some tips for your application 🫡
Showcase Your Dashboard Skills:Make sure to highlight your experience in building interactive dashboards. We want to see how you've translated business needs into meaningful reports, so share specific examples that demonstrate your ability to challenge assumptions and align insights with data.
Be Specific About Your Tech Skills:When listing your skills, be clear about your experience with Power BI, DAX, SQL, and Excel. We love details, so mention any advanced techniques you've used, like optimising performance or troubleshooting formulas. This helps us see how you can contribute to our team.
Communicate Clearly:Your written application should reflect your communication skills. Keep it concise and ensure you articulate your understanding of the role and its requirements. Remember, we value clarity and precision, just like we do in our dashboards!
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 gives you a chance to explore more about what we do at StudySmarter!
How to prepare for a job interview at Deepstreamtech
✨Know Your Dashboards
Make sure you can talk confidently about your experience building interactive dashboards. Be ready to share specific examples of how you've translated business needs into meaningful reports, and don't shy away from discussing any challenges you faced and how you overcame them.
✨Brush Up on Your Tech Skills
Since the role requires expertise in Power BI, DAX, SQL, and Excel, we recommend you review these tools before the interview. Prepare to discuss how you've used advanced Excel features like pivot tables and formulas, and be ready to demonstrate your SQL knowledge with practical examples.
✨Understand the Business Context
Familiarise yourself with EcoOnline's business model and how data impacts decision-making. This will help you align your answers with their goals and show that you're not just a tech whiz but also understand the bigger picture of how your work contributes to the organisation.
✨Communicate Clearly and Effectively
As you'll be working closely with stakeholders, practice articulating your thoughts clearly. Be prepared to explain complex data concepts in simple terms, and think about how you would communicate timelines and expectations for project delivery to non-technical team members.
