Posted 1mo ago

Applications Analys- Business Intelligence- Level 3

@ Great Lakes Water Authority
Detroit, Michigan, United States
$89k-$141k/yrHybridFull Time
Responsibilities:defining requirements, analyzing systems, deploying applications
Requirements Summary:Develop and maintain Power BI dashboards with SQL and API integrations; analyze data for asset reliability; 5+ years required; bachelor’s degree in IT/engineering fields.
Technical Tools Mentioned:Power BI, SQL, APIs, Web Services, Programming
Save
Mark Applied
Hide Job
Report & Hide
Job Description

Compensation

$88,569.60 - $140,837.17

(Based on Experience)

Summary

We are seeking an Applications Analyst – Business Intelligence (BI) to develop and maintain Power BI dashboards built from multiple systems, such as the CMMS, using SQL and API integrations. These dashboards will provide clear data visualization and interpretation, transforming operational and maintenance data into actionable insights for daily decision making and long term asset reliability planning, optimizing maintenance strategies, reduced downtime, improving asset reliability, and supporting organizational efficiency and compliance.

In Addition, the incumbent should have a basic understanding of Reliability and Maintenance Engineering (RME), equipment mechanical integrity, and statistical data analysis. This knowledge will support the development and management of ad hoc reports and Power BI dashboards related to safety, costs, resources, etc.

Job Responsibilities

  • Meet with customers to define business requirements, applications and systems goals, and to identify and resolve applications and systems issues
  • Review and analyze the effectiveness and efficiency of existing applications and systems and develop strategies for improving or further leveraging these applications and systems
  • Assist in the deployment of new applications and in delivering enhancements to existing applications
  • Perform application design, configuration, and integration
  • Can develop and maintain programs written in common programming languages including stored procedures and web services
  • Conduct cost-benefit and return on investment analyses for applications and systems in order to aid management in making acquisition and implementation decisions
  • Coordinate and perform tests for existing and new applications, including user acceptance tests. Provide training to end users
  • Identify potential risks and dependencies between applications, systems and business processes and provide solutions, impacts and recommendations to resolve conflicts if they should arise
  • Develop application prototypes and mockups to present to the project user group to collect functional clarifications and requirements
  • Plan, design, and implement additions, upgrades, replacements, or retirement of applications including the database management environment on the Web to support the capacity to store a substantial amount of data
  • Ability to drive a motor vehicle on all terrain
  • Follow security and safety policies and procedures in carrying out work duties
  • Provide on the job training

Required Education and Experience

At the time of application, applicant must:

  • Bachelor’s degree in computer science, computer engineering, information technology, engineering, construction, or related field, or an equivalent combination of skills, experience, and education
  • A minimum of five (5) years of related work experience


Preferred Education and Experience

  • Manufacturing Process Environment Experience
  • Reliability and Maintenance Engineering (RME) Experience

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties. This position requires physical ability to climb, balance, stoop, kneel, crouch, crawl, reach, stand, walk, push, lift, finger, grasp, feel, talk, hear see, and perform repetitive motions. Essential duties require the mental and/or physical ability to work in a standard office environment; read fine print on blueprints and display terminals; converse by telephone, two-way radio and in person using writing instruments, calculators, and personal computers; and strength to lift and carry up to 40 pounds. The work requires the ability to distinguish colors and to hear audible alarms. Incumbents may be subject to potentially hazardous physical conditions, atmospheric conditions, extreme temperatures, intense noise, and/or vehicle traffic. Employees will also be required to pass a bio-mechanical physical. Environmental

Working Requirements

Work is performed within an office, plant environment, remote sites, or other locations within the GLWA Service Area. Employees within this classification may be exposed to dust and electrical connections, and frequent work with computer equipment.

Other Requirements

  • Valid Michigan Driver's License is required
  • Ability to work irregular hours, commute to GLWA facilities and work sites, and respond to after-hour emergencies and on-call responses

Benefits

Comprehensive benefits package effective the first of the month following 30 days of employment. This includes health, dental, vision, tuition reimbursement, and team member discount programs. Retirement and Retirement Health Savings are effective the first day of employment. Click HERE for more information.

Note: Part-Time employment is not eligible for health benefits, however, is eligible to participate in the 457 Retirement Plan.

GLWA is an equal opportunity employer.

Introduce Yourself

Not the right fit? Let us know you're interested in a future opportunity by clicking Introduce Yourself in the top-right corner of the page or create an account to set up email alerts as new job postings become available that meet your interest.