Reformatting a BI/Data Engineer role for {company}. Key responsibilities include:
* Design, develop and maintain ETL solutions ensuring seamless data flow across multiple sources.
* Maintain and document Data Lake and Data Warehouse structures for clarity and consistency.
* Collaborate with DBA and IT Support teams to manage data integration points and accessibility.
* Work closely with BI and business teams to identify opportunities where data drives valuable insights.
The ideal candidate has:
* Proven experience with the Microsoft SQL Server stack (SSIS, SSAS, SSRS).
* Strong expertise in SQL Server development (T-SQL, Stored Procedures, Functions).
* A deep understanding of relational and dimensional data modelling and data warehouse design.