Position Summary:
The ER&A Senior Analyst works with business intelligence tools, analytical databases, and multidimensional datasets, to create dashboards and reporting for business leaders to answer key business questions., They are responsible for data management, requirements gathering, report design/authoring, as well as ad-hoc analysis. The ER&A Senior Analyst utilizes strong business and technical knowledge to ensure the highest level of service and efficiency for the customer.
Key Responsibilities:
- Assist in training, documentation, and end-user support related to SAP Business Objects WebI query and Report development
- Assist in maintaining Azure Databases containing consolidated data used for report creation, ad-hoc data requests, and reporting processes
- Ability to understand financial and operational requests from the business and translate them into data requirements, acquire data from possible multiple sources and develop a reporting solution
Work with the managed service provider to ensure accurate data, trouble shoot BI application issues and development of new methodologies to move our analytics capabilities forward. - Assist with Data Warehouse enhancements and operations including trouble shooting data issues and requirements gathering for new data elements
- Understand, design and develop business intelligence solution components including SQL development, database integration, ETL processes, report and dashboard creation, and analytics deliverables.
- Design and build BI interfaces such as dashboards and reports using SAP Business Objects and
- Power BI for end-user reporting needs
- Work with team to improve efficiency and effectiveness of reporting
- Special projects as needed
Required Education & Experience:
- Strong knowledge of Excel, including formulas and macros
- SAP Business Objects WebI and Power BI or similar technical reporting experience a must
- Ideal candidate would have 3 to 5 years experience
- Ability to interact with diverse technical and non-technical groups, spanning organizational levels.
- BA/BS in Accounting, Finance, or IT related field
- Understanding of financial and operational analysis and reporting
- Ability to work within a cross-functional team setting and shifting priorities
- Good communication and interpersonal skills.
- Experience writing and understanding complex SQL queries
- Business experience in professional services environment
- Azure Data Factory experience desired but not required