Resources, assessments, and opportunity evidence

Free and low-cost learning first

Resource	Best use	Access and limits
OpenStax Principles of Financial Accounting	Refresh accounting vocabulary, statements, and transaction-to-statement connections.	Free online textbook. Select only the chapters needed for the weekly exercise.
Microsoft Excel formulas and functions overview	Practice formulas and built-in functions with Microsoft’s downloadable workbook.	Online learning page; access to Excel software may require a separate license. Check what is already available before budgeting.
SQLBolt	Interactive query practice: filtering, joins, grouping, and subqueries.	Browser-based lessons; no credential. Use synthetic data for finance examples.
PostgreSQL tutorial	Optional practice in a relational database after basic SQL.	Official documentation; installation is optional for the core plan.
Microsoft Learn Power BI	Data preparation, modeling, and reports.	Learning paths are free. Power BI Desktop availability is platform dependent; verify access before choosing the tool.
NYU Stern Corporate Finance Online Class	Corporate-finance concepts through 36 short webcasts (about 12–20 minutes each), with slides and post-class tests/solutions.	Public materials in English. Select only relevant sessions; practice time is additional.
NYU Stern Valuation Online Class	Valuation concepts through 25 short webcasts (about 12–20 minutes each), with slides, post-class tests/solutions, and application tools.	Public materials in English. Select only relevant sessions; practice time is additional.
Banco de México SIDIE datasets	Explore Mexican financial and payments-related datasets and definitions.	Public dataset portal; availability and terms vary by dataset. Record source, date range, definitions, and limitations.

Language: Microsoft Learn has English and Spanish paths. The linked OpenStax, SQLBolt, Excel, and NYU Stern learning materials are in English; the Banco de México portal offers an English-language option. Confirm language and subtitle availability on the specific resource before relying on them.

Credentials: only pay for a specific gap

Credential	Coverage and prerequisites	Cost, effort, and recommendation
Microsoft Office Specialist: Excel Associate (MO-210)	Excel workbooks, cells/ranges, tables, formulas/functions, charts. Microsoft describes an approximately 150-hour instruction/hands-on candidate profile. Check exam language and local provider availability before scheduling.	Microsoft’s page prices exams by testing region and does not state the current Mexico price. Defer unless Excel assessment exposes a meaningful gap and an employer sample values the credential.
Microsoft Certified: Power BI Data Analyst Associate (PL-300)	Data preparation, modeling, visualization/analysis, and Power BI management/security. Microsoft lists Spanish and English exam languages and a 12-month renewal frequency. No mandatory prerequisite is stated on the certification page.	Learning paths are free; exam price depends on country/region and must be confirmed at scheduling. Optional, after completing and independently validating the Power BI project.
Azure Fundamentals (AZ-900) or AWS Certified Cloud Practitioner	General cloud concepts.	Not required for finance analysis or payment analytics based on the accessible posting evidence; defer unless a target role explicitly asks for cloud fundamentals.
FinOps Certified Practitioner	Cloud financial management and cost optimization, a distinct cloud-cost practice.	Current official price/access details were not independently verified in this research. Not part of the FinTech plan; consider only for a separate cloud FinOps direction.

Budget recommendation: MXN $0 in exam spending during the 12-week core, assuming access to a computer and spreadsheet software. This is a spending recommendation, not a verified statement that every tool or optional resource is free. Check license terms and exam scheduling prices before purchase. No exam is an application prerequisite in this plan.

Study effort estimates: allocate the 10 weekly hours as described in the paths. Credential preparation hours depend on baseline; no provider time-to-pass claim is made here.

Portfolio specifications

Keep the two projects small, reproducible, and clearly labeled as independent learning projects using synthetic or public data. Do not use employer, customer, account, or personally identifying data.

1. Finance performance and forecast: a synthetic transaction/ledger dataset; data dictionary; budget-versus-actual workbook; reconciliation and exception log; driver-based 12-month forecast with base/upside/downside cases; SQL checks; a concise dashboard or report; and a one-page memo that separates measured results from assumptions.
2. Payments analysis: synthetic transaction-level records plus an optional public Banco de México aggregate series for context; documented definitions for approval, refunds, disputes, and net contribution; SQL transformations; control checks; segment/cohort analysis with sample-size caveats; visual summary; and a short English presentation.

For either project, preserve the raw inputs, source/version/date, assumptions, formulas or queries, test cases, reconciliation evidence, known limitations, and instructions to reproduce one key result. The month-nine investment analysis can be a further learning artifact, not a substitute for the two core projects.

Connect evidence to applications

• Résumé: describe a learning project as a project, not employment. Use action + method + verifiable output; include numbers only when they can be reproduced. Represent internship or other work separately and accurately.
• Interviews: rehearse a 30–45 minute Excel reconciliation/forecast exercise, a short SQL join/aggregation task, a finance case explaining profit versus cash, and a five-minute English project walkthrough with follow-up questions.
• Manageable routine: reserve one weekly session to search employer sites and record 3–5 relevant postings; compare actual required/preferred skills and eligibility, then submit up to 1–3 well-matched applications per week when suitable roles exist. This is a planning suggestion, not a market-volume expectation. A remote label alone does not prove Mexico eligibility.
• Every two weeks: review completed project checks, recurring errors, application responses, and interview feedback. Change the next two-week priority based on this evidence; do not add a certification just to fill time.

First seven days

1. Confirm privately the available weekly hours, software/computer access, training budget, work authorization, graduation timing, English/Spanish working level, and acceptable work arrangement.
2. Complete the short Excel, SQL, finance, and communication baseline exercises on the overview.
3. Create a small synthetic ledger and write its data dictionary, source note, assumptions, and expected reconciliation totals.
4. Check the Citi and PepsiCo pages in the dated opportunity snapshot directly; record whether they are open and whether the detailed eligibility fits.
5. Explain one finding in English for two minutes and ask a reviewer to check the calculation and clarity.

Dated opportunity snapshot

Research date: October 14, 2026. This is a limited evidence sample, not a full count of the Mexico market. Listing content and availability can change. Confirm each role on the employer’s page before relying on it.

Employer and exact title	Location / arrangement	Eligibility and skills directly visible in the posting	Verification status
Citi — Banking, Corporate Banking, Full-Time Analyst, Mexico City, 2027	Mexico City; hybrid; full time	Final-year student graduating by Dec 2026 or June 2027, or graduate within the last two years; fluent English and Spanish. Work includes data preparation, proposals, strategic planning, research, and financial performance evaluation. No certification requirement or salary appeared in fetched content.	Employer page opened and detailed requirements were available on Oct 14, 2026; active application status/closing date was not explicit in retrieved content. Graduation date and language eligibility must be checked.
Citi — Services, Full-Time Analyst, Mexico City, 2027	Mexico City; arrangement not stated in fetched detail; full time	Final-year student graduating by June 2027 or graduate within the last two years; fluent English and Spanish; analytical problem solving and basic Word, Access, Excel, PowerPoint. Rotations across Services business functions.	Employer page opened and detailed requirements were available on Oct 14, 2026; application status/closing date was not explicit. It is treasury/services/payment-adjacent, not cloud FinOps. No salary visible.
PepsiCo — Finance Support Analyst – Digital Planning	Miguel Hidalgo, Mexico	Fetched employer page exposed the title and location only. Degree, experience, English, skills, arrangement, pay, and posting status could not be verified from returned content.	Employer listing page returned a title and location on Oct 14, 2026; insufficient detail to establish current eligibility or whether applications remain open.

Leads that are not verified openings

The following surfaced on a third-party job board or repost but were not verified as active on an employer page in this research. Do not count them as confirmed opportunities:

