actionable insights and address reporting needs. Using data mining techniques to extract information from data sets and identify correlations and patterns Lead the data modelling, data mapping and data solution testing activity on projects within the role's remit Identify synergies across data requests from business stakeholders and deliver … the data pipelines as well as visualisations Identify opportunities to maximise data usage, applying modelling and optimization methods to enhance data assets and reporting products Review business processes and conceptualise the entities that interoperate within the business process, developing entity relationship diagrams to represent these connections. Work with multiple … Demonstrable experience of working in a data integration-related role, ETL processes and data warehousing principles A strong understanding and experience in key data modelling methodologies, techniques and concepts (dimensionalmodelling, entity relationship modelling, logical & physical models) Experience with at least one of the reporting tool more »
applies the enterprise data life cycle (creation, replication, archival, disposition of historical and PII data). - Responsible for evaluating and recommending data query and modelling tools to assist with data architecture activities, development and communication of best practices for those tools, and activities to improve effectiveness and quality. - Develops … with workflow management technologies such as Airflow, Oozie, Luigi, etc. - Experience working in public cloud environments like AWS and Azure. - Experience with (modern) data modelling languages like Data Vault, Dimensional models, etc. - Experience with (modern) data modelling Tools like Enterprise Architect (Sparx), Erwin, etc. - Experience with data more »
applies the enterprise data life cycle (creation, replication, archival, disposition of historical and PII data). Responsible for evaluating and recommending data query and modelling tools to assist with data architecture activities, development and communication of best practices for those tools, and activities to improve effectiveness and quality. Develops … with workflow management technologies such as Airflow, Oozie, Luigi, etc. Experience working in public cloud environments like AWS and Azure Experience with (modern) data modelling languages like Data Vault, Dimensional models, etc. Experience with (modern) data modelling Tools like Enterprise Architect (Sparx), Erwin, etc. Experience with data more »
Shefford, Bedfordshire, South East, United Kingdom Hybrid / WFH Options
Central Bedfordshire Council
migrate data to new target replacement systems Contribute to the CBC Azure Data Platform/Lakehouse projects by designing and implementing data warehouses and dimensional models Develop ETL data pipelines using Azure Data ETL tools such as Data Factory and Databricks. An understanding of legacy SSIS packages will be … have experience in Python/PySpark and T-SQL scripting, Azure Data Factory, Databricks, and Synapse Analytics, designing and implementing Data warehouses and associated dimensional models, and proficiency in reporting and analytics tools, such as PowerBI A strong background in developing ETL data pipelines with Azure Data ETL tools more »
PAW Direct experience using Business Intelligence (BI) and Visualization reporting tools ( Business Objects, Cognos, Tableau, SAP, etc.) Knowledge of Data Warehouse, BI, OLAP, and dimensionalmodelling Experience with SQL authoring and RDBMS databases Bachelor's Degree (BS/BA) in Computer Science, Accounting, Finance or related business/ more »