As a Data Engineer – BI Analytics & DWH , you will play a pivotal role in designing and implementing comprehensive business intelligence solutions that empower our organization to make data-driven decisions. You will leverage your expertise in Power BI, Tableau, and ETL processes to create scalable architectures and interactive visualizations. This position requires a strategic thinker with strong technical skills and the ability to collaborate effectively with stakeholders at all levels.
Key Responsibilities:
• BI Architecture & DWH Solution Design: Develop and design scalable BI Analytical & DWH Solution that meets business requirements, leveraging tools such as Power BI and Tableau.
• Data Integration: Oversee the ETL processes using SSIS to ensure efficient data extraction, transformation, and loading into data warehouses.
• Data Modelling: Create and maintain data models that support analytical reporting and data visualization initiatives.
• Database Management: Utilize SQL to write complex queries, stored procedures, and manage data transformations using joins and cursors.
• Visualization Development: Lead the design of interactive dashboards and reports in Power BI and Tableau, adhering to best practices in data visualization.
• Collaboration: Work closely with stakeholders to gather requirements and translate them into technical specifications and architecture designs.
• Performance Optimization: Analyse and optimize BI solutions for performance, scalability, and reliability.
• Data Governance: Implement best practices for data quality and governance to ensure accurate reporting and compliance.
• Team Leadership: Mentor and guide junior BI developers and analysts, fostering a culture of continuous learning and improvement.
• Azure Databricks: Leverage Azure Databricks for data processing and analytics, ensuring seamless integration with existing BI solutions.