We are looking for an Applications Analyst – Systems Integration to participate in the analysis, design, development, deployment, and support of data feeds, conversions, interfaces, and integrations related to system implementations, business intelligence (reports/dashboards/KPIs), and other operational needs. Primarily, this position will develop and maintain data feeds, conversions, interfaces, and integrations between application systems and databases using API, ETL, and similar processes and tools.
Also, 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, reports, and dashboards for all business units and enterprise reporting needs. Intelligent water management and decision-making are enhanced with system integration and data aggregation for reporting and the information and insights they bring to the surface.
At GLWA we use system integration and BI to analyze asset management and operations performance, optimize work activities, perform data audits, increase collaboration, leverage data in disparate systems, and tell our story. Come join our dynamic BI team who is achieving exciting results using data and analytics technology!
- Develops requirements for and creates, tests, and maintains data feeds, interfaces, and integrations between application systems and databases using batch file import/export, ETL, API, webhooks, web services (REST/SOAP), and similar processes and tools
- Collaborate with ancillary system analysts and users, and software vendors to understand and develop business and functional ETL and interface requirement
- Participates in projects and other initiatives that have integration, interface, and reporting components
- Uses Power BI, with familiarity in SSRS, Tableau, Qlik, Oracle, Telerik, and/or other types of business reporting software
- Designs develop, 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 and supports internal customers to develop analyses that lead to actionable insights
- Works with several large and complex data models and cubes
- 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 following retention policies
- Continues to learn and keep up to date with start-of-the-art technology through training, webinars, and conferences related avenues.
- Minimum of an associate degree in Computer Science, Information Technology, or related field and three (3) years of experience; or combination of related work experience and education
- Possess a domain-specific entry-level certification (e.g., Certified Business Process Analyst, Certified Entry-Level Python Programmer, Certified Business Intelligence Professional, etc.), or a combination of related work experience and education
- Meet all of the requirements to advance to Applications Analyst Level 3 within three (3) years of Level 2 designation
- Interface and ETL tools (e.g., Microsoft Flow, TIBCO, Snap Logic, Boomi, Integromat, Zapier, Apache Airflow, MuleSoft, etc.); at least experience with one tool is a requirement for this position
- Reporting tools (e.g., PowerBI, SSRS, Oracle, Tableau, Qlik, etc.); PowerBI or Tableau experience is a requirement for this position
- Concepts and procedures in one or more IT disciplines (i.e., system integration, database administration, networking, systems, or applications support, BI or project management)
- Operating system and server knowledge (Windows, Linux)
- Version Control Systems (such as CVS, SVN, GIT)
- Relational Databases (e.g., Microsoft SQL Server, Oracle, PostgreSQL, schema design, object model relationships); SQL Server is a requirement for this position
- Web Server (such as IIS, Apache, Mongrel, etc.)
- 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
- Principles and practices of the functions performed by IT Services
- Database and data architecture familiarity (e.g., structured, unstructured)
- BI architecture including design and configuration of Power BI-related server software
- PowerBI software including PowerBI Desktop, PowerBI Premium, and PowerBI Report server
- Cloud (e.g., AWS, Oracle, Microsoft, private hosted) and on-premises system interface experience
- Principles and techniques of systems analysis, design, and development lifecycle
- Installation and maintenance of hardware, software, application, database, and network components
- Knowledge of water and wastewater or other utility sector business functions and operations are preferred, but not required.
- 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 professionally 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 and generate clear and concise technical documentation
- Understand and translate the needs of varied business users into IT system requirements
- Demonstrate willingness and ability to successfully configure BI-related server software, develop BI dashboards, reports, and visuals, and modify data and databases including joining, transforming, and analyzing data
- Demonstrate willingness and ability to successfully design, develop, deploy, and support new and existing 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
- Apply innovation and vision in problem-solving and meeting objectives promptly
- Utilize logical approaches to analyze problems, pinpoint their sources, correct any errors, and redesign interfaces to prevent future problems
- 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, configure, remove, and make modifications to the technology
- Instruct, guide, and support groups or individuals on technology
- Interact and communicate with IT staff and business users including analyzing and translating requirements into functional and non-functional requirements
- Write technical and non-technical documentation including, but not limited to, interface requirements, configuration specification, and testing plans
- 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 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 and maintain confidentiality
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 the 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.
- A valid Michigan Driver's License is required.
- Ability to work irregular hours, commute to GLWA facilities and worksites, and respond to after-hour emergencies and on-call responses.
- Valid Michigan Driver’s License
- Ability to work irregular hours, commute to GLWA facilities and worksites, and respond to after-hour emergencies and on-call responses
THE WAY WE WORK
The Employees of GLWA...
- Work and accept responsibility to search for, create and execute new and innovative approaches to improve the performance of GLWA’s services and objectives
- Assist external and internal customers to serve their needs and take responsibility for continuously improving customer service
- Foster meaningful interaction among people through the exchange of information to produce understanding
- Continuously develop and use effective strategies and interpersonal styles to engage and guide others towards the accomplishment of identified objectives and goals in the best interest of the Organization and community
- Consistently work toward the common good of the organization and encourage others to do the same
- Conduct themselves at all times in a professionally appropriate and respectful manner following the GLWA Common Behaviors
- Apply the proper safety/security practices according to established protocols, guidelines, and policies
This title is a non-Civil Service and at-will position. The organization may in its sole discretion fill this position on a full-time or part-time basis. The organization may in its sole discretion utilize a contract of employment, “direct hire”, or other processes to fill the Position within this Title. Incumbency is a position within this title that does not create a property right or expectation for the incumbent. The presence of this title or the position within this title does not in any way restrict the organization’s sole discretion to utilize independent contractors or other means to provide for the performance of this work.
The above statements describe the general nature and level of work performed by employees assigned to this class. Incumbents may be required to perform job-related responsibilities and tasks other than those stated in this specification. Specific job duties may vary from position to position. Employees in this class are required to undergo alcohol and drug screening and are subject to a criminal background investigation.