Data Analyst - Missoula, Montana $55,000-$75,000/DOE

ELM Utility Services•Missoula, MT

1d•$55,000 - $75,000•Remote

About The Position

ELM Utility Services, with a team of over 1300 employees nationwide, is offering a great opportunity for a Data Analyst in the Missoula, Montana area. This position can be offered as a remote position to the right candidate pending interview. This position is open to early to mid-career candidates (1–5 years), and recent or soon-to-be graduates are encouraged to apply. Our team provides reporting services, database administration, and GIS endpoints used by operations and corporate groups for essential workflow and business management. This role is ideal for someone who enjoys solving real business problems with data, working in a collaborative environment, and building reliable reporting and analytics solutions across SQL Server / SSMS / T-SQL, Power BI, and SSRS.

Requirements

1–5 years of experience in data analysis, reporting, business analysis, or a related role (or equivalent project/internship experience).
Comfort, working directly with internal stakeholders to define requirements and deliver results.
Strong T-SQL skills and experience writing complex custom queries (T-SQL preferred).
Experience modifying/creating stored procedures in SQL Server and using SSMS.
Experience building dashboards/reports in Power BI (DAX competency a plus).
Understanding of basic ETL/data pipeline concepts.

Nice To Haves

SSRS / SQL Server Reporting Services (Report Builder, subscriptions, scheduled delivery).
GIS experience (ArcGIS Enterprise/Server, ESRI tools, QGIS/OpenStreetMap) and/or spatial data familiarity.
Python/R for analytics and data manipulation.
Cloud exposure (Azure preferred).
Familiarity with database design/development methodologies.

Responsibilities

SQL Server & T-SQL (core)
Write and maintain complex T-SQL queries, views, and stored procedures to support reporting and analytics.
Troubleshoot query performance and data quality issues; recommend indexing or query changes in partnership with DBAs/developers.
Build reusable datasets and definitions that keep reporting consistent across teams.
Power BI & Reporting (core)
Develop and maintain Power BI dashboards and interactive reports (DAX, Power Query, modeling, refresh strategies).
Create and support operational reporting using SSRS / SQL Server Reporting Services (Report Builder, subscriptions, parameterized reports).
Work with stakeholders to translate requirements into clear KPIs, report layouts, and self-service datasets.
Data Pipelines & Automation (core-to-growing)
Support basic ETL / data pipeline work (SQL-based ETL, scheduled jobs, incremental loads, validation checks).
Contribute to “automate everything” improvements: repeatable refreshes, standardized definitions, alerting, and documentation.
GIS / Python / Analytics (nice-to-have)
Use Python for analysis and data manipulation (e.g., pandas), and optionally GIS analytics (e.g., ArcGIS Enterprise/Server, ArcGIS Pro, spatial joins).
Work with GIS applications and datasets (ESRI, OpenStreetMap/QGIS) and support GIS endpoints consumed by the business.
Collaboration & Support
Partner with operations and corporate teams to understand workflow needs and deliver reporting that improves decision-making.
Communicate clearly, manage priorities in a fast-paced environment, and help triage urgent reporting/operational needs.

Benefits

Optional benefits like Medical, Dental, Vision, Life, Disability, FSA, H.S.A., and Teledoc.
Company Paid Life Insurance
Paid-Time Off (PTO) for vacation and sick time (Accrues up to 80 hours per full year and increases with years of service.)
6 Paid Holidays
401(k) plan
Bonuses for milestone anniversaries
Competitive pay based on experience
Long history of stable employment and promoting from within
Opportunity to lead and modernize production systems with meaningful operational impact

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume