SQL Developer

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!

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

Work Mode: WORK FROM OFFICE

Role Descriptions:

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

Required Skills:

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

Skills: Business Analysis~ORACLE SQL

Locations: ~HYDERABAD~PUNE~

Desire candidate

• Candidate should have valid PF.

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, 

Job Description – QA & Data Validation Engineer

Experience: 5–6 Years

Location: Pan India

Employment Type: Full-Time

Work Mode: Pan India / Remote or Hybrid as applicable

About the Role

We are looking for an experienced QA & Data Validation Engineer with 5–6 years of hands-on experience in data quality assurance, solution analysis, data validation, SQL, Python, PySpark, Azure Data Factory, Azure Synapse Analytics, and Power BI validation.

The ideal candidate will be responsible for validating large-scale data pipelines, performing source-to-target reconciliation, analyzing business rules, investigating data defects, and ensuring the accuracy, completeness, and consistency of data across source, staging, intermediate, and target systems.

The role requires strong analytical and problem-solving skills along with the ability to work closely with development, data engineering, business, and other stakeholders in an Agile delivery environment.

You will also contribute to the design, development, and maintenance of automated validation frameworks and utilities using Python, SQL, PySpark, Azure Data Factory, and Azure Synapse.

---

Key Responsibilities

1. QA & Solution Analysis

- Analyze business and technical requirements to understand data processing and validation needs.

- Participate in requirement analysis sessions and clarify functional and technical requirements with stakeholders.

- Review solution designs, data flows, mapping documents, interface specifications, and business rules.

- Validate that implemented solutions meet defined business and technical requirements.

- Identify gaps, inconsistencies, ambiguities, and potential data quality issues during requirement and solution analysis.

- Translate business requirements into detailed test scenarios, test cases, and validation conditions.

- Perform end-to-end validation of data processing workflows.

- Ensure data is accurately processed from source systems through intermediate layers to final outputs.

- Validate business rules and transformation logic implemented within data pipelines.

2. Test Planning & Execution

- Prepare comprehensive test strategies, test plans, test scenarios, and test cases for data-intensive applications.

- Execute functional, integration, regression, system, and data validation testing.

- Perform positive and negative testing for different data processing scenarios.

- Validate data pipelines across multiple environments, including staging, testing, and production.

- Identify test data requirements and prepare appropriate datasets for validation.

- Execute SQL queries to validate data processing and transformation results.

- Document test results, observations, defects, and validation evidence.

- Track testing progress and communicate status, risks, issues, and dependencies to stakeholders.

3. Data Validation & Reconciliation

- Perform detailed source-to-target data validation and reconciliation.

- Validate source, intermediate, staging, and output datasets.

- Perform record count validation between source and target systems.

- Verify data completeness, consistency, accuracy, and integrity.

- Validate data transformations against defined business rules.

- Perform field-level and record-level comparisons.

- Validate data types, formats, precision, scale, and null handling.

- Verify schema structure, layout, column names, and column sequence.

- Validate mandatory and optional fields.

- Identify missing, duplicate, truncated, or incorrectly transformed records.

- Analyze invalid records, rejected records, and exception datasets.

- Verify exception and reject-handling mechanisms.

- Compare production and staging data to identify discrepancies.

- Perform reconciliation between files, databases, and reporting layers.

- Validate data across different processing stages and identify the root cause of discrepancies.

4. File & Data Processing Validation

- Validate large-scale datasets across multiple file formats.

- Perform validation of:

 - CSV files

 - Delimited files

 - Fixed-width files

 - Excel files

 - Database tables

 - Structured and semi-structured datasets

- Validate file layouts, headers, delimiters, record formats, and column sequences.

- Verify file-level and record-level counts.

- Analyze source, intermediate, and final output files.

- Validate file-to-database and database-to-file reconciliation.

- Identify incomplete, corrupted, malformed, or invalid records.

- Verify data movement and transformation between different storage locations.

- Validate Azure-to-AWS file transfer processes.

- Ensure transferred files are complete and match the expected source datasets.

---

5. Defect Investigation & Root Cause Analysis

