Data Science Analyst at Angel One · Remote only · 1 - 4 years · ₹5L - ₹16L / yr · Profitable · Remote only · Posted 22 Aug 2022

Position description:
- Architect and own the report automation framework using GCP’s Bigquery and any scripting language (R/Python)
- Work on the enhancement of existing and new analysis on Tableau
- Work closely with the existing team and mentor them
- Work on Ad-hoc analysis
Primary Responsibilities:
- Architect and own the report automation framework using GCP’s Bigquery and any scripting language (R/Python)
Reporting Team
- Reporting Designation: Data Science Analyst
- Reporting Department: Digital Analytics BI (2511)
Required Skills:
- Hands-on experience in relevant tools like SQL(expert), Excel, R/Python, Tableau/PowerBI
- Advanced ability to draw insights from data and clearly communicate them to the stakeholders and senior management as required

About Angel One
About
We are Angel One (formerly known as Angel Broking). India's most trusted Fintech company and an all-in-One financial house. Founded in 1996 Angel One offers a world-class experience across all digital channels including web, trading software and mobile applications, to help make millions of Indians informed investment decisions.
Certified as a Great Place To Work for six-consecutive years, we are driven by technology and a mission to become the No. 1 fintech organization in India. With a 9.2 Million+ registered client base and more than 18+ million app downloads, we are onboarding more than 400,000 new users every month. We are working to build personalized financial journeys for customers via a single app, powered by new-age engineering tech and Machine Learning.
We are a group of self-driven, motivated individuals who enjoy taking ownership and believe in providing the best value for money to investors through innovative products and investment strategies. We apply and amplify design thinking with our products and solution.
It is a flat structure, with ample opportunity to showcase your talent and a growth path for engineers to the very top. We are remote-first, with people spread across Bangalore, Mumbai and UAE. Here are some of the perks that you'll enjoy as an Angelite,
- Work with world-class peer group from leading organizations
- Exciting, dynamic and agile work environment
- Freedom to ideate, innovate, express, solve and create customer experience through #Fintech & #ConsumerTech
- Cutting edge technology and Products / Digital Platforms of future
- Continuous learning interventions and upskilling
- Open culture to collaborate where failing fast is encouraged to invent new ways and methods, join our Failure Club to experience it
- 6-time certified as a Great Place To Work culture
- Highly competitive pay structures, one of the best
Come say Hello to ideas and goodbye to hierarchies at Angel One!
Photos
Connect with the team
Similar jobs (10)
Job Title: Senior Data Analyst
Location: Sharnam Metrolinks, Amraiwadi, Ahmedabad
Working Days: 6 Days a Week
Department: MDO
Reporting To: COO
Employment Type: Full-Time
Job Summary
We are seeking a highly analytical and detail-oriented Senior Data Analyst to lead data management, reporting, automation, and system development initiatives across the organization.
The role focuses on transforming raw data into meaningful insights, designing and implementing automated systems, strengthening data structures, and supporting cross-functional teams with accurate, actionable intelligence to drive strategic and operational business decisions.
Key Responsibilities
1. Data Management & Reporting
● Collect, clean, validate, and consolidate data from multiple internal and external sources.
● Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.
● Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.
2. Database & Data Accuracy Management
● Manage and regularly update internal databases, spreadsheets, and reporting systems.
● Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.
● Implement best practices for data validation, version control, and audit checks.
3. Data Analysis & Business Insights
● Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.
● Translate data findings into clear, actionable insights and recommendations to support
strategic and operational decision-making.
4. Reporting Automation, System Recommendation & Implementation
● Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.
● Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.
● Proactively suggest new automation tools, system enhancements, or integrations to
improve efficiency, accuracy, and scalability.
● Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.
● Continuously monitor and optimize automated systems in line with business growth and evolving data needs.
5. Cross-Functional Coordination & Support
● Collaborate with Sales, HR, Finance, Operations, and other departments to understand
reporting and data requirements.
● Provide support for ad-hoc analysis, custom reports, and special data requests.
● Act as a data partner to department heads for decision support and performance tracking.
6. Documentation & Compliance
● Maintain complete and updated documentation for MIS processes, reports, data models,
automation logic, and system changes.
● Ensure compliance with company data governance policies and applicable data protection standards.
System Development & Data Structuring Responsibilities
● Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.
● Review existing manual and digital data systems to identify operational gaps, risks, and
mprovement opportunities.
● Recommend structured data models, reporting formats, and storage solutions aligned with
business requirements.
● Coordinate with department heads to define data structures, access levels, and reporting
standards.
● Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP
integrations) with minimal operational disruption.
● Design structured data formats and role-based access controls to ensure secure and
organized data management.
● Train employees on newly implemented systems and provide post-implementation
support.
● Monitor system performance, resolve issues, and continuously improve systems based on
user feedback and organizational growth.
Qualifications & Experience
● Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.
● 3–5 years of experience in data analytics, reporting, or system automation roles.
● Strong analytical thinking, logical reasoning, and problem-solving abilities.
● High attention to detail with excellent organizational and documentation skills.
Technical Skills (Must Have)
● Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts
● BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)
● Google Apps Script: Automation in Google Sheets, custom functions, triggers, API integrations, workflow optimization
● Vlook
Preferred Skills
● Strong verbal and written communication skills
● Ability to handle sensitive and confidential information responsibly
● Quick learner with a tech-savvy, improvement-driven, and solution-oriented mindset

