Cognos BI Developer

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

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.

Only Immediate joiners are considered.

Key Skills:

Technical Skills

• Power BI Development: 4-5 years of hands-on experience developing Power BI reports, dashboards, and data models
• DAX: Strong proficiency in DAX (Data Analysis Expressions) for creating measures, calculated columns, and complex calculations
• Power Query / M Language: Expertise in data transformation and ETL processes using Power Query
• Data Modeling: Solid understanding of dimensional modeling, star schema, and data warehouse concepts
• SQL: Proficient in SQL for data extraction, manipulation, and querying relational databases
• Power BI Service: Experience with Power BI Service administration, workspace management, scheduled refreshes, and deployment pipelines
• Custom Visualizations: Experience creating and configuring custom visuals, including use of AppSource visuals and custom visual development using Power BI Visuals SDK
• API Integration: Hands-on experience with Power BI REST APIs for automating deployments, managing workspaces, and embedding reports
• Knowledge of data visualization best practices and UI/UX principles for dashboard design
• Experience with data source connectivity (SQL Server, Azure SQL, Oracle, SAP, Excel, APIs, web services)

Additional Required Qualifications

• Bachelor’s degree in computer science, Information Systems, Business Analytics, or related field
• Strong analytical and problem-solving abilities
• Excellent communication skills to work with both technical and non-technical stakeholders
• Ability to manage multiple projects and prioritize tasks effectively
• Detail-oriented with commitment to delivering high-quality work
• Client-facing experience with ability to gather requirements and present solutions

Preferred Qualifications

• Microsoft Power BI certification (PL-300 or equivalent)
• Experience with Azure ecosystem (Azure Data Factory, Azure Synapse Analytics, Azure SQL Database)
• Knowledge of other Microsoft BI tools (SSRS, SSAS, Excel Power Pivot)
• Familiarity with Python or R for advanced analytics integration
• Experience with Dataflows and incremental refresh strategies
• Understanding of API development for custom visuals or Power BI embedded solutions
• Experience working in Agile/Scrum development environments

Key Skills:

Technical Skills

• Power BI Development: 4-5 years of hands-on experience developing Power BI reports, dashboards, and data models
• DAX: Strong proficiency in DAX (Data Analysis Expressions) for creating measures, calculated columns, and complex calculations
• Power Query / M Language: Expertise in data transformation and ETL processes using Power Query
• Data Modeling: Solid understanding of dimensional modeling, star schema, and data warehouse concepts
• SQL: Proficient in SQL for data extraction, manipulation, and querying relational databases
• Power BI Service: Experience with Power BI Service administration, workspace management, scheduled refreshes, and deployment pipelines
• Custom Visualizations: Experience creating and configuring custom visuals, including use of AppSource visuals and custom visual development using Power BI Visuals SDK
• API Integration: Hands-on experience with Power BI REST APIs for automating deployments, managing workspaces, and embedding reports
• Knowledge of data visualization best practices and UI/UX principles for dashboard design
• Experience with data source connectivity (SQL Server, Azure SQL, Oracle, SAP, Excel, APIs, web services)

Additional Required Qualifications

• Bachelor’s degree in computer science, Information Systems, Business Analytics, or related field
• Strong analytical and problem-solving abilities
• Excellent communication skills to work with both technical and non-technical stakeholders
• Ability to manage multiple projects and prioritize tasks effectively
• Detail-oriented with commitment to delivering high-quality work
• Client-facing experience with ability to gather requirements and present solutions

Preferred Qualifications

• Microsoft Power BI certification (PL-300 or equivalent)
• Experience with Azure ecosystem (Azure Data Factory, Azure Synapse Analytics, Azure SQL Database)
• Knowledge of other Microsoft BI tools (SSRS, SSAS, Excel Power Pivot)
• Familiarity with Python or R for advanced analytics integration
• Experience with Dataflows and incremental refresh strategies
• Understanding of API development for custom visuals or Power BI embedded solutions
• Experience working in Agile/Scrum development environments

We are seeking a talented Senior Power BI Engineer to join our team and deliver high-quality business intelligence solutions for our clients.

Technical Skills:

• Power BI Development: 4-5 years of hands-on experience developing Power BI reports, dashboards, and data models
• DAX: Strong proficiency in DAX (Data Analysis Expressions) for creating measures, calculated columns, and complex calculations
• Power Query / M Language: Expertise in data transformation and ETL processes using Power Query
• Data Modeling: Solid understanding of dimensional modeling, star schema, and data warehouse concepts
• SQL: Proficient in SQL for data extraction, manipulation, and querying relational databases
• Power BI Service: Experience with Power BI Service administration, workspace management, scheduled refreshes, and deployment pipelines
• Custom Visualizations: Experience creating and configuring custom visuals, including use of AppSource visuals and custom visual development using Power BI Visuals SDK
• API Integration: Hands-on experience with Power BI REST APIs for automating deployments, managing workspaces, and embedding reports
• Knowledge of data visualization best practices and UI/UX principles for dashboard design
• Experience with data source connectivity (SQL Server, Azure SQL, Oracle, SAP, Excel, APIs, web services)
• Looking out for only immediate joiners

