Req ID: 134134 Region: Americas Country: USA State/Province: New Hampshire City: Remote Employee US General Overview Functional Area: Supply Chain Management (SCM) Career Stream: Supply Chain Management (SCM) Role: Specialist (SPE) Job Title: Specialist, SCM Data Job Code: SPC-SCM-SCD Job Level: Level 08 Direct/Indirect Indicator: Indirect Summary Incumbents apply in-depth knowledge in a specific area of specialization. Work is performed within established professional standards and practices. Works on problems of moderate scope where analysis of situations or data requires a review of identifiable factors and a considerable degree of judgement. Erroneous decisions or failure to achieve results may have a negative impact on the division’s/department’s operations, schedules, and/or performance goals. Works under minimum Supervision. Seeks approval from others on matters outside of job/role scope. Receives instruction on specific assignment objectives and possible solutions. Unusual problems are solved jointly with manager. Work is reviewed for application of sound technical judgment. May lead a work group or project team consisting of technical and support staff. Builds internal and external relationships, with emphasis on those that facilitate the achievement of job/role accountabilities, such as relationships with key suppliers, customers and internal service. Detailed Description Performs tasks such as, but not limited to, the following: - Develops, and implements new systems and processes to support SCM business requirements. - Leads or participates in the implementation of ERP / decision support systems and solutions. - Designs and documents specifications for new systems, system enhancements or interfaces. Works with IT todevelop and implement programs. - Provides system, process, and training support for new acquisitions in areas of database development.. - Maintains processes that ensure the accuracy of ERP systems. - Conducts training on processes and procedures that affect data integrity. - Reviews, recommends and implements enhancements / new systems required by business. Implements andensures adherence to SCM policies and practices. Knowledge/Skills/Competencies Job Responsibilities - The Data Analyst is responsible for accelerating the development of analytics using Excel, Power BI & other platforms. - This role will bring together data from different sources to provide metrics and insights that enable visibility andimprovements to Supply Chain Operations - Work collaboratively with business partners at varying levels to identify, design and deliver reporting & analyticssolutions - Provides analysis, tracking of data and ongoing reporting, ad hoc analysis and partnership to share insights within thebusiness - Uses data to highlight key trends and collaborate with businesses to identify causes, costs and potentialinterventions/solutions - Lead multiple project activities simultaneously where prioritization skills are critical - Engaged in the team’s Lean Business Process objectives to provide continuous improvement Physical Demands Duties of this position are performed in a normal office environment. Duties may require extended periods of sitting and sustained visual concentration on a computer monitor or on numbers and other detailed data. Repetitive manual movements (e.g., data entry, using a computer mouse, using a calculator, etc.) are frequently required. Frequent overnight travel may be required. Salary The stated range includes Base Salary and target Short-Term Incentive (STI) compensation only. A comprehensive benefits package is offered in addition to this range. The range described in this posting is an estimate by the Company, and may change based on several factors, including but not limited to a change in the duties covered by the job posting, or the credentials, experience or geographic jurisdiction of the successful candidate. Salary Base Range: $74K-$99K Typical Experience Three to six years of relevant experience. Typical Education Three to six years of relevant experience. Notes This job description is not intended to be an exhaustive list of all duties and responsibilities of the position. Employees are held accountable for all duties of the job. Job duties and the % of time identified for any function are subject to change at any time. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Celestica's policy on equal employment opportunity prohibits discrimination based on race, color, creed, religion, national origin, gender, sexual orientation, gender identity, age, marital status, veteran or disability status, or other characteristics protected by law. This policy applies to hiring, promotion, discharge, pay, fringe benefits, job training, classification, referral and other aspects of employment and also states that retaliation against a person who files a charge of discrimination, participates in a discrimination proceeding, or otherwise opposes an unlawful employment practice will not be tolerated. All information will be kept confidential according to EEO guidelines. COMPANY OVERVIEW: Celestica (NYSE, TSX: CLS) enables the world's best brands. Through our recognized customer-centric approach, we partner with leading companies in Aerospace and Defense, Communications, Enterprise, HealthTech, Industrial, Capital Equipment and Energy to deliver solutions for their most complex challenges. As a leader in design, manufacturing, hardware platform and supply chain solutions, Celestica brings global expertise and insight at every stage of product development – from drawing board to full-scale production and after-market services for products from advanced medical devices, to highly engineered aviation systems, to next-generation hardware platform solutions for the Cloud. Headquartered in Toronto, with talented teams spanning 40+ locations in 13 countries across the Americas, Europe and Asia, we imagine, develop and deliver a better future with our customers. Celestica would like to thank all applicants, however, only qualified applicants will be contacted. Celestica does not accept unsolicited resumes from recruitment agencies or fee based recruitment services. This location is a US ITAR facility and these positions will involve the release of export controlled goods either directly to employees or through the employee's movement within the facility. As such, Celestica will require necessary information from all applicants upon an applicant's acceptance of employment to determine if any export control exemptions or licenses must be filed.

