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.
Role & 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.
Skills & Qualifications
Must-HaveS:
- QLMicrosoft SQL ServerData Mapping
- Data IntegrityT-SQLPL/SQLPostgreSQLMetadata Management
- PreferredCollibraInformatica IDQAlationBenefits & Culture Highlights
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.
Skills:
microsoft sql server, metadata management, data integrity, data mapping, pl/sql, postgresql, sql