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.ResponsibilitiesWrite and maintain complex T-SQL queries, views, and stored procedures to support reporting and analyticsTroubleshoot query performance and data quality issues; recommend indexing or query changes in partnership with DBAs/developersBuild reusable datasets and definitions that keep reporting consistent across teamsDevelop 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 datasetsSupport 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 documentationUse 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 businessPartner with operations and corporate teams to understand workflow needs and deliver reporting that improves decision-makingCommunicate clearly, manage priorities in a fast-paced environment, and help triage urgent reporting/operational needsSkills1–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 resultsStrong T-SQL skills and experience writing complex custom queries (T-SQL preferred)Experience modifying/creating stored procedures in SQL Server and using SSMSExperience building dashboards/reports in Power BI (DAX competency a plus)Understanding of basic ETL/data pipeline conceptsExposure to tools like SSIS, Azure Data Factory, Azure SQL, or similarSSRS / SQL Server Reporting Services (Report Builder, subscriptions, scheduled delivery)GIS experience (ArcGIS Enterprise/Server, ESRI tools, QGIS/OpenStreetMap) and/or spatial data familiarityPython/R for analytics and data manipulationCloud exposure (Azure preferred)Familiarity with database design/development methodologiesBenefitsOptional benefits like Medical, Dental, Vision, Life, Disability, FSA, H.S.A., and Teladoc.Company Paid Life InsurancePaid-Time Off (PTO) for vacation and sick time6 Paid Holidays401(k) planBonuses for milestone anniversariesCompetitive pay based on experienceLong history of stable employment and promoting from withinOpportunity to lead and modernize production systems with meaningful operational impactCompany OverviewELM 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