Data Architect - Data Warehousing

Data Architect JD:

- Define structure, integrate, govern, store, describe, model, and maintain data in the enterprise for accuracy and usage maintaining current state

- Map to information entities that can define how information should flow and be consumed by various business and IT customers

- Support policies and procedures enforced by the data governance committee to ensure best practices of data architecture including accountability, governance, and requirements

- Support operational use of data for business process functions such as customer centricity, supply chain, product positioning, sales efficiency, and other domain centric functions

- Document data inventory and data flow diagrams to determine what can be measured, when and how.

Required Skill Sets:

- Experience in IT Industry with a wide range of experience in Microsoft SQL Server Database Development, Administration, SSIS, SSRS & Reporting services.

- Have Solid Experience in SQL SERVER-2016/2008 R2/2005.

- Knowledge in T-SQL Statements, Stored Procedures, Triggers, Functions and Views, CTE.

- Knowledge in Index creation.

- Knowledge in Query Optimization & Performance Tuning using SQL Profiler.

- Knowledge in SSIS, SSAS & SSRS using MSBI.

- Expert in Generating Reports using Crystal Reports and SSRS.

- Strong Knowledge to develop complex Matrix report in HRMS and MIS reports RO, Sales, Invoicing and Finance.