Business Analyst with SQL & Banking Domain

This role will be permanent with NAM info and deploy to client location Hyderabad & Pune.

Work Mode: WORK FROM OFFICE

Role Descriptions:

• Perform detailed data analysis and support business decision-making
• Gather and document business requirements and translate them into technical specifications
• Work closely with stakeholders to define data needs and reporting requirements
• Create user stories, functional specifications, and support UAT activities
• Ensure alignment between business objectives and data solutions

Required Skills:

• Strong expertise in SQL and data querying
• Proven experience in data analysis, requirement gathering, and stakeholder management
• Ability to translate business requirements into technical solutions and user stories
• Good understanding of data models, reporting, and analytics concepts

Skills: Business Analysis~ORACLE SQL

Locations: ~HYDERABAD~PUNE~

Desire candidate

• Candidate should have valid PF.

Strong Data Analyst Profile with advanced Excel and SQL expertise

2

Mandatory (Experience 1): Must have 4+ years of overall experience as a hands-on Data Analyst

3

Mandatory (Tech skill 1): Must be highly proficient in advanced Excel — complex functions, macros, calculations, and pivots

4

Mandatory (Tech skill 2): Must have strong hands-on SQL and a good understanding of relational database concepts

5

Mandatory (Tech skill 3): Must be able to automate routine tasks using Python (for automation purposes)

6

Mandatory (Skill 1): Must have exceptional analytical, problem-solving, and logical skills, with strong attention to detail and accuracy

7

Mandatory (Skill 2): Must be able to understand complex data and business logic and convert it into a model (the role models complex utility tariffs, rates, and programs)

8

Mandatory (Communication): Must have strong verbal and written communication, able to work independently with India- and US-based team members and articulate problems and solutions over calls and email.

9

Mandatory (Location): Must be based locally in Pune (or the nearby Maharashtra belt — Mumbai, Nagpur), as the final round is in person

10

Preferred (Domain): Experience in the Energy/Utility industry and familiarity with basic utility (electrical/gas) tariff concepts

We're hiring a Data Analyst to turn raw data into clear, actionable insight. You'll partner with product, sales, marketing, and operations teams to answer their most important questions with data — building dashboards, running deep-dive analyses, and defining the metrics the business runs on. The ideal candidate is fluent in SQL, comfortable wrangling messy datasets, and just as strong at telling the story behind the numbers as they are at producing them. You'll own the accuracy and trustworthiness of the reporting stakeholders rely on to make decisions.

Key Responsibilities

• Design, build, and maintain dashboards and recurring reports across business functions
• Write and optimize SQL queries to extract, join, and transform data from multiple sources
• Run ad-hoc and deep-dive analyses to answer specific business questions
• Define, document, and standardize metrics and KPIs alongside stakeholders
• Investigate data-quality issues and ensure the numbers people see are accurate
• Translate analysis into clear recommendations and present them to non-technical audiences
• Support experimentation and A/B test analysis where relevant
• Automate repetitive reporting to free up time for higher-value analysis

Requirements

• 3+ years in a data analyst or business-intelligence role
• Strong SQL and hands-on experience with Power BI and/or Tableau
• Working knowledge of Python (pandas/numpy) for analysis
• Solid grounding in statistics and analytical methods
• Advanced Excel and strong data-visualization / storytelling skills
• Ability to work independently with stakeholders across functions

Nice to have

• Experience with cloud data warehouses (BigQuery, Snowflake, Redshift)
• Exposure to dbt or other ETL/transformation tooling

Define and obtain source data required to deliver insights and use cases.

● Determine data mapping and join multiple data sets across various sources.

● Develop methods to highlight and report data inconsistencies for user review.

● Propose and assist with suitable data migration sets for stakeholders.

● Support teams in processing data migration sets and coordinating migration activities.

● Plan, track, and coordinate the data migration team and migration run-book.

● Collaborate with stakeholders to avoid negative customer and business impacts.

● Ensure robust communication and escalation mechanisms across project portfolios.

● Implement strategic solutions and avoid short-term workarounds.

● Maintain strong control and compliance standards in data handling.

Required Skills

● Minimum 7+ years of experience as a Data Analyst, preferably in financial services.

● Strong expertise in Pyspark, Python, and SQL.

● Experience with big data programs and data models in banking or financial markets.

● Ability to write SQL queries and navigate databases such as Hive, CMD, Putty, and Note++.

● Excellent analytical skills and commercial acumen.

● Strong verbal and written communication skills.

● Proven ability to manage multiple priorities and deliver within tight deadlines.

