Data Engineer - Python | 5+ Year

Apexon

Bengaluru

On-site

INR 1,800,000 - 2,600,000

Full time

3 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Group Health Insurance

Paid Holidays

Paid Parental Leave

Learning & Career Development

Job summary

Apexon Bangalore is seeking a Python Data Engineer & Automation Developer with 5–7 years of experience to design and maintain Python-based ETL/ELT pipelines, data models, and automated PDF reports. You will build REST APIs, optimize queries, and automate end-to-end data workflows in a 5-days-in-office model.

The role requires strong Python, SQL, and Snowflake skills, plus experience with visualization libraries and programmatic report generation. Join a team focused on robust data solutions.

Qualifications

Bachelor's degree in CS/IS/SE or related field.
5–7 years of professional Python development or data engineering.
3+ years writing complex SQL and using cloud data warehouses (Snowflake preferred).
Strong Python data manipulation libraries and database connectors.
Hands-on experience with Python data visualization libraries and programmatic reporting.

Responsibilities

Design, develop, and maintain Python-based ETL/ELT pipelines for Snowflake.
Build scalable data models, handle historical data, and reconcile data.
Create programmatic charts and embed in automated PDF reports.
Develop document generation engines (PDF/report generation) and automate workflows.
Write modular Python code for backend engineering and automation tasks.
Design and integrate REST APIs to sync data across systems.
Automate end-to-end data workflows and monitor processes for reliability.
Troubleshoot and optimize database queries and Python scripts.

Skills

Python development

Data engineering

SQL queries

Snowflake

ETL/ELT pipelines

Data modeling

API integration

Automation scripting

Workflow orchestration

PDF report generation

Visualization libraries

Education

Bachelor's degree in Computer Science or related field

Tools

Pandas

NumPy

Snowflake Connector for Python

Matplotlib/Seaborn/Plotly

WeasyPrint/ReportLab

Job description

Role : Python Data Engineer & Automation Developer
Experience: 5 to 7 years
Location: Bangalore
Work Model: 5 Days Working from Office

Python Development & Data Engineering

ETL/ELT Pipeline Development: Design, develop, and maintain robust, reusable Python-based ETL/ELT pipelines to extract, transform, and load data from cloud data warehouses, specifically Snowflake.
Data Modeling & Reconciliation: Build and optimize scalable data models, handling complex business logic, historical data snapshotting, and rigorous data reconciliation.
Programmatic Charting & Visualization: Design and generate complex financial charts (stacked bar, line, area, and matrix heatmaps) programmatically using Python visualization libraries to embed directly into automated PDF reports.
Automated Document Generation: Develop programmatic document generation engines (e.g., PDF/report generation using ReportLab, WeasyPrint, or FPDF2) and automate secure distribution workflows.
General Automation & Scripting: Write clean, modular, and well-documented Python code to support diverse backend engineering, automation, and scripting tasks.
API Integration: Design, build, and integrate custom REST APIs and connectors to sync data across disparate enterprise systems.
Workflow Orchestration: Automate, schedule, and monitor end-to-end data workflows and system processes to ensure high availability and reliability.
Performance Optimization: Troubleshoot, debug, and optimize database queries and Python scripts for maximum performance.

Required Qualifications

Bachelors degree in Computer Science, Information Systems, Software Engineering, Data Analytics, or a related field.
5–7 years of professional experience in Python development, data engineering, or backend software automation.
3+ years of hands‑on experience writing complex SQL queries and working with cloud data warehouses (Snowflake preferred).
Strong proficiency in Python data manipulation libraries (Pandas, NumPy) and database connectors (Snowflake Connector for Python).
Strong hands‑on experience with Python data visualization libraries such as Matplotlib, Seaborn, Plotly (static export), or ReportLab Drawing/Charts.
Proven experience with programmatic document generation, HTML/CSS templating (e.g., WeasyPrint), or automated reporting solutions.
Solid understanding of data modeling, ETL/ELT processes, API integrations, and software design patterns.
Strong analytical, debugging, and problem‑solving skills with excellent attention to detail.

Preferred Qualifications

Experience working in Banking, Financial Services, Capital Markets, or other highly regulated environments.
Experience with cloud orchestration tools (AWS Lambda, or Snowflake Tasks).
Familiarity with CI/CD pipelines, version control (Git), and agile development methodologies.
Power Platform, Power BI familiarity is a huge plus.

Interview Process

1st Round – Assessment Test
2nd Round – Technical Interview with Panel
3rd Round - Client Discussion

Our Commitment to Diversity & Inclusion:

Did you know that Apexon has been Certified™ by Great Place To Work®, the global authority on workplace culture, in each of the four regions in which it operates: USA (for the seventh time in 2026), India (for the tenth consecutive time in 2026), the UK (for the fourth time in 2026) and Mexico (for the second time in 2026). Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. You can read about our Job Applicant Privacy policy here Job Applicant Privacy Policy (apexon.com)

Our Commitment to Environment:

Actively contribute to Apexon's commitment to environmental responsibility by following sustainable practices and supporting ESG initiatives.

Our Perks and Benefits:

Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience, and provide care and support for you and your loved ones. As an Apexon Associate, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well‑being benefits and assistance.

We also offer: