Job Details

Email to Friend Save Back

Data Analyst

SCOTTSDALE-85264, AZ, US
06/18/2021

-

Required Skills

SQL, ETL

Company

Enconosoft

Experience

6 to 8 Year(s)

Job Description

Candidate must have strong skills in data profiling, mapping , data modeling and data governance. Includes ability to query data repositories to determine Source to target mappings, data quality, completeness and transformation rules necessary for merging into target repositories
Strong skills in Informatica, Informatica Data Quality, Information Analyzer, and IBM data architect, Erwin is big plus. Strong SQL skills are a must.
Hands-on experience in creating/updating conceptual, logical, and physical data models most appropriately needed to satisfy the business requirements.
Should be able to understand and explain complex data integration and extraction/transformation/load processes (ETL).
Should be able to work with the business to define scope of Data-centric or supportive projects.
Should be competent in reviewing Project Initiation Document, Reference/Domain value mapping.
Should be able to work with Business and Architects to identify Pain points impacting data capabilities.
Should be able to establish program/project specific Data Analysis approach.
Should be competent at Source-Target Data mapping, S/T Record building/ Join conditions, writing transformations building data lineage.
Should be able to conduct Peer Reviews.
Should be able to support ETL/Test questions, output file validation, defect analysis.
Should ensure data analysts (and other data leads, as necessary) are following standard work and best practices.
Qualifications

6+ years’ experience in Data Analytics and Analysis
ETL
Informatica
Informatica Data Quality
Information Analyzer
IBM Data Architect
SQL
Preferred Qualifications

Experience with Erwin