Job Summary

We are seeking a Senior Data Analyst to support enterprise data initiatives across Data Warehouse, Operational Data Store (ODS), Data Replication, ETL, and Data Management environments. This role will be responsible for investigating data anomalies, supporting complex data-related initiatives, validating data transformations, and assisting with Data Governance and Master Data Management activities. The ideal candidate will possess strong SQL expertise, Oracle and Exadata experience, analytical problem-solving skills, and a passion for data quality and data management.

Key Responsibilities
• Investigate, analyze, and resolve data anomalies and data quality issues reported by business users and stakeholders.
• Support enterprise data initiatives across Data Warehouse, ODS, ETL, Data Replication, and Data Management environments.
• Collaborate with Business, DBA, ETL, Replication, and Data Management teams to analyze data movement, transformations, and derivations.
• Document data flows, transformation logic, business rules, and data lineage processes.
• Assist with production support, break-fix activities, and validation of data-related issues.
• Support data replication, data integration, and data processing initiatives across multiple platforms.
• Ensure consistent support methodologies and best practices are followed for data movement and transformation processes.
• Assist with the configuration, implementation, and ongoing support of Data Virtualization solutions.
• Support Master Data Management (MDM) initiatives and ongoing platform administration activities.
• Maintain and update data governance artifacts, including data dictionaries, data standards, metadata, and lineage documentation.
• Gather data from multiple sources and analyze trends, patterns, and relationships to support business needs.
• Develop and execute complex SQL queries for analysis, validation, troubleshooting, and reporting purposes.
• Participate in Agile development and support processes while managing multiple priorities and deliverables.
• Collaborate with technical and business teams to improve data quality, consistency, and governance practices.

Required Qualifications
• 4+ years of experience as a Data Analyst.
• 4+ years of SQL experience working with OLTP, Data Warehouse, and Big Data environments.
• 4+ years of experience working with Oracle databases.
• 4+ years of experience working with Exadata environments.
• 4+ years of experience working with SQL Server databases.
• Extensive experience writing complex SQL queries for data analysis and troubleshooting.
• Strong understanding of Data Warehousing concepts and methodologies.
• Strong knowledge of ETL processes, data replication, and data movement technologies.
• Strong understanding of data processing concepts including ETL, APIs, OLAP, and data tracking best practices.
• Experience investigating and resolving data quality and data integrity issues.
• Strong analytical and problem-solving skills.
• Excellent verbal and written communication skills.
• Strong attention to detail.
• Ability to work effectively in a fast-paced, team-oriented Agile environment.
• Self-motivated with the ability to manage multiple priorities simultaneously.

Preferred Qualifications
• Experience writing medium to complex stored procedures.
• Experience with Denodo or other Data Virtualization platforms.
• Experience with Master Data Management (MDM) solutions.
• Experience with Big Data technologies such as Hadoop and MongoDB.
• Experience working with PostgreSQL databases.
• Experience with cloud-based data platforms and cloud technologies.
• Experience supporting Data Governance initiatives.
• Experience creating and maintaining Data Dictionaries, Data Lineage, and Metadata repositories.
• Experience supporting enterprise data quality and data standardization programs.

Primary Skills
• SQL
• Oracle
• Exadata
• SQL Server
• Data Analysis
• Data Warehousing
• ETL
• Data Replication
• Data Governance
• Master Data Management (MDM)