Data Specialist

Spectraforce Technologies; Oakland (CA); Hybrid; USD 75,000 - 120,000; Full time

Job summary

Spectraforce Technologies is seeking a Data Specialist for our Oakland, CA hybrid engagement. The role focuses on identifying, analyzing, and managing lifecycle and disposition of systems containing personal information, with emphasis on data lineage, governance, and regulatory compliance.

Ideal candidates will have strong SQL, hands-on experience with Informatica/Collibra/Alation, and proven ability to document data flows and collaborate across Legal, Privacy, IRG, and IT teams in a fast-paced

Qualifications

• 5+ years of experience in a technical data integration or database-focused role.
• Proven understanding of relational database structures and entity relationships.
• Experience identifying and documenting upstream/downstream data flows and dependencies.
• Strong knowledge of PI data governance, data minimization, and retention strategies.
• Hands-on experience with lineage systems such as Informatica, Collibra, or similar tools.
• Familiarity with system decommissioning and integration lifecycle management.
• Ability to interpret data dictionaries and interface specifications.
• Excellent communication and collaboration skills to work across technical and non-technical teams.

Responsibilities

• Analyze upstream and downstream system dependencies for data disposition.
• Evaluate integration points to determine the impact of data removal on related systems and processes.
• Collaborate with Data Stewards, Privacy, IRG, Support IT SME and Legal teams to ensure personal information data is identified and handled appropriately.
• Utilize lineage tools (Informatica or similar) to trace data flows and confirm mappings.
• Partner with business analysts/project managers to align data disposition with retention schedules and regulatory requirements.
• Assist in defining technical solutions and developing transition strategies for end-of-life systems.
• Participate in technical reviews, data mapping, and architecture discussions.
• Support documentation efforts including lineage diagrams, system interface maps, and dependency logs.
• Monitor and troubleshoot issues related to data lineage and integration for in-scope systems.

Skills

SQL

Data lineage

ETL processes

Data governance

CCPA compliance

Cloud platforms

Stakeholder comms

Tools

Informatica

Collibra

Alation

Job description

Data Specialist

Oakland, CA 94612 (Hybrid - 2 days onsite per week)

4 Months

*Local Candidates only*

*Manager needs candidates that are able to commute into both Oakland, CA and San Ramon, CA*

Overview:

• The Team is seeking a Data Analyst/Data Specialist to support our efforts in identifying, analyzing, and managing the lifecycle and disposition of systems containing personal information (PI). This role requires a strong understanding of relational databases, upstream and downstream system dependencies, and integration points across complex client's system landscapes.


• Familiarity with data governance frameworks and regulatory compliance requirements like GDPR and CCPA is crucial, as are sharp analytical and problem-solving abilities. Outstanding communication skills enable them to effectively convey complex data concepts to non-technical stakeholders and collaborate seamlessly with varying teams. The ideal candidate is proactive, self-motivated, and adaptable to evolving environments, maintaining composure under pressure and managing multiple tasks efficiently.

Data Analyst with Lineage Experience:

• Strong understanding of data lineage concepts, methodologies, and best practices.


• Proficiency in data lineage and metadata management tools (e.g., Informatica, Collibra, Alation)


• Experience with SQL and database management systems (e.g., Oracle, SQL Server, MySQL).


• Knowledge of ETL processes and data integration techniques.


• Knowledge of Data Disposition/retention categories


• Familiarity with data governance frameworks and regulatory compliance requirements (e.g., CCPA/CPRA).


• Ability to document complex data flows and create clear visual representations by working with different stakeholder across functional organization.


• Experience with cloud data platforms (e.g., AWS, Azure, Google Cloud) is a plus.


• Relevant certifications / Proficiency with industry-standard data lineage and metadata management tools such as Informatica, Collibra, or Alation are a plus


• Ability to conduct Kick of sessions with Application stake holders and document the Disposition processes.

What we are looking for

• Ability to convey complex data concepts to non-technical stakeholders.


• Ability to work under minimal supervision.


• Adaptable to changing environments and requirements.


• Strong documentation and organizational skills.

Key Responsibilities:

• Analyze and provide consultation to document upstream and downstream system dependencies for legacy and active systems slated for data disposition.


• Evaluate integration points to determine the impact of data removal on related systems and processes.


• Collaborate with Data Stewards, Privacy, IRG, Support IT SME and Legal teams to ensure personal information data is identified and handled appropriately.


• Utilize lineage tools (preferably Informatica or similar) to trace data flows and confirm business rule mappings across the ecosystem.


• Partner with business analysts/project managers and system owners to ensure that data disposition efforts align with retention schedules and regulatory requirements.


• Assist in defining technical solutions and developing transition strategies for systems entering end-of-life.


• Participate in technical reviews, data mapping, and architecture discussions to inform disposition readiness.


• Support documentation efforts including lineage diagrams, system interface maps, and dependency logs.


• Monitor and troubleshoot technical issues related to data lineage and integration for in-scope systems.

Qualifications:

• 5+ years of experience in a technical data integration or database-focused role, preferably client.


• Proven understanding of relational database structures and entity relationships.


• Experience identifying and documenting upstream/downstream data flows and dependencies.


• Strong knowledge of PI data governance, data minimization, and retention strategies.


• Hands-on experience with lineage systems such as Informatica, Collibra, or similar tools.


• Familiarity with system decommissioning and integration lifecycle management.


• Ability to interpret data dictionaries and interface specifications.


• Excellent communication and collaboration skills to work across technical and non-technical teams.

Preferred:

• Background in client experience with data privacy requirements.


• Informatica and Collibra experience


• Development and implementation


• Project Management skills


• Experience with system disposition or migration projects.


• Knowledge of data quality frameworks.