Senior Data Analyst - Enterprise Analytics Clive Analytics provides stakeholders with immediate BI access to data from Aon Connect (Oracle CRM). Our stakeholders include users of Aon Connect to executive leadership teams across Aon globally. The technical scope of the reporting team encompasses: + Data ETL Processes: This includes data replication (extraction), preparation (transformation), and integration into a comprehensive data model (load). We are currently operating within Oracle Autonomous Data Warehouse (ADW) and are transitioning to Databricks. + Dashboard Support and Development: Responsibilities include constructing/building dashboards, advising on dashboard creation and visualization, and training both authors and consumers. We serve as catalysts and advisors in the dashboard development process. + User Engagement: This involves conducting demonstrations, gathering user requirements, and ensuring effective communication with end users. + Data Validation and Quality Assurance: Ensuring the reliability of data presented to end users is critical. This includes validating data and identifying configuration issues within Aon Connect. + Data and Analytics Support: In addition to Clive analytics, support will also include other parts of the business the Enterprise Analytics manages. + Technology Transition: Dashboards and reports are currently developed in Oracle Analytics Cloud, with a planned migration to Power BI in Q3. Aon is in the business of better decisions At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organization, we are united through trust as one inclusive team and we are passionate about helping our colleagues and clients succeed. What the day will look like The team collaborates with data warehouse specialists and IT colleagues, while also engaging with end users across various levels of seniority. User administration for Clive dashboards is managed within this team. Innovation is a core focus, with an emphasis on automating processes and eliminating manual steps in data workflows. In addition to technical skills, the team values soft skills such as brand compliance, effective documentation, and communication through various channels (e.g., standard welcome emails, Teams, Aon Avenue). Managing the case queue and issue tracker is also part of the team's responsibilities. While primarily utilizing Aon Connect and Eloqua data, the team is also tasked with augmenting and enriching this data with additional sources and employing other business intelligence tools as needed. Duties and Responsibilities: Oversee the dashboard lifecycle, ensuring alignment with organizational goals and stakeholder needs. Dashboard Lifecycle Management + Lead and manage the entire lifecycle of dashboards: + Collaborate with collaborators to gather and refine requirements for dashboards. + Translate requirements into robust data models and visualizations. + Collaborate with team members and other groups to acquire necessary data and build data models. + Perform data validation and reconciliation to ensure dashboard accuracy. + Critically review requests, challenging customers when necessary, and ask clarifying questions to avoid assumptions. + Work effectively both independently and as part of a project team. + Provide support for other team functions Maintenance and Improvement + Oversee and manage 'Steady State Operations' to ensure seamless functionality. + Maintain data integrity and ensure regular data backups. + Continuously review and update existing dashboards to align with current standards and branding. + Address and resolve data-related issues and user inquiries, applying case management and issue tracking systems. + Monitor operational efficiency and generate reports on performance metrics. Training and Internal Communication + Conduct training sessions for both dashboard authors and consumers. + Deliver demonstrations to potential new users and leadership teams. + Develop and update training materials, including documentation and instructional videos. + Stay informed on industry trends and advancements through ongoing training and professional development. Development & Innovation + Drive innovation by exploring and implementing new features to enhance Clive IQ. + Conduct sentiment analysis to derive insights from data. + Apply machine learning techniques and predictive modeling to advance analytics capabilities. How this opportunity is different Aon’s Senior Data Analyst is uniquely positioned at the forefront of our Enterprise Analytics (EA) transformation, with direct influence over both technology strategy and business outcomes. Unlike competitors, our EA team members manage the complete analytics process—from ETL and data modeling to crafting dashboards and collaborating with interested parties. This role offers close collaboration with technologists, developers, and business leaders across all levels of the organization. Become a member of the inclusive Clive Analytics team, acknowledged for encouraging originality, cooperation, and personal advancement. Skills and experience that will lead to success + Strong analytical and logical thinking abilities. + Keen attention to detail. + Self-motivated and capable of independently managing tasks. + Effective great teammate with the ability to work autonomously. + Open to continuous learning and embracing innovation. + Proficient in Power BI and Power Automate. + Experienced in SQL and relational database management. How we support our colleagues In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions for our colleagues as well. Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued. Aon values an innovative and inclusive workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace. Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status. We are committed to providing equal employment opportunities and fostering an inclusive workplace. If you require accommodations during the application or interview process, please let us know. You can request accommodations by emailing us at ReasonableAccommodations@Aon.com or your recruiter. We will work with you to meet your needs and ensure a fair and equitable experience. #LI-Associate #LI-Remote #technology&security #li-jb3 2567281 Senior Data Analyst - Enterprise Analytics Clive Analytics provides stakeholders with immediate BI access to data from Aon Connect (Oracle CRM). Our stakeholders include users of Aon Connect to executive leadership teams across Aon globally. The technical scope of the reporting team encompasses: + Data ETL Processes: This includes data replication (extraction), preparation (transformation), and integration into a comprehensive data model (load). We are currently operating within Oracle Autonomous Data Warehouse (ADW) and are transitioning to Databricks. + Dashboard Support and Development: Responsibilities include constructing/building dashboards, advising on dashboard creation and visualization, and training both authors and consumers. We serve as catalysts and advisors in the dashboard development process. + User Engagement: This involves conducting demonstrations, gathering user requirements, and ensuring effective communication with end users. + Data Validation and Quality Assurance: Ensuring the reliability of data presented to end users is critical. This includes validating data and identifying configuration issues within Aon Connect. + Data and Analytics Support: In addition to Clive analytics, support will also include other parts of the business the Enterprise Analytics manages. + Technology Transition: Dashboards and reports are currently developed in Oracle Analytics Cloud, with a planned migration to Power BI in Q3. Aon is in the business of better decisions At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organization, we are united through trust as one inclusive team and we are passionate about helping our colleagues and clients succeed. What the day will look like The team collaborates with data warehouse specialists and IT colleagues, while also engaging with end users across various levels of seniority. User administration for Clive dashboards is managed within this team. Innovation is a core focus, with an emphasis on automating processes and eliminating manual steps in data workflows. In addition to technical skills, the team values soft skills such as brand compliance, effective documentation, and communication through various channels (e.g., standard welcome emails, Teams, Aon Avenue). Managing the case queue and issue tracker is also part of the team's responsibilities. While primarily utilizing Aon Connect and Eloqua data, the team is also tasked with augmenting and enriching this data with additional sources and employing other business intelligence tools as needed. Duties and Responsibilities: Oversee the dashboard lifecycle, ensuring alignment with organizational goals and stakeholder needs. Dashboard Lifecycle Management + Lead and manage the entire lifecycle of dashboards: + Collaborate with collaborators to gather and refine requirements for dashboards. + Translate requirements into robust data models and visualizations. + Collaborate with team members and other groups to acquire necessary data and build data models. + Perform data validation and reconciliation to ensure dashboard accuracy. + Critically review requests, challenging customers when necessary, and ask clarifying questions to avoid assumptions. + Work effectively both independently and as part of a project team. + Provide support for other team functions Maintenance and Improvement + Oversee and manage 'Steady State Operations' to ensure seamless functionality. + Maintain data integrity and ensure regular data backups. + Continuously review and update existing dashboards to align with current standards and branding. + Address and resolve data-related issues and user inquiries, applying case management and issue tracking systems. + Monitor operational efficiency and generate reports on performance metrics. Training and Internal Communication + Conduct training sessions for both dashboard authors and consumers. + Deliver demonstrations to potential new users and leadership teams. + Develop and update training materials, including documentation and instructional videos. + Stay informed on industry trends and advancements through ongoing training and professional development. Development & Innovation + Drive innovation by exploring and implementing new features to enhance Clive IQ. + Conduct sentiment analysis to derive insights from data. + Apply machine learning techniques and predictive modeling to advance analytics capabilities. How this opportunity is different Aon’s Senior Data Analyst is uniquely positioned at the forefront of our Enterprise Analytics (EA) transformation, with direct influence over both technology strategy and business outcomes. Unlike competitors, our EA team members manage the complete analytics process—from ETL and data modeling to crafting dashboards and collaborating with interested parties. This role offers close collaboration with technologists, developers, and business leaders across all levels of the organization. Become a member of the inclusive Clive Analytics team, acknowledged for encouraging originality, cooperation, and personal advancement. Skills and experience that will lead to success + Strong analytical and logical thinking abilities. + Keen attention to detail. + Self-motivated and capable of independently managing tasks. + Effective great teammate with the ability to work autonomously. + Open to continuous learning and embracing innovation. + Proficient in Power BI and Power Automate. + Experienced in SQL and relational database management. How we support our colleagues In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions for our colleagues as well. Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued. Aon values an innovative and inclusive workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace. Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status. We are committed to providing equal employment opportunities and fostering an inclusive workplace. If you require accommodations during the application or interview process, please let us know. You can request accommodations by emailing us at ReasonableAccommodations@Aon.com or your recruiter. We will work with you to meet your needs and ensure a fair and equitable experience. #LI-Associate #LI-Remote #technology&security #li-jb3