Data Engineer (Data Conversion - SQL and AWS)

Reporting Relationships

Interfaces With: N/A

Details of Duties and Responsibilities

• Data Profiling & Analysis:
  • Profile source system data to identify data quality gaps, mapping requirements, and transformation logic.
  • Investigate data anomalies, trace root causes across related tables, and document findings for stakeholder review.
  • Design and maintain SQL staging views that transform legacy data into target system format.
  • Create and maintain lookup/reference views that map source system codes to target platform values.
  • Build stored procedures for data population and scope management across multiple product lines.
• Data Validation & Quality:
  • Build and execute validation queries, reconciliation checks, and load report resolution workflows.
  • Participate in iterative data quality cycles (profile, fix, reload, validate) until target thresholds are m...