Data Architect

Responsibilities:

• Should be able to understand different cloud Platforms/Architecture, preferably on AWS Platform Services for Data & Analytics
• Architect end-to-end data solutions on data lakes, warehouses, and real-time analytics.
• Should have Designed/Architected Medium to Large Data Warehouses
• Should have created Conceptual, Logical, Physical Data Models, OLTP, OLAP/Dimensional Data Models, Data Analysis
• Should be aware of Data Architecture/Design Patterns in the areas of Data Ingestion / Curation / Data Consumption / Reporting Semantic Models
• Should have participated in Defining Data Strategy/Roadmaps in Data & Analytics
• Should be hands on in some of the areas of the required Technology tools.
• Should be aware of Data fabric, Data Ingestion Tools, Data Quality Management, Metadata Management, Data Lineage, Data Security
• Should have good experience in Designing Reusable utilities
• Should have good experience with Data Warehouse Migrations
• Should be aware of Agile Methodologies/Data Products, leading teams technically from Design to Development to Deployment, through DevOps, DataOps
• Automate data quality checks and validations to maintain high data integrity. Monitor, troubleshoot, and resolve issues across data platforms

Qualifications:

• Should have at least 12-15 years of total IT experience in Software Development, with 5 years exclusively in Design & Architecting Data Warehousing projects
• Should have good hands-on below tools & technologies

Must Have:

• Data Lake Architecture / Data Fabric
• Snowflake (Tasks, Streams, Stored Procs, Snow pipes), SQL Server
• Data Modeling tools (like Erwin)
• Data Warehouse Migrations
• Agile Methodologies
• Replication tools (like AWS DMS, Qlik Replicate)
• OLAP/Dimensional Data Models
• NoSQL Databases (like MongoDB)

Good to have

• ETL Tools (like SSIS, dBT)
• BI/Reporting tools (Power BI, Tableau)
• Cloud Platforms (AWS, Microsoft Fabric)
• Real-Time databases (Cassandra, DynamoDB)
• Solid understanding of the Agile development process and software release processes.
• Must be a self-starter who is highly organized, hands-on, and a team player.
• Should be able to create Design Documents/Mapping documents (either PPT or Word document)
• Should be able to communicate & Collaborate with all stakeholders (Director level, Business Units, other Architects, Product Managers, Scrum Stay updated on industry trends to continuously improve data systems and processes.