You are viewing a preview of this job. Log in or register to view more details about this job.

Data Management & Financial Analytics Intern

G&A
Email

Job Title: Data Management & Financial Analytics Intern 

Location:

Portland, OR

About G&A 

G&A is recognized internationally as a leader in creating successful, engaging experiences— synthesizing the physical and digital worlds in ways that move people—momentarily stopping time and creating lifelong impact. G&A brings a highly regarded collaborative style, plus design and service excellence to clients and public spaces around the world. G&A is dedicated to cultivating a meaningful and impactful intern experience that gives you opportunities for creative freedom while also sharpening your technical skills. We have studios across the country in Washington, DC, New York City, Portland, Oregon and other remote locations. 

 

Our core values:

  • Client-Focused Impact: We partner with our clients to co-create outcomes that mutually align their goals with our standards of excellence.
  • Brave Innovation: We continuously evolve ways of making meaning of our constantly changing world. We push past the expectations and refuse to settle for what worked before.
  • Inclusive Collaboration: Everyone at G&A is expected to contribute to the creation of extraordinary experiences for our clients’ guests and visitors. We integrate diverse perspectives to realize our shared goals.
  • Engaging with Openness: We consider different perspectives with mutual respect and a learning mindset. Our expectation for cross-capability collaboration only happens on a foundation of continuous personal growth, open communication, and earned trust.



 

Position Summary

We are seeking a detail-oriented and analytical Data Management Intern with a strong academic foundation in Financial Principles and Statistics. This role will support data collection, validation, analysis, and reporting initiatives, helping drive data-driven decision-making within the organization. The ideal candidate is highly organized, numerate, and eager to apply theoretical knowledge to real-world datasets.


 

Job Description & Key Responsibilities

  • System Audit & Cleanup: Assist in the system audit and data cleanup across our core platforms: Sage Intacct (ERP), Kantata (Project Management), and Ramp (Spend Management).
  • Data Integration: Help map data fields and validation rules between systems to ensure smooth integration and eliminate manual entry bottlenecks.
  • Data Integrity: Support data management processes including data entry, database maintenance, and data integrity checks across financial and operational software.
  • Insights & Dashboards: Generate reports, dashboards, and visualizations to track critical agency metrics like team utilization, project margins, and real-time profitability.
  • Process Automation: Help automate repetitive data processes using Excel, Power Query, and AI-assisted tools.
  • Cross-Functional Collaboration: Collaborate with finance, operations, and analytics teams to ensure data accuracy and alignment across client projects.
  • Documentation: Document data processes, workflows, and standards for consistency and audit readiness.
  • Ad Hoc Requests: Participate in ad hoc financial data analysis and reporting requests as needed.



 

Qualifications

  • Currently pursuing or recently completed a Bachelor’s or Master’s degree in Finance, Business Analytics, Statistics, Economics, Data Science, or a related field.
  • Strong understanding of financial and operational principles (e.g., how project expenses and labor hours impact a profit & loss statement).
  • AI Fluency: Familiarity with using modern AI productivity tools (e.g., ChatGPT, Claude) to accelerate data restructuring, problem-solving, and formula generation.
  • Proficiency in Microsoft Excel (advanced formulas, pivot tables, and data analysis functions).
  • Basic knowledge of relational databases, data structures, or modern cloud-based ERP environments.
  • Solid foundation in statistical concepts
  • High attention to detail, data accuracy, and strong analytical thinking.
  • Effective communication and the ability to present visual data findings clearly to non-finance teams.

Preferred Skills

  • Experience working with large datasets, timesheet data, or financial project tracking.
  • Familiarity with data transformation tools, such as Excel Power Query.
  • Exposure to data visualization tools (Tableau, Power BI, or native Kantata/Sage dashboard builders).
  • Basic familiarity with coding languages like Python or SQL for data manipulation is a strong plus, but not required.
  • Ability to manage multiple data tasks and meet deadlines in a fast-paced environment.

Learning Opportunities

  • Gain hands-on, real-world experience in cloud ERP data management and agency financial analytics.
  • Work directly alongside experienced leadership and our Accounting Manager to build out department infrastructure.
  • Develop advanced technical skills in data integration, automated reporting, and modern business intelligence tools.
  • See firsthand how data cleanliness directly drives executive decision-making and profitability.



 

To Apply

Please submit your resume, portfolio of relevant work if able, and a cover letter to hr@gallagherdesign.com

 

G&A is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to their race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected classification.