Senior Data Analyst - Data Governance & Lineage

Senior Data Analyst
- Data Governance & Lineage

Oakland, CA

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.

Title: Senior Data Analyst
- Data Governance & Lineage

Sector: Information Technology

Location: Oakland, CA (Hybrid)

Job Type: Contract

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.

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

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

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