Roles and Responsibilities

- Design, develop, and maintain robust ETL data pipelines and ingestion processes to ensure data availability and performance.
- Write complex SQL queries, analytical functions, views, and aggregate routines for detailed business analysis and data modeling.
- Create interactive dashboards and visual reports in Tableau to support key executive decision-making processes.
- Define and manage Critical Data Elements (CDEs), data mapping documentation, and data quality governance across enterprise repositories.
- Develop PySpark scripts to execute scalable data processing, data aggregation, and data transformations across relational and NoSQL databases.
- Perform end-to-end testing including Manual, Functional, Regression, and UAT to guarantee data integrity and pipeline stability.
- Partner with engineering and product management teams using Git, JIRA, Confluence, and Airflow within an Agile SDLC workflow.

Preferred Candidate Profile

Assumed Requirements:



Familiarity with cloud platforms (AWS/Azure/GCP) and enterprise data warehouses (Snowflake/PostgreSQL/Oracle) is assumed based on regional enterprise standards.

Experience:

- 5 to 8 years of hands-on experience in Data Analysis, Data Engineering, Process Improvement, and Project Management.
- Ability to work from Pune on the 11:00 AM to 9:00 PM IST mid-shift schedule.

Technical Expertise:

- Core Technical: Advanced SQL, PySpark, Data Modeling, ETL Ingestion, Data Pipeline Development, Data Mapping.
- Data Governance: Critical Data Elements (CDE) identification, Data Quality Management, Data Asset cataloging.
- Databases & Tools: Relational Databases (RDBMS), NoSQL Databases, Tableau, Apache Airflow, Git, JIRA, Confluence.
- Preferred Add-ons: AI/ML fundamentals, Automated & Manual Testing (UAT, Functional, Regression).

📌 Data Analyst (Pune)
🏢 SG Analytics
📍 Pune