Data Engineer

This is our direct client opening for a Data Engineer, San Mateo, CA. This is a 3-6+ Months Contract Position.

The Business Technology team is looking for a talented Data Engineer to join the team. You will be responsible for making sure that we are our own best user of Zuora Analytics. This data engineer will be the SME for anything "Data" in business and technical context. S/he will work with various teams within the company to perform data analysis around Customer 360 (Marketing, Sales, Quote to Cash, Revenue Recognition and other 3rd party managed data sources) and Bookings. This position requires constant interaction with the Products, Operations, Finance and BT teams to analyze data anomalies. The candidate must be able to deal with constant change in the user requirements, multiple parallel assignments and collaborate across groups as necessary.

Responsibilities

Perform business data analysis (licensing, telemetry, sales hierarchies, visibilities, support tickets etc.) to drive decision making

Create data dictionary and metadata catalog to ensure standardization of data vocabulary

Design, Build, launch data pipelines optimized for SaaS Data Lake and own data quality for the pipelines

Monitor and remediate data quality issues with closed feedback loop; create daily anomaly reports

Enhance and maintain data pipelines to be extremely efficient & reliable for large amounts of data from source systems (Salesforce, Zendesk etc.), pre-processing, loading into derived Data Lake for downstream processing and analysis

Work with multiple teams in high visibility roles and own the solution end-to-end

Enable self-service. Develop new systems, tools, interfaces, dashboards to enable teams to consume and understand data & gain insights

Maintain custom transformations/calculations to meet specific business requirements (e.g. utilization model)

Implement and maintain Inbound/outbound integrations with Salesforce, Marketo, Zuora or Revpo etc.

Participate in sprint demonstrations with executive and customer stakeholders

Create design specs and ensure traceability from Functional, technical requirements to solutions

Skills & Qualifications

Experience with business processes and data around Customer 360, CRM and Revenue Recognition

In-depth knowledge of Database design, SQL and NoSQL, SaaS Data Lake, Time series analysis, OLAP, Data Warehouses and Metadata management

Hands on Experience with AWS services, security framework, events and notifications

Expert in SQL, Python/Java/PHP specifically as they relate to data management

Experience in ETL design, implementation and maintenance and using Mulesoft / Boomi / SnapLogic

General experience with BI tools and working with business users on analytics and reporting

Hands on experience in large scale high volume database design and optimization

Excellent problem solving skills with troubleshooting and root cause analysis

Good communication skills, both oral and written with experience working in a distributed, collaborative team

Ability to work without supervision

Hands on experience with Zuora is a plus

Bachelors/Masters in Computer Science or equivalent with 3-5 years of experience in data processing

Please complete the below skills-matrix and send back with your most updated resume

Full Name:

Degree/Major:

Total Experience as a Data Engineer:

Total Experience with Customer 360:

Total Experience with CRM:

Total Experience with SQL:

Total Experience with Data Warehouses:

Total Experience with Metadata Management:

Total Experience with ETL Design:

Expected Hourly Rate:

Is that on C2C or W2?

If C2C, Name of the Corporation:

What is the link to your LinkedIn Profile?

Phone Number:

What is the best time to reach you at?

Current City/State:

Availability to Start a New Project

Work Status (US Citizen, Green Card, etc.):

Are you ready to relocate on your own expenses and work onsite at San Mateo, CA/ Commute?