- Investigate data discrepancies and application/data pipeline defects.

- Perform detailed root cause analysis for data quality and validation failures.

- Analyze source data, transformation logic, pipeline execution, database records, and output datasets to identify defects.

- Collaborate with developers and data engineers to resolve identified issues.

- Reproduce defects and provide detailed technical evidence.

- Perform defect impact analysis.

- Conduct retesting and regression testing after defect resolution.

- Monitor recurring data quality issues and recommend preventive solutions.

- Maintain detailed defect documentation and validation results.

---

6. Python Development & Automation

- Develop Python scripts and utilities for data validation and reconciliation.

- Design, develop, and maintain reusable data validation frameworks.

- Automate repetitive data comparison and validation activities.

- Build automated utilities for:

 - Record count validation

 - Data completeness checks

 - Schema validation

 - Column sequence validation

 - Source-to-target comparison

 - Duplicate detection

 - Exception identification

 - Data quality checks

 - Automated reporting

- Develop Python-based validation and reporting utilities.

- Optimize Python scripts for processing large datasets.

- Maintain and enhance existing automation frameworks.

- Implement reusable validation components to improve testing efficiency and coverage.

---

7. SQL Development & Data Analysis

- Write complex SQL queries for data analysis and validation.

- Perform data extraction and comparison using SQL Server / SSMS.

- Validate source and target database records.

- Perform joins, aggregations, subqueries, CTEs, and analytical queries as required.

- Develop SQL queries to identify data mismatches, duplicates, missing records, and transformation issues.

- Validate database tables, schemas, columns, constraints, and relationships.

- Perform record count and reconciliation checks using SQL.

- Analyze SQL Server metrics databases.

- Validate data processing results against expected business rules.

- Troubleshoot data discrepancies using SQL queries.

---

8. PySpark & Large-Scale Data Processing

- Develop and execute PySpark notebooks for large-scale dataset processing and validation.

- Analyze large volumes of structured and semi-structured data.

- Perform data transformation and validation using PySpark.

- Compare large source and target datasets efficiently.

- Implement data quality and reconciliation checks using PySpark.

- Analyze exception, reject, and invalid datasets.

- Optimize data validation processes for large datasets.

- Work with Azure Synapse notebooks and data processing environments.

---

9. Azure Data Factory & Pipeline Testing

- Design and execute validation scenarios for Azure Data Factory (ADF) pipelines.

- Validate pipeline execution, data movement, transformations, and dependencies.

- Monitor pipeline runs and investigate failures.

- Validate source-to-target data movement through ADF.

- Develop and maintain test pipelines using Azure Data Factory.

- Verify pipeline parameters, triggers, activities, and execution results.

- Validate file ingestion and processing workflows.

- Perform end-to-end testing of data pipelines.

- Investigate pipeline-related data discrepancies and failures.

---

10. Azure Synapse Analytics

- Work with Azure Synapse Analytics for data validation and analysis.

- Develop and execute Synapse notebooks using PySpark.

- Validate datasets processed through Synapse pipelines and notebooks.

- Perform data quality and reconciliation checks within Synapse environments.

- Analyze large-scale datasets and processing results.

- Validate data movement between Azure storage, Synapse, databases, and reporting systems.

---

11. Azure Storage & Cosmos DB

- Validate data stored in Azure Storage Accounts and Containers.

- Verify file ingestion, processing, and output data.

- Perform file-level and content-level validation within Azure storage.

- Validate data processing workflows involving Azure Storage.

- Perform data validation in Azure Cosmos DB.

- Verify records, fields, formats, and data completeness within Cosmos DB.

- Investigate discrepancies between source files, Azure storage, databases, and Cosmos DB.

---

12. AWS S3 & Azure-to-AWS Validation

- Validate files stored in AWS S3.

- Perform source-to-target validation for files transferred between Azure and AWS.

- Verify file counts, file names, sizes, formats, and record counts.

- Compare source files with transferred S3 files.

- Validate data integrity after cloud-to-cloud file transfers.

- Investigate missing, incomplete, duplicate, or corrupted files.

- Support end-to-end validation of Azure-to-AWS data movement processes.