• Data Extraction: Pull health plan, member, provider, and operations data from various sources and databases using SQL • Data Analysis: Analyze large datasets to identify trends, patterns, and discrepancies across different types of operating data. • Provider Data Reconciliation: Reconcile provider data across internal systems and external sources to ensure accuracy, consistency, and completeness • Predictive Modeling: Build and apply predictive models to forecast member behavior, utilization trends, and operational outcomes • Reporting and Visualization: Create reports, dashboards, and visualizations to present complex findings in an accessible format for both technical and non-technical audiences/stakeholders. • Collaboration: Work with teams across the company to manage different types of data requests and to implement and evaluate data-driven solutions. • Data Quality: Ensure data integrity across our systems by identifying discrepancies and recommending/implementing data capture and maintenance standards/processes.

• Create, maintain, troubleshoot, and implement automated and ad-hoc solutions for reporting and analytical needs • Work cross functionally to support Inventory Team, Account Managers, Sales, Finance, and more • Develop and maintain complex spreadsheets in Excel, utilizing advanced formulas and functions to support data analysis and reporting • Troubleshoot and resolve reporting errors and data discrepancies within client-facing dashboards • Manage and maintain Business Intelligence tools, including Tableau, to support reporting and analytics needs • Maintain and enhance the existing Python codebase to support reporting, automation, and data workflows • Automate custom reports for stakeholders using Python to improve efficiency and scalability • Develop additional reports and analyses on an ad-hoc basis and support evolving business needs as required • Develop and maintain clear documentation and SOPs to support consistent data processes, knowledge sharing, and operational continuity

