Senior Data Analyst

Crucial Education and Experience

• Bachelors degree in Computer Science Information Technology or a related field; a Masters 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 problemsolving 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 nontechnical stakeholders effectively conveying complex technical concepts.
• Capable of working independently or as part of a team adept at managing multiple tasks and projects concurrently.

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 crossfunctional 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.
• Bachelors degree in Computer Science Information Technology or a related field; a Masters 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 problemsolving 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 nontechnical stakeholders effectively conveying complex technical concepts.
• Capable of working independently or as part of a team adept at managing multiple tasks and projects concurrently.

Interested can contactOR email resume to

Data Analysis,python,CRM,Sql,Data Modeling,SAP HANA SQL,SPARK SQL,data bricks,DAX queries