Data Analyst

Sentinel Peak Resources8 months ago
Bakersfield, CA, United States
Remote
Full-time
Junior Level (1-3 years)

Job Description

Job Type

Full-time

Description

BASIC PURPOSE OF POSITION:

The role of the Data Analyst is to help support and grow SPR's data ecosystem. The overall goal of the Data Analyst is to facilitate a seamless flow of information throughout the company, considering both backend data structure and front-end accessibility for end-users through reporting and analytics.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

  • Lead SPR's Data Quality and Governance initiatives by implementing proactive data quality checks and triaging data quality and integration discrepancies across applications and reports
  • Work with both technical and non-technical teams to gather requirements, ask clarifying questions, and contribute to root cause analysis efforts
  • Assist with managing and supporting SPR Master Data Management platform
  • Work with Operational Technology (SCADA) team to troubleshoot and address data quality issues
  • Manage ETL and procedural dependencies and scheduling
  • Help support SPR's Data Lake and Warehouse in Azure Databricks environment
  • Develop new reports and dashboards based on business requirements
  • Troubleshoot data quality issues and identify resolution
  • Identify slow running queries and implement optimization
  • Manage and respond to tickets in ticketing system
  • Work with end users and IT project teams to facilitate best practices for data access, data consumption, code management, and data integration

Requirements

POSITION SPECIFICATIONS:

  • 5 years of relevant industry experience in data analysis, data management, or related field
  • Knowledge of oil and gas industry applications highly preferred
  • Bachelor's Degree in Computer Science or related job experience
  • Highly proficient in SQL
  • Python knowledge is a plus
  • Experience with Time Series Data Integration and Historians
  • Understanding of Master Data Management principles
  • Knowledge of SPR's Azure Data stack technologies (Data Factory, Data Lake Storage, Databricks, PowerBI) is a plus
  • Experience with Microsoft on-prem analytics and reporting stack (MSSQL, SSIS, SSRS, SSAS) is a plus
  • Experience at working both independently and in a team-oriented, collaborative environment is essential
  • Strong written and oral communication skills
  • Strong interpersonal skills
  • Adept at conducting research into project-related issues, technology, and software products
  • Must be able to learn, understand, and apply new technologies
  • Ability to effectively prioritize and execute tasks in a high-pressure environment is crucial

Salary Description

$85,000-120,000 per year

Required Skills

Python
SSIS
Microsoft MSSQL
ETL Processes
Master Data Management
Data Quality and Governance
Azure Databricks
Data Analysis
SSAS
Data Management
Reporting and Analytics
SQL
SSRS
Data Warehousing
Data Integration
Data Lake