Sr Analyst Data Analytics & Reporting

Republic Services•Phoenix, AZ

About The Position

POSITION SUMMARY: The Sr. Analyst Data Analytics & Reporting is responsible for gathering, analyzing and documenting technical specifications and data mappings from business requirements to provide accurate direction to application developers. The Sr. Analyst Data Analytics & Reporting leverages their analytical skills, knowledge of application tools and techniques to drive the development of services and analytical solutions that meet the business requirements. The Sr. Analyst Data Analytics & Reporting works closely with IT architecture and development teams to ensure product development meets design criteria and deployment timelines. The Sr. Analyst Data Analytics & Reporting is a data specialist who works with the SME’s to analyze and develop standards for preparing and delivering business reports. The Sr. Analyst Data Analytics & Reporting contributes to the overall improvement of business reporting by maintaining the data systems and implementing processes and initiatives that ultimately increase the effectiveness and integrity of data reporting and documentation. This role relies heavily on analytical skills to evaluate complex information, formulate insights, and develop sound recommendations to support the management of assets, inventory, work orders, planning & scheduling, warranty, vendor management, master data management and reporting & analytics. PRINCIPAL RESPONSIBILITIES: Standardizes, audits, queries, and cleanses system data and develops governance processes to maintain data cleanliness. Owns reports requirements development (technical specifications and data mapping requirements), rationalization and prioritization in conjunction with business partners. Partners with the business and functional leads to ensure business understanding of the code and what it is doing in a deployed environment. This includes training the end users by explaining detailed software mapping documents. Coordinates with other analysts to ensure alignment of middleware solutions across various business domains. Interfaces with executive and operational management to create software-mapping documents including transformations and software algorithms. Compiles information into various formats, may create executive briefings from entity relationship diagrams, logical architectures and presents information to executive and operational leadership in written and verbal forms. Defines and documents reporting metrics and how those metrics are calculated from source system data. Analyzes source data systems for content, writes technical definition specifications, report layouts/mockups and test scripts. Uses Rally or similar agile tools to create scorecards and reports for communicating metrics, goals and performance-to-date. Creates technical flow diagrams based on standards and process flow diagrams, wireframes and prototypes which are used to collaborate and guide development resources to rapidly develop integration assets. Uses query languages like SQL to mine data, create reports and uses the latest technology to identify and analyze performance trends. This includes performance and forecast impact on future results. May also make recommendations on use of information to improve results, including recommendations on changes to business processes. Constructs SQL queries in large-scale databases to provide research, audit and analysis of complex data needs. Develops quality training content and manages rollout of new or adjusted processes to the field. Develops and completes system and dashboard test scripts. Uses agile software tools to track performance and creates logical software flow diagrams to solve complicated business processes. Performs other job-related duties as assigned or apparent.

Requirements

Experience with business intelligence and Reporting tools like MSFT Power BI, Qlik, Tableau, Alteryx.
Experience in workflow modeling, data modeling, process engineering.
Experience using data virtualization tools and data catalogs like Denodo, AWS Glue, TIBCO Data Virtualization.
Demonstrated ability to extract data from large data warehouse (using SQL/SAS and/or Advanced Excel with Macros, Advanced Excel math Functions, Pivot tables, Pivot Charts and Excel dashboards for data analysis )
Solid working knowledge of SharePoint.
Minimum of 5 years of experience in a business or technical analysis role
Experience with project management techniques (i.e. 3 years experience with Agile, experience using Agile software tools such as Rally or similar tools)

Responsibilities

Standardizes, audits, queries, and cleanses system data and develops governance processes to maintain data cleanliness.
Owns reports requirements development (technical specifications and data mapping requirements), rationalization and prioritization in conjunction with business partners.
Partners with the business and functional leads to ensure business understanding of the code and what it is doing in a deployed environment. This includes training the end users by explaining detailed software mapping documents.
Coordinates with other analysts to ensure alignment of middleware solutions across various business domains.
Interfaces with executive and operational management to create software-mapping documents including transformations and software algorithms.
Compiles information into various formats, may create executive briefings from entity relationship diagrams, logical architectures and presents information to executive and operational leadership in written and verbal forms.
Defines and documents reporting metrics and how those metrics are calculated from source system data.
Analyzes source data systems for content, writes technical definition specifications, report layouts/mockups and test scripts.
Uses Rally or similar agile tools to create scorecards and reports for communicating metrics, goals and performance-to-date.
Creates technical flow diagrams based on standards and process flow diagrams, wireframes and prototypes which are used to collaborate and guide development resources to rapidly develop integration assets.
Uses query languages like SQL to mine data, create reports and uses the latest technology to identify and analyze performance trends. This includes performance and forecast impact on future results. May also make recommendations on use of information to improve results, including recommendations on changes to business processes.
Constructs SQL queries in large-scale databases to provide research, audit and analysis of complex data needs.
Develops quality training content and manages rollout of new or adjusted processes to the field.
Develops and completes system and dashboard test scripts.
Uses agile software tools to track performance and creates logical software flow diagrams to solve complicated business processes.
Performs other job-related duties as assigned or apparent.