Data Engineer

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

Business Intelligence Analyst - 2

Planview is the world leader in enterprise software planning for enterprise-wide deployment strategies, processes and resources. More than 4000 customers, among the world's largest and most respected companies, have successfully implemented Planview software to optimize their enterprise portfolio management, project, portfolio and resource management, business intelligence and expense tracking processes. We have had stable, organic growth for years and now need reinforcement.

Job Summary:

The Planview BI Team is seeking an experienced Business Intelligence Analyst – 2 to support, troubleshoot, optimize, and enhance business intelligence and reporting solutions built on Planview products.

This role focuses on advanced BI support across Power BI, Microsoft Fabric, SQL Server, SSAS, SSRS, OData, Dataflows, Data Pipelines, Data warehousing, and Data models. The BI Analyst – 2 will handle complex technical issues, perform advanced root-cause analysis and performance tuning, and work closely with customers and internal teams to deliver scalable BI solutions.

Key Responsibilities:

· Troubleshoot and resolve complex issues involving data accuracy, refresh failures, report behavior, connectivity, security, and performance across Power BI, SSRS, SSAS, SQL Server, OData, and Data warehousing layers.

· Perform advanced T-SQL development and performance tuning, including execution plans, indexing, query optimization, stored procedures, views, and complex queries.

· Support, develop, maintain, and optimize Power BI semantic models, DAX measures, Power Query, datasets, workspaces, gateways, refreshes, and Row-Level Security.

· Support and troubleshoot SSAS Tabular and Multidimensional models, including processing, calculations, relationships, security, and performance.

· Develop and troubleshoot advanced SSRS/paginated reports, including parameters, subreports, drill-through, expressions, pagination, subscriptions, and export formats.

· Support Microsoft Fabric solutions including Data Pipelines, Dataflows Gen2, Lakehouse/Warehouse, semantic models, and Power BI integration.

· Troubleshoot ETL/ELT processes, data pipelines, Dataflows, refresh failures, and data transformation issues across BI environments.

· Analyze and troubleshoot OData feeds, including filtering, pagination, refresh, connectivity, and large-volume data scenarios.

· Support Planview Automart, Datamart, and data warehouse implementations and ensure data consistency across source, warehouse, semantic, and reporting layers.

· Perform end-to-end root-cause analysis and performance optimization across the BI technology stack.

· Collaborate with customers, Product, Engineering, Hosting, and Support teams on complex technical issues and escalations.

· Provide technical guidance and mentoring to BI Analyst – 1 team members and contribute to BI best practices and documentation.

Required Skills & Qualifications:

·      5+ years of professional experience in Business Intelligence Development, BI Support, Data Analytics, or a related field.

·      Strong hands-on experience with Power BI, DAX, Power Query, and enterprise data modeling.

·      Advanced knowledge of SQL Server and T-SQL, including query optimization and performance tuning.

·      Strong experience with SSRS and enterprise reporting.

·      Experience with SSAS Tabular and/or Multidimensional models.

·      Experience with Microsoft Fabric, particularly Data Pipelines, Dataflows, Lakehouse/Warehouse, and Power BI.

·      Experience working with OData and enterprise data integration.

·      Strong understanding of Data Warehousing, Datamarts, Automart, ETL/ELT, and data modeling.

·      Experience troubleshooting Power BI Service, gateways, refreshes, security, and semantic models.

·      Strong analytical, troubleshooting, and root-cause analysis skills.

·      Proven ability to work directly with customers and communicate technical concepts to both technical and non-technical stakeholders.

·      Experience with tools such as DAX Studio, Tabular Editor, Performance Analyzer, Query Store, or SQL Profiler is an advantage.

• Relevant Microsoft certifications such as PL-300, DP-600, or DP-203 are an added advantage.

About the Role

We are looking for an experienced Power BI Architect to lead enterprise-wide BI initiatives. This role will be responsible for designing, implementing, and governing scalable Power BI solutions across the organization. The ideal candidate will play a key role in establishing best practices, driving adoption, and owning the overall BI architecture within the Center of Excellence (CoE).

Key Responsibilities

