SQL Developer at Wissen Technology · Hyderabad · 5 - 10 years · Profitable · Posted 6 Nov 2024

Responsibilities include:
- Develop and maintain data validation logic in our proprietary Control Framework tool
- Actively participate in business requirement elaboration and functional design sessions to develop an understanding of our Operational teams’ analytical needs, key data flows and sources
- Assist Operational teams in the buildout of Checklists and event monitoring workflows within our Enterprise Control Framework platform
- Build effective working relationships with Operational users, Reporting and IT development teams and business partners across the organization
- Conduct interviews, generate user stories, develop scenarios and workflow analyses
- Contribute to the definition of reporting solutions that empower Operational teams to make immediate decisions as to the best course of action
- Perform some business user acceptance testing
- Provide production support and troubleshooting for existing operational dashboards
- Conduct regular demos and training of new features for the stakeholder community
Qualifications
- Bachelor’s degree or equivalent in Business, Accounting, Finance, MIS, Information Technology or related field of study
- Minimum 5 years’ of SQL required
- Experience querying data on cloud platforms (AWS/ Azure/ Snowflake) required
- Exceptional problem solving and analytical skills, attention to detail and organization
- Able to independently troubleshoot and gather supporting evidence
- Prior experience developing within a BI reporting tool (e.g. Spotfire, Tableau, Looker, Information Builders) a plus
- Database Management and ETL development experience a plus
- Self-motivated, self-assured, and self-managed
- Able to multi-task to meet time-driven goals
- Asset management experience, including investment operation a plus

