Data Analyst

Sentinel Peak Resources Management LLC•Bakersfield, CA

just now

About The Position

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.

Requirements

5 years of relevant industry experience in data analysis, data management, or related field
Bachelor’s Degree in Computer Science or related job experience
Highly proficient in SQL
Experience with Time Series Data Integration and Historians
Understanding of Master Data Management principles
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

Nice To Haves

Knowledge of oil and gas industry applications highly preferred
Python knowledge is a plus
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

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