Rush Amro

Leading the Business Insights division - managing a team of over 15 data analysts, engineers and business analysts.

· Performed statistical analysis on a diverse range of commercial datasets to understand key revenue streams and cost savings opportunities.

· Provided clear and concise presentations to key business decision makers to utilise data in driving business strategy.

· Ensured closer alignment with key business stakeholders by placing emphasis on relationship management, communication and collaboration with domain experts.

· Applying data visualisation and data management expertise in complex client reporting projects - utilising Azure software such as Fabric, Synapse, data factory and databricks, as well as PowerBI, Qlikview and Looker for visualisations.

· Establishing a data strategy to enable scaling of business data - enabling new key revenue streams for investment and strategy teams.

· Restructure of data function into specialised squads, with a focus on collaborating closely with key business areas to enable data to drive business value.

· Enabling data teams to work in a SDLC whilst also ensuring high intensity business requirements and timelines are met.

· Management of all data requests and needs for the organisation and clients.

· Adhoc requests, utilising SQL and Excel to help process and create and analyse financial and investment reporting for pharma clients as well as private equity investors in the business.

· Pushed for the scale up the team to modernise and meet the needs of the entire business fully in house, including reforming the request process, hiring new data prospects, mentoring data analysts within the business, as well as creating a new data development framework.

· Completed over 1,000 data requests, ranging from large complex projects, to small data pulls.

· Ensured seamless communication with stakeholders and timely delivery of requests, following data governance and development processes

· Designed and implemented custom dashboards for real-time analytics, improving decision-making processes and increasing operational efficiency by over 40%

· Applied skills in SQL, Azure, Project Management, Business Analysis, PowerBI, and Azure Synapse/Data factory.

· Improving data quality and data product reliability through working and maintaining a close relationship with data governance and data quality assurance.

· Helped coach and mentor future data talent through apprenticeship schemes, as well as providing training to business users to help democratise data within Sciencus.

· Led and managed the end-to-end process of client and business intelligence data requests, overseeing the development of 50 + reports and data solutions.

· Worked closely with business stakeholders and 3rd party clients to collect complex data requirements and manage the delivery of these projects within strict timelines.

· Established a data governance and quality forum to ensure data quality is kept to a high standard and relevant to business rules.

· Successfully led the roll out of Snowflake and DBT software, ensuring full training to team members - enabling highly scalable, cost efficient data pipelines to meet the growing 3rd party client reporting needs.

· Deployed python code in GCP, and AWS environments to maintain pipelines from data vendors, establish new data models, and proactively develop new data capabilities.

· Monitored usage and collected feedback to ensure continuous delivery of business value through solutions.

· Collaborated with a team of analysts to understand client reporting and analytics needs, implementing an efficient ticketing system to streamline client requests and deliver solutions within specified timelines.

· Managed EMEA BigQuery and Snowflake data warehouses, optimising tables for efficient querying and creating views with complex business logic.

· Utilised Power BI, Tableau, and Looker to automate reports and deliver complex investment financial reporting, supporting EMEA BI Developers in maintaining best practices for fast, smooth, and reliable reports.

· Oversaw a team of 10 BI and Data analysts to deliver a wide variety of data products, including ad-hoc analytics, data pipelines, and automated reports.

· Collaborated with Investment Management leadership and consultants to integrate new data sources, streamline data pipelines, and address ad-hoc queries in a timely manner.

· Statistical analysis of complex investment management and property data sets, generating customised reports and dashboards, and provided actionable insights to key stakeholders.

· Utilised SSIS (migrated to Azure Data Factory), Python and SQL to build and maintain highly scalable data warehouses in cloud.

· Establish new metrics and calculations to improve investment decision making and property management.

· Developed stored procedures and views for efficient data retrieval and manipulation.

· Led initiatives to liaise with investment teams to ensure decision-making needs were met, and facilitated communication between teams for cohesive data strategies.

· Led and mentored junior business intelligence analysts as well as business users interested in SQL and PowerBI, providing feedback and tasks to help develop future data talent for Lloyds Banking Group.

· Develop predictive data models to forecast future investment and property costs and returns accurately.

· Economic and statistic analysis of complex finance and banking data in SQL, Excel, PowerBI and Tableau, providing findings in clear and concise powerpoint presentations.

· Directed Data projects to implement reporting tools for finance, investment analysis, and operational reporting.

· Developed ad-hoc queries, v lookups, macros, and dashboards for operational, change management, and investment analysis purposes

· Collaborated with tech teams to automate processes for operational efficiency.

· Established skills to become dedicated Business Change manager within 3 months.

· Helped establish and scale up the Change Management process to ensure operational stability and timely deployment of changes by technical teams.

· Managed Information Security projects to ensure business compliance with external ISO Standards.

· Utilised sales skills in B2B sales with extensive training in financial services.

· Demonstrated leadership by taking ownership of and improving business processes for efficiency improvements throughout the organisation.

· Took ownership of data products and delivery throughout the business, transforming the data strategy into a cohesive business wide initiative.

· Partook in graduate leadership training, enabling ownership and confidence in complex projects.

· Learned from industry experts how to analyse financial products performance in Excel.

· Utilised advanced Excel functions including Vlookups, pivot tables, VBA, and Macros to develop reports for clients.

· Generated PowerPoint slides for client presentations.

· Demonstrated clear communication skills with clients and established key business relationships.

· Applied macroeconomic and econometric principles in forecasting product performance.

· Contributed to market research initiatives, gaining valuable industry insight.