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.
- 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.
- 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
RequirementsPreferred Skills
- Azure / AWS / GCP Fundamentals
- Apache Airflow
- Azure Data Factory (ADF)
- Databricks
- Data Pipeline Automation
- B.E. / B.Tech (IT, Computer Science or related field)
- M.Sc. IT or equivalent qualification
Skills Required
- Strong SQL knowledge, including MySQL, PostgreSQL, and SQL Server
- Python programming
- Pandas and NumPy
- ETL concepts
- Data cleaning and validation
- Excel and CSV data processing
- Basic data warehousing concepts
- Git or version control
- Azure, AWS, or GCP fundamentals
- Apache Airflow
- Azure Data Factory
- Databricks
- Data pipeline automation
- B.E. or B.Tech in IT, Computer Science, or a related field
- M.Sc. IT or equivalent qualification
What We Do
ScatterPie Analytics is a data analytics and business intelligence company that modernizes enterprise decision-making. It brings together open-source technologies and enterprise tools to create powerful, cost-effective, and flexible intelligence solutions. The company delivers end-to-end analytics, including data engineering, cloud data platforms, business intelligence, AI, decision intelligence, and industry-focused analytics solutions, transforming raw data into actionable insights for evidence-based decisions across modern organizations.
