Applications Analyst - Business Intelligence

Applications Analyst - Business Intelligence 6425 Huber St, Detroit, MI 48211, USA Job Description Posted Wednesday, August 9, 2023 at 4:00 AM Compensation: $65,270 - $127,337 (Based on Experience) Summary We are looking for an Applications Analyst – Business Intelligence to participate in the analysis, design, development, deployment, and support of data feeds, conversions, integrations, 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, integrations 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, 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 is 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 and 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 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 and supports with internal customers to develop analyses which leads 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 in accordance with 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 Minimum of associate degree in Computer Science, Information Technology, or related field and five (5) 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 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 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 Comprehensive benefits package effective 30 days after employment, including health, dental, vision, tuition reimbursement, 401k, and team member discount programs. Click HERE for more information. #J-18808-Ljbffr Great Lakes Water Authority