At a Glance
- Tasks: Develop Power BI reports and build a new Data Hub for analytics.
- Company: Join a forward-thinking organisation focused on data innovation.
- Benefits: Competitive daily rate, remote work, and opportunities for travel.
- Other info: Exciting role with potential for career growth in data analytics.
- Why this job: Make an impact by transforming data into actionable insights.
- Qualifications: Strong Power BI and SQL skills, with experience in data engineering.
The predicted salary is between 40000 - 48000 £ per year.
This is a superb interim opportunity for an accomplished, UK based Power BI Developer to play a key part in building our client's new Data Hub that will bring together data from all areas of the organisation onto a single platform for analytics and improving data in their key operational systems.
This position will play a critical role in developing Power BI Sales reports using Fabric Direct Lake Semantic Data Models. This Developer role will primarily be visual Power BI reporting using Fabric Direct Lake Semantic Data Models. However, additional Data Engineering skills with strong experience of data ingestion, transformation and aggregation using Pipeline Copy and Fabric Gen2 Dataflows best practices will be a big advantage.
The successful candidate will have experience in the following:
- Power BI technical skills: Strong in-depth knowledge of the Power BI desktop toolbox, BI storytelling skills, experience of reporting pipeline sales KPIs and understanding of sales terminology.
- SQL: Ability to write and reverse engineer complex SQL views, understanding of fiscal calendars (worked with retail/manufacturing calendars) - the building of structured data models.
- Business Process: Understanding the sales pipeline i.e. from quote to completed sale to work in progress.
- Multiple layout reporting: Experience of developing Desktop, Mobile and Tabular reports.
- Semantic Data modelling: Previous experience of Star Schemas.
- Data Engineering: Experience building Pipelines & Gen2 Dataflows for big data to an Enterprise standard, DAX skills.
- Fabric Direct Lake experience: Built Power BI reports using Fabric Direct Lake.
- Advanced relationships knowledge: Knows how to overcome common Sales relationship issues.
- Power BI admin.
- Business Analysis: Has conducted requirements gathering, process mapping, metric definition and KPI designs, must understand percentages and ratios.
Significant experience in data analytics, BI development, or data modelling roles is required. If your profile demonstrates strong and recent experience in the above areas, please submit your application to Jackie Dean at TXP for consideration.
Please note due to the high volume of applications and to ensure a fair process, we are unable to accept phone calls. All applications must be submitted online. Rest assured, our team will review your application and provide an update via email as soon as possible.
Power BI Developer - Fabric Direct Lake, SQL in Dudley employer: TXP
Join a forward-thinking organisation that values innovation and collaboration, offering a dynamic work culture where your contributions as a Power BI Developer will directly impact the development of a cutting-edge Data Hub. With remote working flexibility and opportunities for occasional travel to the West Midlands, you will enjoy a supportive environment that fosters professional growth and encourages the sharing of ideas. This role not only provides competitive compensation but also positions you at the forefront of data analytics, allowing you to enhance your skills in a rapidly evolving field.
StudySmarter Expert Advice🤫
We think this is how you could land Power BI Developer - Fabric Direct Lake, SQL in Dudley
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with Power BI or data analytics. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI projects, especially those using Fabric Direct Lake. This visual evidence of your expertise can really set you apart during interviews.
✨Tip Number 3
Prepare for the interview by brushing up on common Power BI scenarios and SQL challenges. Practising how to explain your thought process will help you shine when discussing your experience with sales KPIs and data models.
✨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 take the initiative to connect directly with us.
We think you need these skills to ace Power BI Developer - Fabric Direct Lake, SQL in Dudley
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your Power BI skills and experience with Fabric Direct Lake. We want to see how your background aligns with the role, so don’t be shy about showcasing your relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to tell us why you’re the perfect fit for this role. Share specific examples of your work with SQL and data modelling, and let your personality shine through!
Showcase Your Technical Skills:When detailing your experience, focus on your technical prowess in Power BI and SQL. We love seeing candidates who can write complex SQL views and have a solid understanding of data engineering practices.
Apply Through Our Website:Remember, all applications need to be submitted online. It’s the best way for us to keep track of everything, and it ensures your application gets the attention it deserves. So, head over to our website and get that application in!
How to prepare for a job interview at TXP
✨Know Your Power BI Inside Out
Make sure you’re well-versed in the Power BI desktop toolbox. Brush up on your skills with Fabric Direct Lake and be ready to discuss how you've used it in past projects. Prepare to showcase your BI storytelling abilities, as this will be crucial for presenting your reports effectively.
✨Master SQL and Data Modelling
Since you'll need to write and reverse engineer complex SQL views, practice doing this before your interview. Be prepared to explain your understanding of fiscal calendars and how they relate to structured data models. Highlight any experience you have with Star Schemas and how they can enhance reporting.
✨Demonstrate Your Data Engineering Skills
Familiarise yourself with building Pipelines and Gen2 Dataflows, as these are key components of the role. Be ready to discuss best practices for data ingestion, transformation, and aggregation. If you have examples of how you've implemented these in previous roles, share them!
✨Understand the Business Process
Show that you grasp the sales pipeline from quote to completed sale. Be prepared to discuss how you’ve conducted requirements gathering and process mapping in the past. Understanding metrics, KPIs, and how to define them will set you apart, so make sure you can talk about these confidently.
