Analyst – Data Administration
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, Experience, Knowledge, Skills & Abilities:
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 (Commensurate with Level):
Analyst Level:
Bachelor’s degree or equivalent work experience with 2–5 years of relevant experience in master data, enterprise applications, or a related technical/operational field.
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.