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