22 Apr
Applications Analyst - Systems Integration
Vacancy expired!
- 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
- Web-based programming languages (such as Python, Ruby, JavaScript, R); Python 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)
- Web technologies such as HTTP, HTML, CSS, JSON, REST, XML, SOAP, XSLT, DOM, JavaScript, Servlets, JSP, ASP, AJAX, SFTP, Web Services
- 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
- 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
- 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
Vacancy expired!