Data Architect

POSITION SUMMARY

The Data Architect is responsible for designing and visualizing overall enterprise data management framework. This Data Management Framework describes the processes to execute for planning, creation, maintenance, usage, archiving, retrieval, control (secure), and cleanup of data. The Data Architect works with other architects and stakeholders to identify, evaluate, and test relevant tools and platforms to support the execution of data management framework.

DUTIES AND RESPONSIBILITIES

• Explore and understand current data structures, and create blueprints for building data management framework
• Design and implement effective database, data warehouse and/or data lake solutions and data models
• Define the processes involved in data modeling, testing and maintaining data stores, data warehouse and data lake.
• Assess database and data warehouse implementation procedures to ensure they comply with policies and regulations.
• Deploy and maintain data warehouse or data management solutions.
• Lead data migration from current systems to new solutions.
• Monitor the performance of data solutions by performing regular tests, troubleshooting, and implementing new features.
• Identify and recommend data solutions to for system enhancements.
• Educate other staff by means of training and or demonstrations.
• Provide support for production issue investigations by performing root cause analysis and troubleshooting. Offer support by responding to system problems in a timely manner.
• Prepare accurate data design and data architecture artefacts for management and team members.

QUALIFICATIONS AND REQUIREMENTS

Education & Experience

• Bachelor's degree in Information Management, Computer Science, Information Technology, or a related field.
• Minimum 8 years of relevant experience in data architecture, data engineering, database development, or related technology roles.
• Strong understanding of the systems/software development lifecycle (SDLC) and enterprise data environments.
• Experience translating business requirements into scalable and effective technical solutions.

Data Architecture & Engineering

• Strong experience in data architecture frameworks, standards, principles, and reference architectures.
• Knowledge of Data Science, Data Modeling, and Data Architecture principles and practices.
• Proven experience in defining data models, metadata, security models, and reference data.
• Strong understanding of Databases and Big Data Technologies.
• Experience with Data Warehouse Infrastructure and Data Warehouse Platforms, covering both Cloud and On-Premises environments.
• Strong understanding of Data Governance and Security principles and practices.
• Strong understanding of data flows, including data movement, transformation, governance, security, and changes throughout the data lifecycle.
• Experience with cloud and/or on-premises data warehouse solutions, such as Amazon Redshift and Google Cloud BigQuery.
• Knowledge of Enterprise Architecture Frameworks, such as TOGAF.
• Experience working with Hasura and GraphQL, with an advanced understanding of GraphQL integration with PostgreSQL and SQL Server, is an advantage.

Technology Stack

• Languages: SQL
• Cloud & Data Warehouse: AWS S3, AWS RDS, Amazon Redshift, Google Cloud SQL, Google BigQuery
• BI & Analytics: Tableau, Power BI
• Databases & Caching: PostgreSQL, SQL Server, MySQL, Oracle, Redis
• DevOps & Version Control: Git, GitLab, Bitbucket, CI/CD

Core Competencies

• Strong analytical and problem-solving skills, with the ability to assess, isolate, and interpret complex business and technical requirements.
• Strong understanding of business processes and their application within data and technology solutions.
• Strong Project Management skills, with the ability to manage technical initiatives, coordinate stakeholders, and oversee project implementation and delivery.

The following certifications are preferred but not required:

• AWS Certified Developer – Associate
• AWS Certified Solutions Architect – Associate
• Microsoft Certified: Azure/Database-related certification
• Google Professional Cloud Architect