Full Scale

Data Architect, Data Modeler

Full Scale

contract

Posted on:

Location Type: Remote

Location: Philippines

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AzureHadoopHBaseSQLTableau

About the role

  • Create and edit logical and physical data models, XML schemas, and file formats using ER/Studio, XML Spy, or equivalent tools.
  • Build tables, define columns and data types, and perform database scripting (DDL, inserts, updates, data movement).
  • Analyze and profile data sources; develop source-to-target mappings with detailed transformations and business rules using Erwin Mapping Manager or similar.
  • Collaborate with business and technical stakeholders to define transformation rules and data flow, ensuring mapping rules and data governance are followed.
  • Write SQL scripts to analyze, validate, or correct data, including complex stored procedures, views, and functions.
  • Monitor data quality, investigate issues, and execute remediation plans.
  • Provide guidance to teams on solutions, enterprise architecture best practices, and standards.
  • Review project deliverables for quality and compliance; recommend improvements.

Requirements

  • Minimum 3 years experience in data modeling, SQL scripting, database design, and backend data validation.
  • Experience with enterprise data tools, BI platforms, and Hadoop ecosystems is preferred.
  • Proficiency in data modeling for transactional and dimensional databases.
  • Strong SQL skills, including writing DDL statements, stored procedures, and scripts for data movement.
  • Experience creating source-to-target mappings, mapping tables, files, and XML schemas.
  • Expertise in data profiling, validation, auditing, and reconciliation.
  • Familiarity with Azure databases (Fabric Lakehouse, Synapse), Hadoop platforms (Hive, HBase, Impala), and BI/analytics tools (Tableau).
  • Knowledge of Data Quality concepts and tools.
  • Excellent communication and collaboration skills; able to explain complex findings to technical and non-technical stakeholders.
Benefits
  • Flexible work arrangements
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data modelingSQL scriptingdatabase designbackend data validationdata profilingdata validationdata auditingdata reconciliationsource-to-target mappingstransformation rules
Soft Skills
communication skillscollaboration skills