Job description

Database/Warehouse Architect– a. Minimum 12 years of relevant experience in architecting, design, and development of databases or Datawarehouse systems in On-prem as well as in the cloud using Industry best practices. b. Experience in building end to end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc. c. Maintain complex Data Warehouse models to ensure data integrity, including the development, enhancement, and administration of appropriate ETL functions in support of Cognos TM1 and Cognos BI frameworks and reports. d. Experience in Data platforms development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS related to database. e. Experience in data governance, data management, data modeling, data cleansing, data extraction and transformation, data analysis, data migration, data integration and data mapping. f. Strong experience using SQL Server Integration Services (SSIS), SSAS and SSRS for analysis and report generation. g. Proficient in writing complex T-SQL Queries, Store Procedures, Views and ETL in re-designing Databases/Data warehouse using SQL server, SSIS and any custom scripts. h. Knowledge or working experience with Cognos BI environment or other business Intelligence tool set such as Power BI or tableaus preferred. i. Must be hands on, deeply technical and exposure to latest features within data platform development, able to do both coding and guide junior database engineers. j. Excellent communications, presentation skills with ability to interact at all levels of the organization on a regular basis. k. Ability to act independently to resolve issues, excellent communication and interpersonal skills, strong critical & analytic thinking. l. Bachelor's degree in computer science/engineering or related fields.

Requirements