At a Glance
- Tasks: Design and optimise AWS data pipelines while enhancing reporting and analytics capabilities.
- Company: Join a forward-thinking company driving AI and data innovation.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Other info: Dynamic role with a mix of hands-on engineering and innovative project development.
- Why this job: Be at the forefront of AI-driven data solutions and make a real impact.
- Qualifications: Degree in Computing or related field; experience in BI and AWS required.
The predicted salary is between 60000 - 80000 £ per year.
We are seeking an experienced Business Intelligence Engineer with strong AWS Data Engineering capabilities to support the development of a modern data platform while contributing to emerging AI-driven initiatives. This role is ideal for a hands-on engineer who combines Business Intelligence expertise with AWS data engineering experience and has practical exposure to AI/ML technologies, tools, or initiatives. You will play a key role in enhancing reporting and analytics capabilities, supporting existing data services, and helping shape future data and AI solutions.
Key Responsibilities
- Design, develop, maintain, and optimise AWS-based data pipelines and platform components.
- Develop and support Power BI reports, dashboards, and analytical solutions across multiple business functions.
- Build and maintain robust data models and semantic layers within Power BI.
- Contribute to the development and enhancement of a modern data lake and data platform architecture.
- Support both BAU activities and the delivery of new data and analytics capabilities.
- Collaborate with stakeholders to gather requirements, define user stories, and translate business needs into technical solutions.
- Work closely with technical and business teams to support AI-related initiatives and roadmap delivery.
- Ensure best practices are followed for data quality, governance, security, and performance optimisation.
- Manage Power BI administration activities including access management, role-based security, subscriptions, and gateway configuration.
- Support migration of reporting and data workloads from legacy platforms into modern AWS and Power BI environments.
- Maintain code repositories and contribute to CI/CD and DataOps practices where applicable.
Core Technical Requirements
- Strong hands-on experience with Power BI report and dashboard development.
- Power BI administration, including security, access management, gateways, and subscriptions.
- Advanced SQL development and optimisation.
- AWS services including Athena, S3, Lambda, Glue, Redshift, EC2, and RDS.
- PostgreSQL, Postgres RDS, MySQL, and AWS Athena.
- Data modelling and semantic layer design.
- DAX query language.
- Python for data processing and pipeline development.
- GitHub and source code management.
- Agile delivery environments.
AI / ML Exposure (Essential)
You must demonstrate practical exposure to one or more of the following:
- Working with cloud-based AI services such as AWS Bedrock or similar platforms.
- Supporting AI-enabled products, workflows, or data solutions.
- Exposure to Generative AI technologies and prompt engineering concepts.
- Experience working alongside Data Science teams or supporting ML pipelines.
- Understanding of how AI capabilities can be integrated into data platforms and analytics solutions.
Please note that AI/ML does not need to be your primary specialism; however, practical exposure must be clearly demonstrated.
Experience Required
- Typically 4–8+ years of experience in Business Intelligence, Data Engineering, Analytics Engineering, or related disciplines.
- Proven track record delivering AWS-based data and analytics solutions.
- Strong experience developing Power BI reporting solutions in enterprise environments.
- Experience working with data warehouses, analytics platforms, and modern data architectures.
- Experience supporting and enhancing production reporting environments.
- Ability to engage effectively with technical and non-technical stakeholders.
Desirable Skills
- AWS Bedrock or other cloud AI services.
- Data lake implementation experience.
- Infrastructure as Code (Terraform).
- API integration experience.
- CI/CD and DataOps practices.
- Experience migrating reporting platforms and legacy data solutions.
- Experience working within complex, regulated, or public sector environments.
Role Split
- Approximately 50% Business Intelligence and Data Engineering delivery/support.
- Approximately 50% New capability development including data platform enhancement and AI initiatives.
Key Attributes
- Strong problem-solving and analytical mindset.
- Hands-on engineering approach with attention to detail.
- Comfortable working within evolving and fast-paced environments.
- Ability to bridge the gap between data engineering, analytics, and emerging AI use cases.
- Proactive, collaborative, and delivery-focused.
- Excellent communication and stakeholder engagement skills.
- Able to work independently while contributing effectively within cross-functional teams.
Qualifications Essential
Degree in Computing, Engineering, Data Science, Mathematics, or another numerate discipline.
Business Intelligence/ SQL Engineer employer: ALOIS UK
Join a forward-thinking company that values innovation and collaboration, where your expertise as a Business Intelligence/SQL Engineer will be pivotal in shaping cutting-edge data solutions. With a strong focus on employee growth, we offer extensive training opportunities and a supportive work culture that encourages creativity and teamwork. Located in a vibrant area, our modern office environment fosters a dynamic atmosphere, making it an excellent place for professionals eager to make a meaningful impact in the realm of data and AI.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence/ SQL Engineer
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or attend industry meetups. You never know who might have the inside scoop on job openings or can refer you directly to hiring managers.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI reports, AWS data pipelines, and any AI/ML projects you've worked on. This gives potential employers a tangible look at what you can do.
✨Tip Number 3
Prepare for interviews by brushing up on common technical questions related to SQL, AWS services, and data modelling. Practise explaining your past projects and how they relate to the role you're applying for.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Business Intelligence/ SQL Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with AWS, Power BI, and SQL. We want to see how your skills match the job description, 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 this role and how your background in Business Intelligence and AI/ML makes you a perfect fit for us. Keep it engaging and personal!
Showcase Your Technical Skills:When filling out your application, make sure to mention specific tools and technologies you’ve worked with, especially those listed in the job description. We love seeing hands-on experience with AWS services and data modelling!
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 to do!
How to prepare for a job interview at ALOIS UK
✨Know Your Tech Inside Out
Make sure you brush up on your AWS services, especially those mentioned in the job description like S3, Lambda, and Redshift. Be ready to discuss how you've used these tools in past projects, as well as your experience with Power BI and SQL. The more specific examples you can provide, the better!
✨Showcase Your AI/ML Exposure
Even if AI/ML isn't your main focus, it's crucial to demonstrate your practical exposure to these technologies. Prepare to talk about any projects where you've worked with AI services or supported ML pipelines. Highlight how you see AI integrating into data platforms and analytics solutions.
✨Prepare for Stakeholder Engagement
This role requires collaboration with both technical and non-technical stakeholders. Think of examples where you've successfully gathered requirements or translated business needs into technical solutions. Being able to communicate effectively across different teams will set you apart.
✨Emphasise Your Problem-Solving Skills
With a strong problem-solving mindset being a key attribute for this role, prepare to discuss challenges you've faced in previous positions and how you overcame them. Use the STAR method (Situation, Task, Action, Result) to structure your answers and make them impactful.
