Data Analyst – Advanced Excel / Power Query / Power Pivot

Data Analyst – Advanced Excel / Power Query / Power Pivot $35–$40/hour W2 | 3-Month Contract | 40 Hours/Week | 100% Remote Financial Services / Banking Data Environment No C2C. No Sponsorship. No F1/OPT We are partnering with a growing operational services organization seeking a highly capable Data Analyst to support a focused 3-month engagement. This role is best suited for someone who enjoys architecting structured Excel-based data models, merging complex datasets, and delivering executive-ready insights with minimal oversight. This is not a basic reporting role. We are looking for someone who can build governed, scalable Excel models that function like mini data platforms and who understands when logic belongs in Power Query, the Data Model (Power Pivot), or visualization tools like Power BI. You will report into Operations leadership and collaborate closely with a Senior Director of Operations Excellence. What You’ll Do • Merge multiple structured reports into unified datasets using Power Query (M) • Replace worksheet-based lookups with query-driven transformations and joins • Build relational data models in Power Pivot with optimized DAX measures • Design executive-ready summary reporting and dashboards • Deliver clear business insights and recommended next steps — not just charts • Prepare and validate data files for upload into an internal operational database • Implement audit checks, reconciliation logic, and refresh workflows Primary Tools • Advanced Excel (dynamic arrays, structured formulas; LET/LAMBDA preferred) • Power Query (M language) • Power Pivot / Data Model (DAX) • SQL • Power BI (secondary but helpful) What We’re Looking For • 3–5+ years in data analysis or business intelligence (5–10 preferred) • Strong Excel architecture and modeling capability • Experience handling 50k–500k+ row datasets • Comfort explaining modeling and transformation decisions • Ability to translate analysis into business-facing recommendations • Highly self-directed, structured, and motivated Preferred Experience • Experience in operational or service-based analytics • Familiarity with ERP, CMMS, or similar structured systems • Experience working with financial services or banking datasets (transactional data, portfolio reporting, structured financial data environments, etc.) Compensation & Eligibility • $35–$40/hour W2 • 40 hours per week • 3-month contract (potential for extension or conversion) • Must be authorized to work in the U.S. without current or future sponsorship • No F1/OPT, no H1B transfers, no C2C • This is an opportunity to produce high-trust outputs, build governed analytical structures, and support operational decision-making in a structured financial data environment.