Senior Data Analyst

Pune MH BP Energy

Entity:

Finance

Job Family Group:

Business Support Group

Job Description:

Role Synopsis

We are seeking an experienced Data Analyst with expertise in SAP HANA SQL logic and procedures to join our team. The ideal candidate will play a critical role in transforming SAP HANA SQL into ADH Databricks Spark SQL, enabling us to leverage the power of big data analytics.

Key Accountabilities

Analyze and comprehend existing SAP HANA SQL logic and procedures to identify conversion opportunities and optimization strategies for ADH Databricks SPARK SQL.

Highly proficient in databricks and building data products (data pipeline, data flow) in databricks.

Azure DevOps knowledge.

Translate SAP HANA SQL queries, views, and stored procedures into efficient ADH Databricks SPARK SQL code, prioritizing data integrity and precision.

Collaborate with data engineers and architects to design and implement efficient data pipelines in the Databricks platform.

Apply expertise in star and snowflake schema structures and data modeling to enhance data storage efficiency and retrieval mechanisms.

Conduct thorough performance tuning on SPARK SQL queries, refining data transformations, and enhancing query execution speeds.

Design, build, and manage data structures and tables within Databricks Delta Lake, optimizing for both storage and query performance.

Engage with cross-functional teams to grasp business requirements, converting them into robust data solutions.

Produce comprehensive technical documentation outlining SPARK SQL code, data transformations, and performance improvements with clarity and precision.

Keep abreast of industry trends and emerging best practices in data processing, performance optimization, and cloud technologies to inform ongoing enhancements.

Bachelor's degree in Computer Science, Information Technology, or a related field; a Master's degree is advantageous.

Possess 8 years of experience in roles such as Data Analyst, demonstrating a successful history of migrating from SAP HANA to ADH Databricks SPARK SQL.

Exhibit expertise in SAP HANA SQL logic and procedures, adept at transforming them into streamlined ADH Databricks SPARK SQL code.

Thorough comprehension of data models, including star and snowflake schema structures, along with proficiency in data normalization and denormalization principles.

Proficient in Apache SPARK, Databricks, and SPARK SQL for data processing, transformation, and optimizing performance.

Experience with Databricks + Spark and preferably HANA as well

Data modeling and data engineering experience

Experience working in scrum

SAP FI/CO experience

Proven track record in performance tuning, query optimization, and diagnosing SPARK SQL execution issues.

Familiarity with cloud platforms such as AWS, Azure, and their respective data services.

 Exceptional problem-solving abilities and keen attention to detail, enabling analysis of intricate data scenarios and delivery of effective solutions.

 Strong communication skills essential for collaborating with technical and non-technical stakeholders, effectively conveying complex technical concepts.

 Capable of working independently or as part of a team, adept at managing multiple tasks and projects concurrently.

Crucial Education and Experience

– Bachelor's degree in Computer Science, Information Technology, or a related field; a Master's degree is advantageous.

– Possess 8 years of experience in roles such as Data Analyst, demonstrating a successful history of migrating from SAP HANA to ADH Databricks SPARK SQL.

– Exhibit expertise in SAP HANA SQL logic and procedures, adept at transforming them into streamlined ADH Databricks SPARK SQL code.

– Thorough comprehension of data models, including star and snowflake schema structures, along with proficiency in data normalization and denormalization principles.

– Proficient in Apache SPARK, Databricks, and SPARK SQL for data processing, transformation, and optimizing performance.

– Proven track record in performance tuning, query optimization, and diagnosing SPARK SQL execution issues.

– Familiarity with cloud platforms such as AWS, Azure, and their respective data services.

– Exceptional problem-solving abilities and keen attention to detail, enabling analysis of intricate data scenarios and delivery of effective solutions.

– Strong communication skills essential for collaborating with technical and non-technical stakeholders, effectively conveying complex technical concepts.

– Capable of working independently or as part of a team, adept at managing multiple tasks and projects concurrently.

Travel Requirement

No travel is expected with this role

Relocation Assistance:

This role is eligible for relocation within country

Remote Type:

This position is not available for remote working

Skills:

Agility core practices, Analytical Thinking, Commercial Acumen, Communication, Creativity and Innovation, Data Analysis, Decision Making, Digital fluency, Integration, Managing strategic partnerships, Research and insights, Risk Management, Stakeholder Engagement, Stakeholder Management, Sustainability awareness and action

Legal Disclaimer:

We are an equal opportunity employer and value diversity at our company.  We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, socioeconomic status, neurodiversity/neurocognitive functioning, veteran status or disability status. Individuals with disabilities may request a reasonable accommodation related to bp’s recruiting process (e.g., accessing the job application, completing required assessments, participating in telephone screenings or interviews, etc.).  If you would like to request an accommodation related to the recruitment process, please contact us to request accommodations.

If you are selected for a position and depending upon your role, your employment may be contingent upon adherence to local policy.  This may include pre-placement drug screening, medical review of physical fitness for the role, and background checks.

To apply for this job please visit itjobpro.com.