ingest data from new ERP system into Snowflake Architect and develop the Snowflake data warehouse to support reporting and analytics needs, incorporating existing SQL-Server based business logic, whilst optimising the warehouse structure for performance, scalability, and ease of use Ensure that the BI and Data … requirements into a delivered solution Experience with Power BI Desirable: Experience of Business Systems reporting, including ERP Understanding of the MS BI stack (SSIS, SSAS) Knowledge of Microsoft Dynamics AX or IFS Manufacturing and supply chain exposure Understanding of financial principles Experience of business KPI reporting Profile Key Skills & Experience … requirements into a delivered solution Experience with Power BI Desirable: Experience of Business Systems reporting, including ERP Understanding of the MS BI stack (SSIS, SSAS) Knowledge of Microsoft Dynamics AX or IFS Manufacturing and supply chain exposure Understanding of financial principles Experience of business KPI reporting Job Offer Opportunity to More ❯
Bristol, Lulsgate Bottom, Somerset, United Kingdom
Mackenzie Jones IT
. Role: Design & implementation of ETL/ELT processes. Centralise ERP data into Snowflake. Snowflake Data Warehouse - Architect & develop - support reporting, analytics & incorporate SQL Server. Translate business & technology requirements. System Architecture models. BI & Data - understand, qualify, design, build test & requirements. Transforming, storing & retrieving data. BI Infrastructure & Services … Warehousing solutions. Kimball Methodology - support analytics & reporting. Data Migration - mapping to new data sources. Converting business requirements - to technical solution. BI - Power BI SSIS & SSAS (Desirable) Business Systems Reporting (Desirable) ERP - Dynamics AX or IFS - (Desirable) Third-Party providers - collaborate & partner with external providers. Leadership - ability to lead a small … to communicate with technical & non-technical stakeholders. Excellent Communication skills. Keywords: Data Warehouse Lead, Data Warehousing, Data, BI, BI Lead, Snowflake, ETL, ELT, SSIS, SSAS, Kimball, ERP, Dynamics AX, Data Modelling, Data Migration, Data, Data Warehouse, Bristol, Permanent, T6/MN/(phone number removed). More ❯
. Role: Design & implementation of ETL/ELT processes. Centralise ERP data into Snowflake. Snowflake Data Warehouse - Architect & develop - support reporting, analytics & incorporate SQL Server. Translate business & technology requirements. System Architecture models. BI & Data - understand, qualify, design, build test & requirements. Transforming, storing & retrieving data. BI Infrastructure & Services … Party providers - partner with external providers - adherence to SLAs. Partner with senior stakeholders - deliver KPI reporting. Experience Required: ETL & ELT tools - data lifecycle. SQLServer & Snowflake - Data … Warehousing solutions. Kimball Methodology - support analytics & reporting. Data Migration - mapping to new data sources. Converting business requirements - to technical solution. BI - Power BI SSIS & SSAS (Desirable) Business Systems Reporting (Desirable) ERP - Dynamics AX or IFS - (Desirable) Third-Party providers - collaborate & partner with external providers. Leadership - ability to lead a small More ❯
