Data Analyst - DOE

Overview

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.

• Voluntary Medical, Dental, Vision, Life, Disability, FSA, H.S.A., and Teladoc.
• Company Paid Life Insurance up to $50,000
• Paid-Time Off (PTO) for vacation and sick time purposes
• 6 Paid Holidays
• 401(k) plan
• Bonuses for milestone anniversaries
• Annual Reviews with potential for increases
• 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
• 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.
• (Nice-to-have) Exposure to tools like SSIS, Azure Data Factory, Azure SQL, or similar
• GIS / Python / Analytics (nice-to-have)
• (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, Open Street Map /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.

• Education & Experience
• 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.
• Technical Skills (must-have / strongly preferred)
• 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-have
• SSRS / SQL Server Reporting Services (Report Builder, subscriptions, scheduled delivery).
• GIS experience (ArcGIS Enterprise/Server, ESRI tools, QGIS/Open Street Map ) and/or spatial data familiarity.
• Python/R for analytics and data manipulation.
• Familiarity with database design/development methodologies.