Data Analyst

Data Analyst

Location: 100% Remote

3 month contract to start, high possibility of extensions

Must haves:

-4+ years of experience with data analysis & data profiling in project, business requirements definition or data engineering

-Strong background in data quality

-Intermediate SQL skills

-Advanced Excel – vlookups, pivot tables, etc

-Experience with Transactional data

-Have working experience with Master Data (Product, Customer, Location etc).

-2+ years of strong Data Profiling experience & ability to identify trends and anomalies in the data to inform data model build out.

-Experience working with structured/unstructured datasets, ability to clearly document and communicate requirement to technical team members.

-Experience with Business Intelligence tools, SQLTools.

-Strong understanding of table lineage

-Experience following the flow of data to trace it back to the source

-Ability to coordinate with technical teams

-Great communication, documentation and critical thinking skills

Plusses:

-Experience with Databricks

-Python/pyspark

-3+ years of experience with SAP modules , FICO, MM, SD

-Experience in data cataloging

Day to day:

A Fortune 100 client is seeking to hire a Data Analyst/JR Data Steward within India. As a member of the data stewardship team, you will be the key finance domain expert overseeing PepsiCo's business process and drive a strong discussion for how Supply Chain, Financial, Consumer, Channel, Category business needs to be defined and prioritize by working very closely with business leads, data science team and data engineering team. You'll develop an in-depth understanding of business processes in and translate business requirements to data engineering team in technical way. Accountabilities:

-Discover, analyze, and scope data requirements & representing them in conceptual and logical data models

-Gather and analyze data pertaining to various business processes such as forecasts, capital requirements, inventory, logistic, manufacturing and production capacity to develop supply chain models. geographics, POS, pricing and promotion, store profile, e-commerce data to develop channel models.

-Create high-level process models (system interface diagrams, workflow & swim lane diagrams, data flow diagrams) to represent processes for the area under analysis

-Empower the business by creating value through the increased adoption of data, data science and business intelligence landscape.

-Responsible to improve the quality of data in relation to defined expectations

-Perform analysis of system data to identify patterns, exceptions, and erroneous data