Locals Only Urgent Need Data Analyst
Core
Data Analyst supporting audit, balancing, and reconciliation processes for an Enterprise Data Warehouse (EDW) by analyzing data flows, developing SQL controls, and creating dashboards.
Role type
Data Analyst (Audit & Reconciliation)
Builds
Post-load audit routines, reconciliation dashboards, and data quality controls for an EDW
Domain
Data Management / Enterprise Data Warehousing / Audit (via careerplan.io/jobs/96226014-locals-only-urgent-need-data-analyst-at-usm)
Required skills
SQL, data profiling, data quality analysis, data lineage documentation, audit and balancing processes, test planning and execution, requirements traceability
Preferred skills
Master's degree in related discipline
Technologies
SQL, EDW, staging tables
Responsibilities
Develop complex SQL for post-load audit and balancing; Verify delivered systems against functional and non-functional requirements; Author test plans, test cases, and maintain requirements traceability matrix; Create dashboards and canned reporting for monitoring reconciliation exceptions; Elaborate standard operating procedures for audit and balancing processes
Seniority
Mid-Senior (7+ years experience)
