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.

Requirements

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