Software Engineer I

Summary
We are seeking a Senior Data Engineer to architect and build modern Azure-based data solutions, lead large-scale data platform modernization initiatives, and mentor junior engineers. The ideal candidate should have deep expertise in Azure Synapse Analytics, Databricks, Azure Data Factory (ADF), and modern data engineering practices. Experience with Informatica PowerCenter is a plus but not mandatory.
Key Responsibilities
Design and implement end-to-end Azure data architectures using Azure Synapse Analytics, Databricks, and ADLS Gen2.
Lead and support data modernization and migration initiatives to Azure.
Perform solution assessment, complexity analysis, and migration planning.
Develop scalable data pipelines using PySpark, Spark SQL, and Azure Data Factory (ADF).
Implement data engineering best practices including SCD, CDC, UPSERT/MERGE, and data quality frameworks.
Optimize data processing performance, storage design, and cloud costs.
Design partitioning, data distribution, and performance tuning strategies.
Mentor team members and establish coding standards and engineering best practices.
Drive adoption of AI-assisted development tools such as GitHub Copilot to improve productivity and code quality.
Required Skills
Strong hands-on experience with:
Azure Synapse Analytics
Azure Databricks
PySpark
Spark SQL
Azure Data Factory (ADF)
Advanced SQL expertise across platforms such as:
Oracle
SQL Server
PostgreSQL
Experience with Git/GitHub, CI/CD, and Azure DevOps.
Strong understanding of:
Data Warehouse Concepts
Medallion Architecture
Data Governance
Data Security (RBAC, Key Vault)
Experience designing scalable and enterprise-grade data platforms.
Good to Have
Exposure to Informatica PowerCenter (IPC).
Experience with Kafka, Azure Event Hubs, or Streaming Architectures.
Terraform or Infrastructure as Code (IaC).
Power BI and Analytics solutions.
AI/ML integration with data platforms.
Domain experience in Insurance or Financial Services.

Work arrangement
Hybrid