Data Analyst ($55,000 to $75,000/annually DOE)
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