SQL Lead

Job Summary

The Technical Lead will be responsible for overseeing and leading projects related to Azure Data Factory (ADF), Azure Databricks, SQL, Oracle PL/SQL, and Python. The role involves designing, developing, and implementing data solutions while ensuring they meet the business requirements and align with best practices. (1.) Key Responsibilities

1. Lead and manage end-to-end data engineering projects using azure data factory, azure databricks, sql, oracle pl/sql, and python.

2. Collaborate with stakeholders to gather and understand requirements for data pipelines and analytics solutions.

3. Design and develop etl processes, data models, and data integration solutions.

4. Provide technical guidance and mentorship to the team members.

5. Ensure data quality, data governance, and data security standards are maintained throughout the project lifecycle.

6. Troubleshoot and optimize data pipelines and processes for performance and efficiency.

7. Stay updated on the latest trends and technologies in data engineering and contribute to continuous improvement efforts.

Skill Requirements

1. Proficiency in azure data factory (adf) and azure databricks for building and managing data pipelines.

2. Strong experience with sql and oracle pl/sql for data querying and manipulation.

3. Advanced programming skills in python for scripting and data processing tasks.

4. Knowledge of data modeling, data warehousing concepts, and database design principles.

5. Ability to work in a collaborative team environment and communicate effectively with stakeholders.

6. Strong analytical and problem-solving skills with attention to detail.

7. Experience in data visualization tools and techniques is a plus.

Certifications: Relevant certifications in Azure Data Factory, Azure Databricks, SQL, Oracle PL/SQL, or Python are advantageous.

Skill (Primary)

Data Fabric-Azure-Azure Data Factory (ADF)

Job Description

• Design and Implement Data Solutions: Lead the design, development, and implementation of scalable and secure Azure-

based data platforms, ensuring integration with various data sources and business systems. Deliver at least 2 major

projects every year with a focus on data engineering best practices.

• Optimize Data Pipelines: Build and optimize end-to-end data pipelines using Azure Data Factory, Azure Databricks, and

Azure Synapse, with an emphasis on automating data workflows. Achieve a 20% reduction in pipeline execution times

within the first 6 months.

• Cloud Infrastructure Management: Manage and maintain the Azure data environment, ensuring high availability, disaster

recovery, and cost optimization. Track and improve system uptime to exceed 99.9% reliability.

• Collaborate with Cross-Functional Teams: Partner with data scientists, data analysts, and business stakeholders to translate

business requirements into efficient data solutions. Facilitate at least 3 collaborative sessions per quarter to address key

business use cases.

• Ensure Data Security & Compliance: Implement data security measures, ensuring compliance with industry regulations

(GDPR, HIPAA, etc.) and company policies. Achieve and maintain full compliance in all data environments within the first

quarter of onboarding.

• Continuous Learning & Knowledge Sharing: Stay up-to-date with emerging Azure technologies, and mentor junior

engineers to promote knowledge sharing. Complete 1 Azure certification annually and conduct at least 2 internal

knowledge-sharing sessions per year.

• Sound knowledge of data governance practices, data quality management, and data security principles.

• Play a pivotal role in shaping our organization's data-driven journey, driving innovation through data analytics and insights.

• Optimize data storage, processing and retrieval mechanisms for performance, cost, and scalability using data storage

services (such as Azure Data Lake Storage, Azure SQL Database, etc.), data processing services (such as Azure Data Bricks,

Azure Synapse, etc.) and data visualization (PowerBI, Qlik, etc.) & integration services (Data API builder, logic apps, etc.)

• Monitor and troubleshoot data platform performance, identify and resolve issues, and provide recommendations for

continuous improvement.

• Collaborate with DevOps teams to automate deployment, configuration, and monitoring processes using Azure DevOps,

PowerShell, or other relevant tools.

• Stay up to date with the latest trends and advancements in cloud data services and provide recommendations on adopting

new technologies or features to enhance the data platform.

• Document technical designs, procedures, and guidelines for data platform engineering and operations

Knowledge, Skills & Experience

Job Experience • Bachelor's degree in Computer Science, Engineering, or a related field. Advanced

degree preferred.

• Proven 6-10 years experience in playing platform engineer or admin role

• Experience with big data technologies such as Apache Spark, Hadoop, or similar

frameworks.

• Solid understanding of cloud computing concepts and experience with cloud

infrastructure management and provisioning.

• Solid understanding of network security concepts and technologies (such as

firewalls, VPNs, intrusion detection/prevention systems, etc.) and data security

concepts and technologies (such as access controls, encryption, observability,

privacy laws/regulations, etc.)

