Apply on Employer Site

ELM Utility Services · 1 day ago

Data Analyst ($55,000 - $75,000 Annually DOE)

Missoula, MT

Full-time

Hybrid

Entry, Mid Level

$55K/yr - $75K/yr

1+ years exp

ELM Utility Services is a nationwide company with a team of over 1300 employees, offering an opportunity for a Data Analyst in the Missoula, Montana area. The role involves solving business problems through data analysis, developing reporting solutions, and collaborating with teams to enhance decision-making.

ManufacturingPublic SafetyService Industry

Responsibilities

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

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

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

(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)

(Nice-to-have) Work with GIS applications and datasets (ESRI, OpenStreetMap/QGIS) and support GIS endpoints consumed by the business

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

Qualification

T-SQLPower BISQL ServerETLSSRSPythonGISAzure

Required

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

Preferred

Exposure to tools like SSIS, Azure Data Factory, Azure SQL, or similar

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

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