---

13. Metrics, Reporting & Power BI Validation

- Extract and validate source system metrics.

- Validate metrics stored in SQL Server databases.

- Perform reconciliation between source metrics, database metrics, and reporting outputs.

- Validate Power BI dashboards and reports against underlying source data.

- Verify report calculations, KPIs, measures, filters, and aggregations.

- Perform file-to-database-to-Power BI reconciliation.

- Validate data displayed in Power BI against SQL Server and source datasets.

- Identify discrepancies between backend data and dashboard results.

- Support reporting and analytics teams with data validation and troubleshooting.

---

14. Production Support & Job Monitoring

- Monitor scheduled data processing jobs and pipelines.

- Perform production validation and health checks.

- Analyze production failures and data discrepancies.

- Support incident investigation and resolution.

- Compare production and staging environments to identify differences.

- Validate production data after deployments and pipeline executions.

- Monitor ECG jobs and provide support for job execution and data processing issues.

- Perform post-production validation and reconciliation.

- Communicate critical production issues and risks to relevant stakeholders.

---

15. Agile Delivery & Stakeholder Collaboration

- Work effectively within an Agile/Scrum delivery environment.

- Participate in sprint planning, daily stand-ups, backlog refinement, sprint reviews, and retrospectives.

- Collaborate with Business Analysts, Developers, Data Engineers, DevOps teams, Product Owners, and other stakeholders.

- Provide timely updates on testing progress and issues.

- Participate in requirement clarification and solution discussions.

- Support release planning and production deployment activities.

- Track work items and defects using Rally.

- Ensure testing activities are aligned with sprint and release timelines.

---

Required Technical Skills

Mandatory Skills

- 5–6 years of experience in QA / Data Validation / Data Testing / Data Quality Engineering.

- Strong experience in SQL and data analysis.

- Hands-on experience with Python development and automation.

- Experience with PySpark and large-scale data processing.

- Strong experience with Azure Data Factory (ADF).

- Experience with Azure Synapse Analytics / Synapse Pipelines / Notebooks.

- Strong understanding of source-to-target data validation and reconciliation.

- Experience in data completeness, record count, schema, layout, and column validation.

- Experience in defect investigation and root cause analysis.

- Experience validating large datasets and multiple file formats.

- Experience with SQL Server / SSMS.

- Experience with Power BI dashboard/report validation.

- Strong understanding of data pipelines and ETL/ELT processes.

Cloud & Data Platform Experience

- Azure Data Factory

- Azure Synapse Analytics

- Azure Synapse Pipelines

- Azure Synapse Notebooks

- Azure Storage Accounts

- Azure Storage Containers

- Azure Cosmos DB

- Azure Privileged Identity Management (PIM)

- AWS S3

- Azure-to-AWS file transfer validation

---

Preferred Skills

- Experience developing automated data validation frameworks.

- Experience building automated reporting and reconciliation utilities.

- Knowledge of ETL/ELT testing methodologies.

- Experience working with very large datasets.

- Experience in production data validation and support.

- Knowledge of cloud-based data platforms.

- Experience with Power BI data reconciliation.

- Experience working in Agile environments.

- Experience with Rally or similar Agile project management tools.

- Familiarity with Microsoft Copilot and AI-assisted productivity/automation tools.

---

Key Responsibilities at a Glance

The successful candidate will be responsible for:

- Requirement analysis and clarification

- Business rule validation

- Test planning and execution

- Data quality and data validation

- Source-to-target reconciliation

- Record count and completeness validation

- Schema and layout validation

- Column sequence validation

- Exception and reject data analysis

- Production vs. staging comparison

- SQL-based data analysis

- Python automation

- PySpark development

- Azure Data Factory pipeline testing

- Azure Synapse validation

- Azure Storage validation

- Cosmos DB validation

- AWS S3 validation

- Azure-to-AWS file transfer validation

- Power BI dashboard validation

- SQL Server metrics validation

- Automated reporting

- Defect investigation and root cause analysis

- Production job monitoring and support

- Agile delivery and stakeholder collaboration

---

Candidate Profile

