Applications Analyst- Business Intelligence- Level 3

Great Lakes Water Authority; United States; On-site; USD 91,000 - 145,000; Full time

Job summary

Great Lakes Water Authority is seeking an Applications Analyst – Business Intelligence (BI) to design and maintain Power BI dashboards pulling data from multiple systems, including CMMS, via SQL and API integrations. You will transform maintenance and operational data into actionable insights for daily decisions and long-term asset reliability planning.

The role requires a Bachelor’s degree and at least five years of related experience.

Qualifications

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

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

Skills

Power BI

SQL

APIs

Education

Bachelor’s degree in CS/IT/Engineering or related field

Tools

Power BI

SQL

API integrations

Job description

Compensation $91,226.69 - $145,062.29 (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. 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.

One Water, One Team When you work at Great Lakes Water Authority, you help make a difference in the environment and in your local community. “One water, one team” is more than just a phrase, it’s a way of doing business. Here, you don’t work for GLWA, you work with GLWA. And together, we’re racing toward a shared goal to become the region’s most-trusted, high-quality water and wastewater resource. We are all strategic partners on the path to becoming a Utility of the Future, and GLWA prioritizes the recruitment and selection of highly talented, well-qualified individuals to help us get there.

We have moved to a new recruiting system. You will need to create a new profile in this system and complete an application. You will have the option to upload your resume to streamline the application process. This will make all our future follow-ups a great experience! You can also track the status of your application with ease.