Previous Job
Data Architect
Ref No.: 19-01861
Location: Menlo Park, California

Our client, a leader in the Social Networking and Media industry, is seeking a temporary worker to support their Partnerships team, working within Partnerships Analytics. The Partnerships team works with the leading content creators in the world, in entertainment, sports, news, and other verticals. This role entails generating pipelines and new data structures that will enable easier dashboard creation in the future. If this is something you are interested in learning more about, please apply ASAP!

Develop methods to unlock access to data for stakeholders across the Partnerships Organization
Design, build and launch efficient & reliable data pipelines to move and transform data (both large and small amounts)
Optimize and maintain existing pipelines, ensuring that data arrives accurately and on-time
Build and ensure data tables can serve as the source of truth for various high-level priorities
Create scripts to automate operational processes
Work cross-functionally to define problem statements, collect data, and make recommendations
Build data expertise and own data quality for allocated areas of ownership
Define and manage SLA for all data sets in allocated areas of ownership
Work with data infrastructure to triage infra issues and drive to resolution
Support on-call shift as needed to support the team

BS/BTech in Computer Science, Math or related field
4+ years experience in the data warehouse space
4+ years experience in custom ETL/data pipeline design, implementation and maintenance
4+ years of SQL (Oracle, Vertica, Hive, etc.) or relational database experience (Oracle, MySQL) writing queries
Experience with programming languages, Python
Experience with data architecture, data modeling, schema design and software development
Experience with large data sets, Hadoop, and data visualization tools
Experience initiating and driving projects, and communicating data warehouse plans to internal clients/stakeholders

Experience with packages such as R, Tableau, SPSS, SAS, STATA, etc.
Familiar with version control systems (git, mercurial, etc.)