Job Description
Position:
Business Intelligence Analyst
Responsibilities:
-
Gather business requirements from clients or internal departments to design, develop, and deploy a new database for corporate reporting system.
-
Create SQL Server Integration Service Packages (SSIS) using different sources and transformations.
-
Design ETL processes to transform bulk data across systems.
-
Migrate legacy ETL setups to updated platforms, including SSIS and Azure Data Factory.
-
Modify current database by adding tables, altering referential integrity and relationships to support new corporate reporting system.
-
Build complex stored procedures, functions, views and optimize the embedded application T-SQL and PL/SQL scripts to support the customization of reports.
-
Rewrite the existing TSQL code for long running queries by replacing cursors with various joins, common table expression (CTE).
-
Conduct performance tuning by re-indexing, updating statistics, recompiling, error handling stored procedures, and performing other maintenance tasks.
-
Conduct unit tests to compare the new system with old system and to increase the reliability of the new system.
-
Create logic for data validation before loading, redirect bad data to separate tables and notify business end users by sending emails.
Educational requirements:
-
Bachelor’s Degree in business analytics, data analytics or related.
Special skills requirements:
-
Familiar with T-SQL, MSSQL Server 2016/2017, SSIS, SSRS, Data modeling, ETL.
Location:
East Windsor, New Jersey