Applications Analyst- Business Intelligence- Level 3

Great Lakes Water Authority; Detroit, Northern (MI, KY); Hybrid; USD 91,000 - 145,000; Full time

Job summary

Great Lakes Water Authority in Detroit, MI seeks an Applications Analyst – Business Intelligence (Level 3) to build and maintain Power BI dashboards from multiple systems using SQL and API integrations, translating operational data into actionable insights for reliability and efficiency.

The role collaborates with customers to define requirements, deploy new applications, design and test configurations, and deliver ad hoc reports while upholding security and compliance standards.

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 issues.
• Review and analyze the effectiveness of existing applications and systems and develop improvement strategies.
• Assist in deployment of new applications and enhancements to existing ones.
• Perform application design, configuration, and integration.
• Develop and maintain programs including stored procedures and web services.
• Conduct cost-benefit and ROI analyses to aid management decisions.
• Coordinate and perform tests, including user acceptance tests, and provide end-user training.
• Identify risks and dependencies and provide solutions and recommendations.
• Develop prototypes/mockups to gather requirements from users.
• Plan, design and implement additions/upgrades/replacements of applications and databases.
• Follow security policies and work safely in the environment.

Skills

Power BI dashboards

SQL

API integrations

Data visualization

Data analysis

Education

Bachelor's degree in CS/IT/engineering or related field

Job description

## Applications Analyst- Business Intelligence- Level 3Apply: 9300 W. Jefferson Detroit, MI 48209: Full time: Posted 6 Days Ago: R26\\_0000000205**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. 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.