Summary:The Analyst will support the Data Administration team by maintaining, troubleshooting, and administering key enterprise-wide applications and master data domains. This role is responsible for ensuring high-quality, consistent, and compliant referential and master data across the organization. The ideal candidate will demonstrate strong analytical skills, technical aptitude, and the ability to collaborate effectively with cross-functional teams, external partners, and vendors. A strong customer service mindset and the ability to manage multiple priorities in a dynamic environment are essential.
Essential Duties and Responsibilities:- Administer, support, and optimize various enterprise applications, including SAP IS-OIL, Emerson Synthesis, Dearman Trucking suite, PFIS, Transport 4 (T4), Emerson Pipeline Scheduler, WellTrax Trucking suite, RightAngle, MIS Mainstay Vetting, and Schneider Offsites Terminal Suite.
- Perform application configuration, routine maintenance, troubleshooting, and performance tuning to ensure high availability, reliability, and system integrity.
- Create, maintain, validate, and archive all referential and master data to ensure accuracy, standardization, and alignment across business units.
- Understand and support multi-tier software architectures, including user interfaces, middleware layers, integration tools, and backend databases.
- Administer and troubleshoot middleware interface applications, cross-reference tables, data mappings, and system integrations.
- Partner with internal stakeholders (e.g., Pipeline Operations, Terminals, Crude Trucking, Measurement, Scheduling, Finance, Business Development, Accounting, IT) to gather requirements, resolve issues, and improve data and system processes.
- Serve as a liaison with external vendors and customers to support system updates, integrations, data accuracy, and operational needs.
- Document and maintain data management standards, workflows, and compliance requirements. Ensure strict adherence to SOX controls, audit requirements, and corporate governance policies.
- Support continuous improvement efforts by identifying process gaps, recommending enhancements, and participating in system upgrades, testing, and new solution implementations.
- Analyze complex data issues, research root causes, and implement corrective actions to prevent data integrity issues across systems.
Requirements:Education and/or Experience, Knowledge, Skills & Abilities:To perform this job successfully, an individual must be able to perform each essential job duty satisfactorily. The requirements for this position are listed below:
- Demonstrated ability to quickly learn new systems, understand complex business processes, and translate business needs into technical solutions.
- Willingness to participate in an on-call rotation, including nights and weekends, for urgent support needs such as patches, reboots, or critical incident response.
- Strong sense of accountability, urgency, and ownership, with the ability to work independently under changing priorities.
- Ability to act as a trusted advisor by presenting system-based solutions, evaluating impacts of proposed changes, and providing thoughtful recommendations to business partners.
- Excellent customer service and interpersonal skills, with the ability to collaborate effectively across multiple departments and levels of the organization.
- Strong time-management skills with the ability to manage multiple initiatives simultaneously while meeting deadlines in a fast-paced environment.
- Exceptional written and verbal communication skills, including the ability to document procedures, prepare reports, and clearly articulate technical concepts to non-technical audiences.
- Proficiency in MS Office applications (Excel, Word, PowerPoint, Outlook).
- General understanding of accounting information systems, business processes, and data flows across upstream, midstream, or downstream operations.
- Ability to travel as needed, including occasional overnight travel.
- Enhanced Skills & Additional Competencies (added for strengthening the role):
- Strong analytical and problem-solving skills with a focus on data quality, validation, and root-cause analysis.
- Understanding of data governance principles, data lifecycle management, and master data management (MDM) best practices.
- Familiarity with APIs, system integrations, data pipelines, or middleware technologies.
- Experience working with Agile or hybrid project methodologies.
- Ability to design and execute user acceptance testing (UAT), regression testing, and validation scenarios.
- Knowledge of IT security principles and best practices related to data protection, access controls, and system auditing.
- Experience developing or maintaining standard operating procedures (SOPs) and process documentation.
Required experience is commensurate with the selected job level:- The Specialist/Analyst level requires a Bachelor's degree or equivalent experience and 2-5 years of relevant job related experience
- The Senior Specialist/Analyst level requires a Bachelor's degree or equivalent experience and 5-8 years of relevant job related experience
- The Lead Specialist/Analyst level requires a Bachelor's degree or equivalent experience and 8+ years of relevant job related experience
Preferred Qualifications:- Experience with SAP modules (IS-OIL, RightAngle integration, interface tables, and cross-reference table management).
- Enterprise application administration experience across multiple platforms.
- Knowledge of master data management (MDM) principles, tools, and best practices.
- SQL proficiency, including scripting, queries, and data validation.
- Experience with Emerson Pipeline Scheduler and Emerson Synthesis (O2C).
- Experience with Schneider Offsites Terminal Suite and WellTrax.
- Knowledge of MIS Mainstay Vetting or similar vetting/qualification systems.
- Proficiency in MS Office
- Knowledge of Power BI, Databricks and Alteryx or other workflow automation and analytics platforms.
- Project management experience or familiarity with PM methodologies.
Working Conditions:The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
- Usually, normal office working conditions.
- Must be able to remain in a stationary position 50% of the time due to prolonged periods of sitting or standing.
- Occasional overnight travel may be required.
- Occasional visits to industrial/manufacturing settings, which may include exposure to various materials and chemicals, as well as extreme temperature conditions and loud machinery, and require appropriate personal protective equipment.
