Architect,Azure Data Engineer

Job description

Overview

The person will deliver and lead development for Azure Data Lake-Data Engineering, Business Intelligence, Azure, and Advanced Analytics. He or She will be playing the role of scrum master across multiple projects

•Data and Digital Solutions Delivery for data and advanced analytics for AMESA and APAC for functional Areas – Supply Chain, Sales & Distribution, GTM, Finance, Equipment Service, Food Service
. Work on Azure data engineering models/pipelines for AMESA/APAC Projects and solution delivery. 
•Key skill sets like Azure data engineering, Azure Data bricks, Azure Synapse/SQL.
•New Business Requirements / Demand Management / Estimations / Work Intake / Project delivery & sustain
In-depth technical knowldge of tools like Azure Data factory, data bricks , Azure Synapse , SQL DB, ADLS etc.
•Deliver ETL solution including data extraction, transformation, cleansing, data integration and data management. Implement batch & near real time data ingestion pipelines based on reference architecture.
•Ability to augment with new sources of data including internal/external untapped data. Contribute to the establishment and maintenance of cloud computing platform and big data services.
•Operationalize analytics models for production usage with big data workflows, proper security & access control.
•Nice to have skills Python, Scala, Java & with advance knowledge of SQL
Responsibilities

•Data and Digital Solutions Delivery for data and advanced analytics for AMESA and APAC for functional Areas – Supply Chain, Sales & Distribution, GTM, Finance, Equipment Service, Food Service
•Work on Azure data engineering models/pipelines for AMESA/APAC Projects and solution delivery.
Work on development of Azure Data engineering pipelines and lead projects/ work as a developer.
•Drive solution design and build to ensure scalability, performance and reuse
•Ensure on time and on budget delivery which satisfies project requirements, while adhering to enterprise architecture standards.
•Manage work intake, prioritization and release timing; balancing demand and available resources. Ensure tactical initiatives are aligned with the strategic vision and business needs

Qualifications

Years of Experience:

• Bachelor’s degree in Computer Science, MIS, Business Management, or related field
• 8 - 10 years’ experience in Information Technology or Business Relationship Management
• 3-4 years’ experience in Azure Data engineering(BLOB/DATA bricks/ADF/Synapse/Delta Lake)
• 5-6 years experience in working on Data & Analytics projects.

Mandatory Tech Skills:

The role will leverage & enhance existing technologies in the area of Data and Digital Solutions like Power BI, Azure multiple technologies, Teradata/Snowflake, and other Azure services
The role will be responsible to develop IT products and solutions using these technologies and deploy them for internal business users

 Mandatory Non Tech Skills :

• Must be a strong team player with effective teamwork skills
• Assists in successfully integrating new employees into the department
• Provides training and mentoring to less experienced team members
• Builds others skill sets by coaching them (i.e., coaching, mentoring).
• Leverages cooperative relationships to address complex business data issues.
• Handles day-to-day issues within the work team.
• Ability to adapt to change quickly and handle unforeseen requirements effectively.  
• Assists lower level employees with resolving unforeseen requirements.  Leading and setting team priorities.  
• Fully understand data, systems, and end to end business processes within multiple functional areas. 
• Sees and coaches others on connections between data and process. Understands business needs and the impact of his/her/team activities.
• In-depth understanding of Pepsi Co products, services, business processes and business function directly related to the functional area.
• Understands business direction and assesses business impact when evaluating data solutions.

• Proactively analyze data to increase quality as it relates to accuracy, completeness, consistency, integrity, timeliness, conformity, and validity; Verify accuracy of data in functional area and for integration/project activities.  
• Provide recommendations for correcting issues or problems across both systems and process.  
• Able to conduct root cause analysis.
• Accountability for mass data loads including creation of load format, data preparation, load program design, and testing and result verification in collaboration with the business, or lead the design and development of process flows and business metadata documentation. 
• Understanding importance of metadata and reinforcing benefits and usage to team and business partners
• Able to research, understand, and determine the relevance of information applying to all degrees of complexity in analytical tasks.  Directs research work of more junior colleagues.
• Incorporate the broad picture across business units/functions to foresee all potential impacts of system or project issues taking appropriate action to resolve.
• Able to synthesize separate elements to form a coherent whole using reasoning, logical deduction, and other methods without direction for all complexity levels of analytical/design tasks.
• Able to see connections between data and process across multiple functions and can make suggestions when resolving changes.
• Interacts and has effective partnerships with other team members, business customers and other layers within the business to recommend, design, test, and implement data related system and process improvements.
• Assists in establishing and maintaining a strong partnership with business partners and manage expectations.
• Forms productive networks with external experts to bring solutions to internal customers/partners needs.
• Prepare material and interact with executive level on subject matter expertise.
• Ability to independently prioritize own work and work of team in functional area, applying analytical skills to master data requests.
• Proactively identify and escalate potential issues, offering ideas for solutions.
• Proactively adjusts work assignments and schedule to meet changing team priorities.
• Effectively manage multiple priorities simultaneously.
• Take ownership of critical path tasks and prioritize work of self and others to deliver results within agreed upon deadline.
• Adjust to multiple demands/priorities focusing on the big picture.
• Makes key decisions about data design approach to components of projects. 
• Able to explain to senior leaders how arrived at decision process.