Responsibilities:
 

• Maintain, support, and enhance the business intelligence data backend, including data warehouses and data lakes.

• Build interfaces between the business intelligence systems and other college information systems to maintain a timely and accurate integration of data.

• Collaborate and work with data analysts in various departments to ensure that data meets their reporting and analysis needs.

• Provide technical guidance for design and implementation of data governance systems and policy.

• Work extensively towards SQL Server development in writing core TSQL scripts to implement complex business logics.

• Develop SSIS packages to implement complex ETL strategies as a part of business requirements for population of dimensional data structures.

• Work on creating SSAS cubes and various cube objects such as KPIs (Key Performance Indicators), calculated members, attributes hierarchies and perspectives.

• Design eye-catching reports with data from OLTP database, dimensional data structure and OLAP cubes for business reporting purposes.

• Keep abreast of new business intelligence technologies

 

Qualifications:
 

• BS or MS of degree in Computer Science, Information Technology, Engineering or related field is required

• At least 1 year of experience using Microsoft SQL Server Database, SSIS, SSRS, SSAS is required

• Experience with other relational databases, BI reporting and data discovery tools is preferred