• Lead end-to-end implementation of Power BI solutions across the enterprise
• Design scalable, secure, and high-performance BI architecture
• Act as the Power BI Architect, providing technical leadership and direction
• Own and drive BI governance, standards, and best practices within the CoE
• Collaborate with business and technology teams to translate requirements into robust BI solutions
• Define data modeling strategies, reporting frameworks, and dashboard standards
• Ensure data accuracy, consistency, and performance optimization across reports
• Support and guide development teams in Power BI implementation
• Enable enterprise-wide adoption of Power BI through training, documentation, and mentorship
• Work closely with IT/technology teams to integrate Power BI with data platforms and enterprise systems

Required Skills & Qualifications

• 10+ years of experience in BI/Data Analytics, with strong focus on Power BI
• Proven experience in enterprise-wide Power BI implementation
• Strong expertise in:
• Power BI (Desktop, Service, Gateway, Dataflows)
• Data Modeling (Star Schema, Snowflake Schema)
• DAX, Power Query (M language)
• Experience in designing and implementing BI architecture at scale
• Strong understanding of data warehousing concepts and ETL processes
• Experience working within a Center of Excellence (CoE) model
• Excellent stakeholder management and communication skills

Preferred Skills

• Experience with Azure (Azure Synapse, Data Factory, Data Lake)
• Knowledge of DevOps practices for Power BI (CI/CD pipelines)
• Exposure to governance tools and security frameworks
• Certification in Power BI / Microsoft Data Platform

Location: Wakad, Pune

No of position: 1

Shift- 2PM to 11PM; (post 6pm can work from home when visiting office)

Mode of work: Hybrid (3 days from office)

Job Summary

We are looking for a skilled Power BI Developer with 3–5 years of experience in developing interactive dashboards, reports, and business intelligence solutions. The candidate should have strong expertise in Power BI, DAX, Power Query, data modeling, and SQL, with the ability to translate business requirements into actionable insights.

Key Responsibilities

• Design, develop, and maintain interactive dashboards and reports using Microsoft Power BI.
• Develop complex DAX measures, calculated columns, and KPIs to meet business reporting requirements.
• Perform data extraction, transformation, and loading using Power Query (M language).
• Design and optimize data models, including star and snowflake schemas and relationships.
• Write and optimize SQL queries to retrieve and validate data from relational databases.
• Configure Power BI Service workspaces, scheduled refreshes, gateways, and report access.
• Implement Row-Level Security (RLS) and appropriate data access controls.
• Optimize report performance, DAX calculations, and data models.
• Collaborate with business stakeholders, business analysts, and data engineering teams to understand reporting requirements.
• Perform data validation, troubleshoot reporting issues, and ensure data accuracy.
• Support report deployments, enhancements, and production issues.
• Maintain technical documentation and follow BI development best practices.

Required Technical Skills

• 3–5 years of hands-on experience in Power BI development.
• Strong proficiency in Power BI Desktop and Power BI Service.
• Good experience with DAX, including measures, filter context, and time intelligence.
• Strong knowledge of Power Query and M language.
• Experience in data modeling, relationships, calculated tables, and star schema design.
• Proficiency in SQL, including joins, subqueries, aggregations, and query optimization.
• Experience with report publishing, scheduled refreshes, gateways, and workspace management.
• Knowledge of Row-Level Security (RLS) and report performance optimization.
• Experience integrating data from SQL databases, Excel, and other business data sources.

Good to Have

• Exposure to Microsoft Fabric, Azure Data Services, or Azure SQL.
• Knowledge of ETL/ELT concepts and data warehouse fundamentals.
• Experience with Power BI deployment pipelines and version control.
• Familiarity with incremental refresh and large dataset optimization.
• Experience working in Agile/Scrum environments.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
• Strong analytical, problem-solving, and communication skills.
• Ability to work independently and collaborate effectively with cross-functional teams.

Selection Criteria

Candidates should demonstrate practical experience in building Power BI reports, writing DAX measures, transforming data using Power Query, designing data models, and troubleshooting report performance issues.

NOTE: Technical rounds are mandatory to be taken F2F from Pune office on the same day.

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.

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

The Power BI Intern will assist the analytics team in using Microsoft Power BI to create interactive dashboards and reports. Working with actual datasets to assist well-informed business decision-making, this position provides practical exposure to data analysis, visualization, and business intelligence techniques.

Job Description:

Experience: 10+ Years

Job Summary

We are looking for an experienced Azure Fabric Data Architect to lead the design and implementation of an enterprise data platform on Microsoft Fabric. The role involves architecting scalable data solutions, defining data governance, and enabling AI-driven analytics for a global financial services client.

Key Responsibilities

• Design end-to-end data architecture using Microsoft Fabric.
• Build enterprise Lakehouse, Data Warehouse, and OneLake solutions.
• Define data ingestion, ETL/ELT, governance, security, and performance strategies.
• Lead architecture for AI-powered analytics, AI Agents, and enterprise chatbots using Azure AI services.
• Work with business stakeholders to translate requirements into technical solutions.
• Mentor engineering teams and provide technical leadership.

Required Skills

• Microsoft Fabric (Data Factory, Lakehouse, Data Warehouse, OneLake)
• Azure Data Engineering
• Power BI
• Azure AI Services / Azure OpenAI
• Data Architecture & Data Modeling
• SQL, Python
• Azure DevOps, CI/CD
• Strong stakeholder management and solution design experience
• 
  

Preferred: Experience in Capital Markets or Financial Services and Microsoft Azure/Fabric certifications.

NOTE: One technical round is mandatory to be taken F2F from office.

Technical Lead 

Job Description 

Role Overview 

We are seeking a highly skilled Data Engineering Lead with minimum of 5 years of hands-on experience in Azure data engineering, data warehousing, and automation-driven  integration. The ideal candidate should be a proven technical lead, capable of driving end-to-end 

project delivery and working closely with customer teams. This is a Work from Office / Customer Site role. 

Roles and Responsibilities 

• Lead the design, development, and delivery of data engineering and automation projects. 

• Architect and implement ETL/ELT pipelines using Azure Data Factory. 

• Design and manage enterprise data warehouses including dimensional modeling and 

schema optimization. 

• Manage Azure components including Storage Accounts, Data Lakes, Azure SQL, and Synapse. 

• Drive automation initiatives across data ingestion and transformation workflows. 

• Collaborate with business and technical stakeholders to translate requirements into scalable solutions. 

• Mentor team members and enforce engineering best practices. 

• Serve as the technical anchor responsible for ensuring high-quality, on-time delivery. 

Skills and Qualification 

• Strong hands-on experience with Azure Data Factory, Azure Storage, Azure SQL/Synapse. 

• Deep understanding of data warehousing concepts: star/snowflake schemas, fact/dimension modeling. 

• Experience with automation-led data engineering solutions. 

• Strong troubleshooting, optimization, and analytical skills. 

• Excellent communication and stakeholder management abilities. 

• Proven experience as a Technical Lead leading teams and delivery. 

Must Have 

• Min of 5 years of relevant data engineering experience. 

• Strong Azure Data Engineering and Data Warehousing expertise. 

• Proven Technical Lead experience. 

• Ability to work from office and customer site. 

• Strong ownership mindset with a focus on quality and delivery excellence.

Job Description

We are looking for an experienced Azure Synapse Data Engineer with strong hands-on expertise in Azure data engineering, data warehousing, ETL/ELT, and SQL performance optimization.

Key Responsibilities

• Design, develop, and optimize solutions using Azure Synapse Analytics.
• Build and maintain data integration pipelines using Azure Data Factory (ADF) and Synapse Pipelines.
• Design and implement scalable Azure Data Lake Storage Gen2 (ADLS Gen2) architectures.
• Develop robust and high-performance ETL/ELT frameworks for enterprise data platforms.
• Monitor and troubleshoot large-scale data ingestion, transformation, and processing workloads.
• Identify and resolve performance bottlenecks across data movement and transformation processes.
• Ensure data quality, availability, reliability, and consistency across analytics platforms.
• Perform advanced SQL query analysis and optimization.
• Analyze execution plans and optimize complex analytical workloads.
• Configure and tune Synapse Dedicated SQL Pools.
• Design efficient partitioning strategies for large datasets.
• Optimize indexing, statistics, and workload distribution to improve query performance.

Mandatory Skills

• Azure Synapse Analytics
• Azure Data Factory (ADF)
• Synapse Pipelines
• ADLS Gen2
• ETL/ELT
• Strong SQL
• Synapse Dedicated SQL Pool
• SQL query/execution plan optimization
• Partitioning, indexing, and statistics
• Azure data warehouse / data lake architecture
• Performance tuning and troubleshooting

Ideal Candidate

A strong Azure Data Engineer with hands-on experience in Synapse + ADF + ADLS Gen2 + Advanced SQL + Dedicated SQL Pool performance tuning.