Diversified Gas & Oil Corporation (DGOC) is seeking an O.T. Data Analyst to develop new data-driven solutions and expand technical approaches to solve complex business problems with a data-centric approach, serving customers from field personnel to the boardroom.
Requirements
- Development experience in one or more relational database platforms.
- Experience developing and maintaining production facing visualization with tools such as Grafana, Power BI, Spotfire, Plotly.
- Strong analytical skills to support data analysis and integration efforts.
- Advanced capability to write SQL queries, manage ETL processes, and complex system integrations.
- Experience at creating SQL objects: stored procedures, triggers, rules, views, and user defined data types or functions.
- Experience with DB platforms such as Postgres Timescale, Snowflake, MSSQL, Oracle
- One or more language skills: Python, C-Sharp, PowerShell
Responsibilities
- Creating reports and dashboards that make complex data readily consumable.
- Creating data pipelines that automate the flow and transformation of data between key systems.
- Debugging and optimizing performance of queries, reports, dashboards, and data pipelines.
- Troubleshoot data pipeline issues, develop new data pipelines as needed.
- Develop and maintain processes to transform inbound data into standardized schemas.
- Work with source system owners to identify and correct data quality issues.
- Identify technical problems and work to resolve the issues, leveraging internal and external resources.
Other
- Customers will range from field personnel to the boardroom.
- great customer facing skills to support requirements gathering, visualization development and customer adoption.
- Operational skillsets.
- Engineering skillsets.
- Architecture skillsets.
- Bachelor’s degree in computer information systems or a related combination of education and experience.
- Willingness to provide after-hours support when required.
- Desire to help others achieve success, interfaces well with others, and keen to assist and learn about areas outside assigned responsibilities.
- Ownership and accountability. Identify the problem, own it.
- Self-starter with a strong desire to deliver superior results.
- Strong analytical and problem-solving skills.
- Ability to prioritize concurrent and competing priority assignments.
- Excellent interpersonal and written/verbal communication skills.
- Ability to travel up to 10% including field visits with customers for requirements gathering and training.