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:
- Work with team to improve efficiency and effectiveness of reporting
- 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
- 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 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
- Assist with Data Warehouse enhancements and operations including trouble shooting data issues and requirements gathering for new data elements
- 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.
- Special projects as needed
Required Education & Experience:
- BA/BS in Accounting, Finance, or IT related field
- Ability to interact with diverse technical and non-technical groups, spanning organizational levels.
- Strong knowledge of Excel, including formulas and macros
- Business experience in professional services environment
- Good communication and interpersonal skills.
- SAP Business Objects WebI and Power BI or similar technical reporting experience a must
- Understanding of financial and operational analysis and reporting
- Experience writing and understanding complex SQL queries
- Ideal candidate would have 3 to 5 years experience
- Azure Data Factory experience desired but not required
- Ability to work within a cross-functional team setting and shifting priorities