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. We are racing toward a shared goal to become the region’s most-trusted, high-quality water and wastewater resource.
We are looking for a Applications Analyst - Business Intelligence (BI) to participate in the analysis, design, development, deployment, and support of enterprise dashboards and reports related to business intelligence and other operational needs. This position will design, develop, deploy, and support the tools, data stores, cubes, models, stored procedures and queries to generate static and ad-hoc data queries and reports; along with new existing reports for all business units and enterprise reporting needs. In addition, this position will assist with the development and maintenance of data feeds, interfaces and integrations between application systems and databases using API, ETL, and similar processes. Intelligent water management and decision making is enhanced with BI and the information and insights it brings to the surface. At GLWA we use BI to analyze system performance, optimize work, increase collaboration, and tell our story. Come join our dynamic BI team who are achieving exciting results using data and analytics technology!
- Uses Power BI and SSRS, with familiarity in Oracle, Crystal Reports, and other types of business reporting software
- Designs, develops, deploys, and supports the tools, data stores, cubes, models, stored procedures, and queries necessary to generate static and ad-hoc data queries and reports
- Designs, develops, implements, and supports new and existing reports for all business units and enterprise reporting needs
- Performs basic data analysis and high-level data mining as necessary
- Generates ad-hoc reports summarizing business, financial, or economic data for review by executives, managers, clients, and/or other stakeholders
- Assists with the support, maintenance and upgrade to production, testing and development environments as necessary
- Consults with internal customers to develop analyses which leads to actionable insights
- Works with several large and complex data models and cubes
- Develops and maintains data feeds, interfaces and integrations between application systems and databases using API, ETL, and similar processes
- Understands different disaster recovery solutions for reporting systems
- Collects and maintains classifications for data protection, disaster recovery or other purposes
- Plans and implements reports archival/retention strategy
- Maintains retention policies and performs archiving and/or purging activities in accordance with retention policies
- Associate degree in Computer Science, Information Technology, or related field and one (1) to three (3) years of experience; or combination of related work experience and education
- Possess a domain-specific entry level certification (i.e. Certified Business Process Analyst, Certified Entry-Level Python Programmer, Certified Business Intelligence Professional, etc.)
- Meet all of the requirements to advance to Applications Analyst Level 2 within two (2) years of Level 1 designation
- Concepts and procedures in one or more IT disciplines (i.e. networking, database administration, systems or applications support, BI or project management)
- User interface design and graphic software
- Operating system knowledge (Windows, Linux)
- Version Control Systems (such as CVS, SVN, GIT)
- Relational Databases (Oracle, SQL Server, schema design, object model relationships)
- Web Server (such as Apache, Tomcat, Mongrel, IIS)
- System Development Lifecycle, Agile and/or DevOps development methodologies
- COBIT and ITIL, including Change Management, Software/Systems Development Life Cycle for application development and management
- Reporting tools (PowerBI, SSRS, Cognos, Oracle, Crystal Reports, Tableau, Qlikview, etc.)
- Principles and practices of the functions performed by IT Services
- BI architecture including design and configuration of Power BI-related server software
- PowerBI software including PowerBI Desktop, PowerBI Premium, and PowerBI Report server
- SQL, PostgreSQL, Oracle and/or other RDBMS skills including development skills
- Principles and techniques of systems analysis, design, and development lifecycle
- Installation and maintenance of hardware, software, application, database, and network components
- Water and wastewater business functions and operations
- Independently, and as part of a team providing timely, high quality customer-focused services
- Use of advanced technology to perform in a busy environment, with frequent interruptions and still be able to prioritize and resolve conflicting requests
- Work in a professional manner with access to confidential and other data types
- Exercise good judgment, discretion, maintain confidentiality, and work with independence, initiative, and professionalism
- Work in a team environment that provides the capacity for IT project delivery
- Resolve technology and user issues to end-users of varying computing skills
- Deliver quality written and presentations, including the ability to make technology understandable to end-users
- Understand and translate the needs of varied business users into IT system requirements
- Demonstrate willingness and ability to actively and successfully configure BI-related server software, develop BI dashboards, reports and visuals, and modify databases including joining, transforming and analyzing data
- Demonstrate willingness and ability to actively and successfully configure interfaces and integrations using tools, software, scripting, ETL processes and APIs.
- Work independently, and as part of a team, providing timely and high-quality customer-focused services
- Demonstrate critical and creative thinking ability
- Define appropriate technical approaches and solutions to projects and business initiatives
- Determine critical project criteria to ensure project completion
- Demonstrate leadership skills and deep understanding of IT principles and procedures
- Organize, perform and or oversee technology tasks and projects
- Install, remove, and make modifications to technology
- Instruct groups or individuals on technology
- Interact and communicate with IT staff and business users
- Write technical and non-technical documentation
- Apply IT policies and programs in a manner aligned with the GLWA’s and BI mission, goals, values, and strategies
- Learn new application software packages, operating systems, and IT processes and procedures
- Establish and maintain effective working relationships with others
- Communicate effectively, both verbally and in writing
- Understand and follow verbal and written instructions
- Establish and maintain effective working relationships with others, and lead team activities or to work as a team member
- Communicate frequently with team members and other units across IT and the organization about data, process, dashboard/report, interface/integration, infrastructure or other potential problems
- Develop proficiency in unit specific operations and software
- Maintain regular and reliable attendance
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, pull, 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 Great Lakes Water Authority (GLWA) service area. Employees within this classification may be exposed to dust and electrical connections, and frequent work with computer equipment.
- 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.
We are all strategic partners on the path to becoming a Utility of the Future, and GLWA prioritizes the selection of highly talented, well-qualified individuals to help us get there.
We are dedicated to expertly delivering the nation’s best water and wastewater services to southeast Michigan. We offer competitive pay and the starting wage or salary, if hired, is variable. Factors such as your proven hard and soft skills, your level of education, history in the sector or industry, and meaningful work experience will all be evaluated.
We also offer an opportunity for advancement, on the job training, ongoing professional development, tuition assistance and a career in a sector that safeguards public health, supports and strengthen communities, and protects the environment.
We are an equal opportunity employer and value diversity at our organization. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability.