Responsibilities: Data Architect
- Data modeling, ETL design, DataIQ tool.
- 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 data modelling, database design, and data administration is required. Mid-level to senior data architects frequently have 5 years or more of experience.
- Database Expertise: Knowledge of data warehousing ideas and proficiency in various database systems (e.g., SQL, NoSQL).
- Knowledge of data modelling tools such as Erwin, IBM Data Architect, or Microsoft Visio is required.
- Knowledge of ETL methods and technologies (for example, Apache NiFi, Talend, and Informatica).
- 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 Python or Java can be advantageous.