Data Architect

Pro Mach Inc; Kentucky; Hybrid; USD 115,000 - 160,000; Full time

Benefits offered by this job

Medical/dental programs

Life insurance

Generous paid time off

Retirement plan with company match

Job summary

ProMach Inc. is seeking a strategic and hands-on Data Architect to lead the design, development, and optimization of enterprise‑grade data platforms.

You will shape scalable data architecture powering analytics, reporting, and operations across business units. The role requires hands-on Databricks experience, ERP/CRM data integration (SAP, Oracle, Salesforce, SyteLine), and strong data modeling skills for both transactional and analytical use cases.

Qualifications

• Hands-on data architecture experience with enterprise data platforms.
• Experience with Databricks, Delta Lake, and Spark-based processing.
• Strong SQL and Python for data transformation and automation.
• Proven ability to design scalable data models and ETL/ELT processes.

Responsibilities

• Design scalable data architectures across hybrid cloud and on-prem environments.
• Lead data integration from ERP and CRM systems (SAP, Oracle, SyteLine, Salesforce).
• Develop and optimize ETL/ELT pipelines for reliability and performance.
• Lead large data migration projects with data lineage and minimal disruption.
• Model both transactional and analytical data using star schemas and normalization.

Skills

Databricks

SQL

Python

Data modeling

Data pipelines

Delta Lake

Spark transformations

ERP systems integration

CRM systems integration

Education

Bachelor’s degree in Computer Science or related field

Tools

Databricks Unity Catalog

SQL Server

PostgreSQL

Job description

Join 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.

ProMach may not be a brand you see on store or pharmacy shelves, but we are integral to your daily life, powering the processing and packaging machines behind consumer goods, food and nutrition, health, and everyday products. At ProMach, we are committed to responsibility, honesty, safety, and helping you grow. We seek individuals eager to shine—whether creative, strategic, technical, or persuasive—offering opportunities to shape your career in exciting directions. You’ll be challenged and rewarded, making an impact on our customers' performance while helping to build the future of packaging innovation.

Our mission—to help customers protect their reputations and grow consumer trust—along with our core values, drives us to perform with passion, accountability, and proactive problem‑solving. We emphasize collaboration and innovation, where every employee and voice matters, ensuring consistency and excellence in everything we do. When you join our team, you're not just taking a job; you're becoming part of something that lasts.