Data Specialist

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.

 

At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position's pay range is $60.00/hr – $70.00/hr.