BI Developer

Position Summary: Reporting to the Director of Data Performance, the IT Programmer (SQL/BI) is instrumental in developing the BI and reporting systems and upgrading Sofina's data environment for relevance and modernization. This role contributes to shaping Sofina’s data landscape and improving insights to aid strategic decision-making. Success in this role relies on effective collaboration across teams, adept project management, and achieving a balance between maintaining existing systems and fostering innovation Key Accountabilities:

Design, develop and maintain efficient ETL processes from various data sources including ERP / OT systems and third party data Design, develop, and maintain SSAS multidimensional and tabular models to support efficient and accurate data analysis and reporting. Execute a comprehensive business intelligence strategy that addresses both the current SQL Server environment and the creation of a progressive data landscape. Develop and implement a unified data model that encompasses multiple ERP systems to elevate data quality and data literacy across Sofina. Develop visually engaging reports and dashboards utilizing SSRS and Power BI, delivering essential insights to finance, sales, supply chain and other reporting stakeholders. Monitor and enhance the performance of BI solutions, ensuring streamlined operations for both the current and forward-looking environments. Collaborate with cross-functional teams to understand business requirements and…