Sr Data Modeler / Solution Architect

Hiring: Data Modeler

Experience: 6+ years

Location: Bangalore/Gurugram/Pune

Required Skills

• Hands-on experience in conceptual, logical, and physical data modeling.
• Strong knowledge of ER modeling, dimensional modeling, star/snowflake schemas, fact/dimension tables, and SCDs.
• Strong SQL skills for data profiling, validation, and quality checks.
• Experience with source-to-target mapping, data dictionaries, metadata, and data lineage.
• Proficiency in Erwin, ER/Studio, or similar modeling tools.
• Exposure to Snowflake, Databricks, Redshift, SQL Server, or other data platforms.
• Understanding of data governance, UAT, reconciliation, and Agile methodologies.
• Strong analytical, documentation, and stakeholder management skills.

Preferred Qualifications

• Experience in enterprise data warehousing or lakehouse modeling.
• Knowledge of data products, data contracts, quality SLAs, and reusable datasets.
• Exposure to dbt, data cataloging, metadata management, and governance tools.
• Ability to work independently in a fast-paced environment.

If interested please share your cv at : snigdhaattheratebeanhr.com

IMMEDIATE JOINERS ONLY

Key Responsibilities:

1                   Data Flow Mapping & Lineage

2                   Design and produce end-to-end data flow maps for critical data items – from market source/core systems, through Data Lake staging, zone 2 and consumption zone 3, to downstream reporting, dashboards and analytics use cases.

3                   Document data lineage and transformations for critical data elements identified in the Master Data Requirements exercise, ensuring traceability that is audit-defensible and supports regulatory, governance and AI-readiness needs.

4                   Map data availability by country/Data Lake against the Product Hierarchy (to profit-centre level), building the consolidated Commercial Data Landscape view of what exists, where it sits (source only, staging, or consumption) and what is not captured at all.

5                   Document cross-system dependencies and cross-border data flows, flagging data residency, privacy and regulatory considerations to the appropriate governance forums.

6                   Data Inventory, Data Model Alignment & Gap Analysis

•                    Own and mature the data asset inventory, catalogue and data dictionary aligned to the consolidated Master Data Requirements Template – resolving “Not Specified”, “TBD” and “validation required” availability statuses through structured validation with Market IT and Data Engineering.

•                    Align business data requirements to the conceptual and logical data model of the target Data Lakehouse, ensuring the dependency between data model design and lineage tracking of critical data items is explicitly documented.

•                    Perform gap and hydration analysis by market and product, quantifying the scale of data that must be brought into the Data Lakes and providing sizing input to the Data Foundation Lead, DAE architects and Data Engineering delivery plans.

•                    Contribute to the Data Consolidation Plan towards a single source of truth, including recommended sequencing based on business priority (Top 200 fields, Horizon 1–3 priorities).

•                    Stakeholder Engagement & Workshops

•                    Work hand-in-hand with the Data Foundation Lead, Data & Analytics Programme Manager, Data Engineers, DAE/infrastructure architects, Local Market IT and Business stakeholders (Regional and Market) as the connective tissue between business data needs and technical implementation.

•                    Plan and facilitate structured interviews and cross-functional validation workshops with business, technology and data stakeholders to corroborate actual operating data flows against documented processes – establishing a fact-based, evidence-backed view rather than relying on documentation alone.

•                    Translate ambiguous business asks into clear data definitions, mapping rules and acceptance criteria that Data Engineering can build against, and play back findings to senior stakeholders in clear, visual, decision-oriented formats.

•                    Manage competing priorities across multiple markets with tact, keeping momentum in an environment of constrained capacity and differing local system landscapes.

•                    Governance, Ownership & Documentation

•                    Produce and maintain the Data Ownership & Accountability Matrix – mapping data owners, stewards and custodians per data asset and highlighting ownership gaps for remediation.

•                    Classify data assets by sensitivity and business function, aligning to Data Protection Policy, PDPA and applicable regulatory expectations (e.g. MAS guidelines) in partnership with Risk & Compliance.

•                    Ensure all data flow maps, lineage records and inventory artefacts are version-controlled, audit-ready and handed over cleanly into BAU data governance processes.

•                    Produce source to Datalake mapping document and data catalogue for missing data elements to complete Datalake hydration

Key Skills

•                    Data flow mapping and lineage documentation – proven ability to draw clear, accurate source-to-consumption data flow maps across complex multi-system, multi-market landscapes.

•                    Data architecture and modelling – strong grasp of conceptual/logical data models, data lake/lakehouse zone architectures (staging, conformed, consumption), data marts and MDM concepts.

•                    Data inventory, catalogue, dictionary and metadata management; familiarity with lineage/catalogue tooling (e.g. Purview, Collibra) and diagramming tools (e.g. Visio, ErWin, Lucidchart).

•                    Hands-on data profiling and validation skills (SQL essential) to verify what actually exists in source systems and lake zones.

•                    Strong stakeholder management – this is critical: able to build trust and drive outcomes across regional leadership, market business teams, Market IT and engineering, and to facilitate effective cross-functional workshops.

•                    Insurance domain knowledge – ideally commercial and specialty lines, with an understanding of policy, claims, reinsurance and underwriting data.

•                    Data quality, governance and privacy concepts, including cross-border data considerations.

•                    Clear written and visual communication – able to make complex data landscapes understandable to executives.

Experience & Qualification Requirements:

•                    8+ years’ experience in data architecture, data business analysis or information architecture roles, with at least:

•                    3+ years documenting data flows, lineage or data landscapes across multi-system / multi-market environments.

•                    Experience in Insurance or Financial Services, ideally within data foundation, data lake or data governance programmes.

•                    Demonstrated delivery of data inventory / data mapping / current-state data landscape assessments involving both business and IT stakeholders.

•                    Relevant certification (e.g. DAMA CDMP, TOGAF, cloud data platform certifications) preferred.

Solution Architect – AZURE Data Engineering

Job Overview

We are looking for an experienced Solution Architect – Data Engineering with strong expertise in designing data solutions and hands-on experience with Azure, Synapse, PySpark, Data Warehousing, and Data Lakes. The ideal candidate should have strong architectural and data engineering knowledge.

Key Responsibilities

• Design and implement scalable data architecture and solutions.
• Develop and manage Data Warehouse and Data Lake architectures.
• Design data platforms using Medallion Architecture.
• Lead Data Engineering and ETL activities.
• Work with Azure Synapse Analytics for data processing and analytics.
• Develop data solutions using PySpark / Apache Spark.
• Define and implement data validation and data quality processes.
• Collaborate with business, data, and technology teams to deliver effective data solutions.

Required Skills

• Strong experience in Solution Architecture / Data Architecture.
• Strong knowledge of Data Warehouse and Data Lake architecture.
• Good understanding of Medallion Architecture.
• Strong experience in Data Engineering and ETL.
• Hands-on experience with Microsoft Azure and Azure Synapse Analytics.
• Strong knowledge of PySpark / Apache Spark.
• Experience with Data Validation and Data Quality.
• Good communication and stakeholder management skills.
• 
  

Experience

8+ Years

Data Architect – Databricks & AWS

• Strong experience in Data Architecture, Data Engineering, Databricks, Apache Spark/PySpark, Python, and Advanced SQL.
• Design and implement scalable ETL/ELT pipelines, data platforms, and Lakehouse architectures using Medallion Architecture.
• Experience with Databricks, Databricks Workflows, Unity Catalog OR Databricks Jobs
• Strong knowledge of Delta Lake, Databricks Workflows, Delta Live Tables (DLT), and dimensional data modeling.
• Hands-on experience with AWS services such as S3, Glue, IAM, Lambda, and CloudWatch.
• Experience with Apache Airflow, Data Warehouse concepts, Git/CI-CD, performance optimization, and data quality.
• Good to have exposure to Kafka/Structured Streaming, Unity Catalog, and modern data governance.

🚨 HIRING ALERT | DATA MODELLER – Property & Casualty INSURANCE / LLOYD’S MARKET

🚨🔹 Experience: 5–10 Years

🔹 Location: Delhi NCR | Pune | Bangalore

🔹 Notice Period: Only Serving/Immediate Joiners

Required Skills:

✅ P&;C Insurance; Lloyd’s Market (Mandatory)

✅ Data Modelling | ER Modelling

✅ Policy | Claims | Billing | Underwriting

✅ SQL | Data Warehouse

✅ Enterprise / Canonical / Dimensional Data Models

📩 Share CV: snigdhaattheratebeanhr.com

🔁 Know someone suitable? Please share this opportunity

About the Role

We are looking for a Solution Architect with 10–15 years of experience to design scalable, secure, and cloud-ready solutions. The role involves working with customers, Senior Solution Architects, business analysts, project managers, and engineering teams across cloud, modernization, microservices, integration, and digital transformation initiatives.

Must Have Skills

• 10–15 years of experience in software development, architecture, and enterprise application delivery.
• Strong experience with Azure and/or AWS and cloud-native architecture.
• Hands-on experience with Microservices, REST APIs, SOA, and system integration.
• Experience in application modernization and cloud migration.
• Knowledge of Docker, Kubernetes, CI/CD, and Infrastructure as Code.
• Understanding of cloud security, IAM, networking, monitoring, and disaster recovery.
• Ability to create architecture diagrams, solution designs, and technical documentation.
• Strong analytical, communication, and customer-facing skills.

Good To Have Skills

• AWS/Azure certifications.
• Experience with Serverless, Event-Driven Architecture, Messaging, and API Management.
• Exposure to SaaS / Multi-Tenant Architecture.
• Knowledge of Generative AI and AI-enabled solutions.
• Experience with pre-sales, POCs, estimations, and technical proposals.
• Exposure to application security and compliance.
• Experience working with global customers and distributed teams.

Responsibilities

• Design end-to-end solutions and independently own defined architecture workstreams.
• Translate business and technical requirements into application, cloud, integration, and deployment designs.
• Define microservice, API, integration, and data-flow architectures.
• Guide engineering teams on architecture implementation and conduct design/code reviews.
• Contribute to cloud migration, modernization, and digital transformation initiatives.
• Participate in customer workshops, technical discussions, POCs, and solution demonstrations.
• Identify and address architectural, performance, security, and technical risks.
• Ensure solutions follow defined architecture, security, and engineering standards.
• Work closely with the Senior Solution Architect on complex and strategic engagements.
• Develop reusable architecture patterns, templates, and technical accelerators

Next

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!

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

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

Senior Data Engineer – PySpark & Oracle

Experience: 7+ Years

Location: Bangalore

Notice Period: Immediate to 10 Days

Key Skills:

• Strong expertise in Data Modeling, Data Design & Modernization
• Primary skills: PySpark, Oracle SQL/PLSQL
• Secondary skills: Python, ETL & Data Pipelines
• Experience with Kafka and Hadoop
• Exposure to AWS / Azure / GCP
• Good knowledge of Git and JIRA

Roles & Responsibilities:

• Design, develop, and modernize scalable data models and data architecture.
• Develop and optimize data processing solutions using PySpark and Oracle SQL/PLSQL.
• Build and maintain robust ETL workflows and data pipelines.
• Work with Kafka, Hadoop, and cloud platforms for data processing and integration.
• Perform data transformation, optimization, and performance tuning.
• Collaborate with technical teams on data design, development, testing, and deployment.