Data Analyst Intern

Sbicap Securities; Mumbai; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Sbicap Securities is seeking a data professional to develop and optimize data processing pipelines, enabling efficient ETL and analytics pipelines across the organization. You will apply advanced SQL for data extraction, implement quality checks, and explore machine learning for predictive insights, while collaborating with IT and data teams to improve storage, retrieval, and overall performance.

Proficiency in Python or R and familiarity with cloud data services, BI tools, and containerization

Qualifications

• Develop and implement data processing pipelines for ETL tasks.
• Utilize advanced SQL queries to extract and manipulate data from relational databases.
• Design and implement data quality checks and validation processes to ensure accuracy.
• Apply machine learning algorithms for predictive modeling and pattern recognition.
• Collaborate with IT teams to optimize data storage, retrieval, and system performance.
• Contribute to data repositories and data warehousing solutions.
• Work closely with data architects to enhance data infrastructure.
• Proficiency in Python or R for data analysis and scripting tasks.

Responsibilities

• Develop and implement data processing pipelines for ETL tasks.
• Utilize advanced SQL queries to extract and manipulate data from relational databases.
• Design and implement data quality checks and validation processes to ensure accuracy.
• Apply machine learning algorithms for predictive modeling and pattern recognition.
• Collaborate with IT teams to optimize data storage, retrieval, and overall system performance.
• Contribute to the development and maintenance of data repositories and data warehousing solutions.
• Work closely with data architects to enhance data infrastructure.
• Proficiency in programming languages such as Python or R for data analysis and scripting tasks.

Skills

ETL pipelines

Advanced SQL

Data quality checks

Machine learning

Data storage optimization

Data warehousing

Data architecture collaboration

Python or R

Tools

Git

Tableau

Power BI

Docker

Kubernetes

AWS

Azure

Job description

Roles & Responsibilities:

• Develop and implement data processing pipelines for efficient data extraction, transformation and loading (ETL) tasks
• Utilize advanced SQL queries to extract and manipulate data from relational databases
• Design and implement data quality checks and validation processes to ensure accuracy.
• Apply machine learning algorithms for predictive modeling and pattern recognition
• Collaborate with IT teams to optimize data storage, retrieval, and overall system performance
• Contribute to the development and maintenance of data repositories and data warehousing solutions
• Work closely with data architects to enhance data infrastructure
• Proficiency in programming languages such as Python or R for data analysis and scripting tasks

Key Competencies:

• Strong understanding of data structures, algorithms, and database management systems
• Knowledge of statistical analysis, data visualization tools, hypothesis testing and regression analysis
• Experience with version control systems (e.g., Git) for collaborative coding
• Familiarity with financial concepts and instruments, such as market data and trading
• Knowledge of cloud platforms (e.g., AWS, Azure) and their data services
• Familiarity with data visualization tools (e.g., Tableau, Power BI)
• Conceptual clarity of containerization tools (e.g., Docker, Kubernetes)