Lloyd - Business Intelligence Analyst/Specialist

Role purpose:

We are seeking an experienced Business Intelligence Developer with 3-4 years' experience to work with key business stakeholders to identify and deliver BI reports. We are building a Data Analytics Platform using Azure technologies - Azure Data Lake, Azure Data Warehouse / Synapse, Power BI etc. This platform will ingest, transform, prepare and train data from disparate source systems including SAP, Oracle, Salesforce.com etc.

We are looking for an individual with strong skills in Power BI, T-SQL, Azure Data Factory, Azure Data Warehouse / Synapse. The Business Intelligence Developer will be responsible for role-based and data-level security of reports including managing platform access for external data exchange with customers and regulatory bodies.

The Business Intelligence Developer will develop reports for users, during which time he / she will gain understanding of the business and existing data structures and processes, expanding their skills as required with the platforms used by the company. The individual will work collaboratively with business stakeholders in developing new and refining existing data models / reports / processes.

Key Responsibilities:

1. Build and enhance existing data models in Azure Datawarehouse / Synapse to meet reporting requirements

2. Design and build reports and dashboards and assist in development of complex ad hoc queries and analyses in Power BI

3. Design and build reports role-based and data-level security models for both internal and external clients

4. Create ETL procedures, T-SQL queries, indexes on Azure Synapse SQL DW

5. Manage security-based data exchanges with external clients and regulatory bodies

6. Own the release management process and deployments to all environments

7. Support user community on Power BI technology and functionality

8. Work with infrastructure team and Microsoft to ensure system reliability

9. Conduct activities in line with internal procedures, legislation and industry standards.

10. To pursue Continuous Professional Development and maintain a high degree of discipline knowledge and awareness.

11. To mentor/coach other specialist employees to achieve effective specialist knowledge transfer and application.

12. Ensures documentation/data/information and tasks relevant to the section are planned, evaluated and processed in accordance with local business requirements and agreed deadlines.

13. Review & analyse data to provide management information/statistics, including the identification and reporting of process failures, to support the overall delivery of processes.

Technical / Professional Qualifications / Requirements:

1. Sound knowledge and experience of building Power BI based reports and dashboards

2. Good understanding of data warehouse principles and data modelling - Star Schema/Snwoflake Schema for reporting

3. Good hands-on Azure Data Factory, Azure Data Lake, Azure Synapse Datawarehouse

4. Strong experience of T-SQL, Power Query, DAX and other query processing languages

5. Basic experience of Big Data Technologies - Hadoop, Batch processing, Streaming technologies

6. Data Science experience using Python, Scala, R would be desirable

7. Experience in Machine Learning and Artificial Intelligence for Predictive Analytics would be an advantage