Data Analyst/Data Specialist

Spectraforce
Oakland, CA, United States
about 1 month ago
Apply on leoforce.us
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Microsoft Azure Databases Data Dictionary Data Governance Data Integration Extract Transform Load (ETL) Data Mapping Relational Databases Meta-Data Management Microsoft SQL Server MySQL
+9 more
Oracle (Applications) Cloud Services SQL Databases Data Streaming Technical Data Management Systems Google Cloud Data Lineage Collibra Data Management

Job description

  • 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., * 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.

Requirements

  • 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., * 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., * 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on leoforce.us
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

2:18 min

Scaling MySQL databases for massive user growth

Johannes Nicolai Johannes Nicolai +1 · LIVE

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · World Congress 2022

1:48 min

Analyzing network packets with database protocol tools

Daniël van Eeden Daniël van Eeden · World Congress 2026 Europe

Videos

See all

Related articles

See all