At a Glance
- Tasks: Design and develop reporting solutions using Power BI and SQL.
- Company: Join a dynamic team focused on innovative data solutions.
- Benefits: Enjoy flexible working options and opportunities for professional growth.
- Why this job: Make an impact by transforming data into insightful reports for stakeholders.
- Qualifications: Strong T-SQL skills and experience with Power BI and SSRS required.
- Other info: Ideal for tech-savvy individuals eager to enhance their data engineering skills.
Your new role will help design, develop, support and enhance the use of MS SQL and related reporting solutions, dashboards, and other visual summaries of application data to communicate performance and progress to various stakeholders across a range of business applications.
Key Responsibilities:
- Development and maintenance of integrated reporting solutions across a range of business applications
- Report development in Power BI Suite
- Migration of SSRS reports to Power BI
- Integrity and audit check data for application into reporting solutions
- Maintain understanding of various business application database structures
- Act as SQL technical authority to Engineering team with ability to optimise and enhance SQL queries
- Investigate and maintain alternative delivery formats (e.g. dashboards, grouping, drilldown, matrix (pivoted)) to achieve maximum benefit from the underlying data
What you'll need to succeed:
Essential:
- Excellent skills in T-SQL and SQL Server
- Experience of Migration of SSRS to Power BI
- Experience in building dashboards and reports using Power BI
- Experience in SSRS
Highly Desirable:
- Experience of undertaking performance reviews and optimisation activities
- Experience in data warehousing and cubes
- Experience of MS Fabric and Azure Data Landscape
Desirable:
- Experience of SSIS data import packages using ETL procedures
- Power Automate for Report Distribution
Report Engineer - Power BI/SSRS employer: Hays Technology
Contact Detail:
Hays Technology Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Report Engineer - Power BI/SSRS
✨Tip Number 1
Familiarise yourself with the latest features of Power BI and SSRS. Being up-to-date with the tools will not only boost your confidence but also demonstrate your commitment to continuous learning during any discussions.
✨Tip Number 2
Network with professionals in the field of data reporting and analytics. Attend relevant meetups or webinars where you can connect with others who might provide insights or even referrals for the role.
✨Tip Number 3
Prepare to discuss specific projects where you've successfully migrated reports from SSRS to Power BI. Highlighting your hands-on experience will set you apart from other candidates.
✨Tip Number 4
Showcase your problem-solving skills by thinking of examples where you've optimised SQL queries or improved reporting processes. This will illustrate your ability to add value to the team right from the start.
We think you need these skills to ace Report Engineer - Power BI/SSRS
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with T-SQL, SQL Server, and Power BI. Use specific examples of projects where you've developed reports or dashboards to demonstrate your skills.
Craft a Strong Cover Letter: In your cover letter, explain why you're interested in the Report Engineer role and how your background aligns with the key responsibilities. Mention your experience with migrating SSRS reports to Power BI and any relevant performance optimisation activities.
Showcase Relevant Skills: Clearly list your technical skills related to the job description, such as experience with data warehousing, ETL procedures, and Power Automate. This will help you stand out to the hiring team.
Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a role involving data integrity and reporting.
How to prepare for a job interview at Hays Technology
✨Showcase Your SQL Skills
Make sure to highlight your expertise in T-SQL and SQL Server during the interview. Be prepared to discuss specific projects where you optimised queries or developed reporting solutions, as this will demonstrate your technical authority.
✨Discuss Migration Experience
Since the role involves migrating SSRS reports to Power BI, be ready to share your experience with this process. Talk about any challenges you faced and how you overcame them, as well as the benefits that resulted from the migration.
✨Prepare for Technical Questions
Expect technical questions related to Power BI and SSRS. Brush up on your knowledge of building dashboards and reports, and be ready to explain your approach to data integrity and audit checks in reporting solutions.
✨Understand Business Application Structures
Familiarise yourself with various business application database structures. Being able to discuss how these structures impact reporting will show your understanding of the broader context in which your technical skills are applied.