Sr. Data Analyst

Summary: The Sr. Data Analyst role involves reverse-engineering EAB Navigate data exports to create a validated suite of reports for a data migration initiative. The position requires data profiling, modeling, and report development, with a focus on collaboration with stakeholders and ensuring data accuracy. The consultant must be located in the PST time zone and will work remotely for a duration of 12 months. The role is classified as outside IR35.

Key Responsibilities:

• Discovery, Data Profiling and Data Cleanup Plan
• Inventory all tables and fields from the raw export
• Profile data: count, uniqueness, nulls, anomalies
• Identify preliminary candidate keys and joins
• Begin scanning for data cleanup opportunities
• Data Modeling - Deliver preliminary ERD and field mappings for review.
• Reconstruct logical data model (ERD)
• Define inferred business rules and transformations
• Annotate cleanup assumptions and field behavior
• Present preliminary model to stakeholders for validation
• Data Cleanup and Execution
• Deduplicate key entities
• Standardize inconsistent formats and flag outliers
• Resolve referential mismatches and orphaned records
• Document all remediation logic and exceptions
• Report Development
• Build minimum 20 reports to support migration analysis
• Incorporates transformation, filters, and joins as needed
• Track report performance and document logic
• Prioritize critical migration use cases
• QA and Stakeholder Review
• Validate data accuracy and logic consistency
• Run test queries and exception reports
• Review outputs with users, revise as needed
• Maintain issue log and feedback loop
• Post-Migration Validation
• After each data load or test migration:
• Re-test reports and validate logic
• Update ERD and data dictionary
• Log schema drifts or issues
• Refresh deliverables as needed
• Final Documentation & Handoff
• Deliver annotated SQL, ERDs, cleanup scripts, and report definitions
• Package all documentation and changelogs
• Conduct knowledge transfer and closeout session

Key Skills:

• Experience with data profiling and modeling
• Proficiency in SQL and report development
• Strong analytical skills and attention to detail
• Ability to work collaboratively with cross-functional teams
• Experience in data cleanup and validation processes
• Knowledge of EAB Navigate or similar data export systems
• Excellent communication skills for stakeholder engagement

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: Other