Data and Reporting Specialist IV

#WeAreONEOK – Fortune 500 company. 100+ years in business. Leading midstream service provider. Safety first. Sustainable operations. Environmentally responsible. Employee focused.

JOB SUMMARY

ONEOK is looking for a Data and Reporting Specialist who preferably has at least 6-8 years of experience with software development, report authoring, and data analysis. Experience working with stakeholders to solicit requirements and writing SQL queries is critical to this role. Experience with a Data Catalog and Master Data Management (MDM) tools is preferred.
This position has been approved for remote work within an approved state or within 90 miles of Tulsa, OK. Candidates available to work a 3 day onsite / 2-day remote hybrid work schedule in Tulsa will be given priority.

Job Profile Summary

Lead role responsible for implementing and enhancing the Data Catalog and Master Data Management (MDM) systems, and broadly supporting ONEOK’s Data Governance program. The Data Catalog duties require customizing the look-and-feel of the Catalog system, working with the product vendor to fix bugs, and publicizing the Catalog to data stewards. The MDM duties require investigating data quality issues, tuning matching and merging settings, and creating data models and user interfaces within the MDM system.

Essential Functions and Responsibilities

• Consult with stakeholders and data stewards about the priorities, complexities and other impacts of adding new content to the Data Governance systems.

• Create both technical and non-technical plans to add content and make system changes to the Data Governance systems, and then execute the plan.

• Identify and develop business process flows, glossary terms, data catalog entries, data models, data lineage and data-flows.

• Partner with subject-matter experts to validate accuracy and consistency of data, and drive efforts to monitor data quality. Provide solutions to improve the data quality and content.

• Develop training materials and other content that supports the use of data governance applications, data visualization technologies and other data and reporting tools.

• Assist with development and maintenance of data governance best practices and documentation while also researching emerging data governance industry trends and best practices.

• Work, with general supervision, across multiple teams to participate in and to lead projects with well-defined scope while fostering strong relationships. Propose and maintain project endeavors, develop plans and reports, monitor and communicate project status to stakeholders.

Education

• Bachelor's Degree Management Information Systems, Computer Sciences, Accounting, Finance, Business Administration, or other related field with specific job-related experience as follows: 

Experience

• Experience with report authoring, querying database management systems, and hands-on experience writing SQL code.

• Experience in business or process analysis, software development lifecycle and change management techniques including identification of potential process solutions.

• Experience in applying project management techniques.

• Experience with data catalogs and/or MDM software is a plus.

Knowledge, Skills, and Abilities

• Skills in: relational database design including table structures, indexes and primary/foreign key fields.

• •Skills in: use and function of office equipment including computers and applicable software.

• Skills in: interacting, advising and communicating effectively.

• Skills in: developing solutions to complicated issues using abstract thinking in new or complex situations.

• Skills in: managing and prioritizing multiple assignments with competing deadlines.

• Skills in: reading and interpreting correspondence, reports, production statistics, cost analyses, contracts, accounting statements, income statements, ledgers, manuals and legal documents.

• Ability to: develop information, conduct meetings and present information to individuals and groups.

• Ability to: apply math, algebra, statistical and volumetric methods.

• Ability to: be self-motivated and self-directed.

• Ability to: influence and facilitate discussions across a wide range of teams and technologies.

• Ability to: mentor less experienced personnel on complex technologies.

Licenses and Certifications

• None required

Strength Factor Rating - Physical Demands/Requirements

• Sedentary Work - Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently (Frequently: activity or condition exists from 1/3 to 2/3 of the time) to lift, carry, push, pull, or otherwise move objects, including the human body. Sedentary work involves sitting most of the time, but may involve walking or standing for brief periods of time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Strength Factor Rating - Physical Demands/Requirements

• Sedentary Work - Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently (Frequently: activity or condition exists from 1/3 to 2/3 of the time) to lift, carry, push, pull, or otherwise move objects, including the human body. Sedentary work involves sitting most of the time, but may involve walking or standing for brief periods of time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Strength Factor Description - Physical Demands/Requirements

• Standing: Remaining on one's feet in an upright position at a work station without moving about (Occasionally)

• Walking: Moving about on foot (Frequently)

• Sitting: Remaining in a seated position (Constantly)

• Lifting: Raising or lowering an object from one level to another (includes upward pulling) (Occasionally)

• Carrying: Transporting an object, usually holding it in the hands or arms, or on the shoulder (Occasionally)

• Pushing: Exerting force upon an object so that the object moves away from the force (Occasionally)

• Pulling: Exerting force upon an object so that the object moves toward the force (includes jerking) (Occasionally)

• Climbing: Ladders, Stairs (Occasionally)

• Balancing: Maintaining body equilibrium to prevent falling (Occasionally)

• Stooping: Bending the body downward and forward by bending the spine at the waist (Occasionally)

• Kneeling: Bending the legs at the knees to come to rest on the knee or knees (Occasionally)

• Crouching: Bending the body downward and forward by bending the legs and spine (Occasionally)

• Crawling: Moving about on the hands and arms in any direction (Occasionally)

• Reaching: Extending hands and arms in any direction (Constantly)

• Handling: Seizing, holding, grasping, turning or otherwise working with the hand or hands (Manual Dexterity) (Constantly)

• Fingering: Picking, pinching or otherwise working with the fingers primarily (Finger Dexterity) (Constantly)

• Feeling: Perceiving such attributes of objects/materials as size, shape, temperature, texture, movement or pulsation by receptors in the skin, particularly those of the finger tips (Constantly)

• Talking: Expressing or exchanging ideas/information by means of the spoken word (Frequently)

• Hearing: Perceiving the nature of sound by the ear (Frequently)

• Tasting/Smelling: (Occasionally)

• Near Vision: Clarity of vision at 20 inches or less (Constantly)

• Far Vision: Clarity of vision at 20 feet for more (Frequently)

• Depth Perception: Three-dimensional vision; ability to judge distances and spatial relationships so as to see objects where and as they actually are (Frequently)

• Vision: Color - The ability to identify and distinguish colors (Constantly)

Working Conditions/Environment

• Employee is subject to inside environmental conditions

Working Conditions

• Well lighted, climate controlled areas (Constantly)

• Frequent repetitive motion (Constantly)

• CRT (Computer Monitor(s)) (Constantly)

ONEOK is an equal opportunity employer committed to diversity and inclusion. All qualified applicants will receive consideration for employment without regard to race, color, sex, pregnancy, sexual orientation, age, religion, creed, national origin, gender identity, disability, military/veteran status, genetic information or any other categories protected by applicable law.

The job description is not intended to be a complete list of all responsibilities, duties or skills required for the job and is subject to review and change at any time, with or without notice, in accordance with the needs of ONEOK.

ONEOK is committed to making our workplace accessible to individuals with disabilities and will provide reasonable accommodations, upon request, for individuals to participate in the application and hiring process. To request an accommodation email [email protected] or call 1-855-663-6547​.

#LI-Hybrid

Expected Salary Range

$101,000.00 - $151,000.00