Data Architect - Data Warehousing

Description

Key Responsibilities

• Creating data models that specify how data is formatted, stored, and retrieved inside an organisation. This comprises data models that are conceptual, logical, and physical.
• Creating and optimising databases, including the selection of appropriate database management systems (DBMS) and the standardisation and indexing of data.
• Creating and maintaining data integration processes, ETL (Extract, Transform, Load) workflows, and data pipelines to seamlessly transport data between systems.
• Collaborating with business analysts, data scientists, and other stakeholders to understand data requirements and align architecture with business objectives.
• Stay current with industry trends, best practices, and advancements in data management through continuous learning and professional development.
• Establishing processes for monitoring and improving the quality of data within the organisation.
• Implement data quality tools and practices to detect and resolve data issues.

• Prior experience in designing Data Warehouse, data modelling, database design, and data administration is required.
• Database Expertise: Knowledge of data warehousing ideas and proficiency in various database systems (e.g., SQL).
• Knowledge of data modelling tools such as Visual Paradigm is required.
• Knowledge of ETL methods and technologies (for example, Azure ADF, Events).
• Expertise writing complex stored procedures.
• Good understanding of Data Modelling Concepts like Star Schema ,SnowFlake etc
• Strong problem-solving and analytical skills are required to build effective data solutions.
• Excellent communication skills are required to work with cross-functional teams and convert business objectives into technical solutions.
• Knowledge of Data Governance: Understanding data governance principles, data security, and regulatory compliance.
• Knowledge of programming languages such as .net can be advantageous.

About ParentPay Group