Data Analyst
Core
Analyzes enterprise data warehouse (EDW) data flows, performs post-process reconciliation, and develops audit routines to ensure data integrity and balance between source and target systems.
Role type
Senior Data Analyst (Data Quality & Reconciliation)
Builds
Reconciliation routines, audit scripts, and data lineage documentation for Enterprise Data Warehouse (EDW) environments.
Domain
Data Warehousing, Data Quality, Enterprise Architecture
Required skills
SQL, data profiling, data quality analysis, data lineage documentation, source-to-target mapping, audit and balance controls, test planning and execution, requirements traceability matrix (RTM), data architecture alignment, stakeholder communication, technical writing, Ab Initio (GDE, Co>Operating System, EME)
Preferred skills
Master's degree in related discipline, experience with Query>It, Conduct>It, Express>It, Continuous flows, Metadata Hub
Technologies
Ab Initio, GDE, Co>Operating System, EME, SQL
Responsibilities
Map source to target data flows and confirm data flows throughout the EDW; Perform post-process queries to balance and reconcile source data with control files and loaded data; Author test plans, execute tests, and maintain requirements traceability matrix; Collaborate with architects to align data models with solution architecture; Develop standard operating procedures for audit and reconciliation monitoring.
Seniority
Senior, hands-on IC