Careers at AgileOne

OVERVIEW OF THE POSITION:
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, high-performing, and visually intuitive reporting solutions.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• 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, insights, and workforce performance metrics
• Optimize report usability through layout design, drill-throughs, tooltips, bookmarks, and performance tuning
• Apply best practices for Power BI semantic models, governance, and version control
• Must have report design and creation experience within the Contingent Workforce Solutions and Managed Service Provider Industry.
• Build and maintain data models including star schemas, fact and dimension tables, and calculated tables
• Develop complex DAX measures for workforce analytics (spend, headcount, tenure, utilization, compliance, 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 systems
• Validate data accuracy and reconcile discrepancies across systems and reports
• Leverage tools such as Power Automate to streamline reporting and reduce manual processes
• Apply basic scripting or automation concepts to reduce manual effort and improve data reliability
• Document data sources, transformations, and report logic for transparency and auditability
• Stay current with Power BI feature releases and recommend technical improvements
• Collaborate with data engineering and infrastructure teams to align reporting with architecture and governance standards
• Utilize knowledge of contingent workforce systems (Fieldglass, Beeline, VNDLY, or similar)
• Stay current with Power BI updates and continuously improve reporting solutions
• Collaborate with data engineering and infrastructure teams to align reporting solutions with cloud governance, security, and performance standards
• Other duties as assigned

Data Modeling, Transformation & Cloud 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

SUPERVISORY RESPONSIBILITIES/# OF STAFF:
None

QUALIFICATIONS:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily, in a fast paced environment. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

JOB EXPERIENCE REQUIREMENTS:

• Experience in contingent workforce, MSP, staffing, or workforce solutions environments
• Strong experience developing reports in Power BI (Desktop and Service)
• Advanced DAX skills, including complex measures and time intelligence
• Hands-on experience with Power Query (M)
• 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
• Familiarity with workforce metrics (spend, bill rates, tenure, compliance, diversity, supplier performance)
• Experience applying Power BI governance and security models
• Exposure to Tableau, Python, or R is a plus
• Basic understanding of machine learning or advanced analytics concepts
• Strong analytical thinking and problem-solving skills
• High attention to detail and data accuracy
• Ability to manage multiple requests and deadlines independently
• Strong communication skills with ability to explain data clearly
• Ability to work both independently and collaboratively
• Ability to learn new tools and technologies quickly

EDUCATION REQUIREMENT:
Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Business, or related field; or equivalent experience

LANGUAGE/COMMUNICATION SKILLS (written & verbal):
This position requires fluent English. Prefer candidates who have multi-language skills. Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedural manuals. Ability to present information effectively and to respond to questions from groups of managers, clients, customers, and the general public.

COMPUTER/SYSTEM SKILLS REQUIREMENTS:
Working knowledge of computers including Windows environments, email, and the internet. Proficiency with MS Office applications including Word, PowerPoint, Outlook, Project and Visio. Advanced proficiency in Power BI, SQL and Excel. Knowledge of Microsoft data platforms (Azure, Fabric preferred). Ability to learn proprietary AgileOne technologies

• Cloud, Fabric & Infrastructure Knowledge requirements:
  
  • Experience working 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
  •  In depth understanding of VMS tool data structures within Fieldglass, Beeline, VNDLY and other VMS applications

PROFESSIONAL EXPECTATIONS & WORK ENVIRONMENT:

• Perform all job responsibilities with integrity, accountability, and adherence to company standards
• Demonstrate ethical, fair, and professional conduct in all interactions
• Maintain a professional presence appropriate for a client-facing, global organization
• Ability to work effectively in a remote environment with minimal supervision
• Willingness to work additional hours, when required, to meet business needs and deadlines