Great Lakes Water Authority
Applications Analyst - Business Intelligence
Great Lakes Water Authority, Detroit, Michigan, United States, 48228
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 ResponsibilitiesDevelops 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 toolsCollaborate with ancillary system analysts and users, and software vendors to understand and develop business and functional ETL and integration requirementParticipates in projects and other initiatives that have integration, integration and reporting componentsUses Power BI, with familiarity in SSRS, Tableau, Qlik, Oracle, Telerik, and/or other types of business reporting softwareDesigns, develops, deploys, and supports the tools, data stores, cubes, models, stored procedures, and queries necessary to generate static and ad-hoc data queries and reportsDesigns, develops, implements, and supports new and existing reports for all business units and enterprise reporting needsPerforms basic data analysis and high-level data mining as necessaryGenerates ad-hoc reports summarizing business, financial, or economic data for review by executives, managers, clients, and/or other stakeholdersAssists with the support, maintenance and upgrade to production, testing and development environments as necessaryConsults and supports with internal customers to develop analyses which leads to actionable insightsWorks with several large and complex data models and cubesUnderstands different disaster recovery solutions for reporting systemsCollects and maintains classifications for data protection, disaster recovery or other purposesPlans and implements reports archival/retention strategyMaintains retention policies and performs archiving and/or purging activities in accordance with retention policiesContinues to learn and keep up to date with start-of-the-art technology through training, webinars and conferences related avenuesRequired 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 educationPossess 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 educationMeet all of the requirements to advance to Applications Analyst Level 3 within three (3) years of Level 2 designationOther Requirements
Valid Michigan Driver's License is requiredAbility to work irregular hours, commute to GLWA facilities and work sites, and respond to after hour emergencies and on-call responsesBenefits
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.
GLWA is an equal opportunity employer.
Other details
Job Family Applications AnalystJob Function Staff FunctionsPay Type SalaryEmployment Indicator At Will
Apply Now
$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 ResponsibilitiesDevelops 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 toolsCollaborate with ancillary system analysts and users, and software vendors to understand and develop business and functional ETL and integration requirementParticipates in projects and other initiatives that have integration, integration and reporting componentsUses Power BI, with familiarity in SSRS, Tableau, Qlik, Oracle, Telerik, and/or other types of business reporting softwareDesigns, develops, deploys, and supports the tools, data stores, cubes, models, stored procedures, and queries necessary to generate static and ad-hoc data queries and reportsDesigns, develops, implements, and supports new and existing reports for all business units and enterprise reporting needsPerforms basic data analysis and high-level data mining as necessaryGenerates ad-hoc reports summarizing business, financial, or economic data for review by executives, managers, clients, and/or other stakeholdersAssists with the support, maintenance and upgrade to production, testing and development environments as necessaryConsults and supports with internal customers to develop analyses which leads to actionable insightsWorks with several large and complex data models and cubesUnderstands different disaster recovery solutions for reporting systemsCollects and maintains classifications for data protection, disaster recovery or other purposesPlans and implements reports archival/retention strategyMaintains retention policies and performs archiving and/or purging activities in accordance with retention policiesContinues to learn and keep up to date with start-of-the-art technology through training, webinars and conferences related avenuesRequired 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 educationPossess 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 educationMeet all of the requirements to advance to Applications Analyst Level 3 within three (3) years of Level 2 designationOther Requirements
Valid Michigan Driver's License is requiredAbility to work irregular hours, commute to GLWA facilities and work sites, and respond to after hour emergencies and on-call responsesBenefits
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.
GLWA is an equal opportunity employer.
Other details
Job Family Applications AnalystJob Function Staff FunctionsPay Type SalaryEmployment Indicator At Will
Apply Now