remoteonsite
Senior Software Engineer-Data Analyst ETL, SQL, Python - CGI
Data Analyst
Senior Software Engineer‑Data Analyst responsible for designing, building, and maintaining robust ETL pipelines and analytical solutions using Python and SQL to transform raw data into actionable insights.
About the role
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.
Skills
pythonsqldata analysis