Junior Business Analyst - Data Visualization & Automation

Job Title: Junior Business Analyst - Data Visualization & Automation


Job Description:
The Division of Oil, Gas, and Mining seeks a motivated and detail-oriented Business Analyst with a natural curiosity to join our team. This entry-level role is perfect for someone eager to explore and uncover insights through data while leveraging low-code/no-code platforms to support and enhance our operations. The ideal candidate should have a strong interest in technology, a basic understanding of data analysis, and an insatiable desire to ask questions and seek out innovative solutions. Your curiosity will drive you to dig deeper into data trends, find patterns, and contribute to the responsible management of Utah's natural resources.
While experience with Salesforce is a plus, it is not required—training will be provided. The successful candidate will be expected to learn how to utilize Salesforce as a user and will be responsible for teaching others how to use the platform effectively. Additionally, the candidate will assist in troubleshooting and resolving issues related to Salesforce, providing support to colleagues as needed. They will also manage the intake, review, and routing of regulatory forms under Rule R649-8, perform quality control checks, verify well information, and ensure accurate record-keeping.


Principal Duties:

• Create and maintain interactive dashboards and reports using tools like Power BI to provide actionable insights.
• Automate business processes using low-code/no-code platforms such as Microsoft Power Apps and Google App Sheet.
• Learn the current platform in use and assist in the transition to Salesforce, including supporting team members throughout the process.
• Learn and utilize Salesforce effectively, supporting and training others in the division once the transition is complete.
• Assist with resolving issues related to both the current platform and Salesforce during and after the transition.
• Partner with various teams to gather data, streamline operations, and ensure efficiency.
• Manage the intake, review, and routing of regulatory forms under Rule R649-8. 
• Perform quality control checks, verify well information, and ensure accurate record-keeping.
• Produce and maintain reports for internal and public use, responding to inquiries as needed.
• Assist colleagues by learning their responsibilities and providing support as required.
• Organize meetings, create agendas, and document notes for distribution.
• Ensure the accuracy of recorded data through periodic audits and maintain records in the database.

• Has experience or knowledge in the oil and gas industry or a strong willingness to learn.
• Recent graduate with a degree in Business, Information Technology, Data Science, or a related field.
• Basic knowledge of data visualization tools (e.g., Power BI) and low-code/no-code platforms (e.g., Microsoft Power Apps, Google App-Sheet).
• A natural curiosity with the ability to ask the right questions, explore data trends, and seek innovative solutions.
• Willingness to learn Salesforce as a user and take on the responsibility of training others and troubleshooting as needed.
• Strong communication skills to effectively teach, support, and collaborate with colleagues.
• Ability to work well in a team environment while managing multiple tasks.

• 3 medical plan options. Choose a Traditional or High Deductible Health Plan.
• There is an Opt-Out Cash Benefit option for those who have other medical insurance coverage.
• 5 dental plan options, with an Opt-Out Cash Benefit option for those that have other dental insurance coverage.
• 4 vision plan options under EyeMed or OptiCare

• Employees who have any service credit with an employer covered by the Utah Retirement Systems before 7/1/2011 are in the Tier I Public Employees System.
• Employees hired on or after 7/1/2011 and who have never been in the URS retirement system have two options for retirement in the Tier II System.
  • Tier 2 Hybrid Retirement System. Employer contributes an amount equal to   10% of your salary between both plans (pension and 401(k))
  • Tier 2 Defined Contribution Plan. Employer contributes an amount equal to 10% of your salary to a 401(k) plan only.  
• Employer contributions to your 401(k) are vested after four years.

• Annual and sick leave are accrued at 4 hours per pay period each (4 hours annual, 4 hours sick).
• Annual leave amounts increase with years of service.
• We have 12 paid holidays.

Knowledge, skills, and abilities:

• Knowledge of standard business practices
• Knowledge of applications and programming
• Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications
• Skills in assessing workload and planning day to day schedule
• Ability to speak clearly and effectively
• Ability to listen to understand information presented verbally
• Knowledge of media production, communication, and dissemination techniques and methods. 
• This includes alternative ways to inform and entertain via written, oral, and visual media.
• Ability to establish good working relationships with operators, general public and other government agencies
• Ability to read, interpret and apply laws, rules, regulations, policies and /or procedures

• Risks found in the typical office setting, which is adequately lighted, heated and ventilated, e.g., safe use of office equipment, avoiding trips and falls, observing fire regulations, etc.
• Typically, the employee may sit comfortably to perform the work; however, there may be some walking; standing; bending; carrying light items; driving an automobile, etc. Special physical demands are not required to perform the work.