• Experience in a Retail setup is preferred.

Required Skills The position will require someone with the following:

• Strategic Planning

Public

• Communication and Collaboration

• Problem Solving Skills A/B testing & experimentation

• SQL, BI tools, and storytelling with data

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

Key Responsibilities

• Lead end-to-end data migration initiatives, including assessment, planning, mapping, transformation, validation, and reconciliation.
• Define and implement data governance frameworks, standards, policies, and processes.
• Design and manage data solutions using Microsoft Azure Data Services.
• Lead development of BI dashboards, reports, KPIs, and analytics solutions.
• Work with business and technical stakeholders to understand reporting and data requirements.
• Develop and maintain data models, data pipelines, ETL/ELT processes, and reporting architecture.
• Ensure data quality, consistency, integrity, security, and compliance throughout migration and reporting processes.
• Identify data risks, dependencies, gaps, and migration challenges and drive their resolution.
• Establish data validation and reconciliation mechanisms to ensure migration accuracy.
• Provide technical leadership and guidance to data engineers, BI developers, and other project team members.
• Collaborate with application, cloud, infrastructure, and business teams during project implementation.
• Monitor data migration and BI deliverables against project timelines, quality standards, and business objectives.
• Prepare technical documentation, data dictionaries, mapping documents, governance guidelines, and project reports.

Required Skills & Experience

• 7+ years of experience in data, migration, BI, or related technology roles.
• Strong experience working on software/IT projects and managing data-related workstreams.
• Hands-on experience with Microsoft Azure Data Services.
• Strong understanding of data migration methodologies, ETL/ELT, data transformation, and reconciliation.
• Experience in Data Governance, Data Quality, Master Data, Metadata Management, and Data Security.
• Strong experience with BI reporting and dashboard development.
• Good understanding of SQL and relational databases.
• Experience with Power BI and data visualization is highly desirable.
• Knowledge of Azure services such as Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure SQL Database, or equivalent.
• Strong understanding of data architecture and data lifecycle management.
• Excellent stakeholder management, communication, analytical, and problem-solving skills.

Location - Remote (India)

Key Responsibilities 

• Design, develop, and maintain database schemas, stored procedures, views, and queries in SQL Server and MySQL. 

• Identify and resolve query performance bottlenecks using execution plans, indexing strategies, and tuning techniques. 

• Conduct regular database health checks and performance reviews to ensure optimal operation. 

• Collaborate with development and operations teams to support application data requirements. 

• Write and optimize complex SQL scripts to meet business and operational needs. 

• Support the DBA Team Lead with day-to-day database operations and incident resolution. 

• Assist in monitoring database availability, integrity, and backups. 

• Document database structures, procedures, and changes in a clear and organized manner. 

• Implement best practices for data storage, retrieval, and processing efficiency. 

• Contribute to the continuous improvement of database standards and internal processes. 

• Identify and effectively prioritize situations requiring urgent attention. 

• Stay current with system information, database technologies, changes, and updates. 

• Experience with cloud-managed databases (e.g., Microsoft Azure SQL Database, Amazon RDS) and understanding of scaling, cost optimization, and high availability in cloud environments. 

• Hands-on exposure to database automation and CI/CD practices (schema versioning, deployment pipelines, Infrastructure as Code). 

• Strong knowledge of high availability and disaster recovery design, including replication, failover, and defined RPO/RTO ownership. 

• Familiarity with database security best practices (encryption, access control, auditing, and protection of sensitive/regulated data). 

• Experience with monitoring and observability tools, with a proactive approach to performance tuning and alerting. 

• Scripting ability (PowerShell, Python, or Bash) to automate routine database operations and reduce manual effort. 

• Experience with database migrations, version upgrades, or modernization initiatives (on-prem to cloud or legacy to current platforms). 

• Ability to operate in a DevOps-oriented environment, partnering closely with engineering teams and owning database performance tied to application SLA. 

• Proficiency in T-SQL and/or standard SQL. 

• Ability to multi-task and adjust priorities quickly in a fast-paced environment. 

• Ability to research and implement solutions using available technical resources. 

• Strong analytical and problem-solving skills with attention to detail. 

• Ability to clearly communicate technical concepts to non-technical stakeholders. 

• Advanced knowledge of database performance tuning and query optimization. 

• Familiarity with cloud database platforms such as Microsoft Azure SQL, AWS   RDS, or equivalent. 

• Experience with database deployment automation and CI/CD pipelines. 

• Understanding of high availability, disaster recovery, and data protection strategies. 

• Working knowledge of database monitoring and performance management tools. 

• Basic scripting skills (PowerShell, Python, or Bash) for automation. 

• Awareness of data security and compliance considerations in regulated environments. 

Required Skills 

• Proven working experience as a Database Administrator or in a similar role. 

• Working knowledge of Microsoft SQL Server (SSIS, T-SQL, DDL, SML) 

• Working knowledge of MySQL or MariaDB. 

• A minimum of 5 years of experience in database administration. 

• Understanding of database normalization and data modeling principles. 

Nice to Have 

• MacOS, iOS, Android, Linux OS beneficial but not required. 

• ETL processes or data warehouse experience beneficial but not required. 

• Microsoft Certified: Azure Database Administrator Associate or equivalent SQL Server certification preferred but not required. 

• MySQL certification preferred but not required. 

Roles & Responsibilities

• Design, develop, and deliver scalable end-to-end data pipelines using Azure Data Factory, ensuring robust integration

of enterprise-wide data from diverse sources

• Build and optimize data engineering workflows using Databricks and PySpark

• Write efficient, high-performance SQL for data transformation and analysis

• Work with the Azure Cloud platform and associated services, applying strong understanding of data warehousing,

data models, and pipelines

• Provide technical leadership to a team of developers, including code reviews and enforcing best practices across the

development lifecycle

• Oversee CI/CD implementation using Azure DevOps, managing deployments across development, QA, and production

environments with proper change control processes

• Collaborate with cross-functional teams to translate business requirements into scalable data solutions

• Ensure data quality, reliability, and performance across all pipelines and platforms

Ideal Candidate

1Strong Azure Databricks Engineer / Senior Data Engineer Profile

2Mandatory (Experience 1) – Must have minimum 8+ years of overall experience in Data Engineering, Data Development, or related data technology roles, with strong hands-on experience in enterprise data pipeline development.

3Mandatory (Experience 2) – Must have strong hands-on experience with Azure Databricks, including development and optimization of scalable data engineering workflows using Databricks and PySpark.

4Mandatory (Experience 3) – Must have strong hands-on proficiency in PySpark/Python and SQL, with proven experience developing complex data transformations, processing workflows, and performance-optimized queries.

5Mandatory (Experience 4) – Must have hands-on experience with Azure Data Factory (ADF) for designing, developing, and orchestrating end-to-end data pipelines and integrating data from multiple sources.

6Mandatory (Experience 5) – Must have strong experience working on the Azure Cloud platform and associated data services, with solid understanding of data warehousing, data modeling, pipeline architecture, and enterprise data solutions.

7Mandatory (Experience 6) – Must have hands-on experience implementing CI/CD using Azure DevOps, including deployment and release management across development, QA, and production environments.

8Mandatory (Experience 7) – Must have proven technical leadership experience, including code reviews, enforcing development best practices, mentoring developers, and providing technical guidance to a data engineering team.

9Mandatory (Notice Period) – Immediate joiners or candidates who can join within 15 days.

10Mandatory (Note) - The position is open across all Cognizant offices pan India. Candidates must be willing to attend the F2F interview at the nearest Cognizant office location.

Description:

Analytical Engineer with strong Data Analyst and Data Modelling expertise required to translate business requirements into structured, analytics-ready datasets. Must have experience in Data Vault 2.0 / dimensional modelling and advanced SQL for data transformation and analysis. Role focuses on data profiling, validation, and delivery of trusted data for reporting and analytics. Experience with Azure/Databricks and enterprise data environments preferred. Strong stakeholder engagement and ability to bridge business and technical data requirements essential.

Must Have Skills

• Data Analysis
• Data Governance
• Data Modeling tool

Nice to Have Skills

• Business writing skills
• Governance, Risk and Controls
• Principles of project management
• Relevant regulatory knowledge
• Relevant software and systems knowledge

Role Summary

We are looking for an accomplished PowerBi Solution architect to architect and drive scalable, insight-rich analytics solutions across the enterprise. This role sits at the intersection of data engineering, business intelligence, and solution architecture—ideal for a candidate with mastery of modern visualization tools, modeling strategies, and end-to-end data integration.

Key Responsibilities

● Architect and implement scalable Power BI solutions that span data modeling, integration, visualization, and performance tuning

● Design and lead the development of enterprise-grade data models using Star, Snowflake, and composite architecture

● Lead the integration of cloud-based data warehouse platforms including Oracle ADW and Snowflake

● Lead the development of scalable, interactive dashboards using Power BI, driving self-service analytics across business units

● Develop ETL and ELT pipelines to ingest and transform structured, semi-structured, and API-driven data sources

