Senior Data Solutions Architect

Insight Global; New Bremen (OH); On-site; USD 120,000 - 190,000; Full time

Job summary

Insight Global is seeking a senior data architect to design end-to-end data platforms for analytics, reporting, and governance across manufacturing and enterprise environments.

The role emphasizes data ingestion, storage, processing, integration, and consumption layers, with a focus on data quality, security, and compliance in line with Industry 4.0 and OT/IoT contexts.

Qualifications

• Bachelor’s degree or 12+ years of relevant analytics experience.
• 10+ years delivering analytics solutions in manufacturing/services.
• 8+ years in data architecture or data engineering roles.
• 5+ years designing enterprise data solutions.
• ERP systems experience, especially SAP/IFS.
• Cloud-based data platforms, preferably Azure; others AWS/GCP.
• Manufacturing, supply chain or industrial domain experience.
• Proven large-scale data integration and migration success.
• Certifications such as Azure Solutions Architect or Azure Data Engineer.
• SAP BW/4HANA, SAP Data Services or SAP Data Intelligence knowledge; IoT/OT familiarity.

Skills

Data architecture

ETL/ELT design

Cloud platforms (Azure/AWS/GCP)

Governance and security

Data governance frameworks

Manufacturing domain experience

Data integration & migration

Analytics & reporting solutions

Education

Bachelor’s degree in Engineering, Science, Information Systems, Finance or related field

Non-degree with 12+ years of related experience

Tools

SAP

IFS

SAP BW/4HANA

SAP Data Services

SAP Data Intelligence

Azure

AWS

Google Cloud Platform

Job description

Job Description

Design data models and structures that support efficient reporting, dashboards, and analytics use cases.

Create semantic layers and data marts optimized for business intelligence consumption.

Architect solutions that enable self-service analytics while maintaining governance and security.

Design infrastructure to support advanced analytics, machine learning, and AI initiatives.

Implement metadata management and data cataloging solutions to improve data discoverability.

Design and architect end-to-end data solutions including data ingestion, storage, processing, integration, and consumption layers.

Develop comprehensive data architecture blueprints and technical roadmaps aligned with business strategy and analytics requirements.

Create reference architectures for data platforms supporting analytics, reporting, and operational use cases.

Design solutions that ensure data quality, security, privacy, compliance, and governance across enterprise.

Architect data integration solutions across SAP, IFS, BAAN, Quipware and other enterprise applications to create unified data assets.

Design and implement data extraction, transformation, and loading (ETL/ELT) processes from multiple ERP sources.

Develop master data management strategies to ensure data consistency across disparate systems.

Create integration patterns for real-time and batch data synchronization between source systems and data platforms.

Ensure seamless data flow across manufacturing, supply chain, finance, sales, and customer service domains.

Address data quality, reconciliation, and harmonization challenges across heterogeneous systems.

Define and implement data governance frameworks including data lineage, metadata management, and data quality rules.

Ensure solutions comply with regulatory requirements and industry standards (GDPR, SOX, etc.).

Design security architecture including role-based access control, data masking, and audit logging.

Establish data retention, archival, and lifecycle management policies.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

Bachelor’s degree in Engineering, Science, Information Systems, Finance or related field with at least 10 years related experience in delivering analytics solution in a manufacturing/services industry

Non-degree considered if 12+ years of related experience along with a high school diploma or GED

Occasional travel (0-5%) 8+ years of experience in data architecture, data engineering, or related roles with increasing responsibility.

5+ years of hands-on experience designing and implementing enterprise data solutions.

Extensive experience with ERP systems, particularly SAP (SAP ECC, S/4HANA) and/or IFS.

Proven track record architecting cloud-based data platforms, preferably on Microsoft Azure.

Experience in manufacturing, supply chain, or industrial environments

Demonstrate success delivering large-scale data integration and migration projects.

Experience with additional cloud platforms (AWS, Google Cloud Platform).

Certifications such as Microsoft Certified: Azure Solutions Architect Expert, Azure Data Engineer Associate, or similar.

Knowledge of SAP BW/4HANA, SAP Data Services, or SAP Data Intelligence. Experience with IoT data platforms and manufacturing operational technology (OT) systems. Understanding of Industry 4.0, IIoT, and smart manufacturing concepts.