Database Analyst & Tableau Developer- Cybersource Sales Operations : VISA
Apply NowCompany: Cybertec, Inc.
Location: San Mateo, CA 94404
Description:
Description:
Database Analyst & Tableau Developer - Cybersource Sales Operations
Brief Description
Looking for a high-energy data warehousing best-practitioner to join a high-performing Business Intelligence and Analytics team in the Sales Operations group on-site at Cybersource. Will be heavily involved in all aspects of DW/BI from gathering business requirements to helping architect the data solutions and Tableau dashboards 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, and is just as comfortable talking with Business users as they are with technical folks.
Qualifications and Requirements
- Communication and interpersonal skills, including relationship building and collaboration within a diverse, cross-functional team.
- 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.
- Bring a strong sense of execution and ownership to the team. You love helping people.
- Support highly scalable, performant and reliable systems and infrastructure. Experience managing data sets in a data warehouse including partnering with other workgroups globally that may supply and/or use data.
- Sales and Marketing a plus, but the ability to work with any nontechnical business team is a must.
- Organizational and coordination skills along with multitasking capabilities to get things done in a fast-paced environment.
- In depth knowledge of data warehouse design. Big data experience (Hive/Impala or other HDFS based) required. Experience taking large amounts of data and narrowing them down to more focused data sets.
- Tableau Reporting and Dashboard development experience is required. Needs to know, or willing to learn, limitations of the tool and where DBs need to be leveraged vs Tableau.
- 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.
- Salesforce.com experience preferred with ETL and data warehouse integration a huge plus. Experience with integrating SFDC data with additional data sources for use in Business Intelligence tool.
- Provide performance tuning and troubleshooting for existing ETL processes; Monitor production loads, conduct root cause analysis for all load failures, and quickly execute solutions to minimize down-time.
- Technical Skills: Hands-on experience with Shell Scripting; Java; Python; SQL/Hive; JIRA; Tableau developer (Desktop Certification is a plus but not required); Bitbucket to store code; designing, executing and supporting ETL data validation process; and Data Warehousing
- MIS, MBA in CIS/IT or equivalent is desired but not required. Must have skills
5-7+ database administration experience. 4 scripting languages: Java, Python, SQL/Hive, JIRA. Tableau is a must have. Must be flexible on hours as they will be apart of a global team. Some calls are early or later. Nice to have skills
? Bachelor's or Master's degree from a US university ? Tableau desktop certification is a nice have. Roles and responsibilities
Have had FTE/contractor for long time on data warehouse work. FTE has moved on. Need 2 total people to keep team above water. Technical interview to gage of relevance and skills. Communication skills - articulate well in an email or call. Articulate what they are thinking about to a broader audience. Model candidate. Strong communication. Data integration experience. Taking multiple data sources with multiple tables and integrate into one environment. Preference on industry background or previous companies worked for?
N/ Duration of assignment and possible extensions
1 year with possible extension, unsure on conversion. Interview timeline and process
1 phone interview and 1 on-site interview. Manager does not want to see non-local candidates. Qualifying questions required for candidate submission
1. What can you do with Oozie? 2. What can you do with Sqoop? 3. How do you troubleshoot an Oozie job failure? 4. What are limitation or concerns one should consider when attempting to join many tables in a single query?
Database Analyst & Tableau Developer - Cybersource Sales Operations
Brief Description
Looking for a high-energy data warehousing best-practitioner to join a high-performing Business Intelligence and Analytics team in the Sales Operations group on-site at Cybersource. Will be heavily involved in all aspects of DW/BI from gathering business requirements to helping architect the data solutions and Tableau dashboards 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, and is just as comfortable talking with Business users as they are with technical folks.
Qualifications and Requirements
- Communication and interpersonal skills, including relationship building and collaboration within a diverse, cross-functional team.
- 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.
- Bring a strong sense of execution and ownership to the team. You love helping people.
- Support highly scalable, performant and reliable systems and infrastructure. Experience managing data sets in a data warehouse including partnering with other workgroups globally that may supply and/or use data.
- Sales and Marketing a plus, but the ability to work with any nontechnical business team is a must.
- Organizational and coordination skills along with multitasking capabilities to get things done in a fast-paced environment.
- In depth knowledge of data warehouse design. Big data experience (Hive/Impala or other HDFS based) required. Experience taking large amounts of data and narrowing them down to more focused data sets.
- Tableau Reporting and Dashboard development experience is required. Needs to know, or willing to learn, limitations of the tool and where DBs need to be leveraged vs Tableau.
- 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.
- Salesforce.com experience preferred with ETL and data warehouse integration a huge plus. Experience with integrating SFDC data with additional data sources for use in Business Intelligence tool.
- Provide performance tuning and troubleshooting for existing ETL processes; Monitor production loads, conduct root cause analysis for all load failures, and quickly execute solutions to minimize down-time.
- Technical Skills: Hands-on experience with Shell Scripting; Java; Python; SQL/Hive; JIRA; Tableau developer (Desktop Certification is a plus but not required); Bitbucket to store code; designing, executing and supporting ETL data validation process; and Data Warehousing
- MIS, MBA in CIS/IT or equivalent is desired but not required. Must have skills
5-7+ database administration experience. 4 scripting languages: Java, Python, SQL/Hive, JIRA. Tableau is a must have. Must be flexible on hours as they will be apart of a global team. Some calls are early or later. Nice to have skills
? Bachelor's or Master's degree from a US university ? Tableau desktop certification is a nice have. Roles and responsibilities
Have had FTE/contractor for long time on data warehouse work. FTE has moved on. Need 2 total people to keep team above water. Technical interview to gage of relevance and skills. Communication skills - articulate well in an email or call. Articulate what they are thinking about to a broader audience. Model candidate. Strong communication. Data integration experience. Taking multiple data sources with multiple tables and integrate into one environment. Preference on industry background or previous companies worked for?
N/ Duration of assignment and possible extensions
1 year with possible extension, unsure on conversion. Interview timeline and process
1 phone interview and 1 on-site interview. Manager does not want to see non-local candidates. Qualifying questions required for candidate submission
1. What can you do with Oozie? 2. What can you do with Sqoop? 3. How do you troubleshoot an Oozie job failure? 4. What are limitation or concerns one should consider when attempting to join many tables in a single query?