Data/Warehouse Architect
October 16, 2024Business Intelligence Architect
October 16, 2024Experience / Qualifications
- 8+ years of experience in designing, development, testing, and support of Data Warehouse and ETL processes as needed.
- 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 of working in Data platforms development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS related to database.
- Knowledge of or working experience with Cognos BI environment or other business Intelligence tool set such as Power BI or tableaus preferred.
- Experience in maintaining and monitoring of ETL jobs by making sure that jobs are completed in timely manner.
- Experience working with Reporting and DBA teams for any query performance tuning and optimization as required.
- 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