● Business analysis skills, including defining and understanding requirements.

● Familiarity with SDLC, Agile processes, and a bias towards TDD.

● Attention to detail and a proactive, problem-solving mindset.

Nice to Have

● Knowledge and experience in Data Quality & Governance.

● Working experience with Spark Scala or Java for Spark.

● Proven track record of managing small, delivery-focused data teams (for senior roles).

● Experience with market data vendors and domains such as Party/Client, Trade, Settlements, Payments, Instrument and Pricing, Market and/or Credit Risk.

CAP-190 : Senior Data Analyst

📍Location : Bangalore / Hyderabad / Chennai / Pune / NCR

🧠Experience : 7 - 15 Years

🆔Job Code : CAP-190

🏢Work Type : Hybrid - 3 Days in a Week

About the Client (CODE: CAP)

CAP operates at the forefront of the financial services industry, providing consulting, technology, and digital transformation solutions to leading organizations worldwide. With a focus on innovation, CAP empowers clients to navigate complex regulatory landscapes, optimize operations, and drive business growth. The company fosters a collaborative and agile culture, encouraging continuous learning and excellence.

Key Responsibilities

● Define and obtain source data required to deliver insights and use cases.

● Determine data mapping and join multiple data sets across various sources.

● Develop methods to highlight and report data inconsistencies for user review.

● Propose and assist with suitable data migration sets for stakeholders.

● Support teams in processing data migration sets and coordinating migration activities.

● Plan, track, and coordinate the data migration team and migration run-book.

● Collaborate with stakeholders to avoid negative customer and business impacts.

● Ensure robust communication and escalation mechanisms across project portfolios.

● Implement strategic solutions and avoid short-term workarounds.

● Maintain strong control and compliance standards in data handling.

Required Skills

● Minimum 7+ years of experience as a Data Analyst, preferably in financial services.

● Strong expertise in Pyspark, Python, and SQL.

● Experience with big data programs and data models in banking or financial markets.

● Ability to write SQL queries and navigate databases such as Hive, CMD, Putty, and Note++.

● Excellent analytical skills and commercial acumen.

● Strong verbal and written communication skills.

● Proven ability to manage multiple priorities and deliver within tight deadlines.

● Business analysis skills, including defining and understanding requirements.

● Familiarity with SDLC, Agile processes, and a bias towards TDD.

● Attention to detail and a proactive, problem-solving mindset.

Nice to Have

● Knowledge and experience in Data Quality & Governance.

● Working experience with Spark Scala or Java for Spark.

● Proven track record of managing small, delivery-focused data teams (for senior roles).

● Experience with market data vendors and domains such as Party/Client, Trade, Settlements, Payments, Instrument and Pricing, Market and/or Credit Risk.

Why Join CAP (Code Name)

Join CAP to work on impactful data initiatives within the financial services sector, tackling complex technical challenges and driving meaningful business outcomes. You'll collaborate with talented professionals in a dynamic, agile environment that values innovation and continuous improvement. CAP offers opportunities for professional growth, skill development, and the chance to contribute to high-visibility projects that shape the future of financial technology.

About the Employment Model

Direct Hire (Client Payroll) : For this role, you’ll be hired directly by the client and be part of their internal team. Straatix supports the hiring process, but your employment, payroll, and benefits are all managed by the client.

Role Overview

We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.

Key Responsibilities

• Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
• Build and maintain data models to support business processes, reporting needs, and integration workflows.
• Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
• Work closely with cross-functional teams to gather data requirements and understand business logic.
• Develop and execute integration test plans, including functional, data validation, and regression testing.
• Support data migration activities, including extraction, transformation, and loading (ETL).
• Monitor and troubleshoot integration issues, ensuring timely resolution.
• Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
• Ensure integration security, data integrity, and compliance with organizational standards.

Required Skills & Qualifications

• 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• Hands-on experience with data mapping, data modelling, and database schema design.
• Proficiency in SQL (complex joins, stored procedures, performance tuning).
• Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
• Strong analytical and problem-solving skills.
• Experience with API-based integrations (REST/SOAP) is a plus.
• Familiarity with testing methodologies for integrations and data validation.
• Ability to work with business users, understand workflows, and translate requirements into technical solutions.

Preferred Qualifications

• Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
• Knowledge of JSON, XML, CSV transformation.
• Exposure to scripting languages (Python, Shell).
• Experience in Agile/Scrum environments.
• Prior involvement in ERP implementation or upgrade projects.

Competencies

• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
• Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
• Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
• Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
• Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.

Why Join Us?

• Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
• Work on impactful projects that make a difference across industries.
• Opportunities for professional growth and continuous learning.
• Competitive salary and benefits package.

Application Details

Ready to make an impact? Apply today and become part of the QX Impact team!

We are looking for a detail-oriented and analytical Data Analyst to join our team. The ideal candidate will be responsible for collecting, analyzing, and interpreting data to identify trends, generate insights, and support business decision-making.

The candidate should be comfortable working with large datasets, creating reports and dashboards, and communicating findings clearly to business stakeholders.

Key Responsibilities

• Collect, clean, organize, and analyze data from multiple sources.
• Identify trends, patterns, anomalies, and business opportunities from data.
• Create dashboards, reports, and visualizations for business teams.
• Track and report key performance indicators (KPIs).
• Perform ad-hoc analysis to support business and management decisions.
• Develop and maintain automated reports where possible.
• Work with stakeholders to understand reporting and analytical requirements.
• Ensure data accuracy, consistency, and quality.
• Present analytical findings in a clear and actionable manner.
• Maintain documentation for reports, dashboards, and data processes.

Business Analyst – Data (Insurance)

Job Summary

Looking for a Business Analyst with strong experience in Insurance Data and Data Analytics.

The candidate should understand Policy, Accounting, Data Mapping, Data Quality, and business requirements, and be able to bridge business and engineering teams.

Responsibilities

• Gather and document business requirements.

• Perform source-to-target mapping.

• Define business rules and transformation logic.

• Conduct data analysis and profiling.

• Work with data engineering teams during implementation.

• Define data quality rules.

• Validate delivered datasets with business users.

• Prepare functional specifications and mapping documents.

Must Have Skills •

Business Analysis

• Data Mapping

• Source-to-Target Mapping

• Data Quality

• SQL

• P&C Insurance

• Policy

• Accounting

• Excel

• Requirement Gathering

Preferred

• Claims

• Billing

• Underwriting

• Reinsurance

• Azure

• Snowflake

• Databricks  

About Us

Corporate Web Solutions provides technology-driven solutions involving data analysis, automation, web development, and digital transformation.

Role Overview

As a Data Analyst Intern, you'll assist in analyzing datasets, preparing reports, identifying trends, and exploring AI-assisted analytics workflows.

Key Responsibilities

• Collect and organize data.
• Analyze datasets and identify trends.
• Prepare reports and visualizations.
• Work with Excel, spreadsheets, or analytical tools.
• Assist with dashboards and data-driven insights.
• Explore AI tools for data analysis.

Requirements

• Basic understanding of data analysis.
• Familiarity with Excel or Google Sheets.
• Basic knowledge of SQL or Python is a plus.
• Analytical mindset.
• Good attention to detail.

Perks

• Certificate of Internship
• Flexible work hours
• Mentorship and real project exposure
• Potential for PPO
• Letter of Recommendation
• Performance-Based Stipend available up to ₹18,000/month

At Nineleaps, we work on bleeding-edge technology with class-leading engineering practices on products that touch the lives of millions of users. We endeavor on doing things the right way, while also promoting a culture of excellence.

About the Role:

We are looking for a Data Analyst with strong analytical and problem-solving skills to transform complex data into meaningful, actionable business insights. The role involves working with large datasets, conducting deep-dive analysis, driving automation, and supporting data-driven product and business decisions.

Key Responsibilities:

• Analyse historical and large datasets to understand data sources, identify trends and patterns, and uncover meaningful insights.
• Write complex SQL queries and leverage Python to perform data analysis, ad hoc investigations, and solve business problems.
• Create reports and translate analytical findings into clear, concise, and actionable recommendations for stakeholders.
• Identify opportunities to drive automation and process improvements, improving efficiency and reducing manual effort.
• Communicate data-driven insights effectively to both technical and non-technical stakeholders in a clear and impactful manner.
• Maintain accurate documentation, ensure high-quality deliverables, and consistently meet defined timelines.

Requirements:

• 3–6 years of experience in Data Analytics, Business Intelligence, Data Engineering, or a similar analytical role.
• Strong hands-on expertise in Python and advanced SQL, with the ability to work with and analyse large datasets.
• Experience working with Google Sheets, and implementing automation through data pipelines or workflows.
• Strong analytical and problem-solving skills, with the ability to interpret complex data and derive actionable insights.
• Excellent communication skills with the ability to effectively present methods, results, and recommendations to stakeholders.
• Ability to collaborate effectively with remote and geographically distributed teams across different time zones.

Company Link: https://www.nineleaps.com/

Company LinkedIn: https://www.linkedin.com/company/nineleaps/