Business Intelligence Data Analyst

ZT Systems•Secaucus, NJ

3d•$60,750 - $81,000

About The Position

ZT Systems is seeking an entry-level Business Intelligence Data Engineer (T1) to join its BI team. The role helps build and maintain pipelines that move and transform information from manufacturing and business systems into reporting tools. It also supports end-to-end data lineage, data validation, and documentation for SOX compliance. This position connects IT with internal business teams to support reliable reporting. The analyst works across functions to clarify business processes and data definitions, address data-quality issues, and deliver usable, consistent business metrics.

Requirements

Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent experience.
1–2 years of experience in data engineering, business intelligence, or a related role.
Foundational Python scripting skills and experience using pandas for data manipulation.
Baseline SQL skills, including joining tables, writing aggregations and subqueries, and performing standard transformations.
Familiarity with Git version control and Jira task tracking.
Understanding of basic data modeling concepts, data lineage, and data-quality assurance methods.
Strong written and verbal communication skills and willingness to collaborate across business functions.

Nice To Haves

Familiarity with manufacturing, supply chain, or inventory accounting workflows.
Exposure to ERP environments such as SAP, Oracle, or Microsoft Dynamics.
Hands-on experience with visualization tools such as Power BI or Tableau.
General awareness of SOX compliance, internal controls, or audit preparation requirements.

Responsibilities

Design, build, and maintain data pipelines that move and transform data from source systems such as ERP, MES, supply chain, and finance into reporting-ready datasets.
Document and maintain data lineage from source systems through transformations to dashboards and reports.
Support the accuracy, consistency, and usability of business metrics through validation checks and reconciliation.
Build and maintain SOX-compliant data processes, including change management, access controls, audit trails, and documentation.
Work with IT, Finance, Operations, Supply Chain, and other departments to understand business processes and translate them into reliable data solutions.
Connect technical and business teams by clarifying data definitions and resolving data-quality issues.
Manage work through Jira and follow version-control best practices in Git.