Data Analyst, Business Intelligence at AgileOne
Torrance, CA — full-time
he 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. 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 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 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