Data Analyst

Job Description: SQL Developer – Mutual Fund / Capital Markets

Location: Noida, Uttar Pradesh

Work Mode: Hybrid

Experience Required: 10+ Years

Employment Type: Full-time

Job Summary

We are looking for an experienced SQL Developer with strong expertise in Microsoft SQL Server, T-SQL programming, complex query development, and database performance optimization. The ideal candidate should have hands-on experience designing, developing, maintaining, and optimizing database objects and handling complex data processing requirements.

Experience in the Mutual Fund or Capital Markets domain will be highly preferred, particularly in financial systems, transaction processing, data reconciliation, and financial reporting.

Key Responsibilities

• Design, develop, maintain, and optimize SQL Server database schemas and database objects.
• Develop and maintain complex T-SQL queries, stored procedures, functions, triggers, views, SQL Jobs, and scripts.
• Perform query optimization and database performance tuning to improve execution speed and efficiency.
• Analyze execution plans, implement indexing strategies, and work with partitioning and performance monitoring.
• Review existing SQL queries and identify performance bottlenecks and opportunities for improvement.
• Perform data extraction, transformation, migration, data porting, and data processing activities.
• Translate business and financial reporting requirements into effective SQL and database solutions.
• Troubleshoot database issues and provide timely resolutions.
• Support production and UAT environments for database-related issues.
• Perform data validation, reconciliation, and migration activities while ensuring data accuracy and consistency.
• Maintain database security, data integrity, and compliance with established standards.
• Collaborate with application developers, business analysts, QA teams, and other stakeholders.
• Take ownership of assigned tasks and deliver solutions independently.

Required Technical Skills

• Advanced knowledge of Microsoft SQL Server and T-SQL.
• Strong hands-on experience with stored procedures, functions, triggers, views, and SQL Server Jobs.
• Proven expertise in developing simple, medium, and complex SQL queries.
• Strong experience in complex data manipulation and data processing.
• Expertise in SQL query performance tuning and optimization.
• Hands-on knowledge of indexing, execution plan analysis, partitioning, and performance monitoring.
• Ability to analyze, debug, and optimize existing SQL queries.
• Strong database troubleshooting and problem-solving skills.
• Understanding of code versioning and version control systems.
• Knowledge of database security standards and best practices.
• Familiarity with data visualization tools will be an added advantage.

Domain Knowledge

• Good understanding of the Mutual Fund domain is preferred.
• Experience with Capital Markets data platforms and financial systems will be an advantage.
• Understanding of financial transactions, business processes, data reconciliation, and financial reporting requirements is desirable.

Educational Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Relevant certifications or advanced qualifications will be an added advantage.

Preferred Candidate Profile

• 10+ years of relevant experience in SQL Server development.
• Strong technical expertise in T-SQL development and database optimization.
• Ability to work independently and manage complex database requirements.
• Strong analytical, debugging, and communication skills.
• Candidates with relevant Mutual Fund or Capital Markets experience will be preferred.

Work Location: Noida, Uttar Pradesh | Work Mode: Hybrid

Position : SQL Database Developer

Experience : 10+ Years

Domain : Mutual Fund / Capital Markets

Location : Noida

Work Mode : Hybrid

Role Overview :

We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.

Mandatory Skills :

• SQL Server & T-SQL
• Stored Procedures, Functions, Triggers, Views & SQL Jobs
• Complex SQL Queries & Data Manipulation
• Query Performance Tuning & Optimization
• Indexing, Execution Plans & Partitioning
• Data Migration, Porting, Transformation & Validation
• Database Troubleshooting
• SQL Server Performance Monitoring
• Version Control / Git
• Database Security & Data Integrity

Domain Knowledge :

• Mutual Fund / Capital Markets experience preferred.
• Understanding of financial transactions, reporting, reconciliation, and business processes.

Key Responsibilities :

• Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
• Perform query tuning, indexing, execution plan analysis, and performance optimization.
• Handle data migration, transformation, porting, validation, and reconciliation.
• Troubleshoot database and production/UAT issues.
• Ensure data accuracy, integrity, consistency, and security.
• Work with developers, BAs, QA teams, and business stakeholders.
• Independently own database development and optimization activities.
• Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.

Navtech is a premier IT software and services provider. Our mission is to increase public cloud adoption and build cloud-first solutions that become trendsetting platforms of the future.

We have been recognized as the Best Cloud Service Provider by GoodFirms for delivering quality services and results. We strive to innovate and push technology and service boundaries to provide best-in-class technology solutions to our clients globally.

We are a fast-growing company serving clients across the United States, UK and Europe. You will work with a team of talented developers, quality engineers and product managers who are passionate about building impactful technology solutions.

About the Role

We are looking for an experienced Senior SQL Server / SSIS Engineer to design, develop, maintain and optimise database solutions and ETL workflows.

The ideal candidate should have strong hands-on experience with Microsoft SQL Server, SSIS package development, T-SQL programming, database performance tuning and data migration.

