Apply

Ready to go for it?

AI Apply speeds things up—apply directly if you prefer.

FREE ACCESS
5,000–10,000 jobs/day
Scoutfield Logo

See all jobs on Scoutfield

Search thousands of fresh jobs every day.

Discover
  • Fresh listings
  • Fast filters
  • No subscription required
Create a free account and start exploring right away.
EXL

Business Analyst

EXL

. Write complex SQL queries, stored procedures, and optimized transformations across Snowflake, Azure Synapse, BigQuery, or Redshift .

Posted 10/3/2026full-timePune • IndiaJuniorMid-LevelWebsite

Core Competencies

Role fit
Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL query optimization, Python and PySpark data pipeline development, and advanced analytics. Proficient in building and managing ELT/ETL workflows, designing enterprise dashboards, and implementing data governance standards.

Highest-signal resume keywords
Advanced SQLPython ProgrammingData Pipeline DevelopmentPower BI and TableauELT/ETL Workflows

ATS Keywords

Tailor your resume
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills
SQL QueriesStored ProceduresPythonPySparkDAXLookMLData ModelingData QualityStatistical AnalysisAI/LLM Applications
Soft Skills
Stakeholder AdvisingMentoringCollaborationDocumentationAgile Delivery
Tools & Technologies
SnowflakeAzure SynapseBigQueryRedshiftDbtApache AirflowFivetranPower BITableauGit/GitHub
Certifications & Qualifications
Bachelor’s Degree in Data ScienceMaster’s Degree in Data Science
Industry Keywords
Business IntelligenceAdvanced AnalyticsData EngineeringData GovernanceClient-Facing Delivery

Tech Stack

Tools & technologies
AirflowAmazon RedshiftApacheAzureBigQueryDockerETLMatillionNumpyPandasPySparkPythonShell ScriptingSparkSQLTableau

About the role

Key responsibilities & impact
  • Write complex SQL queries, stored procedures, and optimized transformations across Snowflake, Azure Synapse, BigQuery, or Redshift
  • Develop and maintain scalable Python and PySpark data pipelines for batch and near-real-time processing
  • Build and manage ELT/ETL workflows using dbt, ADF, Airflow, or Fivetran
  • Implement Spark-based processing on Databricks or Azure HDInsight and optimize query performance
  • Design, develop, and deploy enterprise dashboards and reports using Power BI and Tableau
  • Build semantic models, calculated measures, KPI frameworks, and row-level security configurations
  • Develop LookML models, explores, and views for governed self-service analytics
  • Design dimensional models and standardize reusable metrics, KPIs, hierarchies, and dimensions
  • Develop or contribute to AI-powered analytics applications, RAG pipelines, conversational BI, vector search, and LLM-driven insights
  • Perform exploratory, statistical, cohort, A/B test, time-series, and forecasting analyses
  • Collaborate with data science teams to integrate ML outputs into BI reporting layers
  • Advise stakeholders, lead requirements workshops and solution design sessions, and present analytics solutions
  • Document technical and functional specifications and participate in Agile delivery
  • Implement data quality, lineage, metadata cataloging, governance, access control, and compliance standards
  • Mentor junior analysts and establish BI and analytics best practices

Requirements

What you’ll need
  • 6–9 years of hands-on expertise in business intelligence, advanced analytics, and data engineering
  • Advanced SQL, including CTEs, window functions, query optimization, stored procedures, and dynamic SQL
  • Proficiency in Python, including pandas, numpy, matplotlib, seaborn, SQLAlchemy, requests, and PySpark
  • Experience with distributed data processing, DataFrame API, Spark SQL, and UDFs using PySpark
  • Advanced DAX, including calculated columns, measures, time intelligence, and row-level security
  • Experience building LookML models, explores, and views in Looker
  • Shell scripting / Bash for pipeline automation and environment management
  • Advanced Power BI and proficient Tableau experience
  • Experience with Snowflake and Azure data platforms
  • Experience with dbt, Apache Airflow, and data ingestion tools such as Fivetran, Matillion, or Azure Data Factory
  • Exposure to LLM APIs, RAG pipelines, vector databases, prompt engineering, and AI-native BI tools
  • Experience with semantic layer technologies and dimensional modeling
  • Git/GitHub/Azure DevOps, Docker basics, Agile/Scrum, and JIRA/Azure Boards
  • Bachelor’s or Master’s degree in Data Science, Computer Science, Statistics, Mathematics, or a related field (preferred)
  • Experience in consulting, professional services, or client-facing delivery environments (preferred)
  • Hands-on experience building end-to-end AI/LLM-powered analytics applications (preferred)