Senior Data Architect

Position: Senior Data Architect

Experience: 12 to 15 years

Location: Nagpur

Role & Responsibilities:

• Expertise in successful deployment of multiple completed complex technical projects.
• Experience in deployment of high-level design and architecture of the solution, including information modelling.
• Robust experience with gathering end user requirements and writing technical documentation.
• Review the architectural/ technological solutions for ongoing projects and ensure the right choice of solution.
• Work closely with CIDO, IT Domain and Business units to capture requirements, identify pain areas, and propose an ideal solution.
• Design, implement, and document data architecture, which includes the use of relational, dimensional, and NoSQL databases.
• Guarantee compliance with data governance and data security requirements while creating, improving, and operationalizing these integrated data approaches.
• Liaise with stakeholders in building trust in the data being used for decision making.
• Prepare architectural standards, guardrails, and best practices related to Data Integration / architecture.

Extensive knowledge

• Data platforms Fabric, Snowflake, CosmoDB, DataBricks, MongoDB, RDBMS
• Data replication/CDC Qlik Replicate, Oracle Golden Gate
• Data modeling ERStudio

Required Experience:

• Must have prior experience with end-to-end implementation of Cloud data technologies (i.e. Fabric, Snowflake).
• Expertise in data modelling, ELT and implementing complex stored Procedures.
• Expertise in various Snowflake technologies like Snowpark, SnowPipe, SnowPipe Stream, Dynamic Tables, Document AI, Cortex Analytics, Unistore etc.
• Expertise in Snowflake cost and query optimization including experience with CapitalOne Slingshot.
• Expertise in advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understanding of how to use these features.
• Awareness in Data Migration from RDBMS, SAP systems, Salesforce, GIS, PI Historian to Snowflake.
• Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling and third normal form)
• Experience with data security and data access controls and design
• Deep understanding of SoX, GDPR and Regulatory/CNI control environments
• In-depth experience in providing resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface.
• Demonstrable ability to troubleshoot problems across infrastructure, platform, and application domains. Controlling access to the data and the reports
• Implementing Data security needs and implement security solutions
• Working with the business intelligence / analytics teams to gather requirements for the database design and model
• Work experience in data disciplines including data integration, model optimization, and/or other areas directly relevant to data management.