Experience: 7–10+ years | Industry Preference: Financial Services / BFSI
Role Overview
We are seeking a Senior Reporting Analyst / Business Intelligence Lead to own and drive
enterprise reporting, analytics, and data insights across the organization. This is a senior,
hands-on role requiring deep technical expertise across the Microsoft data and BI stack,
strong business acumen, and the ability to operate with minimal hand-holding. The ideal
candidate will act as a bridge between business leadership and technical teams, translating
complex business questions into scalable, reliable data models and executive-ready insights.
Key Responsibilities
Serve as the primary owner of enterprise reporting and BI solutions, from data
ingestion through executive dashboards.
Design, build, and maintain scalable Power BI / Microsoft Fabric semantic models using
STAR schema best practices.
Partner closely with business stakeholders and C-level executives to define KPIs,
metrics, and reporting requirements.
Lead and present weekly reporting and insights sessions with senior and executive
leadership.
Ensure data accuracy, consistency, and trust across all reports and analytics outputs.
Proactively identify data quality issues, root causes, and remediation strategies.
Drive automation of reporting, alerts, and data refresh processes to reduce manual
effort.
Collaborate with engineering, data, and application teams to align business logic with
source system data structures.
Mentor junior analysts and establish BI standards, best practices, and documentation.
Technical Skills – Data & Backend
Advanced SQL: complex queries, views, stored procedures, and validation against
source systems (RDN, Recovery Connect).
Azure Data Factory: build and manage copy pipelines from SQL sources to data
warehouses / dedicated pools.
Incremental refresh, parameterized pipelines, and schema replication.
Data warehouse design: STAR schema, fact vs dimension tables, handling deleted
records and SCDs.
Technical Skills – Reporting & Frontend
Power BI / Microsoft Fabric: Power Query, DAX, and M language expertise.
Semantic model design (1-to-many, 1-to-1, many-to-1 relationships).
Query folding and performance optimization best practices.
Paginated Report Builder (SSRS-style) for automated Excel and PDF reporting.
Power Automate integration for alerts and workflow-driven notifications.
Data Quality & Analytics
Ability to clean, normalize, and reconcile data across multiple systems.
Strong troubleshooting skills when business definitions and data do not align.
Translate business terminology into accurate technical mappings and calculations.
Communication & Leadership
Serve as a key liaison between business stakeholders and technical teams.
Comfortable working directly with C-level executives and senior leadership.
Ability to lead executive-level meetings and clearly communicate insights.
Self-starter mindset with minimal hand-holding.
Qualifications
7–10+ years of experience in BI, analytics, or enterprise reporting roles.
Preferred experience in financial services or regulated environments.
Strong experience across the Microsoft BI ecosystem.
Preferred Certifications
Microsoft PL-300 (Power BI Data Analyst)
Microsoft DP-600 (Fabric Analytics Engineer)
Microsoft DP-700 (Fabric Data Engineer)
What Success Looks Like
Executive leadership trusts and relies on BI dashboards for decisions.
Reporting is automated, accurate, and scalable.
BI functions as a strategic partner to the business.
Role Overview
We are seeking a Senior Reporting Analyst / Business Intelligence Lead to own and drive enterprise reporting, analytics, and data insights across the organization. This is a senior, hands-on role requiring deep technical expertise across the Microsoft data and BI stack, strong business acumen, and the ability to operate with minimal hand-holding. The ideal candidate will act as a bridge between business leadership and technical teams, translating complex business questions into scalable, reliable data models and executive-ready insights.
Key Responsibilities
· Serve as the primary owner of enterprise reporting and BI solutions, from data ingestion through executive dashboards.
· Design, build, and maintain scalable Power BI / Microsoft Fabric semantic models using STAR schema best practices.
· Partner closely with business stakeholders and C-level executives to define KPIs, metrics, and reporting requirements.
· Lead and present weekly reporting and insights sessions with senior and executive leadership.
· Ensure data accuracy, consistency, and trust across all reports and analytics outputs.
· Proactively identify data quality issues, root causes, and remediation strategies.
· Drive automation of reporting, alerts, and data refresh processes to reduce manual effort.
· Collaborate with engineering, data, and application teams to align business logic with source system data structures.
· Mentor junior analysts and establish BI standards, best practices, and documentation.
Technical Skills – Data & Backend
· Advanced SQL: complex queries, views, stored procedures, and validation against source systems (RDN, Recovery Connect).
· Azure Data Factory: build and manage copy pipelines from SQL sources to data warehouses / dedicated pools.
· Incremental refresh, parameterized pipelines, and schema replication.
· Data warehouse design: STAR schema, fact vs dimension tables, handling deleted records and SCDs.
Technical Skills – Reporting & Frontend
· Power BI / Microsoft Fabric: Power Query, DAX, and M language expertise.
· Semantic model design (1-to-many, 1-to-1, many-to-1 relationships).
· Query folding and performance optimization best practices.
· Paginated Report Builder (SSRS-style) for automated Excel and PDF reporting.
· Power Automate integration for alerts and workflow-driven notifications.
Data Quality & Analytics
· Ability to clean, normalize, and reconcile data across multiple systems.
· Strong troubleshooting skills when business definitions and data do not align.
· Translate business terminology into accurate technical mappings and calculations.
Communication & Leadership
· Serve as a key liaison between business stakeholders and technical teams.
· Comfortable working directly with C-level executives and senior leadership.
· Ability to lead executive-level meetings and clearly communicate insights.
· Self-starter mindset with minimal hand-holding.
Qualifications
· 7–10+ years of experience in BI, analytics, or enterprise reporting roles.
· Preferred experience in financial services or regulated environments.
· Strong experience across the Microsoft BI ecosystem.
Preferred Certifications
· Microsoft PL-300 (Power BI Data Analyst)
· Microsoft DP-600 (Fabric Analytics Engineer)
· Microsoft DP-700 (Fabric Data Engineer)
What Success Looks Like
· Executive leadership trusts and relies on BI dashboards for decisions.
· Reporting is automated, accurate, and scalable.
· BI functions as a strategic partner to the business.
Data Engineer
Experience - 5+ years
6-7 LPA
Remote
Duration: 1 month contract (We can take as a tentative, It can be extended)
Scope: Subscriber Activation, Churn, FTE and future reporting requirements, with BigQuery as the centralized data warehouse and Power BI as the proposed reporting layer.
Key Skills:
Strong hands-on experience with GCP & BigQuery
Data warehouse architecture, design and implementation
Data ingestion/integration across multiple source systems
ETL/ELT and data pipeline development
Data modelling for reporting and analytics
Experience integrating BigQuery with Power BI or similar reporting tools
Strong Data Analyst Profile with Python, SQL, and data-pipeline expertise, ideally with retail / e-commerce datasets
2
Mandatory (Experience 1): Must have 4+ years of hands-on data-analyst experience, working with large datasets across areas such as sales, inventory, pricing, promotions, and customer behaviour.
3
Mandatory (Tech skill 1): Must have strong hands-on Python for data processing, transformation, automation, and analysis
4
Mandatory (Tech skill 2): Must have strong SQL skills, including complex queries, joins, aggregations, and data validation.
5
Mandatory (Tech skill 3): Must have a solid understanding of Data Lake architecture, ingestion, storage, and processing workflows
6
Mandatory (Tech skill 4): Must have hands-on experience with ETL / ELT pipelines, data integration, and transformation
7
Mandatory (Tech skill 5): Must have experience with Azure or GCP data services.
8
Mandatory (Tech skill 6): Must have understanding of or experience with Databricks and distributed data processing.
9
Mandatory (Tech skill 7): Must have knowledge of data modeling, data warehousing, and Lakehouse architecture
10
Mandatory (Tech skill 8): Must have experience with Power BI, Tableau, or Excel for reporting.
11
Mandatory (Communication): Must have strong analytical, documentation, and stakeholder-communication skills.
12
Mandatory (Education): Must hold a Bachelor’s degree in Computer Science, IT, Engineering, or a related field.
13
Mandatory (Note1): This is a 6-month contract role. Candidate must be comfortable with the contract engagement and able to join immediately (urgent — onboarding within ~a week)
About the Role
We are looking for enthusiastic Data Analytics Interns to join our team remotely for a 3-month internship. This is an excellent opportunity to gain hands-on experience in data analysis, data visualization, database management, and reporting. The selected candidates will have the opportunity to work on real projects, analyze datasets, and develop their technical and analytical skills.
Responsibilities
- Assist in collecting, cleaning, organizing, and analyzing datasets.
- Work with SQL and databases for data retrieval, manipulation, and analysis.
- Use Microsoft Excel to organize data, perform calculations, and prepare reports.
- Assist in creating dashboards and visualizations using Power BI or Tableau.
- Work with Python libraries such as Pandas and NumPy for data analysis.
- Perform exploratory data analysis to identify trends, patterns, and insights.
- Prepare reports and presentations based on analytical findings.
- Assist in tracking key performance indicators (KPIs) and monitoring business data.
- Maintain accurate documentation of data analysis activities and project contributions.
- Collaborate with team members on data-related projects and analytical tasks.
Requirements
- Basic knowledge of Data Analytics and data analysis concepts.
- Understanding of SQL and database fundamentals.
- Familiarity with Microsoft Excel and data management.
- Basic knowledge of Python is preferred.
- Familiarity with data visualization tools such as Power BI or Tableau is an advantage.
- Strong analytical and problem-solving skills.
- Good research and organizational abilities.
- Attention to detail and accuracy.
- Ability to work independently in a remote environment.
- Good communication skills and eagerness to learn.
What You'll Gain
- Real-world experience in data analytics and business intelligence.
- Hands-on experience with data cleaning, analysis, and visualization.
- Exposure to industry-relevant tools such as SQL, Python, Excel, and Power BI.
- Mentorship and exposure to practical analytical processes.
- Completion Certificate at the end of the internship.
- Letter of Recommendation based on performance.
- Opportunity to strengthen your portfolio with real-world data projects.
Internship Details
- Duration: 3 months
- Location: Remote (Work from Home)
- Perks: Completion Certificate + Letter of Recommendation
Databricks BI Developer / Engineer
Rate: 25 LPA
Exp- 5+ years
Location: Remote
Time zone: ET (US Eastern Time)
Shift: Night Shift
Requirements must have: Databricks, Spark, BI (Tableau or something different, or ready to learn quickly)
Task: Main responsibility is the migration of existing Tableau dashboards to Databricks AI/BI Dashboards
We are looking for someone with Databricks experience, strong analytical skills, and the ability to work effectively with ambiguous requirements. Strong communication skills are essential, as the role requires close collaboration with multiple stakeholders, Databricks consultants, and technical teams.
DATABRICKS BI DEVELOPER / ENGINEER
Location: Remote
Experience: 5+ Years
Budget: Up to ₹25 LPA
Work Mode: Remote
Shift: US Eastern Time (ET) – Night Shift
Job Description
We are looking for an experienced Databricks BI Developer / Engineer with strong hands-on experience in Databricks and Apache Spark to support a dashboard migration project.
The primary responsibility will be migrating existing Tableau dashboards to Databricks AI/BI Dashboards.
Key Responsibilities
- Migrate existing Tableau dashboards to Databricks AI/BI Dashboards.
- Work with Databricks and Spark to analyse and process data.
- Understand business requirements and translate them into effective BI solutions.
- Collaborate with Databricks consultants, stakeholders, and technical teams.
- Handle ambiguous requirements and provide analytical solutions.
- Ensure dashboard accuracy, performance, and reliability.
- Communicate project progress and technical updates effectively.
Required Skills
- 5+ years of relevant professional experience.
- Strong hands-on experience with Databricks.
- Good experience with Apache Spark / PySpark.
- Experience with Tableau or other BI tools such as Power BI.
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder management skills.
- Ability to understand and work with evolving or ambiguous requirements.
- Willingness to learn Databricks AI/BI Dashboards quickly, if not already experienced.
Work Requirements
- Remote opportunity.
- Must be comfortable working in the US Eastern Time (ET) night shift.
- Budget: Up to ₹25 LPA.
Data Engineer – Contract Opportunity
We are looking for an experienced Data Engineer with 5+ years of experience to work on subscriber activation, churn, FTE, and future reporting requirements.
Key Responsibilities:
- Work on data requirements related to Subscriber Activation, Churn, FTE, and future reporting.
- Work with BigQuery as the centralized data warehouse.
- Develop and maintain data ingestion and integration pipelines across multiple source systems.
- Design and implement ETL/ELT processes.
- Develop data models for reporting and analytics.
- Integrate BigQuery with Power BI or similar reporting tools.
Required Skills:
- Strong hands-on experience with GCP & BigQuery
- Data warehouse architecture, design, and implementation
- Data ingestion/integration across multiple source systems
- ETL/ELT and data pipeline development
- Data modelling for reporting and analytics
- Experience integrating BigQuery with Power BI or similar reporting tools
Contract: 1 month initially, with potential extension
Compensation: ₹6–7 LPA
Work Mode: Remote
Important
Since this is only a 1-month contract, mention “Potential extension” rather than saying it will definitely be extended.
About VerbaFlo.ai:
VerbaFlo.ai is a fast-growing AI SaaS startup revolutionizing how businesses leverage AI-powered solutions. As a part of our dynamic team, you’ll work alongside industry leaders and visionaries to drive innovation and execution across multiple functions.
Role Overview:
We are seeking a Senior Business Data Analyst with strong experience in analytics, SQL, and dashboarding (preferably Metabase) who can independently lead complex analytical initiatives, translate business problems into scalable data solutions, and mentor junior analysts. This role demands someone who can think strategically, operate with high ownership, and ensure the company runs on accurate, timely, and actionable insights.
Responsibilities:
Strategic & Cross-Functional Ownership
- Partner with leadership (Product, Ops, Growth, Finance) to translate business goals into analytical frameworks, KPIs, and measurable outcomes.
- Influence strategic decisions by providing data-driven recommendations, forecasting, and scenario modeling.
- Drive adoption of data-first practices across teams and proactively identify high-impact opportunity areas.
Analytics & Dashboarding
- Own end-to-end development of dashboards and analytics systems in Metabase (or similar BI tools).
- Build scalable KPI frameworks, business reports, and automated insights to support day-to-day and long-term decision-making.
- Ensure data availability, accuracy, and reliability across reporting layers.
Advanced Data Analysis
- Write, optimize, and review complex SQL queries for deep-dives, cohort analysis, funnel performance, and product/operations diagnostics.
- Conduct root-cause analysis, hypothesis testing, and generate actionable insights with clear recommendations.
Data Infrastructure Collaboration
- Work closely with engineering/data teams to define data requirements, improve data models, and support robust pipelines.
- Identify data quality issues, define fixes, and ensure consistency across systems and sources.
Leadership & Process Excellence
- Mentor junior analysts, review their work, and establish best practices across analytics.
- Standardize reporting processes, create documentation, and improve analytical efficiency.
Core Requirements:
- 5–8 years of experience as a Business Analyst, Data Analyst, Product Analyst, or similar role in a fast-paced environment.
- Strong proficiency in SQL, relational databases, and building scalable dashboards (Metabase preferred)
- Demonstrated experience in converting raw data into structured analysis, insights, and business recommendations.
- Strong understanding of product funnels, operational metrics, and business workflows.
- Ability to communicate complex analytical findings to both technical and non-technical stakeholders.
- Proven track record of independently driving cross-functional initiatives from problem definition to execution.
- Experience with Python, Git, or BI tools like Looker/Power BI/Tableau.
- Hands-on with data warehouses (BigQuery, Redshift, Snowflake).
- Familiarity with product analytics tools (Mixpanel, GA4, Amplitude).
- Exposure to forecasting, financial modeling, or experimentation (A/B testing).
Why Join Us?
- Work directly with top leadership in a high-impact role.
- Be part of an innovative and fast-growing AI startup.
- Opportunity to take ownership of key projects and drive efficiency.
- A collaborative, ambitious, and fast-paced work environment.
- Perks & Benefits: gym membership benefit, workation policy, and company-sponsored lunch.
If you’re looking for an exciting role that combines strategy, execution, and leadership exposure, we’d love to hear from you!
Apply now to join VerbaFlo.AI on this journey.

















