Senior Data Analyst

Position Overview

The Senior Data Analyst supports and analyzes data anomalies for multiple environments including Data Warehouse, ODS, Data Replication/ETL Data Management initiatives. They work closely with Business, DBA, ETL and Data Management teams providing analysis and support for complex Data related initiatives.

Key Responsibilities

• Investigate and Analyze data anomalies and data issues reported by Business
• Work with ETL, Replication and DBA teams to determine data transformations, data movement and derivations and document accordingly
• Work with support teams to ensure consistent and pro-active support methodologies are adhered to for all aspects of data movements and data transformations
• Assist in break fix and production validation as it relates to data derivations, replication and structures
• Assist in configuration and on-going setup of Data Virtualization and Master Data Management tools
• Assist in keeping documentation up to date as it relates to Data Standardization definitions, Data Dictionary and Data Lineage
• Gather information from various Sources and interpret Patterns and Trends
• Able to work in a team-oriented, fast-paced agile environment managing multiple priorities

Qualifications

• 4+ years of SQL experience working in OLTP, Data Warehouse and Big Data databases
• 4+ years of experience working with Exadata and SQL Server databases
• 4+ years in a Data Analyst role
• Strong attention to Detail
• 2+ years writing medium to complex stored procedures (plus)
• Ability to collaborate effectively and work as part of a team
• Extensive background in writing complex queries
• Extensive working knowledge of all aspects of Data Movement and Processing, including ETL, API, OLAP and best practices for data tracking
• Good Communication skills
• Self-Motivated
• Works well in a team environment
• Denodo Experience (plus)
• Master Data Management (plus)
• Big Data Experience (Hadoop, MongoDB) (plus)
• Postgres and Cloud Experience (plus)