Pivot Point Solutions

Pivot Point Solutions is a California-based technology consulting firm that specializes in delivering IT solutions and support for the construction and utility industries. We partner with organizations across the state to provide reliable technology services that improve operational efficiency, enhance project delivery, and support critical business systems.

Our team understands the unique technology challenges facing construction and utility organizations, from field operations and infrastructure projects to enterprise applications and cybersecurity. By combining industry expertise with responsive service, we help clients modernize their technology environments, streamline workflows, and maintain secure, reliable IT systems that support long-term growth.

Job Overview

Title: Senior Data Analyst - Data Governance & Lineage

Sector: Information Technology

Seniority: Senior Level

Location: Oakland, CA (Hybrid)

Job Type: Contract

Contract Length: 12+ Months

Compensation: $130k-180k

As a Senior Data Analyst specializing in Data Governance and Data Lineage, you will support enterprise initiatives focused on managing the lifecycle, governance, and disposition of sensitive business data. Working with technical teams, business stakeholders, and data governance leaders, you'll analyze complex data ecosystems, document data lineage, identify system dependencies, and ensure data management practices align with regulatory and organizational standards.

This role is ideal for someone with strong SQL, metadata management, and data governance experience who enjoys solving complex data challenges while supporting enterprise modernization initiatives.

Your Day-to-Day Activities

• Analyze enterprise applications to identify upstream and downstream data dependencies

• Document data lineage, system interfaces, and data flow mappings across complex environments

• Collaborate with business owners, technical teams, privacy specialists, and data stewards to support data governance initiatives

• Evaluate system integrations and assess the impact of data retention, migration, and disposition activities

• Utilize metadata management and data lineage tools to validate data movement and business rules

• Support system retirement, migration, and data disposition planning efforts

• Participate in architecture reviews, technical design discussions, and solution planning sessions

• Develop and maintain technical documentation including lineage diagrams, interface inventories, and dependency mappings

• Troubleshoot data integration and lineage issues while working closely with application support teams

• Support compliance initiatives related to data privacy, governance, and regulatory requirements

• Assist with data quality analysis and recommend improvements to enterprise data management processes

• Communicate technical findings and recommendations to both technical and non-technical stakeholders

The Job Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field (or equivalent professional experience)

• 5+ years of experience in data analysis, data integration, database administration, or enterprise data management

• Strong understanding of relational databases and data modeling concepts

• Experience documenting data lineage, system dependencies, and data flows

• Proficiency writing SQL queries and working with Oracle, SQL Server, MySQL, or similar relational databases

• Experience with metadata management and data lineage platforms

• Strong analytical, organizational, and problem-solving skills

• Excellent communication skills with the ability to explain technical concepts to business stakeholders

You'll Stand Out If You Have

• Experience with Informatica, Collibra, Alation, or similar data governance platforms

• Experience supporting enterprise data governance or data privacy initiatives

• Knowledge of CCPA, CPRA, GDPR, or related privacy regulations

• Experience with ETL processes, data integration, and system migration projects

• Experience working with AWS, Azure, or Google Cloud data platforms

• Experience supporting application decommissioning or data disposition initiatives

• Project management or business analysis experience

• Knowledge of data quality frameworks and metadata management best practices