Data Analyst ($55,000 to $75,000/annually DOE)

🌍 Remote, USA 🚀 Full-time 🕐 Posted Recently

Job Description

ELM Utility Services is a company with over 1300 employees nationwide, seeking a Data Analyst in the Missoula, Montana area. The role involves solving business problems with data, developing reporting and analytics solutions, and collaborating with teams to enhance decision-making processes.

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

Skills

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
Exposure to tools like SSIS, Azure Data Factory, Azure SQL, or similar
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

Benefits

Optional benefits like Medical, Dental, Vision, Life, Disability, FSA, H.S.A., and Teladoc.
Company Paid Life Insurance
Paid-Time Off (PTO) for vacation and sick time
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

Company Overview

ELM Utility Services specializing in public utility locating helping utilities and contractors find and mark underground infrastructure. It was founded in 1998, and is headquartered in Peoria, Illinois, USA, with a workforce of 1001-5000 employees. Its website is https://elmutility.com/.

Apply To This Job