You should be comfortable working with existing database systems, troubleshooting complex issues, improving performance and ensuring data integrity, security and availability.

Key Responsibilities

• Design, develop and maintain SQL Server databases, database objects and logical data models.
• Develop, deploy and maintain SSIS packages for ETL processes and data integration.
• Build and optimise complex SQL queries, stored procedures, functions, views and triggers.
• Design and implement data extraction, transformation and loading workflows across multiple systems.
• Perform database migrations, data transformations and validation activities.
• Monitor and troubleshoot SQL Server databases, SSIS packages and SQL Server Agent jobs.
• Identify and resolve performance bottlenecks through query optimisation, indexing and execution plan analysis.
• Handle database administration activities, including upgrades, backups, recovery and maintenance.
• Ensure database performance, security, availability and data integrity.
• Troubleshoot database locking, blocking and resource utilisation issues.
• Collaborate with developers, QA engineers and other stakeholders to understand database requirements.
• Maintain technical documentation for database structures, ETL workflows and processes.
• Provide production support and proactively identify opportunities to improve database performance and reliability.

Who Are We Looking For?

• 6–10 years of experience in SQL Server development and database engineering.
• Strong hands-on experience with Microsoft SQL Server, preferably SQL Server 2016/2017 or above.
• Hands-on experience in developing, deploying and maintaining SSIS packages.
• Strong understanding of ETL processes, data integration and data migration.
• Advanced knowledge of T-SQL, stored procedures, functions, views and triggers.
• Experience in database performance tuning, query optimisation, indexing and execution plans.
• Experience in SQL Server monitoring, troubleshooting and resolving database performance issues.
• Good understanding of SQL Server Agent jobs, database backups, recovery and maintenance.
• Experience resolving database locking conflicts, blocking and resource utilisation issues.
• Knowledge of SQL Server system tables and Dynamic Management Views (DMVs).
• Experience with PowerShell scripting and automation is preferred.
• Exposure to AWS RDS, Azure SQL or other cloud database environments is an advantage.
• Knowledge of PostgreSQL or NoSQL databases is a plus.
• Experience leading or mentoring junior developers is preferred.
• Bachelor's or Master's degree in Computer Science, Software Engineering, IT or a related field.
• Excellent analytical, logical, troubleshooting and communication skills.

Good to Have

• Experience with SSRS or SSAS.
• Knowledge of AWS RDS or Azure SQL.
• Experience with PowerShell scripting.
• Exposure to PostgreSQL or NoSQL databases.
• Relevant Microsoft SQL Server certifications.

Why Navtech?

• Performance reviews and appraisals twice a year.
• Competitive compensation package with additional bonuses and benefits.
• Opportunities to work with renowned clients across the US, UK and Europe.
• Medical insurance coverage for self and immediate family.
• Opportunity to work with a culturally diverse and collaborative team.
• Opportunities for continuous learning and technical growth.

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

🚨 Hiring: MicroStrategy Developer

We are looking for an experienced MicroStrategy Developer for a 6-month contract opportunity.

📌 Role: MicroStrategy Developer

💼 Experience: 5+ Years

📍 Location: Bangalore / Hyderabad / Mumbai / Delhi

🏢 Work Mode: Onsite

📅 Contract: 6 Months

Key Requirements:

• 5+ years of hands-on MicroStrategy experience

• Strong experience in MicroStrategy development

• Strong SQL skills

• Experience in BI reporting and dashboard development

• Experience with data warehousing and analytics

• Ability to understand business requirements and develop reporting solutions

• Experience in troubleshooting and supporting MicroStrategy applications

Interested candidates can apply with their updated resume.

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.

Business Intelligence Analyst - 2

Planview is the world leader in enterprise software planning for enterprise-wide deployment strategies, processes and resources. More than 4000 customers, among the world's largest and most respected companies, have successfully implemented Planview software to optimize their enterprise portfolio management, project, portfolio and resource management, business intelligence and expense tracking processes. We have had stable, organic growth for years and now need reinforcement.

Job Summary:

The Planview BI Team is seeking an experienced Business Intelligence Analyst – 2 to support, troubleshoot, optimize, and enhance business intelligence and reporting solutions built on Planview products.

This role focuses on advanced BI support across Power BI, Microsoft Fabric, SQL Server, SSAS, SSRS, OData, Dataflows, Data Pipelines, Data warehousing, and Data models. The BI Analyst – 2 will handle complex technical issues, perform advanced root-cause analysis and performance tuning, and work closely with customers and internal teams to deliver scalable BI solutions.

Key Responsibilities:

· Troubleshoot and resolve complex issues involving data accuracy, refresh failures, report behavior, connectivity, security, and performance across Power BI, SSRS, SSAS, SQL Server, OData, and Data warehousing layers.

· Perform advanced T-SQL development and performance tuning, including execution plans, indexing, query optimization, stored procedures, views, and complex queries.

· Support, develop, maintain, and optimize Power BI semantic models, DAX measures, Power Query, datasets, workspaces, gateways, refreshes, and Row-Level Security.

