Data Architect

Pro Mach, Inc.; Northern (KY); Remote; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical/dental programs

Life insurance

Generous paid time off

Retirement plan with company match

Benefits from day one

Job summary

ProMach, Inc. is seeking a strategic Data Architect to lead design, development, and optimization of enterprise data platforms.

You will shape scalable architectures powering analytics and reporting across diverse business units, with hands-on work in Databricks, ERP/CRM integrations, and data pipelines. The role requires 7+ years in data architecture/engineering, strong SQL/Python skills, and experience with SAP, Oracle, Salesforce, and SyteLine.

Qualifications

• Hands-on 7+ years in data architecture/engineering with a focus on scalable platforms.
• Experience with Databricks, Delta Lake, and Spark-based transformations.
• Proficiency in SQL and Python for data transformation and automation.
• Experience integrating ERP/CRM data (SAP, Oracle, SyteLine, Salesforce).
• Solid data governance, metadata management, and security practices.

Responsibilities

• Design scalable data architectures across hybrid cloud and on‑prem environments.
• Lead data integration from ERP/CRM systems (SAP, Oracle, SyteLine, Salesforce).
• Develop and optimize robust ETL/ELT pipelines with distributed processing.
• Manage large-scale data migrations with integrity and minimal disruption.
• Model logical/physical schemas for transactional and analytic use cases.
• Collaborate with engineers/analysts to operationalize data solutions.
• Ensure performance, scalability, and reliability of data workflows.
• Champion data governance, quality, and metadata management across analytics ecosystems.
• Provide technical leadership and mentorship to data teams.

Skills

Databricks

Delta Lake

SQL

Python

Data Modeling

ETL/ELT

Data Governance

CI/CD for data

Communication

Education

Bachelor's in CS/IS

Master's preferred

Tools

Spark

SQL Server

PostgreSQL

SAP

Oracle

SyteLine

Salesforce

Power BI

Tableau

Job description

## Data ArchitectApply: Remote: US KY Remote: US AR Remote: US IA Remote: US ID Remote: US FL Remote: Full time: Posted Today: JR101542Join ProMach and shine. Whether you're creative, strategic, persuasive, or mechanically inclined, there’s a place for you here. Be a problem-solver, a closer, a futurist - whatever drives you. At ProMach, you'll be challenged and rewarded as you help improve packaging performance and shape the future of automation. And we’ll be proud to have you on the journey. ***Do we have your attention?*** Keep reading. We are 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. ## Duty/Responsibility:· 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.**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:· Experience with 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.**Physical Demands:*** Minimal reaching, lifting, walking.* Consistent use of computer, telephone, typing, and talking. **What’s in it for you?** There's no monopoly on innovative 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! *Please note that the pay ranges listed on external job boards, outside our posting details, do not accurately reflect our internal compensation ranges.* **Pro Mach, Inc.** was named to the Inc. 5,000 list of the fastest growing private companies in the U.S. seven times. We continue to introduce innovative products, enter new markets, expand our global presence, and actively acquire new capabilities. We have the rewards, opportunities, and the market strength of a large organization combined with the entrepreneurial culture of a small, fast-paced company. You will enjoy the benefits of working with a growing company that competes globally, with the personal touch and feel of a smaller company where you can make an impact every day. *ProMach is an Equal Opportunity Employer. Pro Mach uses E-Verify to verify employment eligibility of all new hires to work in the United States. Pro Mach 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.*