Data Engineer Sr. Consultant

Job description

Python Data Engineer & Automation Developer (5–7 years of experience)

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

Bachelor’s 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.