Business Intelligence Analyst

Designation - Business Intelligence Analyst

Location - Mumbai - Goregaon West

Mandatory Skill - Sql and Big Query

CTC - 4 - 8 LPA

Experience - 1 - 4 years

Qualification - Any graduate with relevant skillsets

About the Role:

• The Business Intelligence Analyst will be responsible for
• The incumbent will report to the Manager. The incumbent will have to work as part of a multi-functional team, and this involves collaboration with the internal team and external stakeholders.

Job Responsibilities:

Data Management and Preparation

• Data Sourcing & Integration: Identifying and connecting to various data sources, including databases (SQL, BigQuery), data warehouses, cloud services (Google Cloud), and flat files.
• ETL/ELT Development: Designing, building, and maintaining Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) pipelines to move and prepare data for analysis.
• Data Modelling: Structuring and organising data into logical models within a data warehouse or data mart to optimise for performance and reporting.
• Data Quality and Cleansing: Ensuring data accuracy, completeness, and consistency by identifying and resolving errors, duplicates, and discrepancies.

Analysis and Reporting

• Data Analysis: Analysing data to identify trends, patterns, and anomalies. Answering key business questions through exploratory data analysis.
• Report and Dashboard Development: Designing, developing, and deploying interactive dashboards and reports using BI tools like Tableau, Power BI, Qlik, or Looker Studio.
• KPI and Metric Tracking: Working with business stakeholders to define Key Performance Indicators (KPIs) and developing reports to track them against company goals.
• Ad-Hoc Reporting: Fulfilling specific data requests from business users and management to support immediate decision-making needs.

Technical and System Management

• BI Tool Administration: Managing the BI platform, including user access.
• Database Querying: Writing complex SQL queries to retrieve and manipulate data from relational databases.
• Performance Optimisation: Monitoring and improving the performance of BI dashboards, reports, and underlying data queries.

Collaboration and Strategy

• Stakeholder Collaboration: Working closely with various departments (e.g., Sales, Marketing, Finance, Operations) to understand their needs and deliver relevant insights.
• Requirements Gathering: Translating business requirements into technical specifications for BI solutions.
• Data Storytelling: Communicating complex findings and insights clearly and concisely to both technical and non-technical audiences.
• Training and Support: Providing training and support to end-users to help them effectively use BI tools and dashboards.
• Strategic Planning: Contributing to the overall BI strategy and data governance policies of the organisation.

Key Result Areas:

• Data Visualization and Reports
• Dashboards
• Timely Query Resolution
• Resolve BI modelling issues on time
• Data Accuracy
• Timely project deployment

Competencies (Skills essential to the role)

• Strong analytical skills
• Ability to address complex problems with logical thinking in environments with limited standardisation
• Strong troubleshooting skills
• Excellent verbal and written communication skills

Role Type / Key working relationships:

• Individual Contributor
• Internal team
• External stakeholders

Interested candidates can share resume along with below mentioned details

Current CTC

Expected CTC

Notice Period

Current location in Mumbai

Years of Experience in Big Query

Email - [email removed]