At a Glance
- Tasks: Join us as a Business Intelligence Analyst, optimising SQL queries and building insightful reports.
- Company: Ascendion is a global leader in AI-first software engineering, transforming businesses across continents.
- Benefits: Enjoy opportunities for project extensions, remote work options, and a supportive referral policy.
- Why this job: Work on exciting projects in AI, data science, and cloud engineering while enhancing your skills.
- Qualifications: 5+ years in BI or data analytics with strong SQL/T-SQL and Excel skills required.
- Other info: Experience with Power BI or Sisense is a plus; exposure to ETL processes is beneficial.
The predicted salary is between 36000 - 60000 £ per year.
We are seeking a highly skilled Business Intelligence (BI) Analyst with 5+ years of experience to support multiple BI domains across the organization.
- Collaborate with stakeholders and engineering teams to gather and interpret data requirements.
- Develop and optimize queries using SQL/T-SQL.
- Build and analyze reports using Excel and BI tools such as Sisense and Power BI.
- Support data modeling efforts and contribute to data warehousing strategies.
- Understand and support ETL processes, with exposure to SSIS being a plus.
Requirements:
- 5+ years in BI or data analytics roles.
- Strong SQL/T-SQL and Excel proficiency.
- Experience with Sisense or Power BI.
- Exposure to data modeling, data warehousing, and ETL processes.
Ascendion is a global, leading provider of AI-first software engineering services, delivering transformative solutions across North America, APAC, and Europe. We combine technology and talent to deliver tech debt relief, improve engineering productivity solutions, and accelerate time to value, driving our clients’ digital journeys with efficiency and velocity. Guided by our “Engineering to the power of AI” methodology, we integrate AI into software engineering, enterprise operations, and talent orchestration, to address critical challenges of trust, speed, and capital. At Ascendion you have high chances of project extension or redeployment to other clients. We have a referral policy in place.
Business intelligence Analyst - SQL/ Power BI employer: Ascendion
Contact Detail:
Ascendion Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business intelligence Analyst - SQL/ Power BI
✨Tip Number 1
Familiarise yourself with the specific BI tools mentioned in the job description, especially Power BI and Sisense. Consider creating a portfolio of sample reports or dashboards that showcase your skills in these tools to demonstrate your expertise during interviews.
✨Tip Number 2
Network with current or former employees at Ascendion or similar companies. Engaging with them on platforms like LinkedIn can provide you with insights into the company culture and expectations, which can be invaluable during your interview.
✨Tip Number 3
Brush up on your SQL/T-SQL skills by working on real-world projects or challenges. Websites like LeetCode or HackerRank offer SQL exercises that can help you refine your query optimisation skills, which is crucial for this role.
✨Tip Number 4
Prepare to discuss your experience with data modelling and ETL processes in detail. Be ready to share specific examples of how you've contributed to data warehousing strategies in previous roles, as this will show your depth of knowledge and practical experience.
We think you need these skills to ace Business intelligence Analyst - SQL/ Power BI
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience in business intelligence, particularly with SQL/T-SQL and Power BI. Use specific examples of projects you've worked on that demonstrate your skills in data analysis and reporting.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention how your 5+ years of experience align with their needs, and provide examples of how you've successfully collaborated with stakeholders to gather and interpret data requirements.
Showcase Relevant Skills: Clearly outline your proficiency in Excel, Sisense, and any exposure to ETL processes. If you have experience with SSIS, be sure to mention it as it could set you apart from other candidates.
Proofread Your Application: Before submitting, carefully proofread your application materials. Look for any spelling or grammatical errors, and ensure that all information is accurate and presented professionally.
How to prepare for a job interview at Ascendion
✨Showcase Your SQL Skills
Be prepared to discuss your experience with SQL and T-SQL in detail. You might be asked to solve a problem or optimise a query on the spot, so brush up on your technical skills and be ready to demonstrate your proficiency.
✨Familiarise Yourself with Power BI
Since the role requires experience with Power BI, make sure you can talk about specific projects where you've used this tool. Highlight any dashboards or reports you've created and be ready to explain your design choices and the impact they had.
✨Understand Data Warehousing Concepts
The job involves data modelling and warehousing strategies, so be prepared to discuss your understanding of these concepts. Think of examples from your past work where you contributed to data warehousing efforts and how it benefited the organisation.
✨Prepare for Behavioural Questions
Expect questions that assess your collaboration skills, especially since you'll be working with stakeholders and engineering teams. Use the STAR method (Situation, Task, Action, Result) to structure your answers and provide clear examples of how you've successfully worked in a team.