Level 1 Data Analyst

Company: ELM Locating & Utility Services

General Information
US-MT-Missoula
N/A
4 Year Degree
Full-Time
At least 1 year(s)
Not Specified
False
False
Job Description

DESCRIPTION OF POSITION’S ESSENTIAL FUNCTIONS:

ELM, a national utility services company based in Missoula, Montana, is hiring a Level 1 Data Analyst to our corporate IT staff. Our proprietary workflow software system, developed in-house using the Microsoft technology stack, includes Microsoft SQL Server as the central database repository. The successful candidate will possess an outgoing personality with strong critical thinking and data analysis skills.  This person will work closely with several support and operations personnel while leveraging a deep understanding of our production SQL Server databases to accomplish the following tasks:

  • Learn, understand and diagnose pricing and billing logic and data flow across multiple databases.
  • Support the Customer Support Services team with pricing and invoicing processes, customer setup and reporting.
  • Support Field Operations with data requests including ad-hoc reports and Microsoft Reporting Services published reports.
  • Support marketing and executive team with operations performance analysis and forecasting.
  • Job Requirements

    JOB REQUIREMENTS:

    • Very strong Microsoft Transact SQL (aka T-SQL, aka SQL Script) skills including writing and executing queries to accomplish analysis and reporting tasks.
    • Experience in an enterprise database environment. Comfortable working with hundreds of tables across multiple databases without compromising database integrity or responsiveness on production servers.
    • Ability to read, understand and occasionally write stored procedures, user defined functions and job scripts.


    QUALIFICATIONS:

    • Education – Bachelor Degree in IS, IT, BIS or equivalent desired.
    • Experience with SQL Server Management Studio, SQL Server 2008 or higher preferred.
    • Knowledge of MS Office (Excel, Access) VBA and SQL Server integration desired.
    • Working knowledge using and supporting Microsoft Reporting Services desired.
    • Fulfill a critical role in a small team that contributes daily to the success of the company.


    All qualified applicants will be considered. This is a fulltime, permanent position reporting to the Technology Coordinator in Missoula, Montana.  Competitive compensation package offered, salary DOE.

     

    APPLICATION PROCEDURE

    Apply by emailing your resume/application to Jake Brickzin at [Click Here to Email Your Resumé]. Please reference Job Code MTDA0417.

     

    WE ARE AN EQUAL OPPORTUNITY EMPLOYER