Business Systems Analyst

Employer

Epitec, Inc.

Business Systems Analyst (Job Code: 1379)

Responsible for cleansing and validating Bill of Material (BOM) data for CAT Products; use SQL in a Snowflake database to retrieve historical BOM data and transform it into an established structure; utilize SQL and script languages and regular expressions; analyze and validate that the BOM data was successfully transformed and stored; apply knowledge of CAT Products and mechanical components to validate the completeness of BOM Data;

work with the As-Built BOM to determine the proper methods to achieve results; utilize and apply knowledge of SQL, Python, Tableau, Power BI, Alteryx, Snowflake, AWS, Apache Airflow, Snaplogic, Azure Dev Ops, Git Hub, and CAT business systems/applications to perform assigned duties; conduct data analysis for product quality notifications using work orders, sims, as built BOM and engineering data in Snowflake leveraging smart SQL queries;

create and administer multiple databases for Warranty transformation and product quality in Snowflake; build and deploy data pipelines in Snaplogic to load data into Snowflake; address and meet data needs for Warranty transformations projects; create dashboards for Warranty transformations and Product Quality; collaborate with multiple business teams; assess Gen AI translations for COBOL to natural language output in order to analyze business and data quality rules and enhance performance of Gen AI translations code;

advise on CAT business and data related to service data, digital and warranty; write SQL queries to cleanse and transform historical Bill of Material data into a structured format; and validate Bill of Material data is accurate and properly structured.

Southfield, Michigan and multiple undetermined worksites throughout the US;

$121,784 per year;

• Education:
  
  Master’s – Business Administration, Management Information Systems, Operations Management, or related field (will accept equivalent foreign degree).
• Training:
  None.
• Experience:
  
  Two (2) years in the position above, as a Business Analyst, as a Systems Analyst, as a Data Analyst, Data Engineer, or in a related occupation.
• Other Requirements:
  Experience must include two (2) years use of all the following: SQL, Python, Tableau, Power BI, Alteryx, Snowflake, AWS, Apache Airflow, Snaplogic, Azure Dev Ops, Git Hub, and CAT business systems/applications.
• Will also accept any suitable combination of education, training, and/or experience.

Attn: HR Generalist, Epitec, Inc.

26555 Evergreen, Suite 1700, Southfield, MI 48076

All applicant resumes must reference above job code and be submitted via U.S. Mail to Savanna Krim, Human Resources Team Lead.