Database/Warehouse Architect

Job Description

ITnova is looking for a Data Warehouse Architect with at least 12 years of experience in designing and developing database and data warehouse systems, both on-premises and in the cloud. The ideal candidate should have strong skills in SQL Server and Azure, along with expertise in ETL processes and data governance. Excellent communication skills are essential for collaboration across the organization.Experience / Qualifications

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.

Experience in building end to end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc.

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.

Experience in Data platforms development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS related to database.

Experience in data governance, data management, data modeling, data cleansing, data extraction and transformation, data analysis, data migration, data integration and data mapping.

Strong experience using SQL Server Integration Services (SSIS), SSAS and SSRS for analysis and report generation.

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.

Knowledge or working experience with Cognos BI environment or other business Intelligence tool set such as Power BI or tableaus preferred.

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.

Excellent communications, presentation skills with ability to interact at all levels of the organization on a regular basis.

Ability to act independently to resolve issues, excellent communication and interpersonal skills, strong critical & analytic thinking. Education

Bachelor's degree in computer science/engineering or related fields. Work Location

Hybrid work at 2 Montgomery Street Jersey City, NJ 07302

Full-time

Hybrid remote