BI Analyst

Posted 3 weeks ago

Job ID - 172

General Purpose of Job                                                                                                                      

Implement reports, dashboards and various other BI artifacts and processes for internal and external clients based on business requirements using industry best practices

 

Educational And Professional Experience Requirements                                                                  

  • 4 year degree in a relevant field of study plus 3 years of BI experience or 2 year degree with 5 years of BI experience.

Knowledge,Skills & Abilities Desired                                                                                                 

 

  • Advanced knowledge of SQL Server
  • Advanced Knowledge of database schema design
  • Advanced knowledge of T-SQL
  • Advanced knowledge of Microsoft Reporting Services
  • Advanced Knowledge of Microsoft SSIS or any ETL tool
  • Advanced Knowledge of Excel
  • Medium knowledge of query optimization
  • Medium knowledge of Microsoft PowerBI or any dashboarding tool
  • Basic knowledge of Dimensional Modeling and Star Schema designs
  • Experience in SharePoint is a plus
  • Ability to understand & translate reporting business requirements into ETL processes, reports, and/or dashboards
  • Work with software developers on system designs, advise on BI related processes
  • Demonstrate logic and math skills along with the ability to be inquisitive in analyzing requirements
  • Effective communication and organizational skills
  • Experience in a financial environment is a plus
  • Exposure to AGILE development methodologies is a plus

 

Duties and Responsibilities                                                                           

  • Maintain a positive work atmosphere by behaving and communicating in a manner that will facilitate working with customers, clients, co-workers, and management
  • Responsible for the security of workstation and work area in regard to the confidentiality of the data and the systems
  • Follow documented processes to generate reports, packets, charts to various business units
  • Troubleshoot and resolve technical issues
  • Report progress to team(s) on the implementation of assigned projects/work items through daily scrum meetings
  • Translate basic and moderate reporting requirements into tasks and estimate the size of the tasks
  • Develop basic reports using Microsoft SQL Server Reporting Services development environment
  • Develop code using the T-SQL language to meet BI project requirements
  • Research requirements for BI requests to provide the requested functionality of each request, e.g. data extract, report, dashboard, etc.
  • Design report layouts that provide a user-friendly experience
  • Modify existing reports to meet new requirements by the end users
  • Analyze performance of each report or query and implement proper optimization techniques
  • Decide the best use of available technologies to complete a variety of assigned tasks

Apply Online