BI Developer at Agiletech Info Solutions pvt ltd · Chennai · 4 - 9 years · ₹4L - ₹12L / yr · Bootstrapped · Posted 30 Sep 2022

4 - 8 overall experience.
- 1-2 years’ experience in Azure Data Factory - schedule Jobs in Flows and ADF Pipelines, Performance Tuning, Error logging etc..
- 1+ years of experience with Power BI - designing and developing reports, dashboards, metrics and visualizations in Powe BI.
- (Required) Participate in video conferencing calls - daily stand-up meetings and all day working with team members on cloud migration planning, development, and support.
- Proficiency in relational database concepts & design using star, Azure Datawarehouse, and data vault.
- Requires 2-3 years of experience with SQL scripting (merge, joins, and stored procedures) and best practices.
- Knowledge on deploying and run SSIS packages in Azure.
- Knowledge of Azure Data Bricks.
- Ability to write and execute complex SQL queries and stored procedures.

About Agiletech Info Solutions pvt ltd
About
Similar jobs (10)
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.
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 :
- Power BI Developers : Dashboards, DAX, Power Query, reporting and data modeling
- Azure Data Engineers : Azure Data Factory, Data Lake, Azure SQL and cloud pipelines
- Databricks Engineers : Apache Spark, PySpark, Delta Lake and scalable processing
- Data Engineers : ETL/ELT, SQL, Python, data warehousing and quality
- GenAI / RAG Engineers : LLMs, prompts, embeddings, vector databases and retrieval pipelines
- 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.
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

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.
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
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.
Lead Data Engineer – Databricks & Azure
- We are looking for a Lead Data Engineer with 5–7 years of experience in Azure, Databricks, and Microsoft Fabric to lead and mentor the data engineering team. The role involves implementing scalable data solutions using Databricks as the core platform, building modern data pipelines, and enabling seamless integration with Microsoft Fabric and Power BI.
Responsibilities & Requirements:
- Lead and mentor data engineers while driving hands-on technical delivery.
- Implement approved Databricks and Microsoft Fabric architectures and solutions.
- Develop metadata-driven bronze, silver, and gold data pipelines.
- Build reusable batch, incremental, CDC, and streaming ingestion pipelines.
- Strong hands-on experience with Azure Databricks, PySpark, SQL, and Delta Lake.
- Experience with Microsoft Fabric, OneLake, Direct Lake, and Power BI integration.
- Implement data quality checks, reconciliation, source-to-target mapping, and metadata management.
- Configure Unity Catalog for data governance, access control, auditing, and lineage.
- Implement CI/CD, automated deployments, and Datadog monitoring.
- Drive testing, documentation, operational readiness, and knowledge transfer.
Good to have:
- Experience with MDM and master data integration.
- Exposure to Azure DevOps or GitHub Actions.
- Experience with automated data testing and reconciliation frameworks.
- Experience working with onshore stakeholders and distributed engineering teams.
- Strong communication, problem-solving, and team leadership skills.
Sr. Data Engineer
Location: Pune
Responsibilities
· Lead the end-to-end design and development of scalable, high-performance data pipelines and ETL/ELT frameworks aligned with modern data engineering best practices.
· Architect complex data integration workflows that bring together structured, semi-structured, and unstructured data from both cloud and on-premise sources.
· Build robust real-time, batch, and on-demand pipelines with built-in observability—monitoring, alerting, and automated error handling.
· Partner with analysts, data scientists, and business leaders to define and deliver reliable data models, quality frameworks, and SLAs that power key business insights.
· Ensure optimal pipeline performance and throughput, with clearly defined SLAs and proactive alerting for data delivery or quality issues.
· Collaborate with platform, DevOps, and architecture teams to build secure, reusable, and CI/CD-enabled data workflows that align with enterprise architecture standards.
· Establish and enforce the best practices in source control, code reviews, testing automation, and continuous delivery for all data engineering components.
· Lead root cause analysis (RCA) and preventive maintenance for critical data failures, ensuring minimal business impact and continuous service improvement.
· Guide the team in establishing standards for data modeling, transformation logic, and governance, ensuring long-term maintainability and scalability.
· Design and execute comprehensive testing strategies—unit, integration, and system testing—ensuring high data reliability and pipeline resilience.
· Monitor and fine-tune data pipeline and query performance, optimizing for reliability, scalability, and cost-efficiency.
· Create and maintain detailed technical documentation, including data architecture diagrams, process flows, and integration specifications for internal and external stakeholders.
· Facilitate and lead discussions with business and operational teams to understand data requirements, prioritize initiatives, and drive data strategy forward.
Qualifications
· 7 to 10 years of hands-on experience in data engineering roles with a proven record of building scalable and secure data platforms.
· Over 5 years of experience in scripting languages such as Python for data processing, automation, and ETL development.
· 4+ years of experience with Snowflake, including performance tuning, security model design, and advanced SQL development.
· 5+ years of experience with data integration tools such as Azure Data Factory, Fivetran, or Matillion.
· 5+ years of experience in writing complex, highly optimized SQL queries on large datasets.
· Proven experience integrating and managing APIs, JSON, XML, and webhooks for data acquisition.
· Hands-on experience with cloud platforms (Azure/AWS) and orchestration tools like Apache Airflow or equivalent.
· Experience with CI/CD pipelines, automated testing, and code versioning tools (e.g., Git).
· Familiarity with dbt or similar transformation tools and best practices for modular transformation development.
· Exposure to data visualization tools like Power BI for supporting downstream analytics is a plus.
· Strong interpersonal and communication skills with the ability to lead discussions with technical and business stakeholders.
Education
Bachelor’s or Master’s degree in Computer Science/Information technology or related field.
Equivalent academic and work experience can be considered.
8-12 years experience on Data Engineering role working with Databricks & Azure Cloud technologies.
• Bachelor’s degree in computer science, Information Technology, or related field.
• Strong proficiency in PySpark, Python, SQL.
• Strong experience in data modeling, ETL/ELT pipeline development, and automation • Hands-on experience with performance tuning of data pipelines and workflow
• Proficient in working on Azure cloud components Azure Data Factory, Azure DataBricks, Azure Data Lake etc.
• Experience with data modeling, ETL processes, Delta Lake and data warehousing.
• Experience on Delta Live Tables, Autoloader & Unity Catalog.
Preferred - Knowledge of the insurance industry and its data requirements.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Excellent communication and problem-solving skills to work effectively with diverse teams
• Excellent problem-solving skills and ability to work under tight deadlines.
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.











