Description

You will analyze data anomalies across Data Warehouses, ODS, and ETL environments to ensure data integrity and lineage.

This role is on-site.

Responsibilities

• Investigate and analyze data anomalies reported by business users across multiple environments.
• Collaborate with ETL, Replication, and DBA teams to document data transformations, movements, and derivations.
• Partner with support teams to establish consistent, proactive support methodologies for data movements.
• Assist in setting up and documenting Data Governance and Master Data Management solutions.
• Ensure accurate tracking and documentation of end-to-end data lineage.

Required Skills

• 4+ years of experience as a Data Analyst.
• 4+ years of SQL experience working with OLTP, Data Warehouse, and Big Data databases.
• Extensive experience writing complex SQL queries.
• Deep working knowledge of data movement and processing, including ETL, API, and OLAP.
• Experience with data tracking best practices.
• Strong analytical and communication skills.

Preferred Skills

• 2+ years of experience writing medium to complex stored procedures.
• Experience with Denodo.
• Experience with Big Data technologies including Hadoop, MongoDB, or Exadata.

Key Skills

Education

Any graduate