Data Architect / Data Mapping Architect

Robotics Technologies LLC; Arlington (TX); Hybrid; USD 120,000 - 170,000; Full time

Job summary

Robotics Technologies LLC seeks a Data Architect to lead discovery sessions with key stakeholders and define data architecture for finance, operations, and planning systems. You will design canonical data models, source mappings, and secure data ownership.

The role emphasizes Snowflake data layers, data quality, governance, and integration patterns across ERP, planning tools, and external partners. Hybrid onsite work in Arlington, TX is required.

Qualifications

• Lead discovery with finance, accounting, operations, and execs.
• Translate requirements into measures, reporting dims, canonical data models, mappings.

Responsibilities

• Lead discovery workshops to identify reporting needs, data gaps and priorities.
• Define financial structures (entities, chart of accounts, cost centers, products, suppliers).
• Design Snowflake data layers for ingestion, standardization and reporting.
• Establish data ownership, stewardship, and change processes.
• Define integration patterns across financial apps and planning systems.
• Profile data, test mappings, and develop integration prototypes using SQL and Python.
• Design role-based privileges and data security controls.
• Present options and document implementation-ready requirements.
• Develop phased backlog and roadmap; review designs against standards.

Skills

SQL

Python

Snowflake

Data modeling

Stakeholder engagement

Canonical data models

Data ownership

Tools

Snowflake

Job description

Role : Data Architect / Data Mapping Architect
Location: Arlington, TX
Work Arrangement: Hybrid – Onsite 2 Days per Week
Job Description :

• Lead discovery workshops with finance, accounting, operations, and executive stakeholders to identify reporting needs, data gaps, and priorities.
• Translate business requirements into approved measures, reporting dimensions, canonical data models, source mappings, and acceptance criteria.
• Define financial structures such as legal entities, chart of accounts, cost centers, products, suppliers, and fiscal periods, according to the agreed scope.
• Establish data ownership, stewardship, business definitions, and a practical process for approving changes.
• Design Snowflake data layers for ingestion, standardization, and curated financial reporting, including history, lineage, reconciliation, security, and performance considerations.
• Define integration patterns across financial applications, planning systems, enterprise SaaS applications, and external logistics partners.
• Specify feed contracts, refresh requirements, validation rules, safe replay, and exception handling.
• Use SQL and Python to profile source data, test mappings, validate reconciliations, and develop representative integration or transformation prototypes.
• Design role-based privileges, row-level restrictions, and sensitive-field controls with security stakeholders.
• Present architecture options and tradeoffs to business leaders, secure decisions, and document implementation-ready requirements.
• Develop a phased backlog and roadmap; review engineering designs and implementations against approved standards.
• Coordinate with finance, security, and operations on testing, acceptance, and production readiness.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.