SQL Developer / Business Intelligence Specialist

Job Specification for BI Specialist/SQL Developer

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.