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 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 Jersey City, NJ
System One, and its subsidiaries including Joulé, ALTA IT Services, TeamPeople, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.