Data Engineer

Company Overview World Emblem International is a global manufacturer of patches, emblems, and decorated products. The business operates across ecommerce, sales, finance, production, fulfillment, and marketing systems. As the company expands its AI and internal software initiatives, it needs a reliable data foundation that connects these systems while preserving the purpose and ownership of each operational platform. Role Summary The Senior Data Engineer / Data Architect will be the hands-on technical owner of World Emblem's enterprise data foundation. This person will assess the current data environment, define the future architecture, and build the pipelines, models, controls, and data services required to make company data accurate, secure, and useful. This is not an architecture-only advisory role. The successful candidate must be able to design the target state and personally build the core data pipelines, models, tests, and services needed to deliver it. Why This Role Exists Critical business data currently lives across Microsoft Dynamics 365 Business Central, HubSpot, Optimizely, BigCommerce, marketing platforms, production systems, internal servers, and other applications. Using multiple systems is normal. The gap is dedicated ownership for the data that moves between them. Without a clear cross-system data owner, individual integrations can create duplicate records, conflicting definitions, incomplete reporting, security risks, and growing technical debt. These risks become more important as World Emblem builds AI agents, analytics products, and internal MicroSaaS applications that depend on trusted data. Key Responsibilities 1. Data Audit and Current-State Mapping Create and maintain an inventory of data sources, databases, APIs, integrations, scheduled jobs, reports, owners, and downstream users. Map how customer, product, order, revenue, inventory, marketing, and production data currently moves across the company. Identify duplicate data, missing ownership, weak controls, manual work, reconciliation gaps, security risks, and fragile integrations. Document the current architecture and establish a clear baseline for future improvements. 2. Enterprise Data Architecture Define the authoritative system for each major data domain and, where necessary, for specific fields within that domain. Design a scalable target architecture that supports operational systems, reporting, AI, and internal applications without turning one business platform into the data platform for the entire company. Create common data models and identifiers for customers, companies, products, orders, revenue, inventory, locations, and production activity. Set standards for batch processing, real-time events, APIs, data contracts, schema changes, and data retention. Recommend the right data platform and integration tools based on business needs, security, cost, maintainability, and the existing technology environment. 3. Data Engineering and Integration Build and maintain reliable data pipelines connecting Business Central, HubSpot, ecommerce platforms, marketing platforms, production systems, and internal applications. Develop tested transformations that turn source data into consistent, reusable business data. Create secure APIs and data services that allow approved analytics, AI, and internal tools to use trusted data. Use source control, automated testing, deployment pipelines, and clear release practices for data code and configuration. Design integrations that can recover from failures, handle changing schemas, and avoid duplicate processing. 4. Data Quality and Reliability Create automated checks for completeness, accuracy, duplication, freshness, and consistency. Reconcile key measures such as orders, revenue, inventory, and customer counts across systems. Monitor pipeline health, failed jobs, delayed data, schema changes, and unexpected volume changes. Define response and escalation processes for data incidents and recurring quality issues. Work with business owners to resolve the source of data problems instead of correcting only the final report. 5. Data Governance, Security, and Documentation Establish practical standards for data ownership, access, classification, retention, and approved use. Apply role-based access controls, encryption, audit logging, and appropriate protection for personal and confidential data. Maintain clear data definitions, lineage, integration documentation, runbooks, and architecture diagrams. Partner with IT, Legal, and business leaders to support privacy, security, and compliance requirements. Help department leaders take ownership of the business meaning and quality of the data created within their areas. 6. Reporting, AI, and Internal Product Enablement Create trusted and reusable data models for reporting, dashboards, forecasting, and decision-making. Prepare structured and approved data for AI agents, retrieval systems, automations, and internal MicroSaaS applications. Prevent uncontrolled direct access to production systems by providing governed data access patterns. Partner with the Director of AI and internal product teams to reduce the time required to launch new data and AI use cases. Set standards for monitoring how AI and internal applications use company data. 7. Cross-Functional Leadership Work closely with the CTO, Infrastructure, Applications, Finance, Operations, Ecommerce, Marketing, Sales, and other business teams. Translate technical data issues into clear business risks, options, costs, and recommended actions. Review vendor-built integrations and hold partners accountable for documentation, security, maintainability, and delivery quality. Create standards and training that improve how teams collect, define, share, and use data. First 90 Days Objectives Days 1 to 30: Understand the Environment Inventory the major systems, data stores, integrations, reports, and owners. Meet with technical teams and business departments to understand current processes, pain points, and planned projects. Map the highest-risk and highest-value data flows. Establish an initial baseline for data quality, reliability, security, and documentation. Days 31 to 60: Define the Plan Create the system-of-record matrix for critical data domains. Define common business entities and the most important shared data definitions. Present the target architecture, governance model, security approach, and recommended technology plan. Create a prioritized roadmap based on business value, risk, effort, and AI readiness. Days 61 to 90: Prove the Approach Deliver the first high-value governed pipeline or shared data product. Add automated testing, monitoring, documentation, and reconciliation to the selected use case. Publish the initial engineering standards and operating process for future integrations. Provide an updated roadmap, staffing recommendation, budget view, and delivery milestones. Role Boundaries and Working Relationships This position does not replace the owners or administrators of Business Central, HubSpot, ecommerce platforms, production systems, or infrastructure. Those teams remain responsible for the operation and business use of their platforms. The Senior Data Engineer / Data Architect owns the shared data foundation between those systems, including cross-system architecture, data movement, shared models, quality controls, monitoring, documentation, and approved access for reporting, AI, and internal products. Success will require close partnership with technical teams and department leaders. Business owners will continue to define what their data means, while this role ensures that the data can move across the company in a reliable, secure, and consistent way. Qualifications Required Qualifications Seven or more years of experience in data engineering, including experience designing and owning production data platforms. Strong hands‑on skills in SQL, Python, Apache Spark, Apache Airflow. Experience building and supporting ETL or ELT pipelines, APIs, webhooks, and scheduled or event-driven integrations. Strong understanding of data modeling for operational systems, analytics, and shared enterprise data. Experience with cloud data platforms, data warehouses, lakehouses, or similar modern data environments. Experience implementing data quality tests, reconciliation, monitoring, alerting, and incident response. Working knowledge of security, access control, encryption, privacy, retention, and audit requirements. Experience with Git, code review, automated testing, and deployment pipelines. Ability to explain complex technical issues clearly to executives, business leaders, and nontechnical teams. Proven ability to work independently, set priorities, document decisions, and deliver working systems. Bachelor's degree in computer science, information systems, engineering, or a related field, or equivalent practical experience. Preferred Qualifications Experience integrating Microsoft Dynamics 365 Business Central or another enterprise ERP platform. Experience with HubSpot, ecommerce platforms, digital marketing platforms, or manufacturing data. Experience with Microsoft Fabric, Azure Data Factory, Azure Synapse, Databricks, Snowflake, BigQuery, Redshift, or a comparable platform. Experience with transformation and orchestration tools such as dbt, Airflow, Dagster, or similar technologies. Experience building Power BI semantic models or another governed reporting layer. Experience preparing enterprise data for AI, retrieval-augmented generation, vector search, agents, or machine learning applications. Experience with master data management, metadata catalogs, data lineage, data contracts, and schema governance. World Emblem is an Equal Opportunity Employer (EOE). Qualified applicants are considered for employment without regard to age, race, color, religion, sex, national origin, sexual orientation, disability, or veteran status. World Emblem is proud to be a drug-free workplace. All applicants will undergo a criminal background check and pre-placement drug screen, and we participate in E-Verify. Monday - Friday 9:30 AM to 6:00 PM #J-18808-Ljbffr