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
Deliverable
production ML models | product features | dashboards & analysis | research | client delivery | infrastructure | physical/clinical work
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
