Job description
Lead Consultant - Python + SQL
Job Description
Inviting applications for the role of Lead Consultant, Data Engineer / Data Analyst (Python, SQL)
Key Responsibilities:
- Design, build, and maintain robust data pipelines using Python and SQL.
- Develop reusable scripts for data extraction from various structured and semi-structured file formats.
- Write optimized and scalable queries to retrieve, clean, and transform data for analytics and reporting.
- Integrate data from different sources including APIs and multiple databases.
- Work closely with analysts, data scientists, and business stakeholders to deliver clean, reliable datasets for analysis.
- Document data workflows and ensure best practices in coding and version control.
Qualifications we seek in you
Minimum qualifications
- Core Python: Expert-level proficiency in writing efficient, modular, and production-grade Python code for data extraction, transformation, and loading (ETL) processes.
- Pandas: Expert in using Pandas for complex data manipulation, cleaning, merging, and analysis of large datasets.
- SQL & Databases: Highly skilled in writing complex SQL queries, stored procedures, and optimizing database interactions. Hands-on experience connecting Python scripts with various relational databases (e.g., PostgreSQL, MySQL, SQL Server).
- Data Source Integration: Extensive experience working with diverse file-based data sources such as CSV, JSON, and Excel, including parsing, transforming, and integrating them into ETL pipelines.
- API & DB Connectivity: Exposure to consuming REST APIs for data ingestion and integrating multiple database sources in a unified workflow.
Additional Skills:
- Familiarity with version control (Git), basic shell scripting, and working knowledge of data validation and performance tuning.
Role:
Lead Consultant
Industry:
IT/Computers - Hardware & Networking
Function:
Data Engineering
Job Type:
Permanent Job
