System One
Data Warehouse / ETL Developer
System One, Hoboken, NJ, United States
ALTA is looking for a Data Warehouse / ETL Developer with 8+ years of experience in designing, developing, and supporting Data Warehouse and ETL processes. The ideal candidate should have strong skills in SSIS, SSAS, SSRS, and T-SQL, along with experience working with Azure data platforms and business intelligence tools like Power BI or Tableau. The role also involves maintaining ETL jobs, optimizing query performance, and working independently to resolve issues.
Experience / 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 Tableau 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 Jersey City, NJ