Business Intelligence and Data Analyst, REWS Google Mountain View, CA, USA

Job description

Google operates on a global scale, but each office seeks to emulate the same Googley feel of our Mountain View, California home base. As a Workplace Service Program Manager, you build consistent, outstanding workplace experiences around the world. You design, implement and manage Google's service offerings. You're a great communicator who is comfortable taking on complex projects with a diverse set of stakeholders. You believe that great isn't good enough. You bring an analytical mind to constantly improve the efficiency and efficacy of your projects, from building new workplace tools and applications to mergers and acquisitions. You get satisfaction from knowing your clients are happy, healthy and productive, and are excited about joining a fast-paced, collaborative team that is reinventing what a workplace can be.

You will use data to inform real estate and workplace service business decisions across the globe. You will take a leadership role in providing visibility on key metrics, performance, and opportunities for scale and growth. You will also work closely with Corporate Engineering teams to shape and develop REWS’ (Real Estate and Workplace Services) data architecture, determining how to best structure and visualize key data. You will craft scalable solutions to automate reports and dashboards. You will ensure reports and dashboards that you build deliver high-quality and relevant data to manage our real estate portfolio. You will work with business owners to understand their evolving requirements and with Corporate Engineering to deliver practical but innovative solutions. You will also have the creativity and drive to build your own prototype solutions and to provide training and guidance to team members and partners.

You are naturally curious and you enjoy diving into data to both ask and answer big questions about service performance, real estate utilization and overall planning, for example: predicting impact on team commute times based on office relocations and employee addresses. You are a well-rounded top performer who can be a key contributor in a high-growth environment. You should be a self-starter with good knowledge of Business Intelligence (BI) tools and approaches. You can "crunch the numbers" one minute, and critically think through business problems and communicate to stakeholders the next.

Just as Google products always focus on the user, Google offices focus on the Googler. From state-of-the-art green construction projects to maintaining our resident T. Rex skeleton (named Stan), the Real Estate and Workplace Services team builds environments that keep Googlers feeling inspired and energized. We're a team of inquisitive and energetic real estate, construction and facilities operations professionals that are constantly searching for new ways to improve workplace efficiency and make Google a great place to come to work everyday.

Responsibilities 

• Work closely with REWS management and their teams to understand their information needs, developing a BI strategy that both fulfills current needs and can evolve to anticipate future ones.
• Work with REWS and Corporate Engineering partners to help shape and drive the development of BI infrastructure, tools, and processes.
• Own and deliver multiple BI work streams for diverse internal clients, both on an ongoing and ad-hoc basis; Provide interpretation, analysis, or insight along with clearly-stated information, representing interests of both team and leadership.
• Customize communication and output to a wide variety of audiences; determine best audience for data-driven insights, both inside and outside immediate team.
• Create dashboards, visualizations, and analyses that surface insights and drive key business decisions.

Qualifications
Minimum qualifications:

• BA/BS degree with a quantitative focus or equivalent practical experience.
• 4 years of relevant work experience including database experience with SQL, query optimization and operating with data schemas.
• Programming experience (i.e. Python, R, JavaScript, etc.).

Preferred qualifications:

• Experience with data warehousing (e.g., storage methods/formats, database design) and Google BigQuery.
• Experience in Web-scale databases, Hadoop, NoSQL technologies and related underlying technologies (i.e. App Engine or other cloud platforms).
• Experience with Extraction Transformation Load (ETL) optimization and strong competency working in web-based tools including spreadsheet programs and Apps Script; Tableau and/or GIS.
• In-depth experience analyzing data and creating reports with strong spreadsheet, database query experience (namely SQL), statistical (e.g. R, SAS), quantitative modeling and forecasting skills.
• Working knowledge of command line/console interface and version control (git, svn, etc.).
• Distinctive problem-solving and analytical skills combined with superb communication skills; demonstrated ability to convey complex concepts and solutions to all levels of an organization.

At Google, we don’t just accept difference - we celebrate it, we support it, and we thrive on it for the benefit of our employees, our products and our community. Google is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. If you have a disability or special need that requires accommodation, please let us know.

To all recruitment agencies: Google does not accept agency resumes. Please do not forward resumes to our jobs alias, Google employees or any other company location. Google is not responsible for any fees related to unsolicited resumes.