Compensation $61,466.03 - $88,670.11
(Based on Experience)
Summary We are looking for an Applications Analyst to assist with Greater Detroit Regional Sewer System (GDRSS) compilation and Wholesale Automated Meter Reading (WAMR) billing, Data and/or report creation, Web portal and mobile app development and support. Maintaining HTML, Javascript, Python, and Oracle PL/SQL code.
Job Responsibilities - 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.
Required Education and Experience • Associate's 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 (e.g., 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.
Other Requirements - Valid Michigan Driver's License
Essential 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, 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 GLWA Service Area. Employees within this classification may be exposed to dust and electrical connections, and frequent work with computer equipment.
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.