BI Analyst

OneMagnify; Chennai District; On-site; INR 900,000 - 1,400,000; Full time

Benefits offered by this job

Medical Insurance

PF

Gratuity

Paid holidays

Job summary

OneMagnify is hiring a BI Analyst to design, build and support Power BI reporting for multiple business teams across Manufacturing, Supply Chain, Credit, Mobility, and Warranty. You will collaborate with stakeholders to model data, develop dashboards, and automate reporting on Google Cloud BigQuery.

The role emphasizes hands-on development, data modeling, DAX measures, and governance with security and deployment pipelines. Prior cloud data experience is essential.

Qualifications

• 3–7 years of hands‑on BI / reporting experience, with Power BI focus.
• Strong SQL — joins, aggregations, window functions, and debugging slow queries.
• Experience with a cloud data warehouse (GCP BigQuery preferred).
• Knowledge of ETL/ELT concepts and at least one transformation tool (Dataform, dbt, Alteryx, Dataflow).
• Understanding of dimensional modelling for reporting.

Responsibilities

• Build and maintain Power BI dashboards, reports and datasets end to end — requirement gathering, data model, DAX measures, visuals, publishing and support.
• Write and tune SQL in BigQuery to prepare clean, reliable datasets for reporting.
• Design star‑schema data models and reusable, certified datasets for self‑serve reporting.
• Set up refresh schedules, gateways, workspaces, row‑level security and deployment pipelines; manage performance and costs.
• Build transformation pipelines in Dataform or dbt‑style SQL models and schedule them; use Cloud Run/Cloud Functions for automation.

Skills

BI / reporting experience

SQL proficiency

Data concepts

Stakeholder communication

Education

Engineering, Computer Science or related

Tools

Power BI

BigQuery

Dataform/dbt

Cloud Run/Cloud Functions

Job description

The Impact You’ll Have:

We are hiring a BI Analyst to own the design, build and support of Power BI reporting for business teams across Manufacturing, Supply Chain, Credit, Mobility, Connected Vehicle and Warranty. The majority of the work is hands‑on Power BI development on top of data in Google Cloud (BigQuery). You will work directly with business users to understand what they need, model the data properly, and deliver dashboards people actually use.

What you’ll do:

• Build and maintain Power BI dashboards, reports and datasets end to end — requirement gathering, data model, DAX measures, visuals, publishing and support.
• Write and tune SQL in BigQuery to prepare clean, reliable datasets for reporting.
• Design star‑schema data models and reusable, certified datasets so business teams can self‑serve instead of asking for one‑off reports.
• Set up refresh schedules, gateways, workspaces, row‑level security and deployment pipelines; keep report performance and query cost under control.
• Build transformation pipelines in Dataform (or dbt‑style SQL models) and schedule them; use Cloud Run / Cloud Functions for lightweight automation where needed.
• Investigate data issues, trace them back to the source, and put basic data quality checks in place.
• Sit with business stakeholders, translate their questions into metric definitions and specs, and document what you build.
• Replace manual and Excel‑based reporting with automated solutions.
• Support Gen AI / Vertex AI use cases where useful — natural‑language Q&A on datasets, automated summaries, Copilot features in Power BI.
• Review work from junior analysts and help them level up.

What you’ll need:

• 3–7 years of hands‑on BI / reporting experience, with the bulk of it in Power BI (Power Query, DAX, data modelling, Power BI Service administration)/ similar tools.
• Strong SQL — joins, aggregations, window functions, and the ability to debug a slow query.
• Practical experience with a cloud data warehouse. GCP BigQuery preferred; Snowflake, Databricks, Azure Synapse / Fabric or Redshift equally considered.
• Working knowledge of ETL/ELT concepts and at least one transformation or workflow tool — Dataform, dbt, Alteryx, SAS, Dataflow or similar.
• Understanding of dimensional modelling and how to structure data for reporting rather than just extracting it.
• Ability to talk to non‑technical stakeholders, push back sensibly, and explain numbers clearly.
• A degree in Engineering, Computer Science, IT, Statistics, Business Analytics or any quantitative field.

Future‑Ready Skills (Nice to Have):

• Python (pandas) for data prep or automation.
• Vertex AI, Gen AI / LLM‑assisted analytics, or Power BI Copilot exposure.
• Tableau, Qlik Sense or Looker experience alongside Power BI.
• Git / DevOps, CI‑CD for BI artefacts, Agile ways of working.
• Power Automate / Power Apps for workflow automation.
• Microsoft PL‑300 or Google Professional Data Engineer certification.
• Experience in integrated marketing, digital agency, marketing services, or consulting environments preferred.

Benefits

We offer a comprehensive benefits package including Medical Insurance, PF, Gratuity, paid holidays, and more.

• Medical Insurance
• PF
• Gratuity
• paid holidays

We are an equal opportunity employer We believe that Innovative ideas and solutions start with unique perspectives. That’s why we’re committed to providing every employee a workplace that’s free of discrimination and intolerance. We’re proud to be an equal opportunity employer and actively search for like‑minded people to join our team.

Whether it’s awareness, advocacy, engagement, or efficacy, we move brands forward with work that delivers results. Through meaningful analytics, engaging communications and innovative technology solutions, we help clients tackle their most ambitious projects and overcome their biggest challenges.