• Assist the team in day-to-day tasks spanning various activities throughout the organization, emphasizing process enhancement, data and business analysis, corporate initiatives, and documentation • Acquire proficiency in navigating C1 ’s intranet; editing and indexing techniques to update the Transformation Office intranet page effectively • Gather, interpret, and analyze extensive datasets and databases to derive insights • Learn and demonstrate proficiency in utilizing internal software systems • Cultivate a culture that champions continuous improvement and embraces positive change in alignment with C1 's mission and vision, furthering its tradition of excellence • Actively participate in departmental and team meetings • Fulfill additional responsibilities or duties as reasonably assigned by C1 to contribute to the operational and financial success of the Company

This team member will support the ops360 and anaplan connections for personal investor operational readiness and help inform connectivity across those products and the OR team, as well as cross PI initiatives and analysis for senior leaders Core Responsibilities 1. Engages with internal partners to understand business strategy, questions and goals. Brings structure to business requests, translates requirements into an analytical project approach, and leads complex projects through completion. Delegates tasks and provides tactical and strategic guidance to peers. Serves as the analytics expert on cross-functional teams for large strategic initiatives. Qualifications Minimum of five years related work experience. Undergraduate degree or equivalent combination of training and experience. Graduate degree preferred. Advanced SQL: complex window. functions, query optimization, stored procedures for automation. Advanced Data Visualization experience (Tableau). Special Factors Sponsorship Vanguard is not offering visa sponsorship for this position. About Vanguard At Vanguard, we don't just have a mission—we're on a mission. To work for the long-term financial wellbeing of our clients. To lead through product and services that transform our clients' lives. To learn and develop our skills as individuals and as a team. From Malvern to Melbourne, our mission drives us forward and inspires us to be our best. How We Work Vanguard has implemented a hybrid working model for the majority of our crew members, designed to capture the benefits of enhanced flexibility while enabling in-person learning, collaboration, and connection. We believe our mission-driven and highly collaborative culture is a critical enabler to support long-term client outcomes and enrich the employee experience.

• Lead cross-functional projects using advanced data modeling and analysis techniques to discover insights that will guide strategic decisions and uncover optimization opportunities • Undertake data collection and implement business product solutions • Build, develop and maintain data models, reporting systems, data automation systems, dashboards and performance metrics that support key business decisions • Design and build technical processes to address business issues • Identify, analyze, and interpret trends or patterns in complex data sets • Perform data consolidation/data analysis and communicate findings in a clear manner to external clients • Communicate directly with internal stakeholders as well as clients to translate business/data challenges into reports, insights, and analysis • Create and maintain dashboards to track partner’s KPI in data visualization software (Data Studio, PowerBI, Tableau) • Develop and implement data collection systems, data analyses and new strategies to measure campaign performances • Create documentation for various types of reports including methodologies, templates in Excel, slides, and/or sheets for training purposes • Work closely with clients, programmers, and functional teams to design business intelligence and operational reporting solutions for decision making and compliance monitoring • Research industry changes & provide insight on how to proceed with new processes • Train, develop and assist on supervising analyst-level employees • Ad-hoc special projects

About Airship Airship is trusted by world’s leading brands such as Alaska Airlines, BBC and The Home Depot to drive revenue growth and customer loyalty with exceptional cross-channel customer experiences. Today, brands are challenged to deliver seamless, unified customer experiences across a fragmented array of channels and devices— apps, websites, email, SMS, wallets and more. Airship’s no-code, AI-powered platform was designed with non-technical, growth-focused teams in mind, making it easy to create, test and orchestrate hyper-personalized experiences across all channels. With the ability to easily enrich customer data and rapidly launch growth experiments, Airship enables brands to deliver consistent, meaningful interactions that accelerate conversion and foster deeper customer relationships. We invite you to be part of our journey in building products and delivering services that touch millions of customers around the world every day. To learn more about us, visit www.airship.com, read our blog or follow us on LinkedIn. About the Role You are an experienced data analyst with a track record of extracting insights and actionable information from structured data. You have built dashboards for daily review, summarized results for executive stakeholders, and explained nuanced findings for non-technical audiences. You work with diverse teams who come to you with half-formed problems to refine their needs into answerable questions, answer those questions, and work with them until they understand the implications. What You'll Do Build dashboards using business intelligence software on large relational databases, both customer-facing and for internal customers Develop, support, and optimize semantic data layers used for self-service reporting Perform ad-hoc analyses for stakeholders on a variety of teams, including product, marketing, and engineering Use LookML to describe dimensions, aggregates, calculations and data relationships in a SQL database Collaborate with product and engineering to ensure that the requisite data is being collected to answer questions, drive business decisions, and inform the market Inform schema design and ETL process decision making Improve the end user’s experience through documentation, webinars, and hands-on training Support administration of our business intelligence software Investigate data integrity issues and propose solutions What We're Looking For 3+ year of data analysis or analytics experience Demonstrated experience in querying large data sets and relational databases (SQL) Understanding of the concepts of conditional logic and language syntax of programming languages Experience with web-based business intelligence tools such as Looker, Tableau, Chartio, or similar Strong communication skills Experience experimenting with AI tools in your personal or professional life - or an eagerness to learn! Work Location & Travel Requirements Compensation The starting base pay range for this position is: $100,000 - $120,000 USD per year . Base pay is part of the total compensation package and is determined by a variety of factors such as relevant skills, work experience, business priorities, market demands, and location. All offers include stock options so employees have the opportunity to benefit from Airship’s success. Benefits & Perks Competitive medical, dental, and vision insurance options for you and your dependents Flexible time off, company paid holidays, paid parental leave, and paid volunteer time off Support for your overall wellbeing with mental health and wellness resources Employer-subsidized life insurance as well as short-term and long-term disability A digital-first work environment and a monthly stipend to support remote work Mentorship and growth opportunities to build skills and accelerate professional development And more! California residents can view the CCPA disclosure notice here. ** Please Note: To ensure the security of your personal information, Airship will only contact candidates through email addresses ending with “@airship.com”. Hiring Commitment Airship is committed to fostering a diverse work environment and providing equal employment opportunities to all applicants and employees. We welcome your application and our hiring and employment decisions are made irrespective of race, religion, color, national origin, gender, gender expression, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by law. In alignment with our commitment to equal opportunity, Airship will consider for employment all qualified applicants, including those with criminal histories, in a way that adheres to the principles of fairness and the requirements of local Fair Chance laws, where applicable. By submitting this application, I affirm that the facts set forth in it are true and complete to the best of my knowledge. I understand that if I am employed, false statements, omissions, or misleading information given in my application, interview(s), or in a background check may result in dismissal.