Job Description :
Location: Mountain View, CA
Need local Consultants
C2C


Project

The SBSEG Marketing Data Operations team uses SAS to manage a variety of data processes to support the business. These processes include SAS extracts and macros to streamline data extractions from various data warehouses for the team to easily obtain data for marketing use. There is an initiative to move away from SAS and use alternate industry standard methods to extract and house the data. We looking for a technical expert to help understand these processes and rebuild/rewrite the SAS programs using SQL (AWS EMR Hive



Responsibilities

Partner with members of the team to develop a deep understanding of what & how data is used
Collaborate with others in building innovative data capture and real-time customer data analytic capabilities needed by the business (e.g. requirements identification, design specification, prototype testing)
Work side-by-side with cross-functional team including other members of the SAS community, SBSEG Analytics, and partner DBAs to develop the most optimal data experience.
Rewrite/rebuild processes existing in SAS using SQL (AWS EMR Hive)
Solid communication skills: Demonstrated ability to explain complex technical issues to both technical and non-technical audiences
Educates and provides guidance to business stakeholders on how best to harness available data in support of business needs, makes recommendations, and provides alternatives to meet business needs
Creates complex software programs and applications for management of massive quantities of data (big data) using high level programming languages
Develop and test automated data extractions and data feeds to our e-mail vendors in support of trigger-based e-mail marketing campaigns.
Develop and test ad hoc data extraction queries in support of one-time e-mail marketing campaigns and market research requests.
Automate repeat data requests to create sustainability and efficiencies
Extract and aggregate data for business analysts to enable measurement of key performance indicators.
Ensure all automated data routines run as scheduled with expected results and troubleshoot as necessary when outages occur.
Partner with cross-functional data teams to identify and implement new data capture and aggregation mechanisms to enable more efficient data processing.
Partner with immediate team to improve process, documentation, and data ingestion tools.

Client : INTUIT