• Bimbo — Financial Analyst (Bilingual), Álvaro Obregón — third-party listing; content and current status inaccessible for verification.
• Banorte — Analista Financiero, Cuauhtémoc — third-party listing; details/status unverified.
• MAPFRE — Analista Financiero Cobranza, Benito Juárez — third-party listing; details/status unverified; collections finance is not investment strategy.
• Junior Business & Project Finance Analyst, Benito Juárez — employer identity and details were not verified.
• Amazon — Finance Analyst Intern — third-party lead; not verified as an active Amazon posting.
• EY “Finance Staff 1” / “Consultor Jr. Finance” surfaced through Indeed, but a matching active EY employer posting was not confirmed.

Other researched leads named by learners—HP, Avery Dennison, PayJoy, Morgan Stanley, Banco Plata, and DaCodes—should be searched directly on their career sites. They are not represented here as current vacancies. A graduate program, “junior” label, or remote designation does not by itself establish Mexico eligibility.

Progression reference

EPAM — Senior Financial Analyst is a senior reference, not an entry-level benchmark. Its employer page lists a computing/engineering/information-systems-related degree, at least three years of direct applicable finance/accounting/FinOps/technology-business-management experience, accounting and close knowledge, allocation, amortization, controls, collaboration, and B2+ English. This is a progression signal, not a promise that this learning plan meets the position’s criteria.

Role-to-skill assessment

Do not assign a proficiency level from a self-rating alone. Use the baseline tasks on the overview before tailoring this matrix.

Skill / eligibility	Evidence in postings reviewed	Starting level	Target evidence	Priority and assessment
Graduation timing / work authorization	Citi programs define specific graduation windows; work authorization requirements must be checked in each live posting.	Assess privately.	Confirm month/year and legal eligibility for each application.	Gate: verify before applying.
English and Spanish	Citi postings require fluency in both. A test score alone does not prove current workplace communication.	Assess with a current speaking/writing sample.	Present a five-minute analysis and answer follow-up questions clearly in English and Spanish as required by target role.	High: weekly practice and recorded sample; seek independent feedback.
Excel / financial models	Citi Services states basic Office/Excel; more specific requirements were not visible in the sampled sources.	Validate through baseline exercise.	Reconcile, forecast, run scenarios, and explain formulas.	High: timed Excel task and reviewer reproduction.
SQL / data quality	Not explicitly required in the two Citi listings fetched; relevant to analytical workflows, but not established as a universal job requirement.	Validate through baseline exercise.	Join and aggregate without duplication; document checks.	High for portfolio differentiation: query exercise plus reconciliation.
Power BI / reporting	Not explicitly named in the two Citi listings fetched.	Validate through baseline exercise.	Traceable measures and stakeholder-readable report.	Medium-high: audit one report and reproduce a KPI.
Accounting / reconciliation	Senior reference role names direct accounting and close experience; sampled entry-level role details are limited.	Validate through a small case.	Tie transactions to summaries; explain cash/profit timing and exceptions.	High: synthetic reconciliation case.
Payment and financial-product analysis	Citi Services description covers cash management, working capital, trade finance, and liquidity services; not specific junior-payment analyst criteria.	Unknown.	Define payment-funnel measures and transaction economics from bounded data.	Specialization: synthetic case and documented metric definitions.
Valuation / investment reasoning	Not a requirement confirmed in the sampled postings.	Unknown.	Sourced model, alternative scenarios, limitations, and a clear decision memo.	Later branch: add after core finance and data checks.
Cloud FinOps	Senior reference includes FinOps/cloud finance; no sampled entry-level posting confirmed this specialty.	Unknown.	Allocation, forecasting, optimization, and cloud-cost analysis.	Deferred/separate track: only choose if current postings support it.

Do not over-read the evidence

Only two employer postings yielded detailed qualification text in the available research; a third exposed only title and location. Third-party job leads may be stale. None of the fetched employer content listed salary or a credential requirement. No salary, job probability, or representative market-demand estimate is claimed. Use the date-stamped sample to guide weekly searches, not as a permanent employer target list.