About Wissen Technology
About
The Wissen Group was founded in the year 2000. Wissen Technology, a part of Wissen Group, was established in the year 2015. Wissen Technology is a specialized technology company that delivers high-end consulting for organizations in the Banking & Finance, Telecom, and Healthcare domains.
With offices in US, India, UK, Australia, Mexico, and Canada, we offer an array of services including Application Development, Artificial Intelligence & Machine Learning, Big Data & Analytics, Visualization & Business Intelligence, Robotic Process Automation, Cloud, Mobility, Agile & DevOps, Quality Assurance & Test Automation.
Leveraging our multi-site operations in the USA and India and availability of world-class infrastructure, we offer a combination of on-site, off-site and offshore service models. Our technical competencies, proactive management approach, proven methodologies, committed support and the ability to quickly react to urgent needs make us a valued partner for any kind of Digital Enablement Services, Managed Services, or Business Services.
We believe that the technology and thought leadership that we command in the industry is the direct result of the kind of people we have been able to attract, to form this organization (you are one of them!).
Our workforce consists of 1000+ highly skilled professionals, with leadership and senior management executives who have graduated from Ivy League Universities like MIT, Wharton, IITs, IIMs, and BITS and with rich work experience in some of the biggest companies in the world.
Wissen Technology has been certified as a Great Place to Work®. The technology and thought leadership that the company commands in the industry is the direct result of the kind of people Wissen has been able to attract. Wissen is committed to providing them the best possible opportunities and careers, which extends to providing the best possible experience and value to our clients.
Connect with the team
Similar jobs (10)
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!
The recruiter has not been active on this job recently. You may apply but please expect a delayed response.
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.
The recruiter has not been active on this job recently. You may apply but please expect a delayed response.
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.
About Solutionara
Solutionara is an AI-led IT Consulting and Technology Services organization delivering enterprise transformation through Cloud, Integration, Data Engineering, Digital Experience, AI, and Enterprise Applications.
Headquartered in the United States with a Global Delivery Center (GDC) in Noida, India, Solutionara partners with enterprise organizations across retail, manufacturing, distribution, consumer goods, and other industries to design, implement, and support scalable technology solutions.
As a rapidly growing consulting organization, we foster a culture of ownership, innovation, collaboration, and continuous improvement, empowering our teams to contribute beyond their immediate responsibilities while delivering exceptional value to our global clients.
Every team member is expected to think like a consultant and business problem solver—understanding client objectives, challenging assumptions when appropriate, leveraging AI responsibly, and continuously identifying opportunities to improve quality, productivity, and customer outcomes.
AI is embedded into how we work, but it is an enabler—not a replacement for expertise, critical thinking, or accountability.
Role Overview
Solutionara is seeking a Senior Data Engineer with strong data engineering and database expertise to design, build, optimize, and support enterprise-scale data solutions.
This is a hands-on engineering position requiring strong SQL, Python, ETL/ELT, database, cloud, and troubleshooting capabilities. The engineer will work closely with technical leads and client stakeholders while taking ownership of major engineering components.
Location: Noida, India – Onsite | Employment Type: Full-Time | Experience: 6–9 Years
Key Responsibilities
Data Engineering
- Design, develop, test, deploy, and support scalable ETL/ELT pipelines.
- Build ingestion and transformation solutions across databases, APIs, files, and enterprise applications.
- Develop high-quality SQL and Python-based data processing solutions.
- Implement batch and incremental data-processing patterns.
- Develop reusable engineering components and frameworks.
- Support complex data migration and transformation activities.
- Perform source-to-target mapping and technical data analysis.
- Implement pipeline logging, monitoring, exception handling, and recovery mechanisms.
Database & Platform Engineering
- Design and optimize relational database schemas and data structures.
- Analyze and improve SQL/query performance.
- Support indexing, partitioning, storage optimization, and database performance.
- Implement appropriate database security and access controls.
- Support database monitoring, availability, backup/recovery, and operational requirements in collaboration with infrastructure/platform teams.
- Troubleshoot database and pipeline performance issues.
- Contribute to cloud data-platform configuration and optimization.
Data Quality
- Implement automated validation and data-quality controls.
- Develop reconciliation processes between source and target systems.
- Identify duplicate, incomplete, inconsistent, and invalid data.
- Implement cleansing, standardization, validation, and exception-management logic.
- Work with technical and business stakeholders to understand and implement business data rules.
Technical Delivery
- Convert technical designs into reliable production solutions.
- Participate in technical design and code reviews.
- Mentor junior/mid-level engineers.
- Support estimation and technical planning.
- Troubleshoot complex production and integration issues.
- Collaborate with technical leads, application teams, DevOps, QA, BI, and client teams.
- Document technical designs, mappings, configurations, operational procedures, and engineering decisions.
Consulting & AI-Led Working
- Understand the business purpose behind assigned engineering requirements.
- Raise risks, assumptions, dependencies, and potential improvements proactively.
- Communicate effectively with client and internal stakeholders.
- Use AI-assisted tools to improve coding, testing, analysis, documentation, and troubleshooting productivity.
- Independently verify AI-generated code and recommendations before implementation.
- Identify opportunities for engineering automation and process improvement.
Required Qualifications
- 6–9 years of experience in data engineering, database engineering, data integration, or related areas.
- Advanced SQL skills.
- Strong hands-on Python experience.
- Strong ETL/ELT development experience.
- Strong relational database knowledge, such as SQL Server, PostgreSQL, Oracle, or equivalent.
- Experience with data modeling and database design.
- Experience with AWS, Azure, or another major cloud platform.
- Experience with modern data technologies such as Databricks, Snowflake, Redshift, Synapse, Glue, ADF, Airflow, dbt, or equivalent.
- Experience with performance tuning and optimization.
- Experience with data validation and reconciliation.
- Strong troubleshooting and analytical skills.
- Ability to take ownership of engineering deliverables with limited supervision.
Preferred Qualifications
- Experience working with enterprise ERP, CRM, PIM, PLM, MES, or related systems.
- Experience with manufacturing, retail, distribution, or consumer-goods data.
- Experience with CI/CD and infrastructure/platform engineering practices.
- Experience with API and event-driven integrations.
- Previous consulting or technology-services experience.
What Success Looks Like
- Pipelines and databases perform reliably at enterprise scale.
- Engineering solutions are maintainable, reusable, and well documented.
- Data issues are detected and addressed systematically.
- Junior engineers receive effective technical guidance.
- Problems are owned through resolution rather than simply escalated.
- Engineering decisions reflect both technical requirements and client business objectives.
We are looking for a dynamic Data Engineer to join our team of technology enthusiasts. You will leverage data to drive strategic decision-making and pioneering solutions, working with complex datasets, collaborating closely with stakeholders, and transforming data into actionable insights to drive innovation.
Qualifications and Skills:
- Minimum 5 years of experience as a Data Engineer
- Hands-on experience with Azure cloud-based data solutions
- Expertise in database design and management, including SQL databases such as SQL Server
- Proficient in ETL (Extract, Transform, Load) design for data integration and processing
- Strong knowledge of data modeling principles and techniques
- Ability to analyze and translate data into actionable insights, reports, and visualizations
- Proficiency in Power BI for reporting and data visualization
Desirable Skills:
- Experience with Power BI Report Builder / Reporting Services
- Knowledge of statistical analysis or Data Science
- Experience within the UK Insurance industry is a plus
- Python or R coding skills
Responsibilities:
- Implement efficient data exchange between internal and external systems to increase efficiency and reduce re-keying and translation errors
- Support the Broking business by developing high-quality information resources, ensuring data availability and accessibility for decision-making
- Engineer data inputs and outputs from core applications and semi-structured remote service data through data syncs between data lake, ODS (SQL database), and leveraging Fabric and ADF
- Perform data engineering tasks including ingestion, cleansing, and collation from a wide range of internal and external sources
- Implement different methods of streaming data and create reconciliations for datasets
- Build analytical models to support reporting and analytics
- Collaborate with an agile delivery team to work on the backlog of specified work
We’re looking for a dynamic and driven Data Analyst to join our team of technology enthusiasts. This role is crucial in transforming data into insights that support strategic decision-making and innovation within the insurance technology (InsurTech) space. If you’re passionate about working with data, understanding systems, and delivering value through analytics, we’d love to hear from you.
What We’re Looking For
- Proven experience working as a Data Analyst or in a similar analytical role
- 5+ Years of experience in the field
- Strong command of SQL for querying and manipulating relational databases
- Experience with Power BI for building impactful dashboards and reports
- Familiarity with QlikView and Qlik Sense is a plus
- Ability to communicate findings clearly to technical and non-technical stakeholders
- Knowledge of Python or R for data manipulation is nice to have
- Bachelor’s degree in Computer Science, Statistics, Mathematics, Economics, or a related field
- Understanding of the insurance industry or InsurTech is a strong advantage
What You’ll Be Doing:
- Delivering timely and insightful reports to support strategic decision-making
- Working extensively with Policy Administration System (PAS) data to uncover patterns and trends
- Ensuring data accuracy and consistency across reports and systems
- Collaborating with clients, underwriters, and brokers to translate business needs into data solutions
- Organizing and structuring datasets, contributing to data engineering workflows and pipelines
- Producing analytics to support business development and market strategy
Job Summary – Axiom Technical Analyst
🔹 Experience: 5+ Years
🔹 Skill Set: Axiom + SQL + ETL
🔹 Locations: Bangalore / Hyderabad
🔹 Notice Period: Immediate to 15 Days Joiners Preferred
Required Skills:
🔹 Strong hands-on experience in Axiom
🔹 Good knowledge of SQL and database concepts
🔹 Hands-on experience with ETL processes
🔹 Experience in data extraction, transformation, and loading
🔹 Good understanding of data integration and data processing
🔹 Experience in developing, maintaining, and troubleshooting data workflows
🔹 Strong analytical and problem-solving skills
🔹 Good communication and collaboration skills
🔹 Ability to troubleshoot technical issues and support application/data processes
🔹 Understanding of SDLC and Agile methodologies














