BI - Senior Engineer

Iris Software; Dadri; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Iris Software is seeking a BI - Senior Engineer to provide day-to-day support of production, QA, test, and development using Microsoft BI tools. The role focuses on MSBI administration, upgrades, and performance tuning to ensure 24x7 BI availability.

You will design scorecards and dashboards, collaborate with business users to gather requirements, and implement BI solutions across the enterprise using MSBI, Power BI and related tools.

Qualifications

• Bachelor's degree or an equivalent combination of education and experience is necessary.

Responsibilities

• Administer MSBI infrastructure ensuring 24x7 availability.
• Perform software upgrades, performance monitoring, tuning, and infrastructure management.
• Develop BI solutions, project plans, monitor progress, and resolve issues.
• Serve as SME for MSBI administration and new development.
• Design and develop BI reports, scorecards and dashboards using MSBI.
• Coordinate enterprise BI deliverables and ensure data accuracy and security.

Skills

BI concepts

SQL

Data Warehousing

ETL

MSBI

Power BI

Tableau

SSRS

Education

Bachelor's degree or equivalent

Tools

MSBI

Power BI

Tableau

SSRS

PostgreSQL

Oracle BI

Starburst Presto

Denodo

PL/SQL

Job description

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

• 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