Python Lead Developer

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using Python for ingestion, transformation, and processing.
• Implement and manage ELT workflows using DBT, ensuring modular, reusable, and maintainable transformations.
• Build and optimize Snowflake data models, views, and transformations for analytics consumption.
• Develop frameworks for handling structured and unstructured data ingestion.
• Ensure data quality, validation, and consistency across multiple data systems.
• Automate data workflows using Python-based utilities, SDKs, and CLI tools.
• Perform monitoring, troubleshooting, and performance tuning of pipelines.

Required Skills

• Strong hands-on expertise in Python (Primary skill) for data engineering, including scripting, data processing, and pipeline development.
• Experience with DBT (Secondary focus) for data transformation and modeling.
• Solid understanding of ELT concepts, data pipeline architecture, and workflow orchestration.
• Strong experience with SQL and complex data transformations.
• Hands-on experience with Snowflake (data modeling, transformations, performance tuning).
• Experience integrating with ETL/ELT tools (Informatica, DataStage, or similar).
• Familiarity with data pipeline frameworks and orchestration tools.
• Experience with CLI-based tools and Python SDKs for automation and migration.

Preferred Skills

• Exposure to cloud platforms (AWS/Azure/Google Cloud Platform) and modern data ecosystems.
• Experience with advanced DBT practices (macros, testing, documentation).
• Experience in Insurance domain, especially Pricing / Rating / Analytics datasets.