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.