Senior Systems Architect

TNT Crane & Rigging•Houston, TX

1d•Onsite

About The Position

TNT Crane & Rigging is seeking a Senior Systems Architect to serve as the technical authority over our enterprise systems ecosystem, with particular emphasis on ERP architecture, integration, and data strategy. This role owns the architectural integrity of our ERP platform and its integration with surrounding operational, financial, fleet, safety, and HR systems. The Senior Systems Architect will define how ERP data is structured, governed, integrated, and consumed across the organization while ensuring scalability, performance, and long-term maintainability. The ideal candidate combines deep ERP platform experience with hands-on expertise in data modeling, system integrations, ETL/ELT pipelines, and analytics platforms. This individual will translate business processes into scalable system configurations, guide ERP modernization efforts, and ensure enterprise-wide alignment between business workflows and technical architecture. The ideal candidate is a technically elite, execution-oriented architect who thrives at the intersection of enterprise design and hands-on engineering. They are equally comfortable defining long-term architectural standards as they are writing SQL, building pipelines, configuring APIs, or troubleshooting complex data flows.

Requirements

7+ years of experience in enterprise data architecture, data engineering, or senior technical roles supporting enterprise systems.
Familiarity with data migration methodologies, data mapping, and ETL concepts.
Deep expertise in relational database design, SQL, and data modeling (conceptual, logical, physical).
Hands-on experience with ETL/ELT tools (SSIS, Talend, Informatica, dbt, Apache NiFi, or custom Python/SQL pipelines).
Proven experience designing and implementing integrations using REST APIs, SOAP, middleware, or iPaaS platforms.
Prior experience working in multi-entity or multi-branch organizations undergoing digital transformation.
Demonstrated success leading complex data migration initiatives
Strong experience with Power BI (semantic models, DAX, dataflows) or comparable enterprise BI platforms.
Experience with cloud data platforms (Azure, AWS, or GCP) including data warehouse and integration services.
Proven ability to define and operationalize enterprise data governance standards.
Strong communication skills with the ability to translate complex technical concepts into business-friendly language.
Strong communication skills with the ability to translate complex technical concepts into business-friendly language.
Strong communication skills with the ability to translate complex technical concepts into business-friendly language.

Nice To Haves

Experience in construction, heavy equipment, crane services, or other asset-intensive industries.
Familiarity with ERP data models in multi-entity, multi-site environments.
Experience developing enterprise data architecture roadmaps and reference architectures.
Knowledge of master data management (MDM), metadata management, and data lineage tools.
Experience with change data capture (CDC), event streaming (Kafka, Azure Event Hubs), or real-time integration patterns.
Experience with change data capture (CDC), event streaming (Kafka, Azure Event Hubs), or real-time integration patterns.
Experience with change data capture (CDC), event streaming (Kafka, Azure Event Hubs), or real-time integration patterns.
Bachelor’s degree in IT, Business, Engineering, or related field.
Certified Lean, Six Sigma (Green Belt or higher), or other process improvement certifications
Experience with change data capture (CDC), event streaming (Kafka, Azure Event Hubs), or real-time integration patterns.

Responsibilities

Enterprise Data Architecture & Governance • Design and maintain the enterprise data architecture, including conceptual, logical, and physical data models.
Develop and own a multi-year data architecture roadmap aligned with business strategy and modernization initiatives.
Establish and enforce enterprise data governance standards, including naming conventions, metadata management, data classification, lifecycle policies, and master data practices.
Define integration design patterns and standards to ensure consistency, reusability, and long-term maintainability.
Ensure alignment with security, compliance, and regulatory requirements across all data assets.
Cloud Architecture & Modernization • Lead the modernization strategy for legacy data infrastructure, including migration sequencing, risk mitigation, and architectural transition planning.
Apply cloud-native design principles such as scalability, resiliency, cost optimization, and security-by-design.
Evaluate and implement modern data platform patterns, including data warehouse, data lake, lakehouse, ELT pipelines, and API-first architectures.
Own cloud data platform cost modeling, capacity planning, and performance optimization.
Data Migration & Transformation • Lead end-to-end data migration initiatives, including profiling, mapping, transformation rule definition, reconciliation, and validation.
Design and build scalable ETL/ELT pipelines to transform and preserve historical and operational business logic.
Develop detailed data mapping documentation with full traceability from source to target systems.
Implement validation frameworks to ensure migration accuracy and completeness.
Integration Architecture & Execution • Architect and oversee integrations between core enterprise platforms and ancillary systems (fleet, dispatch, finance, safety, HRIS, and third-party vendors).
Design and implement API-based integrations, middleware solutions, and batch or real-time data flows.
Establish and enforce integration patterns (event-driven, publish/subscribe, request/reply, batch synchronization).
Monitor integration health and implement alerting, logging, and exception-handling mechanisms.
Analytics, BI & Data Quality • Own the data foundation supporting enterprise reporting and analytics, including Power BI semantic models and curated data sets.
Partner with leadership to ensure reporting structures align with KPIs and operational decision-making frameworks.
Implement data quality monitoring, validation controls, and anomaly detection processes.
Establish data lineage and impact analysis capabilities to enhance transparency and trust in enterprise reporting.
Cross-Functional Leadership & Business Translation • Serve as the principal liaison between IT and business units regarding data and integration strategy.
Conduct discovery sessions with operational teams to understand workflows and translate them into architectural decisions.
Communicate technical strategies and trade-offs clearly to executive and board-level audiences.
Provide architectural guidance during system implementations and configuration decisions.
Ensure that data structures are intuitive and aligned with real-world operational terminology.
Performs other duties as assigned.