Data Analytics Engineer

Attractivate Consulting Solutions; Houston (TX); Hybrid; USD 80,000 - 100,000; Full time

Job summary

A consulting firm located in Houston is seeking a skilled data analyst to develop and maintain data models, focusing on maintenance operations in the Oil & Gas sector. Responsibilities include transforming data into actionable insights, creating dashboards, and collaborating on key performance indicators. The ideal candidate has strong skills in Python and SQL, experience in dashboard creation, and excellent communication abilities to convey technical concepts clearly. This is a hybrid role offering a contract opportunity with potential for full-time employment.

Responsibilities

• Transform raw data into actionable reports using SQL and Python.
• Create and maintain dashboards for preventative and predictive maintenance.
• Collaborate cross-functionally to identify data requirements and KPIs.
• Ensure high data quality through rigorous testing and validation.

Skills

Proficiency in Python

Proficiency in SQL

Knowledge of API rules

Experience with GitHub

Familiarity with Machine Learning

Expertise in dashboard creation

Strong organizational skills

Excellent communication skills

Analytical and problem-solving skills

Tools

Power BI

SQL

Python

Tableau

Excel

Spotfire

Job description

Type: 6 Month Contract (Full-time is possible after contract period)

Schedule: Hybrid (3-4 days onsite)

Sector: Oil & Gas

Location: Houston, TX

Overview

You will be instrumental in developing and maintaining data models while delivering insightful analyses of maintenance operations, including uptime/downtime, work order metrics, and asset health.

Key Responsibilities

• Aggregate and transform raw data from systems such as CMMS, ERP, and SCADA into refined datasets and actionable reports/visualizations using tools like SQL, Python, Power BI, and/or Spotfire.
• Own the creation and maintenance of dashboards for preventative and predictive maintenance.
• Collaborate cross-functionally to identify data requirements, key performance indicators (KPIs), and reporting gaps.
• Ensure high data quality through rigorous testing, validation, and documentation.

Qualifications and Skills

• Proficiency in Python and SQL is essential.
• Knowledge of API rules and protocols.
• Experience organizing development workflows using GitHub.
• Familiarity with Machine Learning is a plus.
• Preference for candidates with experience in water midstream/infrastructure or Oil & Gas sectors.
• Expertise in dashboard creation using tools like Tableau, Spotfire, Excel, or Power BI.
• Ability to clearly communicate technical concepts to non-technical stakeholders.
• Strong organizational skills and a customer-service mindset.
• Capability to work independently or collaboratively with minimal supervision.
• Exceptional analytical and problem-solving skills, with a strategic approach to prioritization.
• Ability to analyze data, situations, and processes to make informed decisions or resolve issues, with regular communication to management.
• Excellent written and verbal communication skills.