BI ANALYST

Job Description

Gather business requirements from clients, design data warehouse using Kimball methodologies. Provide business dashboard report for business strategy decision-making process. Provide ad-hoc and interactive dashboard reports using Tableau and SSRS. Govern database and data warehouse in Snowflake, maintain data, create view to automate process data. Design ETL pipelines using SSIS, migrate data from various data source, ensure integrity and validation of data. Implement error monitoring and error handling mechanism to SSIS packages. Perform data preprocessing and manipulation using SSMS.

Responsibilities

Gather business requirements from clients, design data warehouse using Kimball methodologies. Provide business dashboard report for business strategy decision-making process. Provide ad-hoc and interactive dashboard reports using Tableau and SSRS. Govern database and data warehouse in Snowflake, maintain data, create view to automate process data. Design ETL pipelines using SSIS, migrate data from various data source, ensure integrity and validation of data. Implement error monitoring and error handling mechanism to SSIS packages. Perform data preprocessing and manipulation using SSMS.

Qualifications and Skills

Master's degree in Science, Technology, Professional Studies, Engineering, or any related field is required. Bachelor’s degree in any of the above-mentioned fields along with 5 years of experience in job offered or related occupation is acceptable in lieu of the Master’s degree. Any suitable combination of education, training or experience is acceptable.
Work location: Piscataway, NJ and various unanticipated locations throughout the U.S.
Send Resume to HR Dept., Itlize Global, LLC., 242 Old New Brunswick Road, Suite 250, Piscataway, NJ 08854.
Should the candidate accept employment with Itlize Global, LLC., the referring employee will be eligible to receive an award of $1000.00 for the successful referral.