Database Engineer / Administrator - PetroChoice

Overview

About the Company: “PetroChoice is a pioneer in lubricant distribution.  As the nation’s leading lubricant distributor, PetroChoice provides solutions across the industrial, commercial and passenger vehicle customer segments with an extensive and high quality product offering including ExxonMobil and our licensed proprietary brands; Medallion-Plus, DynaPlex21C and Eco-Ultra.. A subsidiary of the Cosan/Moove Group, Petrochoice is revolutionizing service and disrupting the lubrication delivery market. Whether through companies committed to energy transition, with operations dedicated to integrated and efficient logistics or identifying opportunities for the development of innovative businesses, we are more than 55,000 globally distributed employees who move industries and people who, like us, walk toward a sustainable future.

The Opportunity: In this role, you will work on some of the latest applications designed to disrupt the longstanding methodologies of lubricant delivery. With the use of analytics, data decision models, and state of the art technology, you will work directly with key client stakeholders committed to the OilTech disruption. You will lead initiatives to define and solve business problems.  You will be responsible for ensuring business value, communicating results, making executive presentations, and be a part of a leading business technology team, driven toward results. – If you are passionate about the latest technologies, making a difference, and contributing to an organization that is redefining the lubricant distribution sector, then we would like to speak with you.

SUMMARY  

The Database Engineer/Administrator will oversee the IT department’s IT and Business needs using Azure Data Lake and, Local SQL Databases to integrate application data for all business units. They will also be responsible for identifying what platforms and software is best for PetroChoice’s data/business specific needs and work with the Sr. IT Leadership to determine and acquire software to facilitate implementation.   This role will be the primary lead on all MS SQL databases and integrations. Other responsibilities will include IT project oversight, process improvements, and cross-functional system integration.

Responsibilities

ESSENTIAL DUTIES AND RESPONSIBILITIES include but are not limited to the following. The Company reserves the right to add to, delete, change, or modify the essential duties and responsibilities at any time.   All work is to be completed with minimum supervision and in accordance with Company standards.  Other duties may be assigned.

• Collaborate with stakeholders to understand data requirements and Translate them into data architecture solutions.
• Design and engineer efficient data pipelines to extract, transform, and load data from various sources into the data lake.
• Develop and maintain SQL scripts, stored procedures, views, and ETL processes. To support data integration and transformation.
• Perform data modeling to ensure data is structured and optimized for reporting and analysis.
• Work with existing data architectures and propose enhancements or new architectures as needed to meet evolving data needs.
• Implement data quality checks and monitoring processes to ensure data integrity.
• Troubleshoot and resolve issues with data pipelines, ensuring smooth and reliable data flow.
• Collaborate closely with report writers and BI analysts to provide them with the required data in the data lake.
• Stay current with the latest trends and best practices in data engineering and Azure technologies.
• Provide technical guidance and mentorship to team members as needed.

Qualifications

Education and Experience

4 Year/bachelor’s degree or equivalent work experience (4 years of experience in lieu of Bachelor's) in Computer Science, Computer Information Systems, Information Systems, Information Technology or Computer Engineering or equivalent work experience

• 6+ years of experience in data engineering, data architecture, or a related field in manufacturing or distribution industries.
• Strong Proficiency in SQL and Azure SQL Server, with hands-on experience in data modeling and schema design.
• Extensive experience with Azure Big Data technologies, including Azure Data Factory (ADF) and Azure Data Lake.
• Proven ability to design and implement robust data pipelines, ETL processes, and data architectures.
• Experience with data modeling and data quality assurance best practices.
• Experience delivering data mapping and accompanying documentation
• Familiarity with SSRS and Power BI, Python, R is a plus.
• Strong problem-solving, analytical, and troubleshooting skills.
• Excellent communication and collaboration abilities, with the ability to work with cross-functional teams.
• Bachelor’s degree in computer science, Information Technology, or a related field.
• SQL or Azure certifications are desirable but not required if the experience is evident.

 Competencies:

To perform the job successfully, an individual should demonstrate the following competencies to perform the essential functions of this position.

• Analytical — the individual synthesizes complex or diverse information.
• Problem solving — the individual identifies and resolves problems in a timely manner and gathers and analyzes information skillfully.
• Oral communication—the individual speaks clearly and persuasively in positive or negative situations, demonstrates group presentation skills and conducts meetings.
• Quality management—the individual looks for ways to improve and promote quality and demonstrates accuracy and thoroughness.
• Judgment—the individual displays willingness to make decisions, exhibits sound and accurate judgment and makes timely decisions.
• Planning/organizing—the individual prioritizes and plans work activities, uses time efficiently and develops realistic action plans.
• Safety and security—the individual actively promotes and personally observes safety and security procedures and uses equipment and materials properly.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Knowledge of system design, development, implementation, and user support principles and practices.
• Experience with database management
• Experience with project management principals
• Familiarity with information systems troubleshooting
• Ability to communicate technical information to a non-technical audience.

Computer Skills:

To perform this job successfully, an individual should have knowledge of Microsoft Word, Excel, PowerPoint, and other report writing and project planning software. Experience working in an ERP environment is desirable.

EOE