We are looking for a detail-oriented, analytical, and technically strong QA/Data Validation professional who can work independently on complex data validation assignments.

The candidate should be comfortable working with large datasets, writing SQL queries, developing Python automation, analyzing PySpark datasets, validating cloud-based data pipelines, and troubleshooting data discrepancies across multiple systems.

Strong communication and stakeholder management skills are essential, as the role requires regular collaboration with technical and business teams.

---

Education

Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, Data Science, or a related field is preferred.

Experience

5–6 years of relevant professional experience in QA, Data Testing, Data Validation, ETL Testing, Data Quality, Data Engineering QA, or a similar role.

Location

Pan India

Employment Type

Full-Time

Keywords

QA Engineer, Data QA, Data Validation, Data Testing, ETL Testing, Data Quality, SQL, Python, PySpark, Azure Data Factory, ADF, Azure Synapse, Synapse Analytics, Synapse Pipelines, Azure Storage, Cosmos DB, AWS S3, Power BI, SQL Server, SSMS, Data Reconciliation, Source-to-Target Validation, Data Pipeline Testing, ETL QA, Automation Testing, Data Analytics, Root Cause Analysis, Agile, Rally, Cloud Data Testing, Data Engineering QA.

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.

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.

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.

Role Overview

We are looking for an experienced Marketing Analytics Specialist to derive actionable commercial insights from Reckitt’s cross-channel e-commerce sales data. The role involves integrating data from multiple, inconsistently structured sources, developing scalable data pipelines and data models, creating business intelligence dashboards, and analyzing the impact of media platform spending on sales performance across various retailer platforms.

Key Responsibilities

• Commercial Analytics: Analyze cross-channel e-commerce sales data to identify trends, performance drivers, and actionable commercial insights.
• Business Requirements: Collaborate with business stakeholders to understand reporting requirements and translate them into analytical solutions.
• Data Architecture: Design and implement efficient data storage, retrieval, and processing architectures.
• ETL Development: Build and maintain robust, scalable ETL pipelines to integrate data from multiple source systems into data warehouses or other storage solutions.
• Data Modelling: Develop and maintain data models aligned with business reporting and analytical requirements.
• Data Quality: Implement data quality checks, validation, and reconciliation processes to ensure data accuracy, completeness, and consistency.
• BI Dashboards & Reporting: Design and develop interactive dashboards and reports that communicate business performance and insights effectively.
• Media Spend Analysis: Analyze the impact of media platform spending on sales performance across multiple retailer platforms and identify opportunities to improve marketing effectiveness.
• End-User Training: Provide training, documentation, and ongoing support to enable business users to use BI tools effectively.

Required Skills

• 5+ years of experience in Marketing Analytics, Data Analytics, Business Intelligence, or a related field.
• Strong SQL skills for data extraction, transformation, and analysis.
• Hands-on experience with ETL/ELT pipelines and data integration from multiple sources.
• Experience with data warehousing concepts and data modeling.
• Proficiency in Power BI, Tableau, or other BI visualization tools.
• Experience analyzing e-commerce sales, marketing performance, media spending, or retailer data.
• Knowledge of data quality, data validation, and reconciliation techniques.
• Strong analytical, problem-solving, and stakeholder communication skills.

Good to Have

• Experience in FMCG, retail, consumer goods, or e-commerce analytics.
• Understanding of digital marketing metrics such as ROI, ROAS, and campaign performance.
• Exposure to marketing attribution or Marketing Mix Modeling (MMM).
• Experience with cloud data warehouses such as Snowflake, BigQuery, Redshift, or Azure Synapse.
• Knowledge of Python or data transformation tools such as dbt.

Job Title: Senior Data Engineer

Position Summary

We are seeking a highly skilled Data Engineer with strong expertise in reporting infrastructure, data modeling, and analytics platforms. This role will focus on building scalable reporting solutions, optimizing data pipelines, and enabling data-driven decision-making across the organization. The ideal candidate will have deep experience with databases, data warehousing, and complex query development. While Ruby on Rails experience is beneficial, the primary emphasis is on data engineering and reporting systems.

Key Responsibilities

