SUMMARY OF RESPONSIBILITIES: The Business Intelligence Data Analyst is responsible for designing, developing, and maintaining Power BI reports, dashboards, and analytical datasets that support internal teams and external MSP clients within the contingent workforce ecosystem.
This role is highly technical and execution focused, emphasizing Power BI report development, data modeling, SQL, DAX, and analytical problem solving.
The analyst works with large, complex datasets related to contingent labor programs (e.g., spend, suppliers, requisitions, bill rates, compliance, tenure, diversity, and performance metrics) and translates business requirements into accurate, performant, and visually intuitive reporting solutions.
DESCRIPTION OF ESSENTIAL DUTIES AND FUNCTIONS (each duty and function listed indicates % of time to total 100%) :
Report Development, Visualization and Analytics Management 40% Design, build, and maintain Power BI dashboards, paginated reports, and ad hoc analyses for internal stakeholders and MSP clients Develop interactive visualizations that clearly communicate trends, exceptions, and insights related to contingent workforce programs Optimize report usability through effective layout, drill throughs, tooltips, bookmarks, and performance tuning Apply best practices for Power BI semantic models, report governance, and version control Must have report design and creation experience within the Contingent Workforce Solutions and Managed Service Provider Industry.
Design, build, and maintain Power BI dashboards, paginated reports, and ad hoc analyses for internal stakeholders and MSP clients
Develop interactive visualizations that clearly communicate trends, exceptions, and insights related to contingent workforce programs
Optimize report usability through effective layout, drill throughs, tooltips, bookmarks, and performance tuning
Apply best practices for Power BI semantic models, report governance, and version control
Must have report design and creation experience within the Contingent Workforce Solutions and Managed Service Provider Industry.
Data Modeling, Transformation & Engineering 30% Build and maintain Power BI data models, including star schemas, fact/dimension tables, and calculated tables Develop complex DAX measures for workforce analytics such as spend, headcount, tenure, utilization, markups, compliance, and SLA performance Perform data ingestion, cleansing, and transformation using Power Query (M) Write and optimize SQL queries to extract, join, and aggregate data from multiple source systems Validate data accuracy and reconcile discrepancies across systems and reports
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
Build and maintain Power BI data models, including star schemas, fact/dimension tables, and calculated tables
Develop complex DAX measures for workforce analytics such as spend, headcount, tenure, utilization, markups, compliance, and SLA performance
Perform data ingestion, cleansing, and transformation using Power Query (M)
Write and optimize SQL queries to extract, join, and aggregate data from multiple source systems
Validate data accuracy and reconcile discrepancies across systems and reports
Automation, Tools & Continuous Improvement 10% Leverage Power Automate or similar tools to streamline recurring reporting processes Apply basic scripting or automation concepts to reduce manual effort and improve data reliability Document data sources, transformations, and report logic to support knowledge sharing and auditability Stay current with Power BI feature releases and recommend technical improvements
Leverage Power Automate or similar tools to streamline recurring reporting processes
Apply basic scripting or automation concepts to reduce manual effort and improve data reliability
Document data sources, transformations, and report logic to support knowledge sharing and auditability
Stay current with Power BI feature releases and recommend technical improvements
Role Variations - If the position requires a Data Analyst with experience in data, system and infrastructure management, candidate requirements and experiences must also include: Data Modeling, Transformation & Architecture Develop and maintain enterprise Power BI data models using star schemas and dimensional modeling best practices Apply medallion architecture concepts (Bronze, Silver, Gold layers) within Microsoft Fabric, Azure, or AWS-based data platforms Perform advanced data transformation using Power Query (M), SQL, and cloud-based data processing tools Validate data integrity across multiple source systems and analytical layers Leverage Power Automate, Fabric pipelines, or similar tools to automate data refreshes and reporting workflows Cloud, Fabric & Infrastructure Knowledge Work within Microsoft Fabric to support Lakehouse, Data Warehouse, and Semantic Model architectures Demonstrate working knowledge of Azure data services such as Azure Data Lake Storage, Synapse Analytics, Azure SQL, and networking/security fundamentals Exposure to AWS data environments and multi-cloud analytics strategies Collaborate with data engineering and infrastructure teams to align reporting solutions with cloud governance, security, and performance standards In depth understanding of VMS tool data structures within Fieldglass, Beeline, VNDLY and other VMS applications Required Technical Qualifications Strong experience developing reports in Power BI (Desktop & Service) Advanced proficiency with DAX, including complex measures and time intelligence Hands on experience with Power Query (M) for data transformation Strong SQL skills (joins, aggregations, subqueries, performance optimization) Solid understanding of relational data modeling and analytics best practices Experience working with large, complex datasets from multiple sources Proficiency with Excel for data analysis and validation
Data Modeling, Transformation & Architecture Develop and maintain enterprise Power BI data models using star schemas and dimensional modeling best practices Apply medallion architecture concepts (Bronze, Silver, Gold layers) within Microsoft Fabric, Azure, or AWS-based data platforms Perform advanced data transformation using Power Query (M), SQL, and cloud-based data processing tools Validate data integrity across multiple source systems and analytical layers Leverage Power Automate, Fabric pipelines, or similar tools to automate data refreshes and reporting workflows
Develop and maintain enterprise Power BI data models using star schemas and dimensional modeling best practices
Apply medallion architecture concepts (Bronze, Silver, Gold layers) within Microsoft Fabric, Azure, or AWS-based data platforms
Perform advanced data transformation using Power Query (M), SQL, and cloud-based data processing tools
Validate data integrity across multiple source systems and analytical layers
Leverage Power Automate, Fabric pipelines, or similar tools to automate data refreshes and reporting workflows
Cloud, Fabric & Infrastructure Knowledge Work within Microsoft Fabric to support Lakehouse, Data Warehouse, and Semantic Model architectures Demonstrate working knowledge of Azure data services such as Azure Data Lake Storage, Synapse Analytics, Azure SQL, and networking/security fundamentals Exposure to AWS data environments and multi-cloud analytics strategies Collaborate with data engineering and infrastructure teams to align reporting solutions with cloud governance, security, and performance standards In depth understanding of VMS tool data structures within Fieldglass, Beeline, VNDLY and other VMS applications
Work within Microsoft Fabric to support Lakehouse, Data Warehouse, and Semantic Model architectures
Demonstrate working knowledge of Azure data services such as Azure Data Lake Storage, Synapse Analytics, Azure SQL, and networking/security fundamentals
Exposure to AWS data environments and multi-cloud analytics strategies
Collaborate with data engineering and infrastructure teams to align reporting solutions with cloud governance, security, and performance standards
In depth understanding of VMS tool data structures within Fieldglass, Beeline, VNDLY and other VMS applications
Required Technical Qualifications Strong experience developing reports in Power BI (Desktop & Service) Advanced proficiency with DAX, including complex measures and time intelligence Hands on experience with Power Query (M) for data transformation Strong SQL skills (joins, aggregations, subqueries, performance optimization) Solid understanding of relational data modeling and analytics best practices Experience working with large, complex datasets from multiple sources Proficiency with Excel for data analysis and validation
Strong experience developing reports in Power BI (Desktop & Service)
Advanced proficiency with DAX, including complex measures and time intelligence
Hands on experience with Power Query (M) for data transformation
Solid understanding of relational data modeling and analytics best practices
Experience working with large, complex datasets from multiple sources
Proficiency with Excel for data analysis and validation
MARGINAL FUNCTIONS (each function listed indicates % of time) :
Other job-related duties as assigned 5%
REQUIRED QUALIFICATIONS: The primary duties of this position are performance and execution of business operational requirements of the Company.
This position’s primary duties include the exercise of discretion and independent judgement with respect to matters of significance.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
The requirements listed below are representative of the knowledge, skill, and/or ability required.
Experience in the contingent workforce, MSP, staffing, or workforce solutions industry
Familiarity with common workforce metrics (spend, bill rates, tenure, compliance, diversity, supplier performance)
Exposure to Tableau, Python, or R for analytics
Basic understanding of machine learning or advanced analytics concepts
Experience applying Power BI governance and security models
Strong analytical and problem solving skills
High attention to detail and data accuracy
Ability to work independently with minimal supervision
Ability to manage multiple reporting requests and deadlines
Comfortable working in a fast paced, data driven environment
Clear written and verbal communication skills focused on explaining data
Ability to function independently and collaborate as part of a team
Exceptional analytical and problem-solving skills
Strong interpersonal skills
Ability to interpret data through various means and techniques and communicate complex ideas effectively
Applies automation tools such as Power Automate to handle repetitive tasks and functions.
Applies the principals of project management. Prioritizes and manages concurrent activities, workloads, and deliverables
The ability to work effectively under pressure and make decisions independently.
Ability to learn new tools, techniques, software and applies and shares that knowledge with others
Perform all job responsibilities with total integrity and accountability
Maintains a professional appearance
Ethical, fair, and professional conduct in all interactions
Accommodate flexible schedule required to meet business needs
Remote work environment
SUPERVISION EXERCISED And # OF STAFF: None
LANGUAGE/COMMUNICATION SKILLS REQUIRED (written & verbal) : Ability to read, analyze, and interpret analytic concepts, present information with clarity and e able to effectively respond to questions from groups of managers, clients, customers, and the general public.
COMPUTER/SYSTEM SKILLS REQUIREMENTS: See required qualifications and essential duties
Skills Requirements
Strong analytical ability to calculate figures and analyze complex data.
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
Ability to become proficient in: All AgileOne Technology
WORK ENVIRONMENT/ PHYSICAL OR MENTAL ABILITIES: The demands described here are representative of those that must be met by the employee to successfully perform the essential functions of the job with or without a reasonable accommodation.
MENTAL DEMANDS (list below indicates % of time) :
• Logical Thinking 100%
Problem solving 100%
Working with interruptions 50%
Analytical skills 60%
Creativity 50%
Organization 100%
Communications – written 50%
Communications – verbal 50%
PHYSICAL DEMANDS (list below indicates % of time) :
Stand: 5%
Sit: 90%
Squat: 0%
Walk: 10%
Bend: 5%
Repetitive Motion: Telephone Use, Keyboard Activity (up to 90%), Reaching and Grasping
Climb: 0%
Twist: 2%
• Operate Equipment: 0%
Air and other public transportation Business Travel: Less than 5%
Driving: Less than 10%
Lifting (less than 10 lbs): less than 5% Percentage of time Low Lifting: Less than 5% Percentage of time High Lifting: Less than 5%
Percentage of time Low Lifting: Less than 5%
Percentage of time High Lifting: Less than 5%
Carrying (less than 10 lbs): less than 5% Percentage of time Carrying: Less than 5%
Percentage of time Carrying: Less than 5%
Other Job Compensation: This position has no additional compensation.
Computer And System Skills Requirements
We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.
Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records.
For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
If you believe, you need a reasonable accommodation in order to search for a job opening or to apply for a position, please contact us by sending an email to accommodationrequest@ain1.com for assistance.
The Company participates in the E-Verify program in certain locations as required by law.
We are proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, religion, ancestry, color, national origin, age, gender identity or expression, genetic information, marital status, medical condition, disability, protected veteran status, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable federal, state, or local laws. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records.
The Know Your Rights poster is available here: Know Your Rights Poster ( https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf )
The pay transparency policy is available here: Pay Transparency Policy ( https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf )
If you believe, you need a reasonable accommodation in order to search for a job opening or to apply for a position, please contact us by sending an email to accommodationrequest@ain1.com for assistance.
The Company participates in the E-Verify program in certain locations as required by law.
We are very excited to offer an array of benefit programs for our employees.
Internal staff hires working 30 or more hours per week will be offered robust plans including medical, dental, vision, life insurance, accident, LTD, pet discount coverage, legal coverage, identity theft, discount perks, and credit union.
Most plans include a generous employer contribution in addition to the employee’s contribution.
Eligible employees can enroll with an effective date on the first of the month following 60 days of employment.
A minimum of 6 paid sick days are offered per year unless part-time or covered under a local ordinance that requires a greater number of paid sick days.
In addition to 11 paid holidays, the Company offers Unlimited Flexible Paid Time Off to all eligible full and part-time employees, after the initial 90 days of employment, subject to management approval.
Complete details about the FTO program are outlined in the FTO policy available upon hire.
The Company also offers a 401k program with an employer match, with employee contributions beginning the month following enrollment.
Additional Eeo 3
Hours: Normal daytime business hours Monday through Friday
Day 5: Friday
Joining our global team
Joining our global team, you’ll become a member of the business community’s global partner for forward-thinking talent and resource-management solutions.
The ActOne Group is the largest privately held, woman and minority-owned workforce management company in the United States, operates in over 30 countries, and services over 17,000 clients.
A career with The ActOne Group means you’re a part of something bigger.
Your resume will be shared with the entire ActOne Group family, giving you exposure to opportunities in staffing, workforce solutions, and business services through brands like AppleOne, AgileOne, and more!
We want to ensure you have every opportunity to be the best you can be in the position where you fit best.
About AgileOne
Staffing & Recruiting748 employeesFounded 1999
Private, woman- and minority-owned workforce solutions firm providing MSP and talent technology to businesses.
