Design and develop ETL, data integration, data warehouse, data models, and BI reporting solutions. Ensure quality, performance, and standards across the BI team and support junior developers.
RequirementsResponsibilities
- Analyse, design, develop, troubleshoot, and support enterprise reporting and analytics platforms.
- Build and implement reports, dashboards, visualisations, and drill-downs.
- Develop BI solutions using SQL, Azure Data Factory, Synapse Pipelines, SSIS, SSAS, Power BI, and the Microsoft BI Stack.
- Integrate data from multiple source systems (In-house, Vendor, On-prem, Cloud, O365).
- Perform database development: queries, views, schema objects, data models, hierarchies.
- Apply database performance tuning.
- Work with DevOps on database-related changes and Azure DevOps documentation.
- Enforce database security and review BI code.
- Oversee solution quality and mentor junior/intermediate team members.
- Drive innovation in data architecture and support large-scale projects with the Lead Developer.
Qualifications
- 3/4-year IT degree/diploma in Software Development.
- Relevant Microsoft Data certifications.
Experience
- Full BI development lifecycle.
- 6+ years IT experience, 4+ in BI/Data Analytics.
- Experience managing data projects.
- Strong experience with Azure Data Factory/Synapse, SSIS, SSAS, Power BI, SQL Server.
Key Skills
- Knowledge of insurance/accounting principles (advantage).
- Strong understanding of data warehousing, modelling, transformation, reporting, DTS, FTP.
- Excellent troubleshooting ability.
- Experience with relational & multi-dimensional databases, BI mobile deployment, dashboard delivery.
- Strong SQL and data modelling skills.
- Excellent communication, ability to work independently and in a team.
- Financial services/insurance industry knowledge is beneficial.
Desired Skills:
- Power BI
- SQL
- Data Warehouse
- Azure Data Factories
- Azure Synapse Analytics
Desired Qualification Level:
- Diploma
About The Employer: