Data Lake Engineer

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.

Job Description:

We are seeking a skilled Senior Data Engineer with expertise in Databricks to join our dynamic data team. The ideal candidate will design, build, and maintain scalable data pipelines and architectures to support our organization's data-driven initiatives and leverage Databricks to process large-scale datasets, optimize data workflows, enable advanced analytics and machine learning, and integrate Power BI for data visualization and reporting.

Key Responsibilities

·        5-8 years of professional work experience in a relevant field

·        Proficient in Microsoft Fabric platform, Azure Databricks, ADF, Delta Lake, SQL Data Warehouse, Unity Catalog.

·        Good Experience on Microsoft Dynamics 365

·        Experience/ prior knowledge on semi structure data and Structured Streaming, Azure synapse, data lake, data warehouse.

·        Proficient in creating Azure Data Factory pipelines for ETL/ELT processing; copy activity, custom Azure development etc.

·        Good knowledge of SQL and Python for data manipulation, transformation, and analysis

·        Understand business requirements to set functional specifications for reporting applications

• Data Pipeline Development: Design, develop, and maintain robust, scalable data pipelines using Databricks, Apache Spark, and other cloud-based technologies.
• Data Integration: Ingest, transform, and integrate data from diverse sources, including APIs, databases, streaming platforms, and third-party systems, into Databricks for analytics and reporting.
• Power BI Integration: Develop and optimize data models and datasets in Databricks for use in Power BI, ensuring efficient data connections and high-quality visualizations.
• Performance Optimization: Optimize data workflows, API calls, and queries on Databricks and Power BI for performance, cost-efficiency, and scalability.
• Data Modeling: Build and maintain data models to support business requirements, ensuring data quality, consistency, and accessibility for analytics and reporting.
• Cloud Integration: Implement data solutions on cloud platforms (e.g., AWS, Azure, GCP) integrated with Databricks, Power BI, and API ecosystems.
• Security & Compliance: Implement data governance, security, and compliance best practices within Databricks, Power BI, and API environments.
• Technical Skills:
• Proficiency in Databricks, including Delta Lake, Spark SQL.
• Strong programming skills in Python, Scala, or Java.
• Experience with Apache Spark for big data processing.
• Knowledge of SQL for querying and transforming data.
• Proficiency in Power BI for creating data models, DAX queries, and interactive dashboards.

Preferred Qualifications

• Databricks certification (e.g., Databricks Certified Data Engineer Associate/Professional).

Experience with real-time data processing and streaming

Location: Bangalore Experience: 5 to 7 years Employment type: Full-time, permanent Work Hours: General Shift (10.00 AM to 7.00 PM) website: www.amazech.com Qualifications: Minimum B.E./B.Tech, or higher in Computer Science, Information Technology, Data Engineering, or a related field, with a good academic background. Key Responsibilities: • Design, develop, and maintain end-to-end data pipelines. • Build and optimize ETL/ELT processes for large-scale data processing. • Implement Azure-based data solutions ensuring scalability and performance. • Collaborate with stakeholders to understand business data requirements. • Perform performance tuning and optimization across data platforms. • Support production environments, conduct root cause analysis, and resolve data-related issues. • Maintain comprehensive technical documentation and structured knowledge transfer documents. • Work effectively within Agile/Scrum frameworks and contribute to sprint planning and delivery. • Ensure secure and compliant data handling using Azure best practices. Required Skills & Experience • End-to-end ETL/ELT pipeline development, integration, and performance optimization • Azure Synapse, Azure Logic Apps, Azure SQL, and Azure Databricks, with a strong focus on performance tuning • Microsoft Azure services, including Storage Accounts, Key Vault, and Cognitive Services • Advanced proficiency in Python development and modern productivity tools such as GitHub Copilot and Cursor • Strong documentation discipline, including technical design documentation, and structured knowledge transfer documents • Experience operating within Agile/Scrum frameworks, including production support, root cause analysis, and effective stakeholder collaboration

Immediate Joining

We are looking for a Dedicated Resource on Contract for –

Role: Data Engineer

Experience: 5+ Years

Location: Remote

Duration: 3+ Months

Strong hands-on experience with Snowflake, including writing SQL queries, creating views, stored procedures, and functions.

Good knowledge of AI tools such as Claude.

Experience with ETL tools like Alteryx is good to have.

Power BI experience is good to have.

Strong communication skills.

Strong Data Analyst Profile with Python, SQL, and data-pipeline expertise, ideally with retail / e-commerce datasets

2

Mandatory (Experience 1): Must have 4+ years of hands-on data-analyst experience, working with large datasets across areas such as sales, inventory, pricing, promotions, and customer behaviour.

3

Mandatory (Tech skill 1): Must have strong hands-on Python for data processing, transformation, automation, and analysis

4

Mandatory (Tech skill 2): Must have strong SQL skills, including complex queries, joins, aggregations, and data validation.

5

Mandatory (Tech skill 3): Must have a solid understanding of Data Lake architecture, ingestion, storage, and processing workflows

6

Mandatory (Tech skill 4): Must have hands-on experience with ETL / ELT pipelines, data integration, and transformation

7

Mandatory (Tech skill 5): Must have experience with Azure or GCP data services.

8

Mandatory (Tech skill 6): Must have understanding of or experience with Databricks and distributed data processing.

9

Mandatory (Tech skill 7): Must have knowledge of data modeling, data warehousing, and Lakehouse architecture

10

Mandatory (Tech skill 8): Must have experience with Power BI, Tableau, or Excel for reporting.

11

Mandatory (Communication): Must have strong analytical, documentation, and stakeholder-communication skills.

12

Mandatory (Education): Must hold a Bachelor’s degree in Computer Science, IT, Engineering, or a related field.

13

Mandatory (Note1): This is a 6-month contract role. Candidate must be comfortable with the contract engagement and able to join immediately (urgent — onboarding within ~a week)

Job Summary

We are seeking a skilled and detail-oriented Power BI Developer to design, develop, and maintain enterprise-level BI solutions. The ideal candidate should have strong expertise in Power BI, DAX, SQL, Data Modeling, and performance optimization tools such as DAX Studio, Tabular Editor, and ALM Toolkit. The candidate will collaborate with business stakeholders to transform data into actionable insights and deliver high-quality dashboards and reports.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Create complex DAX measures, calculated columns, and calculated tables to meet business requirements.
• Develop and optimize SQL queries, stored procedures, views, and ETL processes.
• Design and implement scalable Star Schema and Snowflake Data Models.
• Perform report and model performance tuning using DAX Studio.
• Utilize Tabular Editor for model management, calculation groups, best practice analysis, and metadata enhancements.
• Manage model deployment, comparison, and version control using ALM Toolkit.
• Configure and manage Power BI Workspaces, Apps, Gateways, and Security (RLS/OLS).
• Work extensively with Power BI Service/Web Experience, including dataset refresh schedules, deployment pipelines, subscriptions, and workspace administration.
• Collaborate with business users to gather and analyze reporting requirements.
• Ensure data accuracy, governance, security, and report performance.
• Troubleshoot data-related issues and implement effective solutions.
• Create technical documentation and provide knowledge transfer to support teams.

Required Skills

Technical Skills

• Strong experience in Microsoft Power BI Development.
• Expertise in DAX (Data Analysis Expressions).
• Advanced knowledge of SQL Server/T-SQL and query optimization.
• Strong understanding of Data Modeling concepts (Star Schema, Snowflake Schema, Fact & Dimension Tables).
• Hands-on experience with Tabular Editor.
• Experience using DAX Studio for model and query performance tuning.
• Experience with ALM Toolkit for model comparison and deployment.
• Strong understanding of Power BI Service/Web Experience.
• Knowledge of Power Query (M Language).
• Experience with Row-Level Security (RLS) and data governance.
• Understanding of data warehousing and ETL concepts.

Job Title : Data / AI / GenAI – Engineering & Analytics

Experience : 4+ Years

Location : Noida / Gurugram / Ahmedabad

Employment Type : Full-time | On-site at client location

Working Days : 5 days per week

Working Hours : Standard business hours

Position Overview : We are seeking professionals to deliver modern data engineering, business intelligence, cloud analytics and AI-powered applications, according to their specialization.

Mandatory Skills :

Python, SQL, ETL/ELT, Data Engineering, Power BI, Azure Data Factory, Databricks, PySpark, Data Modeling, GenAI/LLMs, RAG, Vector Databases, AI Agents (as per role specialization).

Key Roles / Specializations :

1. Power BI Developers : Dashboards, DAX, Power Query, reporting and data modeling
2. Azure Data Engineers : Azure Data Factory, Data Lake, Azure SQL and cloud pipelines
3. Databricks Engineers : Apache Spark, PySpark, Delta Lake and scalable processing
4. Data Engineers : ETL/ELT, SQL, Python, data warehousing and quality
5. GenAI / RAG Engineers : LLMs, prompts, embeddings, vector databases and retrieval pipelines
6. Agentic AI Engineers : AI agents, tool calling, orchestration and multi-agent workflows

Key Responsibilities :

• Design, develop and maintain data pipelines, analytics solutions or AI applications.
• Build and optimize data integration, transformation and processing workflows.
• Develop dashboards and analytical models for business decision-making.
• Use cloud data platforms and modern engineering frameworks.
• Develop and evaluate LLM applications, RAG solutions or AI agents as applicable.
• Ensure data quality, security, performance and reliability.
• Collaborate with engineering teams and stakeholders on testing, deployment and documentation.

Required Skills & Qualifications :

• Bachelor’s degree in Computer Science, IT, Data Science, Engineering or related discipline.
• 4–5 years of relevant experience in data, analytics, AI or software engineering.
• Hands-on expertise in at least one listed specialization; not all technologies are required.
• Relevant Python, SQL, DAX or other technical skills depending on the position.
• Understanding of cloud platforms, APIs, integration and software practices.

Preferred Qualifications :

• Azure, Databricks or Microsoft Fabric experience.
• For GenAI roles : Azure OpenAI, OpenAI APIs, LangChain, LlamaIndex or LangGraph.
• For relevant roles : vector databases, CI/CD, Docker, MLOps or LLMOps.

Note : Candidates are expected to have expertise in their relevant specialization, not in every listed technology or role.

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

Role Overview

We are seeking a Senior Reporting Analyst / Business Intelligence Lead to own and drive enterprise reporting, analytics, and data insights across the organization. This is a senior, hands-on role requiring deep technical expertise across the Microsoft data and BI stack, strong business acumen, and the ability to operate with minimal hand-holding. The ideal candidate will act as a bridge between business leadership and technical teams, translating complex business questions into scalable, reliable data models and executive-ready insights.

Key Responsibilities

·       Serve as the primary owner of enterprise reporting and BI solutions, from data ingestion through executive dashboards.

·       Design, build, and maintain scalable Power BI / Microsoft Fabric semantic models using STAR schema best practices.

·       Partner closely with business stakeholders and C-level executives to define KPIs, metrics, and reporting requirements.

·       Lead and present weekly reporting and insights sessions with senior and executive leadership.

·       Ensure data accuracy, consistency, and trust across all reports and analytics outputs.

·       Proactively identify data quality issues, root causes, and remediation strategies.

·       Drive automation of reporting, alerts, and data refresh processes to reduce manual effort.

·       Collaborate with engineering, data, and application teams to align business logic with source system data structures.

·       Mentor junior analysts and establish BI standards, best practices, and documentation.

Technical Skills – Data & Backend

·       Advanced SQL: complex queries, views, stored procedures, and validation against source systems (RDN, Recovery Connect).

·       Azure Data Factory: build and manage copy pipelines from SQL sources to data warehouses / dedicated pools.

·       Incremental refresh, parameterized pipelines, and schema replication.

·       Data warehouse design: STAR schema, fact vs dimension tables, handling deleted records and SCDs.

Technical Skills – Reporting & Frontend

·       Power BI / Microsoft Fabric: Power Query, DAX, and M language expertise.

·       Semantic model design (1-to-many, 1-to-1, many-to-1 relationships).

·       Query folding and performance optimization best practices.

·       Paginated Report Builder (SSRS-style) for automated Excel and PDF reporting.

·       Power Automate integration for alerts and workflow-driven notifications.

Data Quality & Analytics

·       Ability to clean, normalize, and reconcile data across multiple systems.

·       Strong troubleshooting skills when business definitions and data do not align.

·       Translate business terminology into accurate technical mappings and calculations.

Communication & Leadership

·       Serve as a key liaison between business stakeholders and technical teams.

·       Comfortable working directly with C-level executives and senior leadership.

·       Ability to lead executive-level meetings and clearly communicate insights.

·       Self-starter mindset with minimal hand-holding.

Qualifications

·       7–10+ years of experience in BI, analytics, or enterprise reporting roles.

·       Preferred experience in financial services or regulated environments.

·       Strong experience across the Microsoft BI ecosystem.

Preferred Certifications

·       Microsoft PL-300 (Power BI Data Analyst)

·       Microsoft DP-600 (Fabric Analytics Engineer)

·       Microsoft DP-700 (Fabric Data Engineer)

What Success Looks Like

·       Executive leadership trusts and relies on BI dashboards for decisions.

·       Reporting is automated, accurate, and scalable.

·       BI functions as a strategic partner to the business.

Experience: 7–10+ years | Industry Preference: Financial Services / BFSI

Role Overview

We are seeking a Senior Reporting Analyst / Business Intelligence Lead to own and drive

enterprise reporting, analytics, and data insights across the organization. This is a senior,

hands-on role requiring deep technical expertise across the Microsoft data and BI stack,

strong business acumen, and the ability to operate with minimal hand-holding. The ideal

candidate will act as a bridge between business leadership and technical teams, translating

complex business questions into scalable, reliable data models and executive-ready insights.

Key Responsibilities

 Serve as the primary owner of enterprise reporting and BI solutions, from data

ingestion through executive dashboards.

 Design, build, and maintain scalable Power BI / Microsoft Fabric semantic models using

STAR schema best practices.

 Partner closely with business stakeholders and C-level executives to define KPIs,

metrics, and reporting requirements.

 Lead and present weekly reporting and insights sessions with senior and executive

leadership.

 Ensure data accuracy, consistency, and trust across all reports and analytics outputs.

 Proactively identify data quality issues, root causes, and remediation strategies.

 Drive automation of reporting, alerts, and data refresh processes to reduce manual

effort.

 Collaborate with engineering, data, and application teams to align business logic with

source system data structures.

 Mentor junior analysts and establish BI standards, best practices, and documentation.

Technical Skills – Data & Backend

 Advanced SQL: complex queries, views, stored procedures, and validation against

source systems (RDN, Recovery Connect).

 Azure Data Factory: build and manage copy pipelines from SQL sources to data

warehouses / dedicated pools.

 Incremental refresh, parameterized pipelines, and schema replication.

 Data warehouse design: STAR schema, fact vs dimension tables, handling deleted

records and SCDs.

Technical Skills – Reporting & Frontend

 Power BI / Microsoft Fabric: Power Query, DAX, and M language expertise.

 Semantic model design (1-to-many, 1-to-1, many-to-1 relationships).

 Query folding and performance optimization best practices.

 Paginated Report Builder (SSRS-style) for automated Excel and PDF reporting.

 Power Automate integration for alerts and workflow-driven notifications.

Data Quality & Analytics

 Ability to clean, normalize, and reconcile data across multiple systems.

 Strong troubleshooting skills when business definitions and data do not align.

 Translate business terminology into accurate technical mappings and calculations.

Communication & Leadership

 Serve as a key liaison between business stakeholders and technical teams.

 Comfortable working directly with C-level executives and senior leadership.

 Ability to lead executive-level meetings and clearly communicate insights.

 Self-starter mindset with minimal hand-holding.

Qualifications

 7–10+ years of experience in BI, analytics, or enterprise reporting roles.

 Preferred experience in financial services or regulated environments.

 Strong experience across the Microsoft BI ecosystem.

Preferred Certifications

 Microsoft PL-300 (Power BI Data Analyst)

 Microsoft DP-600 (Fabric Analytics Engineer)

 Microsoft DP-700 (Fabric Data Engineer)

What Success Looks Like

 Executive leadership trusts and relies on BI dashboards for decisions.

 Reporting is automated, accurate, and scalable.

 BI functions as a strategic partner to the business.