SQL Database Administration - Data Mapping & Integrity Analyst

About the Opportunity

A fast-scaling technology firm operating at the intersection of data governance, enterprise analytics, and regulatory compliance, we enable Fortune 500 and mid-market organizations to operationalize trusted, mapped, and auditable data across legacy and cloud systems. Our team builds the data integrity backbone that powers risk reporting, financial close, and cross-functional analytics—ensuring data lineage, schema alignment, and referential accuracy at scale.

Responsibilities

• Design, document, and maintain end-to-end data mapping matrices across source systems, data warehouses, and downstream analytical platforms.
• Enforce data integrity rules using SQL-based constraints, validation scripts, and automated data quality checks within enterprise databases.
• Collaborate with data engineering and compliance teams to implement metadata schemas and lineage tracking aligned with GDPR, SOX, or CCPA standards.
• Identify and resolve data anomalies, duplication, mismatched fields, and referential integrity breaches using T-SQL, PL/SQL, or PostgreSQL.
• Develop and optimize SQL queries, stored procedures, and views to support data governance dashboards and audit trails.
• Partner with business stakeholders to translate operational data requirements into technical mapping specifications and database design blueprints.

Qualifications

Must-Have

• SQL
• Microsoft SQL Server
• Data Mapping
• Data Integrity
• T-SQL
• PL/SQL
• PostgreSQL
• Metadata Management

Preferred

• Collibra
• Informatica IDQ
• Alation

Benefits

• On-site collaborative environment with cross-functional teams driving enterprise data transformation.
• Opportunity to shape core data governance frameworks for high-impact clients.
• Professional development support and exposure to regulatory compliance landscapes.