Data Analyst - Missoula, Montana $55,000-$75,000/DOE

ELM Utility Services; Missoula (MT); Remote; USD 65,000 - 90,000; Full time

Benefits offered by this job

Medical (optional)

Dental (optional)

Vision (optional)

Life Insurance

Disability

FSA/HSA

Teladoc

Paid Time Off

6 paid holidays

401(k)

Job summary

ELM Utility Services in Missoula, MT is seeking a Data Analyst to build reliable reporting and analytics solutions. You will work with SQL Server, SSMS, Power BI, and SSRS to deliver KPI-driven insights and scalable data processes.

The role supports data pipelines, basic ETL, and collaboration with operations to improve decision-making. Remote flexibility is available for the right candidate, with a strong emphasis on data quality and stakeholder communication.

Qualifications

• 1–5 years of experience in data analysis, reporting, business analysis, or related work.
• Experience building dashboards/reports in Power BI; DAX knowledge is a plus.
• Strong T-SQL skills; experience writing complex queries and stored procedures.
• Familiarity with ETL concepts and SQL-based data pipelines.
• GIS experience (ArcGIS) and Python/R for analytics are nice-to-have.
• Cloud exposure (Azure) and SSRS experience are advantageous.

Responsibilities

• Write and maintain complex T-SQL queries and stored procedures.
• Develop and sustain Power BI dashboards and operational reports.
• Support ETL/data pipelines, scheduled jobs, and data quality checks.
• Collaborate with operations and stakeholders to translate requirements into KPIs and reports.
• Explore GIS data and analytics to support business decisions.

Skills

Data analysis

Reporting

Stakeholder collaboration

Problem solving

Tools

SQL Server

SSMS

Power BI

SSRS

DAX

Power Query

ArcGIS

QGIS/OpenStreetMap

SSIS

Azure Data Factory

Azure SQL

Python

R

Job description

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.

Our Total Rewards Package Includes:

• 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

Roles & Responsibilities:

• 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, 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.

Qualifications:

• 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/OpenStreetMap) and/or spatial data familiarity. Python/R for analytics and data manipulation. Cloud exposure (Azure preferred). Familiarity with database design/development methodologies.

WE ARE AN EQUAL OPPORTUNITY EMPLOYER