Facebook People Planning Systems and Insights Analyst in Helena, Montana
Facebook's mission is to give people the power to build community and bring the world closer together. Through our family of apps and services, we're building a different kind of company that connects billions of people around the world, gives them ways to share what matters most to them, and helps bring people closer together. Whether we're creating new products or helping a small business expand its reach, people at Facebook are builders at heart. Our global teams are constantly iterating, solving problems, and working together to empower people around the world to build community and connect in meaningful ways. Together, we can help people build stronger communities - we're just getting started.
Join Facebook’s human resources organization, People@, on the People Planning and Portfolio team. Our group leads the development of our global HR strategy and carefully tracks the portfolio of initiatives and offerings that support achieving our strategic plan. We’re seeking a People Planning Systems and Insights Analyst to create and operate a sustainable ecosystem of portfolio data and strategic metrics.
This role will be responsible for data management and quality for the HR portfolio of strategic initiatives and offerings, data flows related to portfolio information, tracking key strategic metrics, as well as visualization and dashboarding. This role will support maintenance and development of our portfolio management application built on AppSheet, a low-code application development platform. Additionally, this role will closely integrate with partners across the people data ecosystem to support programmatic and ad hoc reporting related to key People@ programs. We are seeking someone who has critical thinking and analytical skills and is excited to be a part of building out and operationalizing our strategic planning and portfolio management capabilities for People@.
Understand complex data ecosystem and business context to develop relevant reporting as well as contextualized analysis and insights related to People@ strategy and planning process including obtaining a thorough understanding of our data sources and collection methods, and provide consultation and subject matter expertise on people planning data and systems
Maintain and document data architecture related to People@ planning and portfolio management capabilities including tables related to project activities and associated attributes
Maintain and build updates for People@ planning application (built on AppSheet, a low-code development platform) and ensure alignment with data architecture
Develop and maintain basic automated data flows using SQL and Python between various information sources to supporting integration of planning data
Build reports (generally using SQL) to support common People@ planning processes including status updates, resource demand and supply review, data quality audits, and other domains
Develop and maintain dashboards and reports in Tableau and other surfaces to support People@ planning and strategy development process, including identifying and tracking key metrics and performance indicators
Utilize knowledge of Workday, BI Tools, relational databases, and Excel to build and maintain reports, dashboards, and metrics, in addition to monitoring the integrity and validity of the data reported
Manage intake and provide ad hoc reporting for special People@ programs and targeted stakeholder needs (e.g., remote work, employee engagement) in close collaboration with key partners across the organization
Support system reporting, audits, security administration, data loads, data warehouse reporting, and basic maintenance of tools like SharePoint and AppSheet
Create detailed artifacts and materials to support portfolio management and planning workflows including data capture spreadsheets, instruction guides, and other materials
4+ years of experience and demonstrated expertise with Excel including creating pivot reports, conditional formulas and formatting, VLOOKUPs, and charts/graphs partnered with analytical and problem solving experience
3+ years of experience and demonstrated expertise working with data visualization tools (e.g., Tableau, PowerBI, Qlik, Cognos)
3+ years of experience and demonstrated expertise with SQL and/or Python (or similar language aimed at querying relational databases)
Experience or willingness to learn AppSheet (low-code application development platform)
Experience with data management, specifically with validating and auditing data and reports from multiple systems
Demonstrated understanding and use of relational data and database systems
Basic understanding of common human capital data attributes and uses
Systems experience, database knowledge, and reporting experience
Experience with data analysis, business analysis, communication and collaboration
BA/BS in a field that emphasizes data analysis and visualization (e.g., computer science, social sciences, physical sciences, math, engineering, or statistics), or equivalent work experience
4+ years of experience in compensation, finance, consulting, investment banking, or a similarly applicable field
Experience manipulating large data sets through statistical software or other methods
Experience with common portfolio management tools and willingness to learn configuration techniques for any new tooling
Experience with basic statistical modeling, including use of R
Comfortable working in a fast-paced and demanding environment
Experience working with HR/organizational and project data preferred
Experience to operate both tactically to complete tasks as well as strategically to evolve planning data capabilities
Equal Opportunity: Facebook is proud to be an Equal Opportunity and Affirmative Action employer. We do not discriminate based upon race, religion, color, national origin, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender, gender identity, gender expression, transgender status, sexual stereotypes, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law. Facebook is committed to providing reasonable accommodations for candidates with disabilities in our recruiting process. If you need any assistance or accommodations due to a disability, please let us know at firstname.lastname@example.org.