Data Engineer

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 Engineer to join our Data Engineering team. You will play a critical role in creating business value through providing enterprise data. Candidate must have AWS data engineering experience, Responsible for, with limited supervision, all aspects of the data pipeline development lifecycle including design, development, testing, monitoring, deployment and maintenance activities. Architecting, building, creating, managing and optimizing data pipelines and then moving these data pipelines effectively into production for use by Data Analysts, Data Modelers, and Data Scientists. Data Engineers also need to guarantee compliance with data governance and data security requirements while creating and improving these integrated and reusable data pipelines. Will require both training, promoting and collaborative working with all IT departments and business units. Build data pipelines: Move data through a series of stages through which data flows from sources or endpoints to consumption for specific use cases. Innovate data pipelines: Drive innovative and use of modern tools, techniques and architectures to partially or completely automate the most-common, repeatable and tedious data preparation and integration tasks. Collaborate with data consumers to ensure adoption of responsible use of data provided through data governance and compliance initiatives. Qualifications/Requirements: Bachelor's degree in a Quantitative field (Finance, Economics, Math, Engineering, Science), Computer Science, Computer Engineering, Information Technology, Systems Analysis or a related study, or equivalent experience. 2 - 5 years of industry or analytics experience. Knowledge of AWS environment, database management, Python, SQL, object-oriented programming, and ETL frameworks. Experience working with data pipelines, especially AWS. Positive attitude and a strong commitment to delivering quality work Effective communication skills (written and verbal) to properly articulate technical details to management and peers This position is eligible for remote work in one of the following states: Arkansas, Colorado, Illinois, Indiana, Iowa, Kansas, Kentucky, Minnesota, Missouri, Montana, Nebraska, New Mexico, North Dakota, Oklahoma, South Dakota, Tennessee, Texas, Virginia, Wisconsin, or Wyoming. This position will require some travel for office meetings, as needed, to our corporate office in Tulsa, OK. Job Profile Summary Responsible for, with limited supervision, all aspects of the software development lifecycle for both package and custom developed applications, including in software design, development, testing, deployment and maintenance activities. Essential Functions and Responsibilities Responsibilities: Works independent with limited supervision to design, develop, test, validate, deploy, monitor and maintain data pipelines as prioritized by the business including creating and updating system documentation and training materials Coordinate and communicate development activities with other team members, infrastructure personnel, vendors and management Contribute input to the data strategy and provide feedback to help ensure data strategy is aligned with user needs. Evangelize Data as an Asset Identify opportunities to deploy existing solutions in other business areas Follow defined change control and compliance procedures associated with software development, including all required documentation and governance standards Apply data management principles to ensure appropriate governance and accuracy of data. Solve difficult, sometimes complex problems Ensure published data quality Follow defined security standards Education Bachelor's Degree in MIS, computer science, mathematics, or other related field, or an equivalent combination of formal education and the following job related experience Work Experience Experience with multiple development languages and/or platforms Experience with software development and programming concepts/techniques Experience with database management systems Experience with all aspects of the software development lifecycle methodology and basic project management concepts Experience with basic infrastructure concepts and how those concepts are impacted by development activities Knowledge, Skills and Abilities Skills in: use and function of office equipment including computers and applicable software Ability to: apply math, algebra, and statistical methods. Ability to: interact, advise and communicate effectively Ability to: develop information, conduct meetings and make presentations Ability to: read and write fluently in English Ability to: communicate and/or exchange information or instruction; conduct oral presentations and/or meetings 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 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) Travel None required, Driving Based on assigned tasks, employee may be assigned a company vehicle requiring the applicable driver's license 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 HRSolutionsONEOK.com or call 1-855-663-6547.