Patrick Kemboi

Power Bi Developer(Ssrs) @Optomi

Design, develop, and optimize scalable data pipelines using Azure Databricks, enabling efficient processing of large-scale datasets for analytics and reporting.• Build and manage ETL/ELT workflows to support data ingestion, transformation, and analysis from diverse sources into Azure-based data platforms.• Develop and orchestrate Databricks notebooks for data wrangling, cleansing, and enrichment, ensuring high-quality data feeds into Power BI dashboards.• Integrate Databricks Delta Lake with Azure Data Lake and Power BI, enabling real-time, reliable, and scalable data pipelines.• Leverage Spark SQL and PySpark within Databricks to perform complex data transformations and aggregations tailored to business reporting needs.• Create interactive and visually compelling Power BI dashboards and reports to support data-driven decision-making across business units.• Collaborate with stakeholders to gather and translate reporting requirements into technical specifications and scalable BI solutions.• Ensure data accuracy, quality, and consistency across all reporting tools and analytics platforms through rigorous validation and governance practices.• Implement data governance and security best practices in collaboration with IT and compliance teams, ensuring regulatory compliance and secure data handling.• Monitor, troubleshoot, and enhance the performance of data processing and reporting systems to maintain high availability and reliability.• Work closely with Data Engineers, Data Governance, and Business Analysts to align on data initiatives and deliver end-to-end analytics solutions.