Solution Architecture and Strategy:
o Collaborate with stakeholders to define the long-term BI strategy, including selecting appropriate tools and technologies.
o Design and develop data models, ETL (Extract, Transform, Load) packages, OLAP (Online Analytical Processing) cubes, and reports utilizing Power BI, while adhering to best practices.
o Document source-to-target mappings, data dictionaries, and database design.
o Work with APIs and tools like Postman to build and test APIs, integrating them seamlessly into the overall architecture.

2. Data Modeling and Governance:
o Develop and maintain reference architectures for reports based on various data sources (Data Warehouse, SharePoint, etc.).
o Ensure adherence to data governance standards, including proper data refreshes and publishing of common dataset hierarchies.
o Implement security measures to protect sensitive data.

3. Technical Leadership and Collaboration:
o Lead technical revie...