SENIOR ANALYST, FUNDRAISING DATA & ANALYTICS (CONTRACT) Duration: One-year contract Location: Remote, Preferred that the candidate be based between UTC−05:00 and UTC+00:00 Summary The Wikimedia Foundation is the non-profit organization that operates Wikipedia—one of the most popular websites in the world, serving nearly half a billion users every month. The Foundation is the only non-profit among the top 50 websites, and is supported by a community of millions of individual donors. Join the Wikimedia Foundation in our ambitious project to empower people to create and share the sum of all human knowledge. The fundraising team at the Wikimedia Foundation conducts worldwide campaigns across nearly 40 countries and 20 languages, collecting donations to support the Wikimedia Foundation’s mission to empower and engage people around the world with free knowledge. The Fundraising Operations team has an opening for a senior data analyst on our team, to support data-driven decisions to improve the effectiveness of our fundraising strategies, while staying true to our values of openness, transparency, and respect of user privacy. This role will be a full-time (40 hours/week) contractor position. As a Senior Data Analyst, you’ll be part of a small and collaborative analytics team with an analytics engineer and two fellow analysts, supported by the Senior Manager, Fundraising Data & Analytics as well as a data engineer on the adjacent fundraising technology team. This team supports our fundraising teams, from online fundraising to donor relations and major gifts. We organize our work in two-week sprints, with consistent backlog reviews, sprint plannings, mid-sprint reviews, and sprint retros. You’ll be joining at an important juncture for both the analytics team and the Foundation. We’ve recently completed an infrastructure migration to a more performant analytics stack and equipped our stakeholders with a self-serve reporting platform, so we’re well set up for working on the most important questions to fundraising. The web traffic landscape is changing quickly, and Wikimedia continues to diversify its fundraising channels and evaluate new approaches. Analytics partners in this work by modeling scenarios, giving fundraising teams visibility and alerting into trends, advising on experiments for evaluating new strategies, bringing in and modeling new data sources, and doing timely ad hoc analysis so that teams can quickly learn and iterate. Our updated stack includes dbt, Metabase, and Jupyter notebooks. Our lakehouse data infrastructure is built on MinIO for storage, using Apache Iceberg table format and Trino as query engine. Code reviews are currently in Gerrit and moving to GitLab. You are responsible for: - Delivering insights and analysis on global fundraising campaigns and fundraising strategic objectives to fundraising teams - Developing and tracking key performance indicators across different fundraising channels - Partnering with colleagues in fundraising and finance on multi-year revenue forecasting - Delivering reporting, statistical analysis, and guidance on testing within our iterative A/B testing program - Modeling the data upstream of your reporting and analysis, cleaning and transforming it in dbt - Peer reviewing your teammates’ work to ensure data quality and interpretability Some examples of the work you may do in the role: - Building and maintaining a donor propensity model to drive revenue across the fundraising program - Building out donor segments in an audience-building tool such as Hightouch - Building a model to personalize ask amount for a donor Skills and Experience: Subject matter expertise - Experienced in fundraising analytics, ideally in a large, international fundraising program - Experience analyzing digital marketing campaigns Technical skills - Highly proficient in SQL for data modeling and analytical queries - Skilled in developing clear data visualizations in a business intelligence platform - Practical statistical expertise for designing experiments and drawing valid conclusions from experimental results - Comfortable working with Python for more advanced calculations or analysis - Experience using predictive modeling to answer “business” questions - Experience efficiently troubleshooting SQL queries and pipelines to find the root cause of a data anomaly Collaboration - Comfortable with giving and receiving code reviews through git (GitLab, GitHub, Gerrit, etc.) - A record of clearly documenting your work for the benefit of your teammates and stakeholders - A record of estimating work accurately and surfacing obstacles to on-time delivery in a timely way - A practice of reaching out for support when stuck or blocked - A growth mindset, enjoy experimenting with new tools and methods - Excellent verbal and written communication skills including the ability to clearly communicate technical concepts to non-technical stakeholders - Experience in a remote work environment Qualities that are important to us: - Strong mission fit with the Wikimedia movement (e.g., freedom of speech, knowledge for everyone, community sharing) - Strong value fit with Wikimedia Foundation values (e.g., collaboration, curiosity, knowledge sharing) - Ability to work effectively across cultures Additionally, we’d love it if you have: - Experience with open source technologies and communities About the Wikimedia Foundation The Wikimedia Foundation is the nonprofit organization that operates Wikipedia and the other Wikimedia free knowledge projects. Our vision is a world in which every single human can freely share in the sum of all knowledge. We believe that everyone has the potential to contribute something to our shared knowledge, and that everyone should be able to access that knowledge freely. We host Wikipedia and the Wikimedia projects, build software experiences for reading, contributing, and sharing Wikimedia content, support the volunteer communities and partners who make Wikimedia possible, and advocate for policies that enable Wikimedia and free knowledge to thrive. The Wikimedia Foundation is a charitable, not-for-profit organization that relies on donations. We receive donations from millions of individuals around the world, with an average donation of about $15. We also receive donations through institutional grants and gifts. The Wikimedia Foundation is a United States 501(c)(3) tax-exempt organization with offices in San Francisco, California, USA. As an equal opportunity employer, the Wikimedia Foundation values having a diverse workforce and continuously strives to maintain an inclusive and equitable workplace. We encourage people with a diverse range of backgrounds to apply. We do not discriminate against any person based upon their race, traits historically associated with race, religion, color, national origin, sex, pregnancy or related medical conditions, parental status, sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, genetic information, or any other legally protected characteristics. The Wikimedia Foundation is a remote-first organization with staff members including contractors based 40+ countries*. Salaries at the Wikimedia Foundation are set in a way that is competitive, equitable, and consistent with our values and culture. The anticipated annual pay range of this position for applicants based within the United States is US$106,227 to US$167,858 with multiple individualized factors, including cost of living in the location, being the determinants of the offered pay. For applicants located outside of the US, the pay range will be adjusted to the country of hire. We neither ask for nor take into consideration the salary history of applicants. The compensation for a successful applicant will be based on their skills, experience and location. *Please note that we are currently able to hire in the following: US States: Arizona, California, Colorado, Connecticut, District of Columbia*, Florida, Georgia, Idaho, Illinois, Indiana, Iowa, Maryland, Massachusetts, Michigan, Minnesota, Missouri, New Jersey, New Mexico, New York, North Carolina, Ohio, Oklahoma, Oregon, Pennsylvania, Puerto Rico*, Rhode Island, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin and Wyoming (*US Territory or Federal District) Countries: Brazil, Canada, Colombia, France, Germany, Ghana, India, Indonesia, Italy, Kenya*, Mexico, Morocco, Netherlands, Poland, Singapore*, South Africa, Spain, Switzerland and the United Kingdom. Our non-US employees are hired through a local third party Employer of Record (EOR) and must have current work authorization in their location. (*native citizens/permanent residents only) We periodically review this list to streamline to ensure alignment with our hiring requirements. All applicants can reach out to their recruiter to understand more about the specific pay range for their location during the interview process. If you are a qualified applicant requiring assistance or an accommodation to complete any step of the application process due to a disability, you may contact us at recruiting@wikimedia.org or +1 (415) 839-6885. More information Applicant Privacy Policy Wikimedia Foundation What does the Wikimedia Foundation do? What makes Wikipedia different from social media platforms? Our Projects Our Tech Stack News from across the Wikimedia movement Wikimedia Blog Wikimedia 2030