Senior Software Engineer-Data Analyst ETL, SQL, Python - CGI

Key Responsibilities

• Design, develop, and optimize ETL processes to ingest, cleanse, and integrate data from multiple sources.
• Write efficient, production‑grade Python scripts and SQL queries for data extraction, transformation, and loading.
• Collaborate with business analysts and stakeholders to translate requirements into scalable data models and reporting solutions.
• Implement data quality checks, monitoring, and performance tuning to ensure reliability and accuracy of data pipelines.
• Document technical designs, data lineage, and operational procedures for ongoing maintenance. Requirements
• 5+ years of professional experience in software engineering or data engineering roles.
• Strong proficiency in Python (pandas, SQLAlchemy) and advanced SQL (CTE, window functions, query optimization).
• Hands‑on experience building ETL workflows using tools such as Apache Airflow, Azure Data Factory, or similar.
• Solid understanding of relational databases, data modeling, and data warehousing concepts.
• Excellent problem‑solving skills and ability to work independently in a fast‑paced environment.