Data Engineer With Visualization

I am looking for a W2 Data Engineer Contract Consultant with my client in South San Francisco for a Hybrid role.

The Data Engineer role will be part of our client's (a global pharma) based in South San Francisco's "Workplace Digital Insights" team which supports making key data-driven decisions for the Workplace Effectiveness (RE&WE) organization and planning strategies for South San Francisco ranging from developing corporate / site location strategies.

Experience/Skills/Abilities:

At least 3 years of experience working as a Data Engineer, Tableau and Oracle SQL specialist Software Engineer with AWS or AZURE or similar position demonstrating the ability to design and implement automation, data modeling, data wrangling, data analysis, and data vision solutions to complex problems, processes, and scenarios.

Familiarity with common data structures and languages.

Understands and writes SQL code in Oracle and Redshift databases to support existing data structures, joins, views. Write and optimize new SQL to support new storage needs, reporting needs, and better performance and efficiency

Wrangling structured, unstructured and poorly structured data into appropriate data structures.

Skills that support understanding SQL queries, database concepts, API’s, AWS/Cloud services, and developing Tableau

Understands how real time data from sensors integrates with corporate systems, combined to cloud based data lake, funnels into data science analytics and will end in visualizations. ( IoT )

Required Background:

Technical Skills:

This is a Data Engineer / Data Programmer/ Data Science role.

SQL

AWS Cloud Serv (Azure will work)

Azure

Tableau

Workplace effectiveness group is a mashup up of Workspace Real Estate professionals and Planners who are technical in their focus

This is a HYBRID role with 2-3 days a week onsite in South San Francisco.

Initial phone screen and then an onsite. Technical component will involve a short live test.

Tableau, strong SQL data querying to extract data, AWS platform, how APIs work, can coordinate a project. Might use R, Python, R Shiny so these are a plus. Statistical analysis is a plus. Any AWS certification is a plus.

IoT -understanding of sensors and connectivity is a plus)

IOT (Internet of all things) involves Cisco Wifi data from sensors. Understanding this data stream is good. S3 bucket, Redshift from Data Streams, Oracle understanding. Understands AWS platform (Amazon Redshift, S3, EC2, Glue jobs, etc.), Dara Wrangling

Biotech is not required.

1. Ability to work with various databases and data structures

2. Excellent communication

3. Problem Solving

This is a Data Science / Data Programmer/ Data Engineer role.

Azure cloud is a plus and is transferrable with AWS

3+ years plus for experience level

Wants to hire quickly

SQL AWS Tableau are all required skills

Desirable Experience (but not required): Experience working with statistical teams and/or data scientists Tools/Programming Experience: Python, R, web services, other languages(e.g. Java, C++, scripting languages) AWS Certifications and working experience Experience with LEAN/KANBAN/SCRUM development methodologies is desirable