MountainViewRecruiter Since 2001
the smart solution for Mountain View jobs

SR ETl with SAS and Strong SQL

Company: Infobahn Softworld Inc.
Location: Mountain View
Posted on: March 27, 2020

Job Description:

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 rebuildrewrite 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. Rewriterebuild 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. 5 years relevant experience Advanced SQL skills to get the data you need from a warehouse (Vertica, Hive, SparkSQL, etc) Advanced SAS skills Experience with AWS EMR Strong ETL experience Experience using Github and Tidal Ability to Cleantransform data from raw data inputs Ability to deep dive into the data to meet stakeholders requirements Outstanding communication skills with the ability to influence decision makers and build consensus with teams Development and execution of data movement tools using scripts in languages such as SQL, HQL, SAS Familiar with Software engineering and programming methodologies (e.g., Agile) Familiar with Vertica environment Proficient in Microsoft Excel Strong communications skills with both technical and non-technical audiences Strong time and project management skills Ability to prioritize own workload Ability to work in a fast paced environment with changing priorities Experience with Alteryx a plus Experience with marketing automation email systems such Eloqua, Pardot, etc., a plus

Keywords: Infobahn Softworld Inc., Mountain View , SR ETl with SAS and Strong SQL, IT / Software / Systems , Mountain View, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Request a Mobile Signing Notary!
Description: Request a Mobile Signing Notary Certified Mobile Notary Service is our priority is in ensuring your success. There simply is no better choice for a loan signing company Certified Mobile Notary Services (more...)
Company: Certified Mobile Notary Service
Location: Rancho Cordova
Posted on: 04/9/2020

Senior Software Engineer (LabView)
Description: Calling the adventurers ready to join a company that's pushing the limits of nanotechnology to keep the digital revolution rolling. At KLA, we're making technology advancements that are bigger and tinier (more...)
Company: KLA
Location: Milpitas
Posted on: 04/9/2020

Lead Software Engineer - SDWAN
Description: Who you'll Work With br br We're looking for a bright and motivated development engineer to join the Enterprise Routing development team, you will be part of a fast growing and industry leading product-line (more...)
Company: Cisco Systems
Location: Milpitas
Posted on: 04/9/2020


Dell Boomi Developer / Architect
Description: Sr. Dell Boomi Architect br br Mountain View, CA br br Contract br br Conduct design architect reviews, gap analysis and assessment when required. br br Responsible for creating and (more...)
Company: W3Global
Location: Mountain View
Posted on: 04/9/2020

Interaction Designer - Mobile
Description: br Location: br br Seattle, WA br br Job Terms: br br Temporary br br Salary: br br 58 hourly br br Start date: br br 03/01/2020 br br Posted By: br br Heather Farrin (more...)
Company: Aquent
Location: Mountain View
Posted on: 04/9/2020

Senior Technical Writer, Developer Documentation
Description: C3.ai is a leading enterprise AI software provider for accelerating digital transformation. The comprehensive and proven C3 AI Suite uses a model-driven abstraction layer to enable organizations to develop, (more...)
Company: C3.ai
Location: Redwood City
Posted on: 04/9/2020

Software Engineer, Edge Devices
Description: About VerkadaAt Verkada, we're rethinking what it means to be physically safe. Today, we build security cameras that detect action, identify danger and help keep people and places safe and secure. Using (more...)
Company: Verkada
Location: San Mateo
Posted on: 04/9/2020

Business Development Manager-IT Services
Description: Job Title Business Development Manager-IT Services IT Staff Augmentation, Managed Projects Sales Territory- San Francisco Bay Area Location Milpitas, CA Full-time Position WinMax provides Business and (more...)
Company: WinMax Systems Corporation
Location: Milpitas
Posted on: 04/9/2020

Software Engineer
Description: What You'll DoWork on a large scale high availability distributed system, including web, audio, video and mobile platforms. Work with multiple product engineering, Cloud Service, TAC Support and cross-functional (more...)
Company: Cisco Systems
Location: Milpitas
Posted on: 04/9/2020

Senior Software Engineer
Description: Upstart is the leading AI lending platform partnering with banks to expand access to affordable credit. Forbes recently ranked Upstart 12 on its list of most promising AI companies in America. By leveraging (more...)
Company: Upstart
Location: San Mateo
Posted on: 04/9/2020

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Mountain View RSS job feeds