Data Analyst
- Hucon Solutions India
- 2 - 2 Years
- Hyderabad
- 5 years ago
- Email to a friend
- Report this job
Job Description
1. Learn and be extremely familiar with Replicons sales/marketing operational workflows2. Learn and be extremely familiar with Salesforce data dictionary/model
3. Deep-dive into Salesforce data records (lead, account, contact, opportunity) and identify
errors, inconsistencies, and perform audit of general hygiene condition of data-field
values, and cleanup bad data
4. Data audit and investigation
a. Scan through existing lead + prospect + opportunity data and flag
missing/inconsistent field values (e.g. FT_UTM_campaign is null, but
FT_UTM_Source == PPC) [Key requirement: understanding and knowledge of
what fields should be populated under what circumstances; begin with correcting
old data, after a point do this as a daily check]
b. Verify marketing data accuracy by referencing Heap/Hubspot (e.g.
FT_UTM_Medium is set as organic, but deep dive proves it was PPC)
c. Opportunity data: Same exercise, plus ensuring no new business opportunity
goes without marketing attribution, campaign assignment; if so, find original
source
d. Find errors in existing data values that do not conform to appropriate match (data
dictionary - WIP; this will provide guidance on what needs correction and to what
data value) (E.g.: referrels to Referral, ppc to PPC)
e. Flag and document data gaps and discrepancies
5. Data clean up
a. Track what needs to be fixed for each exception found above
b. Format the data set for correction in Salesforce (TBD: manual/upload/hybrid)
c. Populate correct SFDC campaign attribution for all EDR/Nurture contacts/opptys
d. Orphan tasks/activities: find exceptions, and flag them so that they may be
associated with correct objects [scenario: xDR created activities are not tied to
any object, reason being a) xDR didnt do it, b) xDR made a call to a phone
number that doesnt exist in SFDC as a contact]
e. Document corrections to be made, by referencing data dictionary
6. Maintain daily checklist of actions performed, and daily documentation of count of
records worked on
Required Skillset
1. Attentive
2. Methodical
3. Detail-oriented
4. Analytical
5. Process/workflow focused
6. Ability to cope with repetitive work / monotony
Competencies
Employement Category:
Employement Type: Part timeIndustry: ITFunctional Area: ITRole Category: Datawarehousing ConsultantsRole/Responsibilies: Data AnalystContact Details:
Company: Hucon Solutions IndiaLocation(s): Hyderabad+ View Contact
Keyskills: Data Analys Reporting Analys
Fraud Alert to job seekers!
₹ Not Specified
Hucon Solutions India
Hucon Solutions India Pvt.Ltd.Hucon Solutions is an Integrated HR Service Provider for all Corporates all over India. We are backed by a good ERP and enough experience in HR and related activities. It has helped generate career opportunities for more than a million individuals in India. Hucon Solu...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in