Search for More Jobs
Forward this job to a friend
Apply by email without Registering
Apply by creating/using account
Please enter your registered email address, and we'll email you a link to reset your password right away.
Company: Artech Information Systems LLC
Position: Data Analyst
Duration: 6 Months with extension
Location: San Francisco, CA
Job Reference Code: 18-30823
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
Architect key SQL tables to enable business reporting. These include:
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
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.
Manager - Staffing
Artech Information Systems LLC
360 Mt. Kemble Avenue, Suite 2000 | Morristown, NJ 07960
Office: 973.967.3519 | Fax: 973.998.2599
Email: email@example.com | Website: www.artechinfo.com
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
Apply by creating/using account