Senior Azure BI Engineer - Sri Lanka

Discovery Partners
Data solution architecture
  • Provide expert technical advice and guidance to strategize the setup, optimisation and life cycle management of the modern data platform
  • Provide expert technical advice and guidance to help scope out and design reporting solutions
  • Translate business requirements into technical data solutions
  • Develop innovative ETL approaches to bring a diverse set of on-prem and cloud-based data sources into the Data Lake
  • Identify and implement suitable data quality management and meta data management solutions
Azure platform development and management
  • Develop and operate the Azure BI platform. Design, develop, test, and roll-out effective Azure data repositories, such as databases, data marts, blob storage, and analytics models to deliver automated reporting, Power BI dashboards, and deploy data science capability
  • Develop Synapse Pipelines, and other data movement processes as required to support the Digital teams in reporting, auditing, and other data needs
  • Where necessary create new formats/processes or methodologies, document and communicate them to the wider BI community as needed to enhance the organisations capabilities
  • Develop and implement error and exception management processes, ensuring causes of poor data quality are identified and escalated to the business owners
  • Ensure the BI environment is proactively monitored, data flows from source systems are robust with adequate fault tolerance, the reporting layer is consistent, and new developments are designed in a modular fashion
  • Maintain and performance tune the cloud-based data storage solutions
  • Degree in computer science, information systems, or another related technical field
  • 4+ years of experience in Azure BI development
  • Possesses a background in software and/or database development and engineering, data architecture, and managing BI Solutions
  • Experience as a database or ETL developer preferable on SQL server platform
  • Experience of designing conceptual and logical data models
  • Hands-on experience with developing in BI cloud technologies in Azure including Data Factory , Synapse Pipelines and Power BI (DAX) and Microsoft Fabric Platform.
  • Extensive working experience of Microsoft BI solutions (SSIS, SSAS, SSRS)
  • Experience in troubleshooting and resolving database issues such as integrity, performance, replication, connectivity, recovery, and security
  • Experience in agile methodologies
  • Experience in preparing data for data science and Machine Learning
  • Design and development of best practice ETL flows, data stores, dimensional models, cubes
  • Data warehousing and best practice BI Architecture
  • Data aggregation and dimensional modelling, OLAP
  • Data preparation (sourcing, acquisition, integration)
  • Fluency with appropriate tools including Azure DevOps, Visual Studio other SQL Server Management tools
  • Hands on dev capability in Synapse / Fabric.
  • Awareness of best practice, trends, and evolutions in the IT industry and most particularly MS Azure technology stack.
Help provides instructions on how to use the SmartMatch™ site and to report bugs. For job-related inquiries please contact the employer.