Logo
ProMach

Data Architect

ProMach, Raleigh, North Carolina, United States, 27601

Save Job

Overview

ProMach is seeking a strategic and hands-on Data Architect to lead the design, development, and optimization of enterprise-grade data platforms. This role will shape the future of scalable data architecture, powering analytics, reporting, and operational efficiency across diverse business units. The ideal candidate brings hands-on expertise in Databricks, relational databases, ERP/CRM systems, data modeling, data migration, and building and maintaining complex data pipelines. Experience integrating and modeling data from platforms such as SAP, Oracle, Salesforce, and SyteLine is critical. As a Data Architect at ProMach, your work will directly impact the operational and strategic success of over 45 business units. You will unify data across hundreds of systems to enable advanced analytics, faster decision-making, and a reliable data foundation for the future. Responsibilities

Design and implement scalable data architectures across hybrid cloud and on-premise environments. Lead data integration efforts from multiple enterprise systems, including ERP (SAP, Oracle, SyteLine) and CRM (e.g., Salesforce). Develop and optimize robust, scalable ETL/ELT pipelines using distributed data processing and orchestration frameworks. Lead large-scale data migration projects ensuring integrity, lineage, and minimal business disruption. Design and maintain logical and physical data models for both transactional and analytical use cases (e.g., star schema, normalized forms). Collaborate with data engineers and analysts to operationalize and enhance data solutions that meet business goals. Ensure performance, scalability, and reliability of data workflows and storage through best practices in indexing, partitioning, and caching. Champion data quality, governance, and metadata management across enterprise reporting and analytics ecosystems. Provide technical leadership and mentorship to data engineering teams and advocate for modern data practices and tools. Monitor evolving trends and emerging technologies in data architecture to drive innovation and modernization. What’s in it for you?

There’s no monopoly on good ideas or limits to how far you can advance with our team. We offer an open, communicative environment that fosters individual initiative. We pride ourselves in being a company where people are happy and choose to build a career. In addition to growth opportunities, as a ProMach employee, you receive more than just a paycheck. Total compensation includes your salary, comprehensive medical/dental programs, as well as life insurance, a generous paid time off program, and a retirement savings plan with a company match. And because we understand the importance of feeling protected, there is no waiting period for benefits – you are eligible on your first day of employment! Qualifications

Bachelor’s degree in Computer Science, Information Systems, or related field (Master’s preferred). 7+ years of experience in data architecture, data engineering, or related roles with a demonstrated hands-on approach. Hands-on experience with Databricks, including building data pipelines, working with Delta Lake, and leveraging Spark-based transformations. Proficiency with relational database development (e.g., T-SQL, schema design, indexing) across platforms such as SQL Server or PostgreSQL. Strong experience integrating and modeling data from ERP and CRM systems, including SAP, Oracle, SyteLine, and Salesforce. Proficiency in SQL and Python for data transformation, analysis, and automation. Experience building robust ETL/ELT processes and supporting data migrations at scale. Solid understanding of data governance principles, metadata management, and data security best practices. Excellent communication and collaboration skills with both technical and business stakeholders. Preferred: Databricks Unity Catalog or other enterprise data cataloging solutions. Knowledge of real-time data processing and streaming architectures. Familiarity with business intelligence platforms like Power BI or Tableau. Understanding of manufacturing, financial, and supply chain data domains. Experience with CI/CD practices, infrastructure automation, and DevOps for data solutions. Travel up to 10%. Benefits

ProMach offers a competitive compensation package and benefits. Total compensation includes your salary, comprehensive medical/dental programs, life insurance, generous paid time off, and a retirement savings plan with company match. You are eligible for benefits from day one. ProMach is an Equal Opportunity Employer. ProMach uses E-Verify to verify employment eligibility of all new hires to work in the United States. ProMach is a drug-free workplace. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

#J-18808-Ljbffr