About the position
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:
About The Employer: