Big Data Analyst
Posted Updated
Summary
Hybrid (3 days in office) big data role in Pune for an analyst with 5+ years of experience, centered on SQL Server data pipeline design, schema/data modeling, indexing and partitioning, and SSRS reporting, plus near-real-time event-driven data processing. Power BI and Copilot exposure are nice to have.
Location: Pune
Hybrid (3days office)
Shift: General
YOE: 5+ Years
Interview: 2 Rounds Virtual
Skills Required:
- SQL Server Development (index creating, storage)
- SSRS Reporting
- Extended SQL server integration
- Data modelling
- Manage, store in SQL
Responsibilities:
- Implement robust data flow designs ensuring high performance, scalability, and reliability of data pipelines.
- Work on event-driven architectures and ensure accurate consumption and processing of data events.
- Design and implement data models and schemas in SQL Server based on the nature and structure of incoming data.
- Proficient in implementing robust index and partition design in SQL Server.
- Troubleshooting database bottleneck issues for efficient storage & data retrieval.
- Understanding of Medallion architecture and implement it in SQL Server.
- Good understanding of JSON data storage in SQL Server and flatten it for reporting usage.
- Solid understanding of data integration patterns, transformation logic, and data quality checks.
- Good understanding of event streaming concepts, data ingestion, and near-real-time data processing.
- Reporting experience on Power BI is good to have.
- Experience handling vulnerabilities and implementing/applying patches through collaboration
- Copilot exposure is good to have