(OBM) Business Analyst

1. Manage and maintain data structures within the Enterprise Data Warehouse, including tables, views, data marts, and semantic layers.
2. Ensure that data is organized according to agreed naming conventions, modelling standards, and governance principles.
3. Develop, maintain, and monitor ETL processes that extract, transform, and load data from source systems into the EDW.
4. Create and maintain SQL-based transformation logic to clean, standardize, enrich, and validate incoming data.
5. Identify data quality issues, investigate root causes, and work with relevant teams to resolve inconsistencies in source data or transformation logic.
6. Support automation and efficiency improvements in the data pipeline, reducing manual effort and improving reliability.
7. Prepare reliable and reusable datasets for Power BI reporting, including data marts, views, and semantic models.
8. Support Power BI developers and business users by ensuring that the underlying data is accurate, complete, and fit for purpose.
9. Contribute to the development of Power BI reports where needed, including data modelling, DAX logic, row-level security, and performance optimization.
10. Ensure consistency between EDW data definitions and Power BI reports to avoid conflicting numbers across the organization.
11. Apply version control principles using GitHub to manage SQL scripts, transformation logic, documentation, and development changes in a controlled and traceable way.
12. Contribute to a structured development workflow, including code reviews, documentation, testing, and deployment support.