Previous Job
Data Warehouse Architect
Ref No.: 18-06828
Location: Foster City, California
Job Title: Data Warehouse Architect
Job Location: Foster City, CA
Job Duration: 1 year with possibility of extension​

Job Description:

Looking for a high-energy data warehousing/programming best-practitioner to join a high-performing Business Intelligence and Analytics team in the Sales Operations group at Cybersource. Will be heavily involved in all aspects of DW/BI from gathering business requirements to helping architect the data solutions that support it. We're looking for leadership personality type who works with a sense of urgency, and thrives in a fast-paced and collaborative environment. The ideal candidate is focused on project delivery, architecting sustainable practices, and is just as comfortable talking with Business users as they are with technical folks.

o Minimum of Batchelor's degree in computer programming or equivalent training required; Master's preferred
o 7+ years experience required

Responsibility level
o Exercises independent judgment with direction from supervisor; individual contributor

o Verbal and written communication skills, problem solving skills, customer service and interpersonal skills (Required)
o Ability to work independently and manage one's time (Required)
o Hands-on experience with Shell Scripting; Java; Python; SQL/Hive; JIRA; Bitbucket to store code; designing, executing and supporting ETL data validation process; and Data Warehousing(Required)
o Hands-on experience with interacting with business stakeholders and creating reports in a BI application such as Tableau
o Statistical Modeling using econometric algorthyms not required, but a huge "plus "

Major Job Duties and Responsibilities:
o Test programs or databases, correct errors and make necessary modifications
o Write and code logical and physical database descriptions and specify identifiers of database to management system
o Work as part of a project team to coordinate database development and determine project scope and limitations
o Review project requests describing database user needs to estimate time and cost required to accomplish project
o Candidate needs to have full BI cycle experience: from requirements (e.g. including data capture and processing, etc) to process design, BI deployment, monitor performance to optimize, and back again.
o Bring a strong sense of execution and ownership to the team.
o Build highly scalable, performant and reliable systems and infrastructure. Experience with data warehouse management principles, including partnering with other workgroups globally that may supply and/or use data.
o Organizational and coordination skills along with multitasking capabilities to get things done in a fast-paced environment.
o In depth knowledge of data warehouse design. Big data experience (Hive/Impala or other HDFS based) required. Will be dealing with datasets in the billions of rows and Terabytes of data and needs to have experience taking large amounts of data and narrowing them down to more focused data sets. - Tableau experience is desired. Needs to know, or willing to learn, limitations of the tool and where DBs need to be leveraged vs Tableau.
o Needs to be able to take a problem and solve it with minimal direction. Looking for someone that has the passion to look beyond the issue, determine possible implications and applications of the solution, and the grit to invite other workgroups as appropriate to execute the solution.