● Implement automated data ingestion and transformation using Python and shell scripting for performance and reliability

● Handle and harmonize data from diverse API sources across applications, platforms, and third-party services

● Deliver interactive dashboards and storytelling experiences tailored for executives, analysts, and operational teams

● Optimize semantic layers, DAX calculations, and deployment pipelines for reusability and governance

● Mentor BI developers and analysts, setting architectural standards and fostering collaboration across analytics teams

● Collaborate with cross-functional teams to translate strategic business goals into robust analytics solutions

Required Qualifications

● 8+ years in Power BI development and analytics Engineering, with 3+ years in architecture leadership roles

● Strong command of DAX, M Query, and performance tuning best practices

● Deep experience in data modeling (Star, Snowflake, composite) and cross-platform architecture

● Hands-on expertise in Oracle ADW, Snowflake, and API-based data ingestion

● Proficiency in Python, shell scripting, and automation of analytics pipelines

● Strong background in ETL/ELT development, data quality assurance, and deployment orchestration

● Demonstrated success in solution architecture across cloud ecosystems such as Azure, Oracle OCI

Preferred Skills

● Experience with Power BI Premium capacity management and deployment pipelines

● Experience with DAX, M language, and performance tuning technique

● Experience integrating third-party BI tools, data lakehouses, and stream processing services

● Effective communicator capable of translating technical architecture into business value

● Exposure to MS Fabric and Azure Data Factor

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: Data Architect – Databricks / AWS

Job Summary

We are looking for an experienced Data Architect to define and drive the target data architecture for the Horizon MVP and its future evolution. The role will be responsible for designing a scalable, secure, governed cloud data platform covering ingestion, storage, processing, analytics, APIs, and downstream data consumption.

The architect will work closely with Data Engineering, Backend, DevOps, QA, and business stakeholders to establish architecture standards and ensure the platform is ready for advanced analytics, AI/ML, vector storage, and future LLM-based capabilities.

• Job Title: Data Architect
• Experience: 8+ Years
• Relevant Architecture Experience: 3+ Years in Data Architecture
• Location: Chennai / Pune
• Work Mode: Hybrid – 3 Days WFO
• Budget: Up to 24 LPA
• Payroll: Haparz
• Notice Period: Immediate Preferred

Key Responsibilities

• Define the target data architecture for the Horizon MVP and establish an architecture roadmap for future scalability.
• Design end-to-end architecture covering data ingestion, storage, processing, serving, reporting, APIs, and downstream applications.
• Establish canonical data models and schemas for travel signals, corridors, sources, evidence, scores, and generated insights.
• Define data normalization strategies for structured, semi-structured, and unstructured data from multiple external sources.
• Design and govern the Databricks platform architecture, including Unity Catalog, data schemas, access controls, and governance standards.
• Establish data-retention, lineage, data-quality, security, privacy, and compliance controls.
• Define secure integration patterns between Databricks, AWS PRODIGY, SharePoint, external APIs, and downstream applications.
• Design scalable data processing for 30-day signal windows, convergence/divergence scoring, corridor ranking, and spike detection.
• Define architecture patterns that support future vector storage, embeddings, LLM integration, and multi-year analytics.
• Design reliable batch and API-driven ingestion frameworks for structured and unstructured data.
• Review technical designs, identify architectural risks, and provide technical direction to engineering teams.
• Guide backend, data engineering, DevOps, and QA teams in implementing architecture standards.
• Ensure architecture decisions align with enterprise security, RBAC, PII handling, privacy, and operational requirements.
• Communicate architecture decisions, trade-offs, and technical recommendations effectively to technical and business stakeholders.
• 
  

What We’re Looking For

• 8+ years of experience in data engineering, data platforms, or data architecture, with at least 3+ years in a Data Architect capacity.
• Strong hands-on experience designing cloud-based data platforms, lakehouses, or analytical platforms.
• Advanced knowledge of Databricks, Apache Spark/PySpark, Delta Lake, and Unity Catalog.
• Strong understanding of AWS data services, IAM, networking, and secure cloud integration patterns.
• Strong expertise in data modelling, metadata management, data lineage, data quality, retention, and governance.
• Experience architecting batch and API-based ingestion pipelines for structured, semi-structured, and unstructured data.
• Understanding of AI/ML workloads, feature pipelines, vector databases, embeddings, and LLM integration patterns.
• Experience designing APIs and downstream data-serving architectures.
• Strong knowledge of PII protection, RBAC, data privacy, and enterprise security controls.
• Excellent architectural communication and stakeholder-management skills.