• Share this Job

SQL Data Analyst

Location : Los Angeles, CA
Job Type : Temp/Contract
Hours : Full Time
Required Years of Experience : 2+
Travel : No
Relocation : No
Job Industry : Marketing

Job Description :

Responsibilities:


·         Own the data integrity process from end to end


·         Learn the business context for each data set: what the data means, its relative importance and level of urgency, and its sensitivity to errors


·         Pull data sets from each level of the data stack


o    Raw data files, typically CSV files from shared folders


o    Ingested data and transformed data, typically queried from SQL databases


·         Compare data sets to ensure data integrity


·         Systematically investigate data integrity issues to narrow own and identify the root cause


·         Communicate data issues promptly to the Engineering team and monitor their progress toward resolution


·         Communicate data issues and ongoing status to the rest of the client team


·         Mitigate the impact of each data issue: identify impacted client reports; pause or modify those reports; draft issue notifications to clients


Required skills and experience:


·         Ability to independently deliver high-quality results, demonstrated by academic or professional success when taking on independent ownership of a deliverable


·         Analytical mindset, demonstrated by academic or professional history in a technical field (science, engineering, business analysis, IT/IS)


·         Moderate Excel skills (understanding of SUMIFS, VLOOKUP, Pivot Tables/Charts)


·         Basic SQL skills (ability to read and understand pre-prepared SELECT statements with JOIN, WHERE, GROUP BY)


Desired skills and experience:


·         Advanced Excel skills (understanding of array formulas, extended experience with SUMIFS, VLOOKUP, etc.)


·         Moderate SQL skills (ability to write and modify SELECT statements with JOIN, WHERE, GROUP BY)


·         Analytical experience, demonstrated by professional history in a technical field (science, engineering, business analysis, IT/IS)


·         Ability to independently deliver high-quality results in a professional setting, demonstrated by professional success when taking on independent ownership of a deliverable


 


#LI-JS1


Required Qualifications :

Required skills and experience:


·         Ability to independently deliver high-quality results, demonstrated by academic or professional success when taking on independent ownership of a deliverable


·         Analytical mindset, demonstrated by academic or professional history in a technical field (science, engineering, business analysis, IT/IS)


·         Moderate Excel skills (understanding of SUMIFS, VLOOKUP, Pivot Tables/Charts)


·         Basic SQL skills (ability to read and understand pre-prepared SELECT statements with JOIN, WHERE, GROUP BY)


Desired skills and experience:


·         Advanced Excel skills (understanding of array formulas, extended experience with SUMIFS, VLOOKUP, etc.)


·         Moderate SQL skills (ability to write and modify SELECT statements with JOIN, WHERE, GROUP BY)


·         Analytical experience, demonstrated by professional history in a technical field (science, engineering, business analysis, IT/IS)


·         Ability to independently deliver high-quality results in a professional setting, demonstrated by professional success when taking on independent ownership of a deliverable


Powered by AkkenCloud