• Design, develop, and maintain reporting infrastructure and data platforms.
• Build and optimize complex SQL queries, data models, and reporting datasets.
• Develop scalable ETL/ELT pipelines and data integration processes.
• Design and maintain database schemas to support analytics and reporting requirements.
• Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions.
• Implement data quality, governance, and performance best practices.
• Support and enhance enterprise reporting solutions and dashboards.
• Work with large-scale datasets in cloud data warehouse environments.
• Troubleshoot reporting issues and optimize database performance.
• Partner with engineering and product teams to establish sustainable data architecture.

Must Have: Technical Skills

• PostgreSQL
• Snowflake
• Advanced SQL
• Data Modeling
• Data Warehousing
• Reporting & Analytics Infrastructure
• ETL/ELT Development
• Query Performance Tuning

Success Profile:

The ideal candidate is a data-focused engineer who enjoys working with complex datasets, designing scalable reporting solutions, and building foundational infrastructure that empowers analytics and business intelligence teams. They should be comfortable navigating databases, optimizing queries, and translating business reporting needs into robust technical implementations.

Experience Range: 5-10 years

Role Type: Individual Contributor / Senior Engineer

Primary Focus: Reporting Infrastructure, Data Engineering, Data Warehousing, and Analytics Enablement.

About Us:

The QX Impact was launched with a mission to make A.I accessible and affordable and deliver AI Products/Solutions at scale for the enterprises by bringing the power of Data, AI, and Engineering to drive digital transformation. We believe without insights; businesses will continue to face challenges to better understand their customers and even lose them. Secondly, without insights businesses won't’ be able to deliver differentiated products/services; and finally, without insights, businesses can’t achieve a new level of “Operational Excellence” is crucial to remain competitive, meeting rising customer expectations, expanding markets, and digitalization.

Job Summary:

We are looking for a Senior Data Engineer who is creative, collaborative, and adaptable to join our agile team of data scientists, engineers, and UX developers. The role focuses on building and maintaining robust data pipelines to support advanced analytics, data science, and BI solutions.

As a Senior Data Engineer, you will work with internal and external data, collaborate with data scientists, and contribute to the design, development, and deployment of innovative solutions.

Key Responsibilities:

• Design, develop, test, and maintain optimal data pipeline and ETL architectures.
• Map out data systems and define/design required integrations, ETL, BI, and AI systems/processes.
• Prepare and optimize data for predictive and prescriptive modeling.
• Collaborate with teams to integrate ERP data into the enterprise data lake, ensuring seamless flow and quality.
• Enhance cloud data infrastructure on AWS or Azure for scalability and performance.
• Utilize big data tools and frameworks to optimize data acquisition and preparation.
• Build architectures to move data to/from data lakes and data warehouses for advanced analytics.
• Develop and curate data models for analytics, dashboards, and reports.
• Conduct code reviews, maintain production-level code, and implement testing approaches.
• Monitor, troubleshoot, and resolve data ingestion workflows to maintain reliability and uptime.
• Drive innovation and implement efficient new approaches to data engineering tasks.

Must-Have Skills:

• Bachelor’s degree in Computer Science, Mathematics, Engineering, or a related field.
• 5+ years of experience working with enterprise data platforms, including building and managing data lakes.
• 3–5 years of experience designing and implementing data warehouse solutions.
• Expertise in SQL, including developing stored procedures (SP) and applying advanced data design concepts.
• Proficiency in Spark (Python/Scala) and Spark Streaming for real-time data pipelines.
• Experience with AWS or Azure services (e.g., AWS Glue, Azure Data Factory, Redshift, Snowflake).
• Familiarity with big data tools such as Apache Kafka, Apache Spark, or Flink.
• Hands-on experience with orchestration tools (e.g., Apache Airflow, Prefect).
• Knowledge of CI/CD processes, version control (e.g., Git, Jenkins), and deployment automation.
• Strong problem-solving, communication, and collaboration skills.

Good-to-Have Skills:

• Experience in integrating ERP data into data lakes.
• Experience with traditional ETL tools (e.g., Talend, Pentaho).

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!