Reporting to the Head of Data Analytics, this person supports B2B in a complex and collaborative environment to create reports that support finance, commercial, and the sales functions. Using knowledge of business operations and data warehouse tools, the analyst will make reporting recommendations to address business problems and/or inefficiencies. The Reporting Analyst will own and lead projects in support of the business units, in collaboration with their business team peers. The Analyst will work on reporting development efforts mainly within the new data warehouse but also the Microstrategy tool. Analyst will also drive the design of more complex reports including dashboards and presentations that will be used directly by managers to make better business decisions.
Build statistical models, diagnoses, validates, and improves the performance of these models over time in addition to creating efficient and reusable SQL code meant for the improvement, manipulation, and analysis of Business data.
Lead on MicroStrategy development, Microstrategy Dashboards, Microstrategy Cubes design code.
Migration of key business reports & dashboards to new data warehouse platform and Microstrategy.
Design, build and implement datasets for large business reporting via SQL (Workbench)
Interpreting volumes of data from several billing systems and presenting their findings in a clear and concise manor
Weekly and Monthly base and revenue reporting
Perform exploratory and ad hoc data analysis with a view to generating business insights and using this to deliver actionable recommendations to the business. This process is both in reactions to requests from the business, but also as a proactive activity.
Represent analytics in a way that is business-user friendly and easy to interpret.
Working with key Business stakeholders and Commercial to conduct analysis to identify target groups across all of Business segments.
Develop report enhancements, including the creation of new reporting templates and analytical reports.
Modeling tools for data warehouse architecture
Strong analytical mind and problem solving
Ability to efficiently establish priorities and effectively meet deadlines on key data projects
Ability to interact effectively with others, focusing upon the attainment of goals and objectives through a commitment to teamwork
Key Performance Indicators:
Migration of data to new EDW and automation via Microstrategy
Reporting Design and building
Automation of reports
Competency Profile :
Influencing & Winning Commitment
Strong knowledge of SQL (Must)
Knowledge of Data Warehouses (Must)
Strong knowledge of Excel (Must)
Proficient in Microstrategy (Good to have)