Sr. Data Analyst at OnActive · Remote only · 8 - 12 years · ₹20L - ₹25L / yr · Bootstrapped · Remote only · Posted 5 Nov 2024

Senior Data Analyst
Experience: 8+ Years
Work Mode: Remote Full Time
Responsibilities:
• Analyze large datasets to uncover trends, patterns, and insights to support business goals.
• Design, develop, and manage interactive dashboards and reports using Power BI.
• Utilize DAX and SQL for advanced data querying and data modeling.
• Create and manage complex SQL queries for data extraction, transformation, and loading processes.
• Collaborate with cross-functional teams to understand data requirements and translate them into actionable solutions.
• Maintain data accuracy and integrity across projects, ensuring reliable data-driven insights.
• Present findings to stakeholders, translating complex data insights into simple, actionable business recommendations.
Skills:
Power BI, DAX (Data Analysis Expressions), SQL, Data Modeling, Python
Preferred Skills:
• Machine Learning: Exposure to machine learning models and their integration within analytical solutions.
• Microsoft Fabric: Familiarity with Microsoft Fabric for enhanced data integration and management.

About OnActive
About
Similar jobs (10)
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
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
Job Summary
We are seeking a skilled and detail-oriented Power BI Developer to design, develop, and maintain enterprise-level BI solutions. The ideal candidate should have strong expertise in Power BI, DAX, SQL, Data Modeling, and performance optimization tools such as DAX Studio, Tabular Editor, and ALM Toolkit. The candidate will collaborate with business stakeholders to transform data into actionable insights and deliver high-quality dashboards and reports.
Key Responsibilities
- Design, develop, and maintain interactive Power BI dashboards and reports.
- Create complex DAX measures, calculated columns, and calculated tables to meet business requirements.
- Develop and optimize SQL queries, stored procedures, views, and ETL processes.
- Design and implement scalable Star Schema and Snowflake Data Models.
- Perform report and model performance tuning using DAX Studio.
- Utilize Tabular Editor for model management, calculation groups, best practice analysis, and metadata enhancements.
- Manage model deployment, comparison, and version control using ALM Toolkit.
- Configure and manage Power BI Workspaces, Apps, Gateways, and Security (RLS/OLS).
- Work extensively with Power BI Service/Web Experience, including dataset refresh schedules, deployment pipelines, subscriptions, and workspace administration.
- Collaborate with business users to gather and analyze reporting requirements.
- Ensure data accuracy, governance, security, and report performance.
- Troubleshoot data-related issues and implement effective solutions.
- Create technical documentation and provide knowledge transfer to support teams.
Required Skills
Technical Skills
- Strong experience in Microsoft Power BI Development.
- Expertise in DAX (Data Analysis Expressions).
- Advanced knowledge of SQL Server/T-SQL and query optimization.
- Strong understanding of Data Modeling concepts (Star Schema, Snowflake Schema, Fact & Dimension Tables).
- Hands-on experience with Tabular Editor.
- Experience using DAX Studio for model and query performance tuning.
- Experience with ALM Toolkit for model comparison and deployment.
- Strong understanding of Power BI Service/Web Experience.
- Knowledge of Power Query (M Language).
- Experience with Row-Level Security (RLS) and data governance.
- Understanding of data warehousing and ETL concepts.
We’re looking for a dynamic and driven Data Analyst to join our team of technology enthusiasts. This role is crucial in transforming data into insights that support strategic decision-making and innovation within the insurance technology (InsurTech) space. If you’re passionate about working with data, understanding systems, and delivering value through analytics, we’d love to hear from you.
What We’re Looking For
- Proven experience working as a Data Analyst or in a similar analytical role
- 5+ Years of experience in the field
- Strong command of SQL for querying and manipulating relational databases
- Experience with Power BI for building impactful dashboards and reports
- Familiarity with QlikView and Qlik Sense is a plus
- Ability to communicate findings clearly to technical and non-technical stakeholders
- Knowledge of Python or R for data manipulation is nice to have
- Bachelor’s degree in Computer Science, Statistics, Mathematics, Economics, or a related field
- Understanding of the insurance industry or InsurTech is a strong advantage
What You’ll Be Doing:
- Delivering timely and insightful reports to support strategic decision-making
- Working extensively with Policy Administration System (PAS) data to uncover patterns and trends
- Ensuring data accuracy and consistency across reports and systems
- Collaborating with clients, underwriters, and brokers to translate business needs into data solutions
- Organizing and structuring datasets, contributing to data engineering workflows and pipelines
- Producing analytics to support business development and market strategy
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/
Job Title: Power BI Developer
Experience: 4+ Years
Location: Pune, Thane (Maharashtra), Indore (Madhya Pradesh)
Employment Type: Full Time with NAM Info Pvt Ltd (Payroll)
Job Description:
- Develop and maintain database and ETL solutions using Microsoft Fabric.
- Create interactive dashboards and reports using Power BI (preferred).
- Work with Qlik Sense or other data visualization tools.
- Write and optimize SQL queries for data analysis and reporting.
- Collaborate with business teams to understand reporting requirements and deliver data solutions.
Required Skills:
- Microsoft Fabric
- Power BI
- Qlik Sense or any Data Visualization Tool
- SQL
- MySQL
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.
About the Role
We are seeking an experienced Power BI Developer to design, develop, and maintain interactive dashboards and reports that drive data-informed decision-making across the business. The ideal candidate will have deep expertise in DAX, Power Query, data modeling, and enterprise data integration, along with strong communication skills to coordinate directly with clients, and the ability to mentor junior team members.
Key Responsibilities
- Design, develop, and maintain interactive Power BI dashboards and reports
- Develop complex DAX measures, calculated columns, and KPIs
- Build and optimize data models using star and snowflake schema design
- Perform data transformation and cleansing using Power Query (M Language)
- Connect Power BI with enterprise data sources including SQL Server, Oracle, PostgreSQL, APIs, Excel, and SharePoint
- Optimize report performance and troubleshoot data/report issues
- Implement Row-Level Security (RLS) and manage Power BI Service workspaces
- Partner with business stakeholders and clients to gather and translate reporting requirements
- Mentor junior developers and contribute to overall BI solution architecture
Required Skills & Experience
- 3-4 years of hands-on Power BI development experience
- Strong proficiency in Power BI Desktop, Power BI Service, DAX, Power Query, SQL, and data modeling
- Experience with relational databases such as SQL Server, Oracle, or PostgreSQL
- Solid understanding of ETL processes and performance tuning
- Excellent analytical, communication, and problem-solving skills, with the ability to coordinate directly with clients and stakeholders
- Basic understanding of Object-Level Security (OLS) in Power BI (not mandatory, but working knowledge is a plus)
- Experience with Incremental Refresh (Incremental Load) and DAX optimization for large datasets
- Hands-on experience handling large datasets (4GB+) in Power BI/Power Query, along with performance and query optimization techniques
- Exposure to big data platforms such as Databricks
- Strong working knowledge of DAX queries and functions
- Familiarity with Power BI MCP Server and AI-driven features (e.g., Copilot in Power BI, natural language querying via MCP)
Preferred / Nice-to-Have Skills
- Experience with Microsoft Fabric
- Knowledge of Azure Data Factory, Azure Synapse, or Azure SQL
- Microsoft Power BI Certification
Eligibility Criteria
- Immediate joiners only — maximum notice period of 15 days
- Must be available to work the 4:00 PM – 11:40 PM IST shift
- Comfortable working in a 100% remote setup
- Excellent communication skills, as the role requires regular coordination with clients
We are looking for a People Analytics Manager to turn people data into decisions.
Responsibilities
- Build HR and recruitment dashboards
- Analyse hiring, attrition and engagement trends
- Improve HR data quality
- Present insights to HR leadership
Requirements
- 3+ years in people or HR analytics
- Skilled in Power BI or Tableau, and SQL or Excel
- Strong storytelling with data
The Power BI Intern will assist the analytics team in using Microsoft Power BI to create interactive dashboards and reports. Working with actual datasets to assist well-informed business decision-making, this position provides practical exposure to data analysis, visualization, and business intelligence techniques.






