Key Facts

Remote From:

Philippines

Fixed term

Mid-level (2-5 years)

English

Hard Skills

Other Skills

•
Collaboration
•
Communication
•
Detail Oriented
•
Mentorship
•
Problem Solving

Roles & Responsibilities

Minimum 3 years experience in data modeling, SQL scripting, database design, and backend data validation.
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.

Requirements:

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.

Full Scale

About Full Scale

Full Scale is a tech services company that helps businesses build teams of software engineers. Our goal is to make finding and retaining highly experienced software engineers fast, easy and affordable. As lifelong entrepreneurs and software startup founders, we tore pages out of our own playbooks in order to create a service offering that is for Founders, by Founders! Matt DeCoursey is a Kansas City-based entrepreneur, co-founder, and CEO of Full Scale, co-host of the Startup Hustle podcast; as well as the founder of Gigabook. He is the top-selling author of Million Dollar Bedroom and Balance Me as well as the co-author of The Realist’s Guide to a Successful Music Career. Matt Watson is a Kansas City-based entrepreneur, co-founder of Full Scale, co-host of the Startup Hustle podcast; as well as the founder of Stackify. After a 150-million-dollar exit from VIN Solutions Matt founded Stackify, to help developers improve application performance so they can focus on building better apps. In 2021, Stackify was acquired by Netreo, earning Matt Watson a two-time exit Founder. Hosting the Startup Hustle podcast, we spend 5 days a week talking to entrepreneurs, influencers, investors and thought leaders shaping the local Startup ecosystem whom all say they have the same problem when it comes to finding the tech talent to help grow their business. It didn’t take long to realize something had to change. With that, we created Full Scale. We take a consultative approach with clients so that you can feel confident you are choosing the right team member for your project. To learn more about what we do: fullscale.io To learn more about who we are: https://linktr.ee/startuphustle

Founded: 2018

Company size: 201 - 500

LinkedIn See all jobs →

Job description

This is a remote position.

Join one of the Philippines’ fastest-growing tech companies! Open to Philippine-based candidates only.

Company Overview:

Full Scale is a tech services company that helps businesses build dedicated teams of skilled software engineers. We make finding and retaining experienced software talent easy and affordable.

Position Summary

We are seeking a Data Architect / Data Modeler to design, maintain, and validate complex data models, transformations, and integrations. The role focuses on ensuring high-quality data architecture and transformation aligned with business requirements and enterprise standards. The ideal candidate will collaborate with stakeholders across departments and technical teams to deliver accurate, efficient, and compliant data solutions.

Key Responsibilities:

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.