Lead Data Engineer

Job Description:

About Us

OPIS, a Dow Jones company, is one of the world’s most comprehensive sources for petroleum pricing and news information. OPIS provides real-time and historical spot, wholesale/rack and retail fuel prices for the refined products, renewable fuels and natural gas and gas liquids (LPG) industries. We deliver award-winning news, market intelligence and transparency to the entire refined energy marketplace and companies looking to go carbon neutral. At its core, OPIS uses a set of complex IT systems and tools, handling huge amounts of data in a reliable way, and providing customers with business applications to use this data as efficiently as possible.

Your Role

We are looking for a Lead Data Engineer that will design, develop and maintain database architecture and code initiatives supporting internal and third-party software solutions, delivering excellent products in scope and on time, and meeting current and long-term business needs for the business area. Participate in an agile team of motivated, driven, high-energy engineers, building trust and confidence with team members and business stakeholders. Lead, mentor, and coach junior data engineers to build stronger and faster teams.

Your Responsibilities

As an experienced and solution-oriented Lead Data Engineer your responsibilities will include, but are not limited to: working with our product teams to provide timely, effective and performant solutions; contributing to the design of scalable data solutions, including the development of automated pipelines; implementing and/or maintaining database systems to ensure the availability and consistent performance of our application suite; understand and define business data requirements and identify data needs and data sources to create scalable data architecture and support enhancements, new product and implementation. You will be a leader coaching, mentoring, and training team members driving both employee and team development and growth.

Your Expertise

• Degree in computer science, related technical field, or equivalent experience

• Minimum of 4 years database developer experience (SQL Server or equivalent)

• Ability to create data models for the integration of multiple systems

• Ability to create and maintain stored procedures

• Ability to write SQL queries and statements to explore source data and data issues

• Working knowledge of cloud data technologies and architecture

• Working knowledge of Python for data analysis and automation

• Working knowledge of building CI/CD pipelines for code deployment

• Proficiency in BI tooling, Power BI preferred

• Familiarity with data-specific unit testing frameworks

• Familiarity with PowerShell scripting for system administration and automation tasks

• Must speak and write in English fluently; Effective communicator

Does this sound like you?

• A strong analytical thinker with a love for planning and organization who can manage competing demands with minimal supervision

• A self-starter with a never-ending curiosity to learn and solve problems

• A critical thinker, with mad problem-solving skills

• A team player with great interpersonal and communication skills

• A structured developer, with good time-management skills

If these things strike a chord with you, we should talk.

We’d also love to hear about your experiences with any of the following:

• Degrees, Certifications, and/or awards/recognition that you have achieved

• Knowledge of SDLC, Agile methodology and/or SCRUM

• Experience working with scripts under source control (Git/TFVC/Mercurial/Svn/etc)

• Experience being part of a continuous integration and deployment process

• Experience using database monitoring tools (like tools from SolarWinds or RedGate)

Our Benefits

• Pension Scheme: Company contributes up to 8% of your salary with matching contributions.

• Healthcare Coverage: Comprehensive health plan with unlimited coverage, including outpatient care, dental, and maternity.

• Life & Disability Insurance: Coverage from day one, including life insurance at 2X salary and accident coverage up to 4X salary.

• Wellness Programs: Access to wellness platforms, mindfulness apps, and free fitness classes.

• Meal & Teleworking Allowance: Monthly meal card and teleworking allowance.

• Flexible Working: Ability to work from home 2 days per week with the option to work remotely for 1 week per quarter.

• Family Care Support: Up to 4 weeks of paid compassionate leave and a generous reimbursement for emergency care.

• Referral Bonus: Earn a bonus for recommending great talent to join us.

----------------------------------------------- 

Current Colleagues 

If you are currently employed by Dow Jones, please apply internally via the Workday internal careers site. 

Reasonable accommodation: Dow Jones, Making Careers Newsworthy - We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law. EEO/AA/M/F/Disabled/Vets. We strongly encourage applications from all qualified individuals, including women, people with disabilities, and those from underrepresented groups. Dow Jones is committed to providing reasonable accommodation for qualified individuals with disabilities, in our job application and/or interview process. If you need assistance or accommodation in completing your application, due to a disability, email us at [email protected]. Please put "Reasonable Accommodation" in the subject line and provide a brief description of the type of assistance you need. This inbox will not be monitored for application status updates.

Business Area:

Dow Jones - OPIS

Job Category:

Data Analytics/Warehousing & Business Intelligence

Union Status:

Non-Union role