Job TITLE: Systems Analyst

Location: San Francisco, CA

Term: Contract

Skill: Business Systems Analyst, Data models, data modeling, advanced SQL

Experience: -

Education: Must Have: 1. 3-5 years as a Business Systems Analyst w/technical focus on Data-centric responsibilities ·2 - 3 years software development experience (Any Programming Languages / Shell Scripting, ETL) ·Functional/technical system integration and CRM Data Analysis (working with disparate data sources) across an internal Hadoop ecosystem, Data Mart, and a 3rd party Email Service Provider (ESP) ·Must have strong Shell scripting skills with experience/ability to read and interpret Shell logs and scripts ·Must have basic to intermediate Python scripting skills from scratch 2.Experience in handling larger datasets ·Thorough knowledge of Data models, Data Modeling (Relational and Dimensional), Data Profiling and working with large data warehouse environment ·Must understand Hadoop environment structure and how to validate data in a Hadoop ecosystem 3.Advanced SQL working on Oracle RDBMS (preferred 10g/11g) ·Modifying data feeds, creating files, working with extracts, debugging PL/SQL code, conducting impact analysis ·Ability to work on large data volumes, writing effective SQL queries to investigate and resolve data issues. 4.Strong understanding of ETL/Data Warehouse environments ·Must have experience working with Data Marts ·Ability to process and analyze complex data sets, and interpret them to make business decisions this is mentioned above but it is a critical requirement) Pluses: 1.Technical background, especially as CRM Data Analyst, PL/SQL developer, ETL Developer, Database Developer 2.Experience working directly on database and/or email marketing systems 3.Experience working with Aqua Data Studio, TOAD, or SQL Developer 4.Able to read programming source code 5.Experience with any CRM tool (i.e. Epiphany, Unica, etc.) Day to Day Responsibilities: 1.Primary role in troubleshooting and priority resolution of daily issues (usually new, undocumented issues) related to breaks/issues in current Data feeds (i.e. Identifying root cause of issues related to Data Mart, Hadoop ecosystem, or ESP) 2.Responsible for the day-to-day operational activities and help in the execution process of enhancements to the email marketing programs by performing the roles of system analyst, system administrator, data auditor, issue investigator and business implementation support 3.Support the email marketing delivery functions on a day-to-day basis to ensure smooth functioning of email programs and campaign deployment activities. 4.Support the marketing analytic team by facilitating data coverage for ad-hoc requests and help in resolving in any data related issues. 5.Responsibilities balanced between ·(50%) Systems Analysis ·(20-25%) Development (i.e. Python, Shell, PL/SQL) ·(25-30%) Data Analysis and standard Business Analysis 6.Working on +/- 6 concurrent projects