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:
- Special projects as needed
- Assist in training, documentation, and end-user support related to SAP Business Objects WebI query and Report development
- 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
Understand, design and develop business intelligence solution components including SQL development, database integration, ETL processes, report and dashboard creation, and analytics deliverables. - 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.
- Design and build BI interfaces such as dashboards and reports using SAP Business Objects and Power BI for end-user reporting needs
- Assist with Data Warehouse enhancements and operations including trouble shooting data issues and requirements gathering for new data elements
- Assist in maintaining Azure Databases containing consolidated data used for report creation, ad-hoc data requests, and reporting processes
- Work with team to improve efficiency and effectiveness of reporting
Required Education & Experience:
- BA/BS in Accounting, Finance, or IT related field
- Strong knowledge of Excel, including formulas and macros
- Business experience in professional services environment
- Ideal candidate would have 3 to 5 years experience
- Experience writing and understanding complex SQL queries
- Azure Data Factory experience desired but not required
- Ability to interact with diverse technical and non-technical groups, spanning organizational levels.
- Balance of Technical and Finance/Business experience
- Good communication and interpersonal skills.
- SAP Business Objects WebI and Power BI or similar technical reporting experience a must
- Ability to work within a cross-functional team setting and shifting priorities
- Willing to express ideas execute on these ideas
- Understanding of financial and operational analysis and reporting