BI - Senior Engineer

BI - Senior Engineer

Location: Noida, UP, India

Company: Iris Software

Job Description

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 new 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

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