Data Analyst – OT & Enterprise Data

EJ has an immediate opening for an Data Analyst.

Generous Benefit Package that includes:

Paid Vacation and Holidays, Paid Maternity & Paternity Leave, 401K (with match), Medical, Dental, Vision, Flexible Spending Account, HSA with Employer Match, Disability Insurance, Employee Assistance Program, Employee Wellness Program, Life Insurance, Tuition Reimbursement and Bonus Program

About EJ: We are the leader in the design, manufacture, and distribution of access solutions for water, sewer, drainage, telecommunications, and utility networks. EJ is a family-owned company with global operations. The corporate headquarters is in East Jordan, Michigan, where the company was founded in 1883.

We are seeking high performing individuals who embrace our values, understand the importance of relationships, and strive for excellence. Our values, which have been passed down for generations, are the essence of our company’s identity and our guide for making decisions. Core values at EJ include safety and security, honesty and integrity, environmental responsibility, respect for others, quality and excellence, and social responsibility.

SUMMARY

The Data Analyst – OT & Enterprise Data is responsible for supporting Operational Technology (OT) data initiatives while also serving as a key contributor to enterprise-wide data integrity and product data quality efforts. This role reports directly to the Data Integrity Team Manager, ensuring close alignment with enterprise data governance standards, while partnering closely with OT, Operations, Engineering, and IT teams.

The analyst will bridge manufacturing/OT data with core business systems (M3, Salesforce, Web, etc.), ensuring that data across the organization is accurate, consistent, well-structured, and aligned with business processes.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

Promotes the culture, the mission and vision, and the core values of the company. This includes adherence to and promotion of the company safety beliefs, employee engagement, competencies, code of conduct, and other policies and procedures.

OT Data & Operational Analytics

• Analyze and support OT-related data sources, including manufacturing, foundry, and production systems
• Validate and maintain data quality across OT systems to ensure accurate reporting and decision-making
• Partner with Operations, Facility Engineering, and IT teams to align data structures with business processes
• Support reporting, dashboards, and data extraction for OT performance, efficiency, and optimization initiatives
• Assist with integration of OT data into enterprise platforms (e.g., Fabric, data warehouse, analytics tools)

Enterprise Data Integrity & Product Data

• Function as a member of the Data Integrity Team, supporting enterprise-wide data quality and governance initiatives
• Act as a data integrity analyst across core systems, including M3, Salesforce, and customer-facing platforms
• Identify, analyze, and resolve data inconsistencies across systems to ensure alignment of product, BOM, and attribute data
• Support ongoing data cleanup and standardization efforts, including Duplicate record identification and remediation
• Attribute standardization and normalization
• Product structure and hierarchy improvements
• Collaborate with business and IT stakeholders to define and enforce data standards, naming conventions, and governance practices
• Ensure consistent and accurate product data across systems, improving reporting, operational efficiency, and customer-facing outputs

Data Governance & Quality Improvement

• Support the Data Integrity Team’s governance framework by helping define, monitor, and enforce data quality rules and metrics
• Participate in data audits and validation processes to proactively identify issues
• Work with stakeholders to improve upstream data entry processes and prevent recurring data issues.
• Document business rules, data definitions, and transformation logic to improve transparency and consistency

Business Process & Cross-Functional Support

• Serve as a liaison between OT, Data Integrity Team, IT, and business units
• Support key initiatives such as foundry transformations, product restructuring, and operational improvements through clean, reliable data
• Assist in preparing and validating data for business-critical processes and projects

AI & Automation Support

• Support data readiness for AI initiatives (e.g., mold optimization, product search, automation workflows)

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION and/or EXPERIENCE

• Bachelors in data science, Industrial Engineering, CS, or equivalent experience.
• 3–5+ years in data engineering/analytics; OT or manufacturing analytics preferred.
• Certifications in IT, Data, Cybersecurity or Programming subject areas a plus

TECHNICAL SKILLS

• SQL (T-SQL), Python, DAX for Power BI, time-series modeling.
• OEE calculations, SPC (control charts), anomaly detection.
• OPC UA/MQTT, REST APIs; version control (Git); CI/CD for analytics artifacts.
• Experience in Java or .NET a plus
• Experience with Microsoft Fabric, ETL tools, and BI platforms a plus

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is frequently required to walk. The employee is occasionally required to stand; sit; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl; talk or hear; and taste or smell. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is occasionally exposed to moving mechanical parts, extreme heat, and risk of electrical shock. The noise level in the work environment is usually moderate.

EJ is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.