Data Center Data Management Specialist
Location
Sunnyvale, CA | United States
Job description
About the role
- The “ Data Center Data Management Specialist” supports a client’s Product Development & New Product Introduction team. The ideal candidate has experience in SQL, developing dashboards, and working in Google systems. The Data Management Specialist will engage with cross-functional teams gather requirements, developing models and dashboards, and support governance and change management.
What you’ll do
- Collaborate with stakeholders: Conduct deep-dive interviews to understand their dashboard needs, KPIs, and use cases, mapping how their work currently interacts with Google systems.
- Analyze existing data: Assess the structure, quality, and potential issues within datasets, paying attention to how the data might be housed within Google's systems.
- Understand security and access: Proactively discuss potential access restrictions and identify approval processes needed for sensitive data within the Google environment.
- Propose solutions with Google tools in mind: Design solutions that leverage Google systems for data sourcing, automation, and integration wherever possible.
- Write SQL queries: Extract and transform data from multiple sources, including those within Google systems, with careful attention paid to group structures and access permissions.
- Data cleaning and validation: Rigorously apply validation rules, correct errors, handle missing values, ensuring data integrity within Google's data standards.
- Data structuring: Use Python and SQL to design hierarchies, relationships, and efficient database schemas tailored for dashboarding and the Google environment.
- Utilize App Scripts: Where beneficial, integrate App Scripts to automate interactions with Google Sheets, data imports from forms, and other Google-specific workflows.
- Design intuitive wireframes: Sketch layouts focused on clarity, considering the best ways to leverage Google tool integrations.
- Utilize PLX and Google tool features: Seamlessly combine PLX components with potential enhancements from Google tools (e.g., data pulled from Sheets, visualizations customized via App Script)
- Build compelling dashboards: Create visualizations that tell data stories effectively.
- User testing & feedback: Involve stakeholders early and often, iterating based on their suggestions within the constraints of the Google environment.
- Script data pipelines: Use Python to automate cleaning, validation, and data updates with Google systems in mind.
- Implement approval workflows: Develop tools within the Google framework (forms, App Scripts) to enforce approvals before critical data goes live.
- Collaborate on data governance: Work with stakeholders to define rules, quality checks, access controls, and documentation standards aligned with Google best practices.
- Monitoring with Google tools: Utilize Google-specific tools or integrate App Scripts to create alerts for data quality issues within PLX dashboards.
Job tags
Salary