Data Analyst

Join our Finance Team as a Data Analyst and advance your career within BP, a global energy leader dedicated to a net-zero future. This role, based in Pune, India, offers a hybrid working arrangement.

Key Accountabilities

• Perform investigative data analysis and exploratory data mining to uncover insights and trends.
• Craft and build scalable data pipelines using Azure Databricks, Spark, and Delta Lake.
• Collaborate with data engineers and architects to implement efficient data pipelines in the Databricks platform.
• Build PySpark-based analytical data assets in finance to solve sophisticated business problems.
• Apply expertise in star and snowflake schema structures and data models to optimize data storage and retrieval.
• Perform performance tuning on Spark SQL queries and PySpark DataFrames, optimize data transformations, and improve query execution times for large data sources.
• Design, develop, and maintain data structures and tables in Databricks Delta Lake for optimal storage and querying.
• Work closely with multi-functional teams to understand business requirements and translate them into effective data solutions.
• Create clear and concise user documentation for developed code, data transformations, and performance enhancements.
• Analyze and comprehend existing SAP HANA SQL logic and procedures to identify conversion opportunities and optimization strategies for ADH Databricks Spark SQL.
• Stay up-to-date with industry trends and standard methodologies in data processing, performance optimization, and cloud technologies.

Education and Qualifications

• Bachelor's degree or equivalent experience in Computer Science, Information Technology, or a related field. Master's degree is a plus.
• 7+ years of experience as a Data Analyst or similar role, with a consistent track record of building data products/applications using PySpark.
• Expertise in using the Azure Databricks platform to build data pipelines.
• Good understanding of data models, star and snowflake schema structures, and data normalization/denormalization principles.
• Proficiency in Apache Spark, Databricks, and Spark SQL for data processing, transformation, and performance optimization.
• Experience with performance tuning, query optimization, and fixing Spark SQL execution bottlenecks.
• Exposure to advanced analytics, machine learning models, or working alongside Data Science teams.
• Familiarity with cloud platforms such as AWS, Azure, and their data services.
• Familiarity with data visualization tools like Power BI, Tableau, or similar.
• Excellent problem-solving skills and attention to detail, with the ability to analyze complex data scenarios and provide effective solutions.
• Good communication skills to collaborate with technical and non-technical collaborators and convey complex technical concepts.
• Ability to work independently and within a team, managing multiple tasks and projects simultaneously.

Additional Information

• Travel Requirement: Negligible travel is expected.
• Relocation Assistance: This role is eligible for relocation within the country.
• Remote Type: This position is a hybrid of office/remote working.