Previous Job
Previous
Data Analyst
Ref No.: 18-30823
Location: San Francisco, California
Position Type:Contract
Experience Level: 2 Years
Start Date / End Date: 08/13/2018 to 02/12/2019
Job Summary:
Company: Artech Information Systems LLC
Position: Data Analyst
Duration: 6 Months with extension
Location: San Francisco, CA
Job Reference Code: 18-30823

Project Overview:
The candidate will have excellent SQL abilities and serve as the go-to analytical resource for numerous teams including AMR Retail, AMR Channel Marketing, EMEA Retail and EMEA Channel Marketing. She will serve as a back-fill for vacancy left by my moving on to support other teams. Primary responsibility will include building analytical infrastructure - SQL tables, SQL Stored Procedures, executive dashboards and analytical tools to enable business (retail) decision-making.

Top 3 Daily Responsibilities:
Rebuild key executive dashboards that are currently broken
Build and QA tables. Eg new SQL tables built by team as part of project Core-Data and tables like devices per household that are helpful for reusable analyses
Analyze newly received data as part of upgraded NPD and GfK contracts

Overall Responsibilities:
Architect key SQL tables to enable business reporting. These include:
Inventory
Activations
Devices/Household
Energy Activations, etc...
QA existing tables and new tables created above to ensure reliability as new products are released
Build relevant dashboards that support Sales business decision-making by leveraging the QA-ed tables built above

Required Skills:
BS degree in Computer Science, Engineering, Mathematics, Statistics, Business Analytics or related field, or equivalent practical experience.
2 years of experience building ETLs and managing databases. Excellent SQL skills, including query performance optimization
Development experience in a scripting language such as Python or R.

Nice to Have Skills/Not Required:
MS degree in Computer Science, Engineering, Mathematics, Statistics, Business Analytics or related field.
2 years of experience working with Big Data frameworks (BigQuery, Hive), and working directly with business or product analysts.
Experience working with data visualization tools and experience working with machine learning models deployed in business settings.
Knowledge of distributed systems concepts, problems and solutions.
Detail oriented, and the ability to create concise documentation for a wide range of technical and non-technical stakeholders.


Madan Poovaiah
Manager - Staffing
Artech Information Systems LLC
360 Mt. Kemble Avenue, Suite 2000 | Morristown, NJ 07960
Office: 973.967.3519 | Fax: 973.998.2599
Email: madan.pooviah@artechinfo.com | Website: www.artechinfo.com
LinkedIn: https://www.linkedin.com/in/madan-poovaiah-715ab43/

Connect with us on - LinkedIn | Facebook | Twitter
 
About Artech Information Systems LLC
Artech is an employer-of-choice for the last 25 years to over 7,500 consultants across the globe. We recruit top-notch talent for over 70 Fortune and Government clients coast-to-coast across the U.S., India, and China. We are #1 Largest Women-Owned IT Staffing Firm in the US and this may be your opportunity to join us! For more check: www.artechinfo.com
Connect with Artech through Social Media
Learn more about our company including the latest events at Artech, new job opportunities, jobseeker tips, and more. Follow us on Facebook, Twitter, LinkedIn, Google+, and YouTube