About the Role
ScatterPie Analytics is seeking a Data Engineer to join our growing Data Platforms & Engineering team. The ideal candidate will be responsible for designing, developing, and maintaining data pipelines, ensuring data quality, and supporting business intelligence initiatives. This role requires strong SQL and Python skills, along with a passion for transforming raw data into meaningful business insights.
Key Responsibilities
- Develop and maintain SQL queries, stored procedures, views, and database objects.
- Design, build, and support ETL processes for data extraction, transformation, and loading.
- Perform data cleaning, validation, and quality assurance activities.
- Analyze raw data and transform it into structured datasets for reporting and analytics.
- Optimize database performance through query tuning and best practices.
- Automate repetitive data processing tasks using Python.
- Process and manage data from multiple sources including databases, CSV, and Excel files.
- Collaborate with business stakeholders and reporting teams to understand data requirements.
- Troubleshoot data-related issues and provide production support.
- Maintain documentation of data workflows and processes.
Required Skills
- Strong SQL knowledge (MySQL, PostgreSQL, SQL Server)
- Python programming
- Pandas and NumPy
- ETL Concepts
- Data Cleaning & Validation
- Excel and CSV Data Processing
- Basic Data Warehousing Concepts
- Git / Version Control
Requirements
Preferred Skills
- Azure / AWS / GCP Fundamentals
- Apache Airflow
- Azure Data Factory (ADF)
- Databricks
- Data Pipeline Automation
Educational Qualification
- B.E. / B.Tech (IT, Computer Science or related field)
- M.Sc. IT or equivalent qualification
