Data Warehouse Manager

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.

Strong Data Engineer (AWS) Profile

2

Mandatory (Experience 1) – Must have minimum 6+ years of experience in Data Engineering, with strong experience designing, developing, and maintaining scalable data pipelines and ETL processes.

3

Mandatory (Experience 2) – Must have 3+ years of hands-on experience with AWS data engineering services, particularly S3, AWS Glue, EMR, Lambda, and Redshift.

4

Mandatory (Experience 3) – Must have strong programming experience in Python, Java, or Scala, with hands-on development of data processing and pipeline solutions.

5

Mandatory (Experience 4) – Must have strong expertise in SQL, data warehousing, and database technologies, including experience with both SQL and NoSQL databases.

6

Mandatory (Experience 5) – Must have hands-on experience working with Big Data technologies and distributed data processing, including designing and optimizing large-scale data pipelines.

7

Mandatory (Experience 6) – Must have experience with data pipeline troubleshooting, monitoring, data quality, governance, and security best practices.

8

Mandatory (Education) – B.Tech / B.E./ M.Tech

Strong Data Engineer (AWS) Profile

2

Mandatory (Experience 1) – Must have minimum 6+ years of experience in Data Engineering, with strong experience designing, developing, and maintaining scalable data pipelines and ETL processes.

3

Mandatory (Experience 2) – Must have 3+ years of hands-on experience with AWS data engineering services, particularly S3, AWS Glue, EMR, Lambda, and Redshift.

4

Mandatory (Experience 3) – Must have strong programming experience in Python, Java, or Scala, with hands-on development of data processing and pipeline solutions.

5

Mandatory (Experience 4) – Must have strong expertise in SQL, data warehousing, and database technologies, including experience with both SQL and NoSQL databases.

6

Mandatory (Experience 5) – Must have hands-on experience working with Big Data technologies and distributed data processing, including designing and optimizing large-scale data pipelines.

7

Mandatory (Experience 6) – Must have experience with data pipeline troubleshooting, monitoring, data quality, governance, and security best practices.

8

Mandatory (Education) – B.Tech / B.E./ M.Tech

Job Title : AWS Data Engineer

Experience : 4+ Years

Location : Bengaluru (HSR – Hybrid, 3 Days WFO)

Notice Period : Immediate Joiner

💡 Role Overview :

We are looking for a skilled AWS Data Engineer to design, build, and scale modern data platforms. The role involves working with AWS-native services, Python, Spark, and DBT to deliver secure, scalable, and high-performance data solutions in an Agile environment.

🔥 Mandatory Skills :

Python, SQL, Spark, AWS (S3, Glue, EMR, Redshift, Athena, Lambda), DBT, ETL/ELT pipeline development, Airflow/Step Functions, Data Lake (Parquet/ORC/Iceberg), Terraform & CI/CD, Data Governance & Security

🚀 Key Responsibilities :

• Design, build, and optimize ETL/ELT pipelines using Python, DBT, and AWS services
• Develop and manage scalable data lakes on S3 using formats like Parquet, ORC, and Iceberg
• Build end-to-end data solutions using Glue, EMR, Lambda, Redshift, and Athena
• Implement data governance, security, and metadata management using Glue Data Catalog, Lake Formation, IAM, and KMS
• Orchestrate workflows using Airflow, Step Functions, or AWS-native tools
• Ensure reliability and automation via CloudWatch, CloudTrail, CodePipeline, and Terraform
• Collaborate with data analysts and data scientists to deliver actionable insights
• Work in an Agile environment to deliver high-quality data solutions

✅ Mandatory Skills :

• Strong Python (including AWS SDKs), SQL, Spark
• Hands-on experience with AWS data stack (S3, Glue, EMR, Redshift, Athena, Lambda)
• Experience with DBT and ETL/ELT pipeline development
• Workflow orchestration using Airflow / Step Functions
• Knowledge of data lake formats (Parquet, ORC, Iceberg)
• Exposure to DevOps practices (Terraform, CI/CD)
• Strong understanding of data governance and security best practices
• Minimum 4–7 years in Data Engineering (3+ years on AWS)

➕ Good to Have :

• Understanding of Data Mesh architecture
• Experience with platforms like Data.World
• Exposure to Hadoop / HDFS ecosystems

🤝 What We’re Looking For :

• Strong problem-solving and analytical skills
• Ability to work in a collaborative, cross-functional environment
• Good communication and stakeholder management skills
• Self-driven and adaptable to fast-paced environments

📝 Interview Process :

1. Online Assessment
2. Technical Interview
3. Fitment Round
4. Client Round

Job Title : AWS Data Engineer / Data Lake Engineer

Experience : 2 to 4 Years

Location : Gurugram Sector 43

Work Mode : 5 Days WFO

Employment Type : Full-Time

About the Role :

We are looking for a skilled AWS Data Engineer with 2 to 4 years of experience in designing, developing, and maintaining data pipelines and cloud-based data platforms.

The candidate will work on an enterprise AWS Data Lake platform that collects data from multiple business systems, processes large datasets, and makes them available for analytics, reporting, and application development.

The ideal candidate should have strong hands-on experience with AWS data services, Python, PySpark, SQL, and Apache Airflow, along with an understanding of data warehousing and API-based data serving.

Mandatory skills :

AWS Data Lake, S3, EMR, Glue, Athena, Redshift, Lambda, RDS, DMS, IAM, Python, PySpark, Apache Airflow, Advanced SQL, ETL / ELT Pipelines, Data Modeling, PostgreSQL, Production Support.

Key Responsibilities :

• Develop, maintain, and optimize data ingestion and ETL / ELT pipelines on AWS.
• Work with AWS services such as S3, Glue, EMR, Athena, Redshift, Lambda, RDS, and DMS.
• Build and manage data processing workflows using Python, PySpark, and Apache Airflow.
• Implement data lake architecture with staging, curated, and consumption layers.
• Write complex SQL queries and perform data transformation, validation, and modeling.
• Work with PostgreSQL and RDS for structured data storage and consumption.
• Support API-based data access using Hasura GraphQL or similar technologies.
• Monitor production data pipelines, troubleshoot failures, and perform root cause analysis.
• Optimize Spark jobs, SQL queries, and data pipelines for performance and cost efficiency.
• Follow AWS security practices, IAM permissions, and data governance standards.
• Collaborate with application, analytics, and business teams to understand data requirements.

Mandatory Skills :

• 2 to 4 years of experience in Data Engineering, AWS Data Engineering, or Data Platform Development.
• Strong hands-on experience with AWS services : S3, Glue, EMR, Athena, Redshift, Lambda, RDS, DMS, and IAM.
• Good experience in Python and PySpark.
• Practical experience with Apache Airflow for workflow orchestration.
• Strong SQL skills and understanding of database concepts.
• Experience in building and supporting ETL / ELT pipelines.
• Understanding of Data Lake architecture, data warehousing, and data modeling.
• Working knowledge of PostgreSQL or similar relational databases.
• Experience handling production pipeline issues and troubleshooting.

Good to Have :

• Experience with Hasura GraphQL or any GraphQL-based API / data-serving platform.
• Knowledge of DBT (Data Build Tool).
• Understanding of Lakehouse architecture and table formats such as Apache Iceberg or Delta Lake.
• Experience with Kafka or other streaming data technologies.
• Knowledge of Amazon Redshift performance optimization, distribution keys, and sort keys.
• Experience with AWS Aurora and API Gateway.
• BFSI, Banking, or Insurance domain experience.

Ideal Candidate Profile :

• Strong hands-on technical and problem-solving skills.
• Experience working on real-time or batch-based production data pipelines.
• Good understanding of data processing, transformation, and storage concepts.
• Ability to troubleshoot technical issues and work independently.
• Good communication and collaboration skills.

Note : Candidates with strong practical experience in AWS Data Lake, PySpark, Airflow, Python, and SQL will be preferred. Real-world project experience is more important than theoretical knowledge or certifications.

We are looking for Data engineer with strong expertise in Data warehousing to join our team.

Key skills : ab initio, ssis , Informatica, Hadoop and Teradata

🚀 Job Title : Data Engineer – AWS, PySpark & Airflow

Experience : 5+ Years

Industry : Health Insurance / BFSI

Location : Sector 43, Gurugram, Haryana

Work Mode : Work From Office (5 Days a Week)

Employment Type : Full-Time

Role Overview :

We are looking for an experienced Data Engineer with strong hands-on expertise in AWS Data Engineering, Data Lake Architecture, Python, SQL, PySpark, and Apache Airflow.

The candidate will be responsible for designing, developing, and maintaining scalable, reliable, and high-performance data pipelines using AWS cloud technologies. The role involves building end-to-end ETL / ELT workflows, implementing data transformation and processing solutions, optimizing pipeline performance, and ensuring the reliability of production data systems.

Mandatory Skills :

AWS Data Engineering | Data Lake Architecture | Amazon S3 | AWS Glue | Amazon EMR | Athena | Redshift | Python | SQL | PySpark | Apache Spark | Apache Airflow | ETL/ELT | PostgreSQL | Data Modelling | Pipeline Optimization | Production Support | Root Cause Analysis

Key Responsibilities :

• Design, develop, and maintain end-to-end data pipelines for data ingestion, staging, transformation, curation, and consumption.
• Build and manage AWS-based data lake solutions using Amazon S3, AWS Glue, Amazon EMR, Athena, and Redshift.
• Develop, maintain, and optimize ETL / ELT pipelines using Python, SQL, Apache Spark, and PySpark.
• Implement and manage workflow orchestration using Apache Airflow, including scheduling, dependency management, retries, monitoring, and failure handling.
• Integrate data from multiple structured and semi-structured sources.
• Design and maintain data models, dimensional models, and analytical data marts.
• Work with relational databases, including PostgreSQL and Amazon RDS.
• Optimize Spark jobs, SQL queries, data transformations, and cloud resource utilization.
• Implement data quality checks, validation rules, and error-handling mechanisms.
• Monitor production data pipelines, troubleshoot failures, and perform root cause analysis (RCA).
• Ensure pipeline reliability, scalability, performance, and compliance with service-level agreements (SLAs).
• Follow data security, access management, governance, and sensitive-data protection best practices.
• Collaborate with business, analytics, and application teams to deliver effective data solutions.
• Maintain technical documentation and follow established data engineering standards.

Required Technical Skills :

• AWS Data Engineering : Strong hands-on experience with AWS-based data engineering and data lake architecture.
• AWS Services : Amazon S3, AWS Glue, Glue Data Catalog, Amazon EMR, Athena, Redshift, AWS Lambda, and IAM.
• Programming : Strong proficiency in Python and SQL.
• Big Data Processing : Hands-on experience with Apache Spark and PySpark.
• Workflow Orchestration : Experience developing and managing workflows using Apache Airflow.
• ETL/ELT Development : Experience building scalable data ingestion, transformation, and processing pipelines.
• Database Technologies : Good understanding of relational databases and PostgreSQL concepts.
• Data Modelling : Experience with data modelling, data transformation, and analytical data structures.
• Production Support : Ability to monitor pipelines, troubleshoot failures, perform RCA, and resolve production issues.
• Performance Optimization : Experience optimizing SQL queries, Spark jobs, and data processing workflows.

Good-to-Have Skills :

• Experience with AWS Database Migration Service (DMS) and Amazon RDS.
• Familiarity with dbt for data transformation and modelling.
• Knowledge of Delta Lake, Apache Iceberg, or Apache Hudi.
• Exposure to Apache Kafka and real-time data streaming.
• Familiarity with GraphQL, Hasura, or similar data-serving technologies.
• Understanding of data governance and data quality frameworks.
• Experience in the BFSI, healthcare, or health insurance domain.

Candidate Requirements :

• 5+ years of relevant experience in Data Engineering.
• Proven hands-on experience building and maintaining production-grade data pipelines on AWS.
• Strong understanding of data lake architecture and large-scale data processing.
• Practical experience with Apache Airflow and Spark / PySpark-based transformations.
• Strong programming, analytical, debugging, and problem-solving skills.
• Experience handling production incidents, pipeline failures, and performance bottlenecks.
• Ability to take ownership of deliverables and work effectively with cross-functional teams.
• Good communication, collaboration, and technical documentation skills.
• Willingness to work from the Gurugram office five days a week.

Ideal Candidate :

The ideal candidate is a hands-on Data Engineer who can independently build, optimize, and maintain AWS-based data pipelines, work with large datasets using PySpark, orchestrate workflows through Airflow, and resolve production issues in a business-critical environment.

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

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!

Shift: Second Shift (2:00 PM – 10:00 PM)

Joining: Immediate

About the Role

We are looking for an experienced Data Integration Developer with strong hands-on expertise in SQL, Python, ETL development, Snowflake, and AWS data services.

The ideal candidate should have extensive experience in designing, developing, and maintaining data integration solutions, building data warehouse architectures, and implementing scalable ETL pipelines. Strong SQL development and performance optimization skills are essential for this role.

This is a remote position; however, candidates must be available to visit our Mumbai or Bangalore location for three days during the onboarding process.

Key Responsibilities

SQL Development & Performance Optimization

• Develop complex SQL queries, stored procedures, and data transformation logic.
• Optimize SQL queries for performance, scalability, and efficiency.
• Perform advanced data analysis, validation, and reconciliation.
• Troubleshoot complex SQL and data-related issues.

ETL Development & Data Integration

• Design, develop, and maintain ETL pipelines and data integration workflows.
• Work with SQL and Python for data extraction, transformation, and loading.
• Ensure data accuracy, consistency, and integrity across systems.
• Identify and resolve data pipeline failures and integration issues.

Data Warehousing & Data Modeling

• Design and maintain data warehouse architectures.
• Develop data warehouse schemas based on business requirements.
• Work on dimensional data modeling, including Facts and Dimensions.
• Implement Slowly Changing Dimensions (SCD).
• Support data analysis and business information reconciliation.

Snowflake & AWS

• Develop and manage data solutions using Snowflake.
• Work with AWS services, particularly Amazon S3.
• Manage AWS connections and data access configurations.
• Build and maintain cloud-based data integration solutions.

Python & Apache Airflow

• Develop data processing and automation solutions using Python.
• Build, schedule, and monitor workflows using Apache Airflow.
• Troubleshoot workflow failures and improve pipeline reliability.

Agile & Development Lifecycle

• Participate in Agile development processes, sprint planning, and team discussions.
• Contribute throughout all stages of the software development lifecycle.
• Collaborate with cross-functional teams to understand business and technical requirements.
• Perform root cause analysis and implement appropriate corrective actions.

Required Skills

• Advanced SQL – Strong hands-on expertise is mandatory.
• Python Development
• ETL Development and Data Integration
• Snowflake
• Apache Airflow
• AWS Services, particularly Amazon S3
• AWS Connection Management
• Data Warehouse Architecture
• Data Modeling (Facts & Dimensions)
• Slowly Changing Dimensions (SCD)
• SQL Query Optimization and Performance Tuning
• Data Analysis and Reconciliation
• Troubleshooting and Root Cause Analysis
• Agile Development Methodologies
• Strong understanding of the Software Development Life Cycle (SDLC)

Experience & Qualifications

• 8–10 years of overall experience in Data Engineering / Data Integration / ETL Development.
• Strong professional experience in advanced SQL and Python.
• Hands-on experience with Snowflake, Apache Airflow, and AWS.
• Proven experience designing and developing data warehouse solutions.
• Experience working across the complete product development lifecycle.
• Ability to independently troubleshoot complex technical challenges.

Additional Requirements

• Immediate joiners preferred.
• Must be comfortable working in the second shift (2:00 PM – 10:00 PM).
• Position is remote, with a mandatory three-day onboarding visit to Mumbai or Bangalore.
• Strong communication, analytical, and problem-solving skills.
• Ability to work independently and collaboratively in an Agile environment.