A data architect roles and responsibilities include Developing and implementing an overall organizational data strategy that is in line with business processes
The strategy includes data model designs, database development standards, implementation and management of data warehouses and data analytics systems

Your Key Responsibilities

Designs, develops, deploys, and supports sustainable data/solutions architectures such as design patterns, reference architecture, conceptual, logical, and physical data models.
Build proof of concepts (POC), minimal viable product (MVP), and produce scalable data architecture solutions with end-to-end delivery.
Build data models, data marts, and semantic layer.
Build solutions with self-sustainable, easily scalable design with zero to no maintenance in mind.
Conduct Assessments (Data Assessments, Data Governance Security Assessments, and Data Quality Assessments).
Build data models using Kimball data model, dimensional modeling, star, and snowflake schema design and development.
Build reusable datasets and models with a single source of truth (SSOT) in mind.
Build data delivery process across the enterprise using different data sources and destinations.
Data migrations from heterogeneous databases (ex: SQL Server, MySQL, PostgreSQL, Oracle, DB2, MariaDB, MongoDB, and Redshift) to Azure SQL or Azure Synapse or Azure Cosmos DB.
Data ingestion from different file types (ex: XML, JSON, Avro, Parquet, and ORC) into databases such as Azure SQL, Azure Synapse, Azure Cosmos DB, and Snowflake.
Meet the requirements and deadlines established for a given project.
Follow internal processes and procedures.
Investigate and resolve data architecture defects, performance issues and build data quality rules.
Work closely with other team members to coordinate assignments and communicate status.

What To Bring

Bachelor s degree in computer science or Data Analytics or Software Engineering or Mathematics.
8+ years of experience in Data Architecture, Data Modeling, and conducting assessments.
Experience in advanced SQL and database (ex. Azure SQL, SQL Server, Snowflake, Redshift, Oracle, SQL Server, MySQL, NoSQL, etc.).
Experience with Azure Data Factory, Azure SQL, Azure Synapse, Azure Databricks, ML/AI, Databricks, and ML Ops.
Experience with Hadoop components.
Experience architecting and developing complex data ingestion pipelines, SQL queries, views, procedures, and functions.
Experience in advanced SQL development experience: Management of high volume of data, building aggregates, and cubes, tuning complex queries for performance, improving overall data retrieval process, indexing and query plan analysis, and refactoring.
Experience in managing and maintaining data integration between different applications and databases using Rest API.
Experience with data extraction with a wide variety of ETL/ELT tools and processes. Azure experience is preferred.
Experience building Data Warehouses, Data Mart, and Symantec data layers.
Experience with Azure Data Factory, Azure SQL, Azure Synapse, Azure Databricks, ML/AI, Databricks, and ML Ops.
Experienced working in the cloud and serverless database solutions (Azure, AWS, Snowflake, BigQuery, BigTable, etc.) in combination with any BI Tools (Power BI, Tableau, Looker, Qlik, etc.). Azure and Power BI technology experience is strongly preferred.
Experience with JIRA, Kimble, etc.
Experience with Version control applications (example: Azure DevOps, GitHub, BitBucket, etc.)
Proficient in relational and NoSQL databases.
Rigorous attention to detail.
Ability to communicate with internal/external stakeholders and work through data-related inquiries and issues.
Effectively manage workload with shifting priorities and varying business requirements.
Excellent problem-solving skills to identify creative ways to achieve solutions.
Capable of taking responsibility for a task and managing it through completion.
Excellent verbal and written communication skills.

Data Architect

Job Description

No Referrers Available