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.
• Proven experience in defining data models, metadata, security models, and reference data.
• 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.
• 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.
• Excellent written and verbal communication skills, with the ability to work effectively with both technical and business stakeholders.
• Strong service orientation with a genuine interest in technology and continuous improvement.
• Demonstrates a can-do attitude, adaptability, and the ability to work effectively in a collaborative team environment.

Preferred Certifications

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