24 hours ago
Data & Advisory Analyst
OurTeam
Hybrid
Contractor
$35,000
Hybrid
Job Overview
Job TitleData & Advisory Analyst
Job TypeContractor
CategoryCommerce
Experience5 Years
DegreeMaster
Offered Salary$35,000
LocationHybrid
Who's the hiring manager?
Sign up to PitchMeAI to discover the hiring manager's details for this job. We will also write them an intro email for you.
Job Description
About the Role: Data & Advisory Analyst at OurTeam
We are seeking a high-caliber Data & Advisory Analyst to support the final stages of a Target Operating Model (TOM) advisory project. This is a 4-month contract.
The primary focus is providing expert-level data support for Talent Acquisition (TA) diagnostic work. While experience in TA or HR Reporting/MI is beneficial, we are prioritizing candidates with exceptional data modeling and advanced Excel capabilities. This role is ideal for a Reporting & MI Analyst or a Financial Analyst with a strong advisory mindset.
Key Responsibilities
- Data Modeling & Analysis: Build and maintain complex data models to support diagnostic assessments and future-state organizational design.
- Advanced Reporting: Develop high-impact charts, tables, and automated dashboards to visualize key findings for project stakeholders.
- Diagnostic Support: Support the Project Lead in executing TA diagnostic work, identifying operational gaps, and surfacing insights through rigorous data interrogation.
- Process Automation: Utilize advanced Excel functions and macros (VBA) to streamline data collection and consolidate disparate datasets into actionable intelligence.
- Ad-Hoc Advisory Support: Provide rapid-response analysis and data validation during critical late-stage project milestones.
Required Technical Skills
- Excel Mastery: "Whiz" level proficiency, including expert use of Power Query, Pivot Tables, advanced formulas, and VBA/Macros.
- Data Visualization: Ability to translate complex data sets into clean, professional charts and tables suitable for senior advisory presentations.
- Modeling: Demonstrated experience in building structured, scalable, and error-free financial or operational models.
Preferred Qualifications
- Background: Previous experience as a Reporting/MI Analyst, Financial Analyst, or Management Consultant.
- TOM Experience: Familiarity with Target Operating Model frameworks or organizational design projects is a significant plus.
- Domain Knowledge: While TA knowledge (e.g., recruitment metrics, pipeline analysis) is a "nice-to-have," pure analytical excellence is the priority.
Key skills/competency
- Data Modeling
- Advanced Excel
- VBA Macros
- Power Query
- Pivot Tables
- Data Visualization
- Reporting
- Financial Modeling
- Operational Modeling
- Talent Acquisition Analytics
How to Get Hired at OurTeam
- Research OurTeam's culture: Study their mission, values, recent news, and employee testimonials on LinkedIn and Glassdoor.
- Customize your resume: Highlight advanced Excel, data modeling, and advisory project experience.
- Showcase analytical prowess: Prepare to discuss specific examples of complex data analysis and visualization.
- Emphasize problem-solving: Be ready to demonstrate how you identify operational gaps and surface insights.
- Network effectively: Connect with OurTeam employees on LinkedIn for insider perspectives.
Frequently Asked Questions
Find answers to common questions about this job opportunity
01What is the primary focus of the Data & Advisory Analyst role at OurTeam?
02What technical skills are crucial for this Data & Advisory Analyst position at OurTeam?
03Is experience in Talent Acquisition necessary for the Data & Advisory Analyst role at OurTeam?
04What kind of reporting will the Data & Advisory Analyst be responsible for?
05How does the Data & Advisory Analyst contribute to process automation?
06What background is preferred for a Data & Advisory Analyst at OurTeam?
07How long is the contract for the Data & Advisory Analyst position?
Explore similar opportunities that match your background