Job Description
From developing reporting capability for the business, providing data from Database/DW using SSIS, SSRS, Power BI, ETL and other Azure tools.
You will utilise your exceptional communication skills to interact with internal stakeholders and deliver across the various credit finance, ERP and CRM systems. As the business is continuing to develop its analytical and reporting capabilities so data integration and report development will help deliver key strategic changes for the business.
In this role you will be;
- Setup the Data Development environment for the use of Power BI so it can be used by key high-end users in the business in alignment with requirements for security and enterprise support as per the IT Operations
- Setup different sync processes based on the source system to land data in Azure This is basically including one of a combination of Azure Data Factory, Azure Data Sync, ETL.
- Create new reports as required by the business using SSRS which connect to the data warehouse.
- Maintain existing SSRS reports and respond to change requests.
- Ensure brand standards are met with layouts and use of report design patterns.
- Prioritise and action the list of change requests and bug fixes that have been identified by the business.
- Work closely with the Business Process and Systems team to ensure standards are developed for the various types of business users - remote travellers, store managers, iPhone consumers.
- Leverage Mobile reporting technologies.
- Leverage Application Insights from Azure and surface it in Power BI reports.
- Experienced in building / developing SSIS Frameworks
- Experience in Power BI will be an advantage
- Experience with the latest technology - SQL Server / Azure SQL
- Strong system integration experience
- Strong understanding of database schemas and tables
- Experience building data/reports from financial systems
- Extensive experience in the SQL Server database / Business Intelligence space
- Extensive experience in delivering reporting services - SSRS
- Experienced in building / developing SSIS Frameworks
- Very strong database development skills - Views, Security Models, Stored Procedures, Tables, indexing, Tables
- Experience with other languages, such as C#, PowerShell will be an advantage
