ETL DATA Analyst

Job Summary

We are seeking a detail-oriented Senior Data Analyst to support enterprise data initiatives across Data Warehouse, ODS, ETL, and Data Management environments. This role will focus on analyzing data anomalies, ensuring data quality, supporting data movement processes, and assisting with Data Governance and Master Data Management (MDM) initiatives. The ideal candidate has strong SQL expertise, analytical thinking, and the ability to collaborate effectively across cross-functional teams.

Key Responsibilities

• Investigate and analyze data anomalies and data quality issues reported by business users.
• Support analysis across Data Warehouse, ODS, ETL, and data replication environments.
• Collaborate with Business, DBA, ETL, and Data Management teams to understand data transformations, derivations, and movement.
• Document data flows, transformations, and lineage processes.
• Assist in troubleshooting, break-fix activities, and production validation related to data pipelines and structures.
• Support configuration and ongoing setup of data virtualization and MDM tools such as Denodo.
• Maintain and update documentation including Data Standards, Data Dictionary, and Data Lineage.
• Analyze data from multiple sources to identify patterns, trends, and root causes.
• Ensure proactive monitoring and adherence to data support methodologies.
• Work effectively in a fast-paced Agile team environment while managing multiple priorities.

Required Qualifications

• 4+ years of experience in a Data Analyst role.
• 4+ years of strong SQL experience across OLTP, Data Warehouse, and Big Data platforms.
• Experience working with Exadata and SQL Server databases.
• Extensive experience writing complex SQL queries.
• Strong understanding of data movement and processing including ETL, replication, APIs, and OLAP.
• Strong analytical skills and attention to detail.
• Excellent communication and collaboration skills.
• Self-motivated and team-oriented.

Preferred Qualifications

• 2+ years of experience writing medium to complex stored procedures.
• Experience with Master Data Management (MDM) and Data Governance initiatives.
• Experience with Big Data technologies such as Hadoop and MongoDB.
• Experience with PostgreSQL and cloud platforms.
• Experience with data virtualization tools such as Denodo.