Data Engineer Lead

About the role:

As a Data Engineering Lead - 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.

What Youll Do:

• 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.