Data Analyst II

The position:

This is a newly created position. The Finance team needs someone who can write SQL, build dashboards and explain what changed and why. This role supports operations and finance managers with weekly reporting, ad hoc analysis and KPI tracking. Remote, open to candidates across the US. Monday to Friday, regular working hours, flexible start and finish.

Day to day:

• Present results to managers and answer follow-up questions
• Investigate data quality issues and work with data engineering to fix them at the source
• Field ad hoc requests through a ticket queue and prioritize them with your manager
• Track sales, inventory or service levels against targets and flag misses early
• Build and maintain dashboards in Tableau, Power BI or Looker
• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Automate recurring Excel reports with Power Query, Python or scheduled SQL

Requirements:

• 3+ years of experience in a data or reporting analyst role
• Habit of checking your own numbers before anyone else sees them
• Advanced Excel: pivot tables, XLOOKUP, Power Query
• Able to juggle several requests and say when a deadline isn't realistic

Compensation and benefits:

The salary range for this role is $94,000 - $119,000 per year. This range reflects base salary only.

• Health savings account (HSA) with employer contribution
• 401(k) with a 100% match up to 5%
• Paid holidays
• Referral program
• Dental insurance
• Profit sharing

About us:

Public utility commissions regulate rates and service standards. Pension plan for most employees.

Frontier Energy is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.

Start: Within 30 days.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Frontier Energy.