Responsibilities:

• Design, develop, and deploy interactive Power BI dashboards and reports for client projects
• Build and optimize data models using star schema and snowflake schema design patterns
• Develop complex DAX measures and calculated columns to support business requirements
• Connect to and integrate data from multiple sources including SQL databases, Excel, APIs, cloud platforms, and data warehouses
• Implement data transformation and cleansing using Power Query (M language)
• Collaborate with clients and stakeholders to gather requirements and translate business needs into technical specifications
• Optimize report performance through query optimization, aggregations, and efficient data modeling
• Configure and manage Power BI Service including workspaces, datasets, dataflows, and row-level security (RLS)
• Create and maintain documentation for data models, reports, and development processes
• Provide training and support to end-users on Power BI reports and dashboards
• Design and implement custom visualizations using Power BI custom visuals and third-party visual libraries.
• Implement conditional formatting, dynamic titles, and dynamic content based on user selections
• Stay current with Power BI updates, new features, and industry best practices

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'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

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
• 3+ 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

Position title: Business Intelligence and Data Analyst

Summary -

• Operate and continuously improve the CARS/BI backend within the global Enterprise Data and Business Intelligence platform, ensuring system stability, continuous data loading, and Warehouse the timely delivery of business-critical reports.

• Own the underlying data foundation — SQL pipelines, relational data models, and data warehouse structures — that internal reporting teams and global Data Management initiatives depend on, and act as 1st and 2nd level support for internal customers such as SCM and Sales.

• The role is needed to secure daily BI availability in the Asian time zone, reduce the risk of late or incorrect reporting, and add dedicated database and ETL capacity to the global BI team, including support to the Data Centre team on infrastructure-related issues.

Responsibilities:

• Operate, monitor, and maintain the CARS/BI data integration and data processing workflows, ensuring continuous data loading and stable daily business operations.

• Provide 1st and 2nd level support for CARS/BI, including user support, incident handling, and root-cause analysis of data issues.

• Develop, maintain, and optimise SQL-based data pipelines and transformations within the Enterprise Data Warehouse.

• Design and maintain relational data models and data warehouse structures for CARS BI.

• Integrate data from ERP and other enterprise systems into the BI backend.

• Ensure data consistency, integrity, and performance at the database level, including query tuning and database efficiency improvements.

• Administer the BI technical environment and contribute to its continuous enhancement as part of a global team.

• Support reporting teams by providing structured, reliable datasets and safeguarding the timely delivery of business-critical reports.

• Contribute to global Data Management initiatives, with a focus on Master Data Management and the development of a Common Data Model within the Business Integration Platform.

• Collaborate with the Data Centre team to resolve infrastructure-related issues affecting BI availability.

Education and Experience:

Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, or a comparable technical field.

Minimum 3 years of relevant professional experience in Business Intelligence, data warehousing, or database development, including hands-on SQL and ETL work in an enterprise environment.

Experience supporting business users in a global or multi-time-zone IT organisation is an advantage.

Competencies:

• Knowledge about either BI platforms (e.g. IBM Cognos BI suite) or ETL tools (e.g. Informatica PowerCenter)

• Database, data modeling and SQL (preferred Oracle PLSQL)

• Good analytical and communication skills

• Teamplayer

• English

• Strong hands-on experience with SQL (advanced level)

• Solid understanding of relational databases and data warehouse concepts

• Experience with ETL tools and database technologies (e.g., Oracle, SQL Server, SAP BW,Informatica or similar)

• Performance tuning and query optimization skills

• Structured, detail-oriented, and quality-focused working style

• Good understanding of enterprise data flows (SAP/CARS is a plus)

Key Interfaces and Stakeholders:

Only internal customers with different topics: e.g. SCM, Sales etc.

Geography to cover and Travel requirements:

Asian Time Zone, Sometimes travel is required

Behavioral Characteristics

Reliability and accountability — the role safeguards daily reporting availability, so dependable ownership of monitoring and issue follow-up is expected. Structured, analytical problem solving with the patience for thorough root-cause analysis. Service orientation and clear communication towards internal customers such as SCM and Sales. Initiative taking and self-reliance, given largely independent work in the Asian time zone. Cooperation and team spirit within a globally distributed BI team across cultures and time zones. Flexibility and resilience under time pressure, including occasional off-hours support during critical data loads. Integrity and discretion when handling confidential business data. Quality focus and attention to detail, with a continuous improvement mindset.

Interview process

2 rounds - Virtual interview and 1 round Face to Face

Any other Criteria

• Notice Period: Below 60 or 90 Days . No Negotiation on Notice Period
• Gender: Female and Male; Female preferred
• Qualification:Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, 

Key Responsibilities

• Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
• Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
• Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
• Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
• Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
• Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
• Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
• Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
• Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.

Required Skills & Qualifications

• Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.
• Proven experience (1–3 years or as per company requirement) in MIS, data reporting/analysis, or similar role.
• Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
• Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
• Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
• Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
• Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.