Business Intelligence Specialist
CurrentETL Architecture:Spearhead the development and management of ETL pipelines through Azure Data Factory, integrating data from SAP BW, HANA S4, QP1, amongst other sources into our SQL Management Server. Responsible for the activation and maintenance of these pipelines, ensuring robust data flow and storage solutions as the designated Data Storage Contributor.Data Modeling Expert:Design and maintain advanced SQL data models, including FACT tables for critical business reports. Utilize the STAR schema in Power BI to enhance data retrieval and dashboard performance.Business Intelligence Developer:Create and manage comprehensive Power BI dashboards based on detailed scoping documents. These dashboards serve our primary stakeholders, including C-level executives and department leaders in Product Management, Global Pricing, Finance, and Sales. Implement complex DAX measures for dynamic financial analytics, maintaining high data integrity across large datasets.Trainer and Security Manager:Conduct targeted training sessions for various stakeholders to ensure effective utilization of BI tools. Oversee access control and implement security measures to safeguard sensitive data.Documentation and Governance Specialist:Develop thorough documentation and a comprehensive data dictionary that detail each process stage, data column usage, sources, naming conventions, and filters. Ensuring transparency and consistency in data handling and usage across teams.