Data Analyst - Missoula, Montana $55,000-$75,000/DOE
ELM Utility Services
Full-time
On-site
Missoula, Montana, United States
$55,000 - $75,000 USD yearly
Data Analyst - Missoula, Montana $55,000-$75,000/DOE
ELM Utility Services is an EEO Employer - M/F/Disability/Protected Veteran Status
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.
• Company Paid Life Insurance
• Paid-Time Off (PTO) for vacation and sick time (Accrues up to 80 hours per full year and increases with years of service.)
• 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
• 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, OpenStreetMap/QGIS) and support GIS endpoints consumed by the business.
• Collaboration & Support
• 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.
• 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/OpenStreetMap) and/or spatial data familiarity.
• Python/R for analytics and data manipulation.
• Cloud exposure (Azure preferred).
• Familiarity with database design/development methodologies.
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.
• Company Paid Life Insurance
• Paid-Time Off (PTO) for vacation and sick time (Accrues up to 80 hours per full year and increases with years of service.)
• 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
• 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, OpenStreetMap/QGIS) and support GIS endpoints consumed by the business.
• Collaboration & Support
• 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.
• 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/OpenStreetMap) and/or spatial data familiarity.
• Python/R for analytics and data manipulation.
• Cloud exposure (Azure preferred).
• Familiarity with database design/development methodologies.
Please visit our careers page to see more job opportunities.