Python Lead Developer

Job Title

Job Overview:

Requirement/Must Have:

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.

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.

Nice to Have:

Exposure to cloud platforms (AWS/Azure/GCP) and modern data ecosystems.

Experience with advanced DBT practices (macros, testing, documentation).

Experience in Insurance domain, especially Pricing / Rating / Analytics datasets.