We are seeking a skilled BI Specialist/SQL Developer on a contract basis to join a financial services company. This role is pivotal in transforming the reporting processes by leveraging modern BI tools and enhancing data-driven decision-making across the organization.
Key Responsibilities
Report Transformation: Transition reports from legacy BI tools and MS Excel to modern reporting platforms, primarily Power BI.
Automation & Efficiency: Develop automated reporting processes to allow business areas to focus on data analysis rather than report creation.
Tool Selection: To optimise reporting efficiency and evaluate and recommend the most suitable BI tools for other business areas.
Dashboard Creation: Design and generate insightful Power BI dashboards and other reporting outputs.
Agile Methodology: Operate within Scrum or Kanban frameworks as required, ensuring flexibility and adaptability in project execution.
Performance & Security: Implement best practice performance optimization and security measures across all reporting tools.
Stakeholder Engagement: Collaborate with stakeholders through workshops to swiftly and effectively gather reporting requirements.
Documentation: Maintain thorough documentation of report creation processes and methodologies on Confluence.
Required Skills
BI / Reporting Expertise: Proven experience as a BI and Reporting Developer.
Power BI: Proficiency in using Power BI is essential.
T-SQL & Database Skills: Strong skills in T-SQL, including the creation of stored procedures and functions.
Ideal Skills
Power Query: Experience with Power Query is highly desirable.
SSRS/SSIS: Familiarity with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) is beneficial.
Excel: Advanced skills in Excel for data manipulation and reporting.
Alteryx, SAS, Spotfire: Experience with these tools is a plus, but not mandatory.
Additional Information
Contract Position: This is a contract role with the potential for extension based on project requirements and performance.
Work Environment: The role requires adaptability to work within an Agile environment, fostering collaboration and quick iteration.
Location: The position may offer flexibility regarding remote work; specifics to be discussed during the hiring process.