Lucas Oil · 14 hours ago
Technical Business Systems Analyst (On-site)
Indianapolis,IN,US
Full-time
Onsite
Senior Level
5+ years expLucas Oil is seeking a hybrid technologist and business partner to serve as the bridge between IT and core business units. The role involves acting as the Product Owner for critical applications and managing system configurations, reporting, and requirements gathering for an ERP modernization initiative.
AutomotiveManufacturingMechanical EngineeringOil and Gas
Responsibilities
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
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
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
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
Handle escalated support tickets related to ERP, CRM, and Data discrepancies
Troubleshoot integration errors between systems
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
Qualification
Required
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
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
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
Prolonged periods sitting at a desk; must be able to lift up to 15 pounds
Ability to travel approximately 12 times per year to other company locations, primarily the Corydon, IN manufacturing plant
Preferred
Sage experience is a strong plus
Experience configuring workflows in Salesforce is a plus
Familiarity with Data Warehousing (Snowflake) and BI tools is preferred
Experience in a Manufacturing or Logistics environment is highly preferred
Company
Lucas Oil
For over 35 years, Lucas Oil Products has been raising the global standard in high-performance oils, additives, and lubricants, delivering premium solutions that power engines across industries.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Forrest Lucas
Founder & CEO
Recent News
Sports Business Journal
2025-07-10
Company data provided by crunchbase