SitusAMC

Intern – Technology Enablement, Data Analytics

SitusAMC

internship

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Salary

💰 $23 - $25 per hour

Job Level

Entry Level

About the role

  • Prepare, clean, and validate financial and operational datasets using Excel, ensuring accuracy, consistency, and usability for downstream reporting and analysis
  • Utilize Power Query to transform, combine, and automate data from multiple source files and systems, supporting repeatable and scalable reporting processes
  • Assist in the development and maintenance of Power BI reports and dashboards, including basic data modeling, measures, and visual quality checks
  • Support the team’s evolving use of AI-enabled tools by assisting with prompt development, testing, and refinement for analytics, documentation, and productivity use cases
  • Perform exploratory analysis to identify trends, variances, and data quality issues, summarizing insights and observations for the broader team
  • Support recurring and ad-hoc financial analysis related to revenue, expenses, forecasts, and performance tracking
  • Contribute to process improvement and automation efforts by identifying manual workflows, inefficiencies, or opportunities to standardize data handling
  • Assist with documenting data definitions, assumptions, reporting logic, and process workflows to improve transparency and reuse
  • Perform other related duties and projects as assigned by the manager

Requirements

  • Actively pursuing a Bachelor’s degree in Finance, Accounting, Economics, Business Analytics, Information Systems, Mathematics, or a related field
  • Strong foundational skills in Excel (formulas, tables, lookups, structured data); exposure to Power Query and/or Power BI is strongly preferred
  • Demonstrated comfort working with numbers and datasets; coursework in statistics, quantitative analysis, or financial analysis is a plus
  • Familiarity with AI tools (e.g., Copilot, ChatGPT, or similar) and interest in prompt writing or applied AI use in analytics, finance, or business workflows
  • Strong analytical and problem-solving skills with attention to detail and data accuracy
  • Interest in finance, analytics, and how data supports business and strategic decision-making
  • Ability to learn new tools quickly and apply them in a practical, business-oriented manner
  • Clear written and verbal communication skills, with the ability to explain analysis and insights concisely
  • Self-motivated, organized, and able to manage multiple tasks while meeting deadlines
Benefits
  • PTO and paid holidays
  • Medical, dental, vision, life, disability insurance
  • 401K
  • Various benefit plans
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
ExcelPower QueryPower BIdata modelingdata validationdata analysisfinancial analysisquantitative analysisstatisticsdata automation
Soft Skills
analytical skillsproblem-solving skillsattention to detailcommunication skillsself-motivatedorganizational skillstime managementadaptabilityteam collaborationcritical thinking