· Support and troubleshoot SSAS Tabular and Multidimensional models, including processing, calculations, relationships, security, and performance.

· Develop and troubleshoot advanced SSRS/paginated reports, including parameters, subreports, drill-through, expressions, pagination, subscriptions, and export formats.

· Support Microsoft Fabric solutions including Data Pipelines, Dataflows Gen2, Lakehouse/Warehouse, semantic models, and Power BI integration.

· Troubleshoot ETL/ELT processes, data pipelines, Dataflows, refresh failures, and data transformation issues across BI environments.

· Analyze and troubleshoot OData feeds, including filtering, pagination, refresh, connectivity, and large-volume data scenarios.

· Support Planview Automart, Datamart, and data warehouse implementations and ensure data consistency across source, warehouse, semantic, and reporting layers.

· Perform end-to-end root-cause analysis and performance optimization across the BI technology stack.

· Collaborate with customers, Product, Engineering, Hosting, and Support teams on complex technical issues and escalations.

· Provide technical guidance and mentoring to BI Analyst – 1 team members and contribute to BI best practices and documentation.

Required Skills & Qualifications:

·      5+ years of professional experience in Business Intelligence Development, BI Support, Data Analytics, or a related field.

·      Strong hands-on experience with Power BI, DAX, Power Query, and enterprise data modeling.

·      Advanced knowledge of SQL Server and T-SQL, including query optimization and performance tuning.

·      Strong experience with SSRS and enterprise reporting.

·      Experience with SSAS Tabular and/or Multidimensional models.

·      Experience with Microsoft Fabric, particularly Data Pipelines, Dataflows, Lakehouse/Warehouse, and Power BI.

·      Experience working with OData and enterprise data integration.

·      Strong understanding of Data Warehousing, Datamarts, Automart, ETL/ELT, and data modeling.

·      Experience troubleshooting Power BI Service, gateways, refreshes, security, and semantic models.

·      Strong analytical, troubleshooting, and root-cause analysis skills.

·      Proven ability to work directly with customers and communicate technical concepts to both technical and non-technical stakeholders.

·      Experience with tools such as DAX Studio, Tabular Editor, Performance Analyzer, Query Store, or SQL Profiler is an advantage.

• Relevant Microsoft certifications such as PL-300, DP-600, or DP-203 are an added advantage.

Job Title: MIS Operations Executive

Location: Mumbai, Maharashtra

Industry: Insurance

Experience Required: 1 -5 Years

Job Summary:

We are seeking a detail-oriented and analytical MIS Operations Executive to support data management, reporting, and operational efficiency within our insurance business. The ideal candidate will be responsible for generating accurate reports, maintaining databases, and assisting in decision-making through data insights.

Key Responsibilities:

• Prepare daily, weekly, and monthly MIS reports related to sales, operations, and performance metrics
• Collect, analyze, and validate data from multiple sources to ensure accuracy and consistency
• Maintain and update databases, dashboards, and reporting systems
• Support business teams with ad hoc data requests and analysis
• Identify trends, discrepancies, and areas for improvement in operational processes
• Ensure timely submission of reports to management
• Coordinate with cross-functional teams (sales, underwriting, claims) for data requirements
• Assist in automation of reports using Excel or MIS tools

Key Skills Required:

• Strong proficiency in MS Excel (Pivot Tables, VLOOKUP, formulas)
• Basic knowledge of MIS reporting and data analysis
• Good analytical and problem-solving skills
• Attention to detail and accuracy
• Ability to manage deadlines and multitask
• Good communication and coordination skills

Preferred Qualifications:

• Bachelor’s degree in Commerce, Business Administration, or related field
• Familiarity with insurance processes (policies, claims, underwriting) is a plus
• Knowledge of tools like Power BI, SQL, or advanced Excel will be an advantage

Salary: As per industry standards

Working Hours: Full-time

Career Growth: Opportunity to grow into senior MIS roles, data analytics, or operations management within the insurance domain

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 Database Developer (PostgreSQL) .

Requirements

- 5+ years of hands-on PostgreSQL experience in a production or production-adjacent context 

- Strong SQL skills, including joins, aggregation, common table expressions, window functions, upserts, and DDL

- Ability to read execution plans and use a systematic approach to diagnose and rewrite slow SQL statements

- Practical understanding of transactions, isolation levels, locking, and MVCC

- Experience with physical database design, including tables, keys, constraints, indexes, and partitioning

- Practical experience with data migrations, including bulk or incremental loads, cutovers, and validation

- Practical backup and restore experience, including retention, point-in-time recovery, or restore testing

- Ability to write reliable operational scripts and idempotent reconciliation or backfill processes

- Basic Python experience for data loading and operational scripting.

Nice to have

- Experience with a schema migration tool such as Alembic, Flyway, or Liquibase 

- Experience managing declarative partitioning at scale

- Experience with managed cloud PostgreSQL

- Experience tuning PostgreSQL statistics, autovacuum, bloat, and lock contention