Applications Analyst - Business Intelligence
Great Lakes Water Authority
Date: 1 week ago
City: Detroit, MI
Contract type: Full time
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
Benefits
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.
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
Benefits
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.
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resume