Technical Business Systems Analyst Job at Lucas Oil Products Inc, Indianapolis, IN

K3ZsbXEyWWJkdFdseWNHOXJLMHBMQnFKVnc9PQ==
  • Lucas Oil Products Inc
  • Indianapolis, IN

Job Description

Job Description

Job Description

  Job Purpose : We are seeking a hybrid technologist and business partner to serve as the bridge between IT and core business units (Finance, Manufacturing, Sales, R&D). You will act as the Product Owner for critical applications (ERP, CRM, LIMS) and the primary data analyst, managing system configurations, reporting, and requirements gathering for our upcoming ERP modernization initiative.

Duties :

Application Ownership & Product Owner

· Serve as the primary IT subject matter expert for core business systems, including Sage (ERP), Rockwell Automation / SCADA, Salesforce (CRM), and specialized tools (LIMS, TMS, EHS, HRIS).

· Act as the gatekeeper for system changes; translate business requests into technical requirements before handing them off to development.

· Manage the application roadmap: schedule upgrades, prioritize feature requests, and determine if custom development is truly required.

· Partner with department heads to manage technical configuration and integrations, roles, and permissions across business applications to ensure security and compliance.

Data Analysis & Reporting (SQL)

· Write and execute SQL queries to extract data to and from our Data Warehouse (Snowflake/Honeycomb) and ERP systems to support Finance and Operations.

· Build and maintain dashboards/reports to enable self-service access to data.

· Lead data integrity initiatives: Identify / clean up data inconsistencies to prepare for ERP modernization.

Data Structure & Governance

· Define and enforce data hierarchies to ensure consistency across integrated systems. You will champion the "one version of the truth" approach for reporting across LIMS, Sage, and Snowflake.

· Partner with Product Strategy to architect and automate data pipelines combining external market data (e.g., Circana) with internal ERP and Regulatory data to drive actionable product insights.

Business Analysis & Process Improvement

· Sit with departments to map current workflows and identify where manual processes can be automated.

· Develop functional requirements for IT projects, ensuring the technical team knows exactly what to build.

· Create and maintain Standard Operating Procedures (SOPs) and technical documentation for system workflows.

User Support (Tier 2/3)

· Handle escalated support tickets related to ERP, CRM, and Data discrepancies.

· Troubleshoot integration errors between systems.

ERP Modernization Support

· Play a key role in the upcoming ERP selection and implementation project.

· Assist in data migration planning and testing. 

· Coordinate User Acceptance Testing (UAT) with department stakeholders.

Skills/Qualifications :

Technical:

· SQL Proficiency: Intermediate to Advanced. Must be comfortable writing queries (joins, subqueries, aggregates) to extract meaningful data.

· ERP Experience: Sage experience is a strong plus, but general Manufacturing ERP experience is required. You must understand how G/L, Inventory, and BOMs interact.

· CRM & Data Tools: Experience configuring workflows in Salesforce is a plus. Familiarity with Data Warehousing (Snowflake) and BI tools is preferred.

Professional:

· Ability to bridge the gap between technical and business teams. You can explain a database error to a salesperson and a business goal to a developer.

· Strong project management skills; ability to juggle multiple requests without losing track of the big picture.

· Curiosity and a root-cause mindset.

Education/Experience :

· Bachelor’s degree in Computer Science, Information Systems, Business Administration, or equivalent.

· 5-7 years of experience in a Business Analyst, Systems Analyst, or Data Analyst role.

· Experience in a Manufacturing or Logistics environment is highly preferred.

Physical Requirements / Travel :

· Prolonged periods sitting at a desk; must be able to lift up to 15 pounds.

Travel: Ability to travel approximately 12 times per year to other company locations, primarily the Corydon, IN manufacturing plant. 

PI9638368529dc-25405-39516054

Job Tags

Similar Jobs

B&H Photo Video

Web Content Writer - Computers Product Descriptions Job at B&H Photo Video

 ...photography accessories along with maintenance of aging descriptions of more popular products. Level 2/Content Writer Responsible for copy for majority of Computer items, ranging from portable SSDs and docks to mainstay accessories. Content Writers will also be involved... 

SmartStart Education, LLC

Math Tutor Job at SmartStart Education, LLC

 ...class youth? If yes, this position with SmartStart Education is right for you! The Job: SmartStart Education seeks a small group Math tutor to work with small groups of middle school students on Mondays, Wednesdays, and Fridays . Each small group consists of 1-4... 

LX Pantos Americas

Warehouse Process Innovation Analyst (Entry ~ Junior Level) Job at LX Pantos Americas

 ...seeking a Warehouse Process Innovation (PI) Analyst / Associate to support enterprise-level...  ...tracking Job Requirement ( Entry ~ Junior Level )- Bachelors degree in Industrial...  ...needed for projects and site support Business Hours Mon-Fri 08:00 AM to 5:00 PM... 

Seneca Resources

Technical Product Owner (Vienna) Job at Seneca Resources

 ...JD Position Title: Technical Product Owner Location: Vienna, VA or Pensacola, FL HYBRID Position Status: Contract W2 Position...  ...and leadership skills. Experience with Agile methodologies (Scrum, Kanban) and tools such as Jira, Azure DevOps, or similar... 

Disney Cruise Line

Senior Technician Walt Disney Theatre Job at Disney Cruise Line

 ...environments that have second-hand smoke, pyrotechnics, chemical smoke, haze, fog, dry ice, and other special effects Experience with Audio Visual and Projection systems, Automation Desks, Stunt Rigging Equipment and Body Harnesses, preferred Additional Information :...