Data Architect

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.