SQL Developer

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.

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.

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.

Job Summary

We are looking for a skilled and experienced Data Engineer to join our growing data team. The ideal candidate will have strong expertise in Python, PySpark, Data Modeling, and Power BI, with hands-on experience in designing, developing, and optimizing scalable data solutions. The role requires working closely with business stakeholders, data architects, and analytics teams to build robust data pipelines and semantic models that enable data-driven decision-making.

Technical Skills

• Strong hands-on experience in Python and PySpark development.
• Expertise in building and optimizing Data Engineering solutions and ETL pipelines.
• Strong understanding of Data Modeling concepts (Star Schema, Snowflake Schema, Dimensional Modeling).
• Experience with Power BI Data Modeling and Semantic Layer development.
• Proficiency in DAX (Data Analysis Expressions).
• Experience designing and managing Semantic Models in Power BI.
• Strong SQL skills and experience working with large datasets.
• Knowledge of data warehousing concepts and best practices.

Preferred Skills

• Experience with cloud platforms such as Azure, AWS, or GCP.
• Exposure to modern data platforms like Databricks.
• Understanding of data governance and data quality frameworks.

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

Job Overview:

We are seeking an experienced Cloud Data Engineer to the architecture, development, Data migration, ETL pipeline in cloud and optimization of a next-generation data platform. This is a development role for an individual with over 4 years of deep data engineering and data migration, data pipeline in AWS expertise, capable of driving technical direction, and delivering high-impact solutions in a fast-paced

4+ Years of hands-on, progressive experience in Cloud Data Engineering, cloud ecosystems AWS, Data Architecture

• Deep conceptual understanding of core data engineering principles, ETL/ELT patterns, and metadata management

•  Ability to translate complex business needs into actionable technical requirements.

•  Strong troubleshooting and problem-solving skills in distributed systems.

•  Agile/Scrum teamwork capabilities and version control practices

• Insurance industry experience preferred but not mandatory

• Tools:

o Cloud Environment: AWS (S3, IAM, VPC, Glue, Lambda etc.)

o Experience with dbt Core, Iceberg, AWS Glue Catalog, AWS lambda, Redshift, Athena, Splunk, AmazonQ, AWS streaming services, Git

o Strong SQL, Pyspark and Python

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

Job Title: Senior Data Architect

Experience: 7+ Years

Location: India (Ahmedabad / Hybrid/Remote)

Job Summary

We are looking for an experienced Senior Data Architect to support the modernization and enhancement of Enterprise Analytic Data Warehouse (ADW). The candidate will be responsible for evaluating existing data architecture, designing scalable data models, assessing data integration across clinical, operational and financial domains, and establishing data governance and data quality standards.

Key Responsibilities

• Assess and review the existing Enterprise Analytic Data Warehouse architecture, database structures and data integration processes.
• Design and improve enterprise data models covering clinical, operational, financial and revenue-cycle information.
• Define data architecture standards, database structures, data relationships and integration strategies.
• Evaluate data flows between source systems and the data warehouse.
• Design and review source-to-target mappings and data lineage.
• Identify architectural gaps affecting data completeness, consistency, integrity and reporting accuracy.
• Establish standardized data definitions, data governance practices and metadata management.
• Ensure consistent patient, facility, payer and other critical identifiers across different datasets.
• Support integration of billing, claims, payment, denial and accounts receivable (AR) data.
• Work with SQL and Python-based data processing solutions to investigate and validate data structures.
• Recommend improvements to warehouse scalability, performance, reliability and maintainability.
• Develop a prioritized architecture and modernization roadmap for future implementation.
• Coordinate with data engineers, analytics engineers and business stakeholders.

Required Technical Skills

• Strong experience in Data Architecture and Enterprise Data Warehousing.
• Advanced SQL and relational database concepts.
• Experience with data modelling (conceptual, logical and physical).
• Knowledge of ETL/ELT pipelines and data integration.
• Experience with data profiling, data lineage and metadata management.
• Understanding of data governance, data quality and data validation frameworks.
• Experience working with large and complex datasets.
• Python knowledge for data analysis and validation.
• Experience with cloud-based data platforms or modern data warehouse technologies.

Preferred Skills

• Experience with Databricks, Azure, AWS or similar cloud data platforms.
• Experience with healthcare data warehouses.
• Knowledge of clinical, financial, billing and claims datasets.
• Understanding of HIPAA, PHI and healthcare data security principles.
• Experience with healthcare analytics, reimbursement and revenue-cycle data.

Location: Hyderabad / Chennai

Experience: 5+ years

Employment type: Full-time, permanent

Work Hours: General Shift

website: www.amazech.com

Qualifications: 

• B.E./B.Tech/M.E./M.Tech in Computer Science, Information Technology, Data Science, or related disciplines.
• Strong academic background with relevant industry experience in Data Engineering and Data Warehousing.

Key Responsibilities:

·       Design, develop, and maintain scalable data warehouse solutions using Snowflake.

·       Write, optimize, troubleshoot, and enhance Snowflake SQL queries with a focus on performance and scalability.

·       Develop and support ETL processes using Talend to ensure reliable and efficient data movement.

·       Collaborate with business, analytics, and application teams to enable reporting, dashboards, metrics, and data exploration capabilities.

·       Perform data analysis and resolve issues across data ingestion, transformation, and reporting pipelines.

·       Debug and troubleshoot Python-based data processing scripts and automation workflows.

·       Implement best practices for data quality, testing, deployment, and code reviews.

·       Work across UI, API, and Data Warehouse layers to support end-to-end data integration and business requirements.

·       Monitor, optimize, and maintain data warehouse performance and operational stability.

·       Create and maintain technical documentation, data models, and process workflows.

Required Skills and Experience: 

·       Strong hands-on expertise in Snowflake Data Warehouse.

·       Advanced SQL skills with experience handling large-scale datasets.

·       Strong understanding of Data Warehousing concepts, dimensional modelling, and data architecture.

·       Hands-on experience with Analytical SQL functions, query tuning, and performance optimization.

·       Experience developing and maintaining ETL solutions using Talend.

·       Proficiency in Python for scripting, debugging, automation, and data processing.

·       Experience integrating UI, API, and Data Warehouse workflows.

·       Strong problem-solving and analytical skills.

·       Experience with testing, code reviews, and deployment best practices.

·       Excellent communication and stakeholder management skills.