At a Glance
- Tasks: Join a dynamic team to analyse data and create impactful reports.
- Company: Innovative Treasury Technology team with a global presence.
- Benefits: Competitive salary, flexible work options, and opportunities for growth.
- Why this job: Make a real difference in financial analytics and reporting.
- Qualifications: Experience in T-SQL, DAX, and data warehousing is essential.
- Other info: Collaborative environment with strong focus on professional development.
The predicted salary is between 36000 - 60000 Β£ per year.
Joining the Treasury Technology team. The team currently has a presence in London and New York and is responsible for providing software and data solutions to enhance and support Cash Management, FX Funding, Treasury Analytics and Liquidity. Working closely with the global team.
Responsibilities:
- Work with other teams to source and ingest data in a variety of forms
- Collaborate with a team of developers using dev ops tools like GIT and CI
- Ingest data into a data warehouse with ELT processes using T-SQL
- Develop and maintain OLAP databases and SSAS cubes
- Create reports and dashboards in Power BI and SSRS
- Writing performant and maintainable code to provide value from data
- Adhere to project deadlines
Qualifications:
- Excellent technical aptitude β T-SQL, DAX, SSAS Tabular, Python etc.
- 2-6 years+ experience gained in a similar environment
- Strong analytical & problem-solving skills with a logical approach
- Knowledge of data warehousing and data processing concepts
- Able to work collaboratively
- Excellent data analytical skills β Data mining / discovery
- Good communication skills, able to convey concepts
- Good business knowledge of Fixed Income and Equities, Repos and STBL
- Good understanding of Treasury
BI Developer (Business Intelligence) employer: Jefferies
Contact Detail:
Jefferies Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land BI Developer (Business Intelligence)
β¨Tip Number 1
Network like a pro! Reach out to folks in the Treasury Technology space on LinkedIn or at industry events. A friendly chat can open doors that a CV just can't.
β¨Tip Number 2
Show off your skills! Create a portfolio showcasing your work with SQL Server, SSAS Tabular models, and Power BI dashboards. This gives us a tangible way to see what you can do.
β¨Tip Number 3
Prepare for those interviews! Brush up on your knowledge of Equities, Fixed Income products, and Treasury functions. We want to see that you understand the business as much as the tech.
β¨Tip Number 4
Apply through our website! Itβs the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining our team.
We think you need these skills to ace BI Developer (Business Intelligence)
Some tips for your application π«‘
Tailor Your CV: Make sure your CV is tailored to the BI Developer role. Highlight your experience with T-SQL, DAX, and SSAS Tabular models, as well as any relevant projects you've worked on that showcase your analytical skills.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about the Treasury function and how your background in data warehousing and analytics makes you a perfect fit for our team.
Showcase Your Technical Skills: Donβt forget to mention your technical aptitude! Include specific examples of how you've used Python, Power BI, or other tools to solve problems or improve processes in your previous roles.
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. Itβs the easiest way for us to see your application and get you into the process!
How to prepare for a job interview at Jefferies
β¨Know Your Tech Inside Out
Make sure you brush up on your T-SQL, DAX, and SSAS Tabular skills. Be ready to discuss how you've used these technologies in past projects, as well as any challenges you faced and how you overcame them.
β¨Understand the Treasury Function
Familiarise yourself with the basics of Treasury operations, including Cash Management, FX Funding, and Liquidity. Being able to speak knowledgeably about these areas will show that you're not just a tech whiz but also understand the business context.
β¨Showcase Your Collaboration Skills
Since you'll be working closely with other teams, prepare examples of how you've successfully collaborated in the past. Highlight your experience with dev ops tools like GIT and CI, and how these have helped streamline your work.
β¨Prepare for Problem-Solving Questions
Expect to face questions that test your analytical and problem-solving skills. Think of specific scenarios where you've had to analyse data or troubleshoot issues, and be ready to walk the interviewer through your thought process.