Junior BI Analyst

Applied Data Finance; India; On-site; INR 600,000 - 900,000; Full time

Job summary

Applied Data Finance is seeking a detail-oriented BI Analyst with 2–3 years of experience to build and maintain dashboards, reports, and data solutions using Tableau and AI-powered visualization tools. You will turn data from Amazon Redshift and MongoDB into accurate, reliable insights and collaborate with business stakeholders and senior BI staff.

You will also support ETL pipelines built with Python, Pentaho, and Spark, implement data quality checks, and provide feedback on data models,

Qualifications

• Bachelor's degree in CS/IT/Engineering/Statistics or related field.
• 2–3 years of experience in business intelligence, data analytics, or reporting.
• Intermediate to advanced SQL with joins, subqueries, CTEs, and window functions.
• Hands-on Tableau dashboards experience (calculated fields, parameters, filters, and LOD expressions).
• Exposure to AI-powered visualization tools (Tableau AI, Power BI Copilot) and quick adoption of new BI tools.

Responsibilities

• Develop, maintain interactive dashboards and reports in Tableau and AI-powered visualization tools.
• Write and optimize SQL on Redshift and query MongoDB to extract, join, and analyze data.
• Use AI tools to speed up report development while validating outputs.
• Gather reporting requirements from stakeholders and translate them into dashboards and KPIs.
• Support ETL workflows using Python, Pentaho, and Spark; optimize pipelines on AWS.
• Perform data validation to ensure dashboards and reports are accurate before release.
• Troubleshoot dashboard issues and data discrepancies with senior team members.
• Share feedback with the data warehouse team on metric definitions and data models.
• Define reusable metrics and business logic to keep KPIs consistent across reports.
• Manage workbooks, data sources, refreshes, deployments, and access on Tableau Server/Cloud.

Skills

SQL

Data visualization

Analytics

Communication

Python for data processing

Version control

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, Statistics, or related fields

Tools

Tableau

Power BI Copilot

MongoDB

Job description

We are looking for a detail-oriented BI Analyst with 2–3 years of experience to build and maintain dashboards, reports, and data solutions using Tableau and AI-powered visualization tools. Working with business stakeholders and senior BI team members, you will turn data from Amazon Redshift and MongoDB into accurate, reliable insights.

The role also involves supporting ETL pipelines built with Python, Pentaho, and Spark, applying data quality checks, sharing data model feedback with the data warehouse team, and using AI to speed up report development.

Key Responsibilities

• Develop, maintain, and enhance interactive dashboards and reports in Tableau and AI-powered visualization tools (e.g., Tableau AI, Power BI Copilot, or similar), using features such as natural-language queries and automated insights.
• Write and optimize SQL on Amazon Redshift and query MongoDB collections to extract, join, aggregate, and analyze data.
• Use AI tools to build reports faster, including generating and optimizing SQL, drafting Tableau calculations and visual layouts, documenting dashboards, and summarizing insights, while validating all AI-generated output.
• Gather reporting requirements from business stakeholders and translate them into dashboards, KPIs, and report enhancements.
• Support the development, monitoring, and maintenance of ETL workflows using Python, Pentaho, and Spark, and help optimize and scale pipelines on AWS (e.g., Spark and Python jobs on EC2 Spot Instances).
• Perform data validation, reconciliation, and quality checks, so dashboards and reports are accurate and consistent before release.
• Troubleshoot dashboard issues and data discrepancies, and work with senior team members to identify and resolve root causes.
• Share feedback with the data warehouse team on metric definitions and data model design, such as missing attributes, grain issues, or performance bottlenecks found while building reports.
• Help build and maintain the semantic layer by defining reusable metrics, dimensions, and business logic so KPIs stay consistent across reports.
• Manage workbooks, published data sources, extract refreshes, deployments, and access permissions on Tableau Server/Cloud and other BI platforms.
• Prepare ad hoc analyses and insights to support business operations and stakeholder requests.
• Maintain documentation for dashboards, SQL, data sources, and business logic, and use version control (Git/Bitbucket) for code.
• Participate in sprint activities, code reviews, testing, and continuous improvement within the BI team.

Required Skills & Qualifications

• Bachelor's degree in Computer science, Information Technology, Engineering, Statistics, or related fields.
• 2–3 years of experience in Business Intelligence, data analytics, or reporting.
• Intermediate to advanced SQL, including joins, subqueries, CTEs, and window functions.
• Hands-on experience building dashboards in Tableau (calculated fields, parameters, filters, and LOD expressions), with a good grasp of visualization principles.
• Exposure to AI-powered visualization and analytics tools (e.g., Tableau AI, Power BI Copilot, or similar) and the ability to adopt new AI-driven BI tools quickly.
• Understanding of data warehousing and dimensional modelling (facts, dimensions, and star/snowflake schemas), with hands-on exposure to Amazon Redshift and/or MongoDB.
• Working knowledge of Python for data processing (e.g., Pandas, NumPy) and exposure to Pentaho or Spark (PySpark).
• Strong analytical and problem-solving skills, with close attention to data accuracy.
• Good communication skills and the ability to work with both technical and business teams.

Preferred Qualifications

• Exposure to AWS services (S3, EC2, EMR, Glue, Lambda) and to scaling pipelines using Spot Instances and advanced Python libraries (e.g., PySpark, Polars, Dask, SQLAlchemy, boto3).
• Hands-on experience in data modelling (e.g., designing fact and dimension tables or star/galaxy schemas) is an advantage.
• Knowledge of semantic layer concepts (governed metrics, reusable dimensions, and Tableau published data sources).
• Domain knowledge of financial services, lending, or fintech.
• Familiarity with Agile/Scrum, Jira, Confluence, and advanced Excel.