Azure Synapse Analytics & Databricks Subject Matter Expert

Key Skills

Python Programming, SQL, Azure, PowerBI, Aartificial intelligence, Machine learning techniques, Data science techniques, Data Visualization, ETL/ELT technologies, Data Modeling, 3D data processing, R Programming, Databricks, PowerShell Programming, Optimization, User support and Troubleshooting, Effective communication skills, Data Warehousing

Job Description

The Reporting & Analytics Organization (R&A) is a global organization responsible for all the data management, reporting and analytics for the Commercial Organization, Category, Finance, Supply-Chain and Customer Support – globally and including Regions, Market and Country level reporting.

The Business Management Solutions (BMS) team is part of the global R&A team and holds responsible for delivering data and analytics solutions to Enterprise Business Planning, Category and Sales Operations teams.

Objective/Purpose:

We are seeking a highly skilled and experienced Techno Functional SME specializing in Business Intelligence (BI) solutions on the Azure platform. In this role, you will be responsible for designing, developing, and implementing robust BI solutions using various Azure services and tools. You will collaborate with cross-functional teams, including business stakeholders, data engineers, data scientists, and developers, to ensure the successful delivery of BI solutions that meet business objectives.

Roles and Responsibilities:

• Collaborate with business stakeholders to understand their BI requirements and translate them into technical specifications and solution designs.

• Design and develop end-to-end BI solutions on the Azure platform, leveraging services such as Azure Data Factory, Azure SQL Data Warehouse, Azure Analysis Services, Azure Databricks, and Power BI.

• Lead and participate in the development and implementation of data integration, data modeling, ETL/ELT processes, data transformation, and data visualization components.

• Conduct performance tuning, optimization, and troubleshooting of BI solutions to ensure efficient and scalable data processing and reporting capabilities.

• Collaborate with data engineers to ensure the availability, integrity, and security of data across Azure services and environments.

• Stay up to date with the latest Azure services, tools, and industry trends, and evaluate their potential application and benefits to enhance existing BI solutions.

• Collaborate with project managers and other stakeholders to define project scope, timelines, and deliverables, and actively contribute to project planning and estimation.

• Participate in knowledge sharing activities, conduct workshops, and contribute to the development of BI solution frameworks, standards, and documentation.

• Act as a liaison between business users, IT teams, and management. Facilitate effective communication, gather feedback, and ensure alignment between business objectives and technical solutions.

Qualifications and Experience :

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.

• Extensive experience (8+ years) in designing and implementing BI solutions.

• In-depth knowledge and hands-on experience with Azure Data Factory, Azure SQL Data Warehouse, Azure Analysis Services, Azure Databricks, and Power BI.

• Strong understanding of data integration, data modeling, ETL/ELT processes, data warehousing concepts, and data visualization techniques.

• Proficient in SQL and experience with SQL-based querying, scripting, and optimization.

• Experience with programming languages such as Python, R, or PowerShell for data manipulation and automation.

• Demonstrated ability to analyze complex business requirements and translate them into scalable and efficient BI solutions.

• Strong problem-solving and troubleshooting skills with the ability to identify and resolve issues in a timely manner.

• Excellent communication skills with the ability to effectively collaborate with cross-functional teams and communicate technical concepts to non-technical stakeholders.

• Added advantage if working experience or knowledge of ThoughtSpot, Machine Learning, AI.

• Experience of MPP databases like Teradata, Vertica or Netezza will be an added advantage.

Sustainable impact is HP’s commitment to create positive, lasting change for the planet, its people, and our communities. This serves as a guiding principle for delivering on our corporate vision – to create technology that makes life better for everyone, everywhere.

HP is a Human Capital Partner – we commit to human capital development and adopting progressive workplace practices in India.

LI-POST

About HP

You’re out to reimagine and reinvent what’s possible—in your career as well as the world around you. So are we. We love taking on tough challenges, disrupting the status quo, and creating what’s next. We’re in search of talented people who are inspired by big challenges, driven to learn and grow, and dedicated to making a meaningful difference.

HP is a technology company that operates in more than 170 countries around the world united in creating technology that makes life better for everyone, everywhere.