Address
Form of workThe Position
The Systems Specialist role will be part of the Workplace Digital Insights team which supports making key data-driven decisions for the Real Estate and Workplace Effectiveness(RE&WE) organization. We help this organization's forward planning strategies for South San Francisco ranging from developing real estate strategies, to campus planning, building investments, occupancy planning and move management.
Our team designs, builds, integrates and operationalizes technology applications that are customized to meet those organizational business needs. We are responsible for the end to end lifecycle of key applications and data streams that feed our Analytics team and Business Operations teams with high quality, well defined data. These data and data streams are critical to those applications and reporting platforms. Important business data originates from real time sensors, Wi-Fi, other databases, and people, then pipelines into storage, validation and then it is combined with other data in cloud storage, processed by software applications, and ends in visualization and decision support.
This specialized role will have to use a wide range of skills to understand business requests, identify the problem and break it into their business process, functional and system components. A clear and critical thinker is required to then bring new potential solutions to fruition, manage and analyze existing pipelines and data.
This role presents a unique opportunity to work with systems developed and maintained by the group as well as within corporate IT environments, multiple vendor systems, our AWS data lake, and all the pipelines in between. This includes working with data from various Internet of Things (IOT) networks and a great opportunity to collaborate and develop new streams and strategies on our horizon. The position must be filled with someone who has sharp critical thinking, combined with excellent project management and coordination skills, having a strong ability to work with both people representing the business people and those supporting roles within the IT organization. Technical skills are also extremely important, especially skills that support understanding SQL queries, database concepts, API's, AWS/Cloud services, and developing Tableau as well. You'll be responsible for understanding 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.
Responsibilities
Experience/Skills/Abilities:
Desirable Experience (but not required):
The expected salary range for this position based on the primary location of California is $112,000 - 208,000. Actual pay will be determined based on experience, qualifications, geographic location, and other job-related factors permitted by law. A discretionary annual bonus may be available based on individual and Company performance. This position also qualifies for the benefits detailed at the link provided below.
Benefits
Who we are
A member of the Roche Group, Genentech has been at the forefront of the biotechnology industry for more than 40 years, using human genetic information to develop novel medicines for serious and life-threatening diseases. Genentech has multiple therapies on the market for cancer & other serious illnesses. Please take this opportunity to learn about Genentech where we believe that our employees are our most important asset & are dedicated to remaining a great place to work.
Diversity and Inclusion (D&I) are critical to the success of our company and our impact on society. We believe that by championing diversity of background, thought and experience, we can foster a sense of belonging and provide an environment where every employee feels valued, included, and able to contribute their best for the patients we serve. We're focused on attracting, retaining, developing and advancing our people to their full potential by rewarding bold ways of thinking and integrating inclusive behaviors into every aspect of our work.
Genentech is an equal opportunity employer, and we embrace the increasingly diverse world around us. Genentech prohibits unlawful discrimination based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin or ancestry, age, disability, marital status and veteran status. For more information about equal employment opportunity, visit our Genentech Careers Homepage.
If you have a disability and need an accommodation in relation to the online application process, please contact us by completing this form Accommodations for Applicants.
The Systems Specialist role will be part of the Workplace Digital Insights team which supports making key data-driven decisions for the Real Estate and Workplace Effectiveness(RE&WE) organization. We help this organization's forward planning strategies for South San Francisco ranging from developing real estate strategies, to campus planning, building investments, occupancy planning and move management.
Our team designs, builds, integrates and operationalizes technology applications that are customized to meet those organizational business needs. We are responsible for the end to end lifecycle of key applications and data streams that feed our Analytics team and Business Operations teams with high quality, well defined data. These data and data streams are critical to those applications and reporting platforms. Important business data originates from real time sensors, Wi-Fi, other databases, and people, then pipelines into storage, validation and then it is combined with other data in cloud storage, processed by software applications, and ends in visualization and decision support.
This specialized role will have to use a wide range of skills to understand business requests, identify the problem and break it into their business process, functional and system components. A clear and critical thinker is required to then bring new potential solutions to fruition, manage and analyze existing pipelines and data.
This role presents a unique opportunity to work with systems developed and maintained by the group as well as within corporate IT environments, multiple vendor systems, our AWS data lake, and all the pipelines in between. This includes working with data from various Internet of Things (IOT) networks and a great opportunity to collaborate and develop new streams and strategies on our horizon. The position must be filled with someone who has sharp critical thinking, combined with excellent project management and coordination skills, having a strong ability to work with both people representing the business people and those supporting roles within the IT organization. Technical skills are also extremely important, especially skills that support understanding SQL queries, database concepts, API's, AWS/Cloud services, and developing Tableau as well. You'll be responsible for understanding 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.
Responsibilities
- 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
- Makes decisions and solves complex problems using sound, inclusive reasoning and judgment. Gathers and analyzes information to fully understand a problem and proactively anticipates needs and prioritize action steps.
- Partners and communicates well with internal stakeholders, business partners, and Global IT to understand, define and help deliver technology needs
- Implements vetted strategies developed by the business to achieve technical roadmaps
- Manages project delivery end-to-end, in other cases helping our IT partner stay on project delivery milestones
- Wrangling structured, unstructured and poorly structured data into appropriate data structures.
- Auditing data in databases and/or reports with a goal of improving data quality from systems or data owners
- Identify opportunities to further build out our IoT strategy
- Develops new and supports existing Tableau dashboard platform, including how to improve sql queries and data management for optimal performance in reporting
- Leads technology projects to completion
Experience/Skills/Abilities:
- At least 7 years of experience working as a Systems Integrator, Data Engineer, Software Engineer 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.
- BS Computer Science, Computer/Electrical Engineering, or Math Degree or relevant experience.
- Experience with IoT, cloud computing, distributed data systems
- Strong capabilities in SQL and Tableau, Excel/Google Suite
- Understands AWS platform (Amazon Redshift, S3, EC2, Glue jobs, etc.)
- Friendly and approachable, with strong communication and presentation skills
- Desire to keep current with a challenging and evolving environment
- Team focused and self-motivated. Able to work as part of a coordinated team, yet independently when necessary
- Proven abilities to take initiative and to be innovative; have an analytical mind with a problem-solving aptitude
- Demonstrated ability in leading technology projects
- Demonstrated experience in bridging business requirements and technical development
- Strong communications skills maintaining ties to product developers and stakeholders
- Demonstrated experience with software lifecycle management
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
The expected salary range for this position based on the primary location of California is $112,000 - 208,000. Actual pay will be determined based on experience, qualifications, geographic location, and other job-related factors permitted by law. A discretionary annual bonus may be available based on individual and Company performance. This position also qualifies for the benefits detailed at the link provided below.
Benefits
Who we are
A member of the Roche Group, Genentech has been at the forefront of the biotechnology industry for more than 40 years, using human genetic information to develop novel medicines for serious and life-threatening diseases. Genentech has multiple therapies on the market for cancer & other serious illnesses. Please take this opportunity to learn about Genentech where we believe that our employees are our most important asset & are dedicated to remaining a great place to work.
Diversity and Inclusion (D&I) are critical to the success of our company and our impact on society. We believe that by championing diversity of background, thought and experience, we can foster a sense of belonging and provide an environment where every employee feels valued, included, and able to contribute their best for the patients we serve. We're focused on attracting, retaining, developing and advancing our people to their full potential by rewarding bold ways of thinking and integrating inclusive behaviors into every aspect of our work.
Genentech is an equal opportunity employer, and we embrace the increasingly diverse world around us. Genentech prohibits unlawful discrimination based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin or ancestry, age, disability, marital status and veteran status. For more information about equal employment opportunity, visit our Genentech Careers Homepage.
If you have a disability and need an accommodation in relation to the online application process, please contact us by completing this form Accommodations for Applicants.
