Data Analyst
- TechTandem Inc.
2 Days Ago
50-55 per W2 Hourly
NA
Phoenix-AZ
7-12 Years
Required Skills: regulatory reporting ,SQL, SQL / NoSQL,Y9C, Y14, Y15, 2052a,Oracle SQL, DBeaver and Hive
Job Description
Job Title: Data Analyst (Regulatory reporting and SQL)
· Demonstrated expertise in data analysis, testing, and automation projects; including responsibilities associated with testing strategy development, test cases documentation and maintenance of testing artifacts
· Experience in data analytics, data profiling, Source to Target (S2T) data mapping, analyzing the System of Record (SOR) data and its Data Quality (DQ) rules to identify data issues in SORs
· Strong SQL / NoSQL and data analysis experience, able to write / understand complex SQL, HiveQL, with hands-on Oracle SQL, DBeaver and Hive experience
· Knowledge of US Regulatory Reports (Y9C, Y14, Y15, 2052a, amongst others), and general understanding of the banking products
· Strong understanding of relational database concepts and experience working in a big data environment (Hadoop / Cornerstone) preferred
· Experience with of MS Excel and Power Query
· Document and understand core components of solution architecture including data patterns, data-related capabilities, and standardization and conformance of disparate datasets.
