BI - Senior EngineerJob Description

Business Intelligence (BI) Programmer Analyst

The Business Intelligence (BI) Programmer Analyst provides day-to-day support of the production, QA, test, and development using Microsoft Business Intelligence tools. Is responsible for the administration of the MSBI Infrastructure and provides 24x7 availability of the Enterprise Business Intelligence. Also performs software upgrades, performance monitoring, system tuning, upgrades and infrastructure management.

Responsibilities

- Responsible for the administration of the MSBI Infrastructure and provides 24x7 availability of the Enterprise Business Intelligence.
- Perform software upgrades, performance monitoring, system tuning, upgrades and infrastructure management.
- Actively provide BI solutions, developing project plans, monitoring progress, and resolving issues.
- Provided consultation and knowledge transfer to peers and internal contacts as a Subject Matter Expert (SME) in the administration and recent development using MSBI.
- Provides technical expertise to design business solutions using acquired knowledge and experience related to MSBI.
- Provide MSBI administration including install, configure, control failover and load balancing across multiple servers and maintain security.
- Plan/drive Business Intelligence project deliverables for the entire organization using MSBI as a BI tool.
- Performs application code migrations.
- Trouble-shoots hardware and software problems as they apply to design, implementation, or installation activities.
- Schedule and coordinate infrastructure maintenance activities including such items as hardware and software upgrades and maintenance.
- Consult with business community to gather requirements for specific BI scorecard, dashboard and reporting needs; write detailed specifications to be used in developing reports and processes.
- Design and develop scorecards, dashboards and multi-dimension data cubes using MSBI.




- Consult with end users to refine/enhance existing BI applications.
- Participate in the design and development of enterprise wide data repositories; make recommendations to improve the efficiency and functionality of the database, MSBI environment and associated processes.
- Develop and deliver reports on an ad-hoc basis using MSBI; develop and execute a verification and security strategy to ensure the accuracy of the data distributed in the reports.
- Function as the enterprise MSBI administrator ensuring performance and security is compliant.
- Assist management in attaining problem resolutions, working with multiple BI partner groups and multiple levels of staff and management.
- Adhere to ethical standards and comply with the laws and regulations applicable to your job function.
- Develops and documents BI coding and naming standards, templates and metadata.
- Ensures BI environment is optimized to address business requirements by designing and creating tables, diagnosing and repairing user and performance issues, and testing, monitoring and tuning software.
- Bachelors degree, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired is necessary.

Mandatory Competencies

- BI and Reporting Tools - BI and Reporting Tools - D3.JS
- Data & AI - ETL OTHERS - Data Warehousing (DWH)
- Data & AI - ETL OTHERS - Enterprise BI & Reporting Integration Concepts
- Data & AI - ETL OTHERS - SQL
- BI and Reporting Tools - BI and Reporting Tools - Power BI
- BI and Reporting Tools - BI and Reporting Tools - Tableau
- BI and Reporting Tools - BI and Reporting Tools - SSRS
- Query Accelerators and Data Virtualization - Query Accelerators and Data Virtualization - Starburst Presto
- Query Accelerators and Data Virtualization - Query Accelerators and Data Virtualization - Denodo
- Database - PostgreSQL - PostgreSQL
- BI and Reporting Tools - BI and Reporting Tools - Oracle BI
- Database - Database Programming - PL/SQL
- Beh - Communication and collaboration

📌 BI - Senior Engineer (Noida)
🏢 IRIS SOFTWARE
📍 Noida