Capco is looking to solve data anomalies and improve data management for their clients across the data management lifecycle
Requirements
- 4+ years of SQL and PL/SQL experience working in OLTP, Data Warehouse and Big Data databases. PL/SQL is a must have
- Previous Management Consulting experience
- 4+ years in a Data Analyst role
- 2+ years writing medium to complex stored procedures a plus
- 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
- Denodo Experience a plus
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 tool
- 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
Other
- Strong attention to Detail
- Ability to collaborate effectively and work as part of a team
- Good communication skills and self motivated
- Works well in a team environment
- 4+ years of experience in a Data Analyst role
