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
Location: , ,
Frontendnode-Production.up.railway.app – Railway: Apply Here