What are the responsibilities and job description for the Data Analyst position at Sentinel Peak Resources Management LLC?
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 : $85,000 - $120,000