Job description

Compensation $70,087.36 - $106,136.11 (Based on Experience) Summary We are looking for an Applications Analyst - Systems Integration to participate in the analysis, design, development, deployment, and support of data pipelines, data transformation, and integrations related to system implementations, business intelligence (reports/dashboards/KPIs), and other operational needs. Primarily, this position will develop and maintain data pipelines, transformations, and integrations between application systems and databases using API, ETL, and similar processes and tools. In addition, this position will design, develop, deploy, and support the tools, data stores, 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 are achieving exciting results using data and analytics technology! Job Responsibilities • Develops requirements for and creates, tests and maintains data feeds, integrations and integrations between application systems and databases using batch file import/export, ETL, API, webhooks, webservices (REST/SOAP), and similar processes using Python and other tools • Collaborate with ancillary system analysts and users, and software vendors to understand and develop business and functional ETL and integration requirement • Participates in projects and other initiatives that have integration, integration and reporting components • Uses Power BI, with familiarity in SSRS, Tableau, Qlik, Oracle, Telerik, and/or other types of business reporting software to visualization and analysis of data from one or more systems • Designs, develops, deploys, and supports the tools, data stores, 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 and dashboards for all business units and enterprise reporting needs • Performs basic data analysis and high-level data mining • Generates ad-hoc reports summarizing for operations, maintenance, asset management, finance and organizational development stakeholders • Assists with the support, maintenance and upgrade to production, testing and development environments as necessary • Consults and supports internal customers in developing analyses, reports, and dashboards which leads to actionable insights • Responds to, troubleshoots, and resolves incident and service request tickets • Plans and implements reports archival/retention strategy • Delivers quality written and presentation deliverables, including the ability to make technology understandable to end-users and generate clear and concise technical requirements and documentation • Works in a professional manner with access to confidential and sensitive data • Continues to learn and keeps up to date with start-of-the-art technology through training, webinars, events, and conferences • Power BI, API and Python experience is required Required Education and Experience At the time of application: • Bachelor's degree in computer science, computer engineering, information technology, engineering, construction, or related field, or an equivalent combination of skills, experience, and education • Three (3) to five (5) years related work experience • Power BI, API and Python experience is required • Acquire and maintain a vendor specific domain "professional", "expert" or "master" level certification (i.e. Microsoft Certified Solutions Expert: Sharepoint, Oracle Certified Professional JAVA SE Programmer or Certified Scrum Master) within two (2) years of Level 2 designation 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. Introduce Yourself Not the right fit? Let us know you're interested in a future opportunity by clicking Introduce Yourself in the top-right corner of the page or create an account to set up email alerts as new job postings become available that meet your interest.

Requirements