Job Purpose:

The Data Analyst is responsible for transforming workforce, program, and market data into accurate, actionable, and client-ready analytics products. This role supports internal stakeholders and external clients by preparing, cleansing, modeling, analyzing, and visualizing data related to requisitions, submittals, placements, rates, suppliers, service level agreements, program performance, and other workforce metrics.

The Data Analyst works extensively within the Microsoft data and reporting environment, including SQL Server, Power BI, Excel, and related technologies. This position is responsible for sourcing and validating data, developing semantic models, building and maintaining dashboards and scorecards, administering Power BI environments, and ensuring reporting outputs are accurate, reliable, and aligned with business and client requirements.

Essential Duties and Responsibilities:

This position is required to ensure compliance of Company operations to all applicable laws, regulations and standards, good business practices, and company documented procedures (including but not limited to quality regulations, government occupational health and environmental regulations, and statutes).

Data Preparation, Modeling, and Analysis

- Extracts, cleanses, transforms, integrates, and validates data from SQL Server, VMS platforms, HR systems, recruiting systems, finance systems, and other internal or external sources.
- Writes and optimizes SQL queries and stored procedures to source, join, transform, and prepare data for reporting and analysis.
- Profiles raw and curated datasets to identify incomplete, inaccurate, inconsistent, duplicate, or anomalous data.
- Develops and maintains analysis-ready datasets and data models that support recurring reporting, ad hoc analysis, benchmarking, and client deliverables.
- Analyzes workforce and program data to identify trends, performance gaps, risks, and opportunities.
- Performs analysis related to cost savings, quality, supplier performance, market rates, service levels, program health, workforce activity, and other business needs.
- Applies consistent definitions, business rules, and calculation logic across reporting and analytical outputs.
- Documents assumptions, data sources, transformations, dependencies, and reporting logic to support transparency and repeatability.

Power BI and Analytics Product Development

- Designs, builds, maintains, and enhances Power BI dashboards, reports, scorecards, and analytical products for internal stakeholders and external clients.
- Develops and optimizes Power BI semantic models, including relationships, hierarchies, DAX measures, Power Query/M transformations, and incremental refresh processes.
- Designs dashboards and reports using robust data visualization principles to ensure outputs are clear, intuitive, accurate, and client-ready.
- Translates business and client questions into meaningful visualizations, KPIs, and analytical views.
- Maintains consistency in metric definitions, report structures, visual standards, and user experience across Power BI products.
- Manages Power BI datasets, dataflows, workspaces, gateways, scheduled refreshes, row-level security, user access, and related administrative functions.
- Troubleshoots report, refresh, gateway, data model, and performance issues and coordinates resolution with appropriate technical teams.
- Reviews dashboards and reports for data accuracy, visual integrity, usability, and alignment with business requirements before release.
- Maintains and enhances existing analytics products based on user feedback, changing business needs, and new data requirements.

Workforce, MSP, and Market Analytics

- Develops analysis and reporting related to Managed Service Program performance, including requisitions, submittals, placements, fill activity, supplier performance, rates, savings, service levels, and other workforce metrics.
- Develops and maintains client and program scorecards, KPI reporting, benchmarking, and performance analysis.
- Analyzes VMS data from platforms such as SAP Fieldglass, Beeline, VNDLY, and similar systems.
- Supports labor market and compensation benchmarking by analyzing wage, rate, supply, demand, geography, skill, and related market data.
- Combines internal workforce data with external market information to support rate analysis, benchmarking, supplier discussions, and client recommendations.




- Identifies trends or variances in client and program performance and communicates findings to appropriate stakeholders.
- Supports development of analytical content for client business reviews, sales presentations, renewals, and account growth opportunities.

Data Quality, Validation, and Governance

- Owns data validation and quality assurance for assigned dashboards, reports, scorecards, and analytical deliverables.
- Reconciles reporting outputs to source systems and investigates discrepancies before information is released to clients or business stakeholders.
- Develops and follows standard quality control procedures for recurring reports and analytics products.
- Partners with IT, Operations, and other technical teams to resolve data integrity, system, and reporting issues.
- Monitors data refreshes, reporting dependencies, and recurring processes to ensure successful and timely completion.
- Identifies data quality risks, reporting inconsistencies, or process weaknesses and recommends corrective actions.
- Maintains data definitions, report documentation, process documentation, and other supporting materials.
- Supports appropriate data access, confidentiality, and security requirements, including row-level security and user permissions.

Reporting Automation and Technical Support

- Develops and maintains standardized, repeatable reporting processes that reduce manual effort and improve consistency.
- Automates recurring data preparation, validation, reporting, and analytical tasks using Power BI, SQL, Excel, Power Query, and other approved tools.
- Builds and maintains the connection layer between SQL Server and Power BI, including gateway configuration, scheduled refreshes, and query performance optimization.
- Works with technical teams to define data collection requirements, troubleshoot source-system issues, and implement reporting solutions.
- Supports implementation of new data sources, reporting tools, Power BI capabilities, and related technology enhancements.
- Evaluates opportunities to improve reporting efficiency, scalability, maintainability, and user experience.
- Cross-trains colleagues and provides documentation to promote continuity and shared knowledge across the analytics function.

Business Partnership and Insights

- Partners with Operations, Account Management, Sales, Marketing, Technology, Finance, and other stakeholders to understand reporting and analytical needs.
- Translates business requirements into reporting specifications, data models, KPIs, dashboards, and analytical solutions.
- Provides data-driven insights and recommendations to management and clients regarding program performance, risks, opportunities, and service improvements.
- Communicates analytical findings clearly to technical and non-technical audiences using effective data storytelling.

Knowledge/Skills/Abilities:

- Strong knowledge of data analysis, reporting, data profiling, data validation, and data visualization practices.
- Advanced Power BI development skills, including DAX, Power Query/M, semantic model design, relationships, incremental refresh, and performance optimization.
- Experience administering Power BI environments, including workspaces, datasets, gateways, refresh scheduling, row-level security, and user access.
- Strong SQL Server skills, including writing complex queries, joins, stored procedures, and troubleshooting query performance.
- Advanced Microsoft Excel skills, including formulas, pivot tables, charts, Power Query, and other analytical capabilities.
- Strong dashboard and data visualization design skills with an emphasis on clarity, usability, accuracy, and professional presentation.
- Strong analytical, critical-thinking, and problem-solving skills.
- Ability to identify data inconsistencies, investigate root causes, and resolve or escalate data quality issues.
- Ability to interpret workforce and program data and translate findings into meaningful business insights.
- Knowledge of Managed Service Program processes and contingent workforce data, including requisitions, submittals, placements, suppliers, rates,



and service levels.
- Familiarity with VMS platforms such as SAP Fieldglass, Beeline, VNDLY, or similar systems.
- Familiarity with labor market, compensation, and workforce benchmarking data and tools.
- Solid written, verbal, presentation, and data storytelling skills.
- Ability to communicate technical and analytical information clearly to non-technical stakeholders and clients.
- Strong organizational, planning, prioritization, and time-management skills.
- Ability to independently manage multiple projects, deadlines, and recurring deliverables.
- Strong attention to detail and commitment to data accuracy and presentation quality.
- Ability to establish effective working relationships across departments and organizational levels.
- Ability to work proactively, exercise sound judgment, and take ownership of assigned work.

Qualifications:

Minimum

- Associates or bachelor’s degree in Data Analytics, Computer Science, Information Systems, Statistics, Business Administration, or a related field, or an equivalent combination of education and experience.
- Minimum of three years of professional experience in data analysis, business intelligence, reporting, or a related analytical role.
- Minimum of three years of hands-on Power BI development experience, including building data models, writing DAX, developing dashboards, and working with Power Query/M.
- Demonstrated SQL Server experience, including independently writing queries against production or enterprise databases to source and transform reporting data.
- Experience designing, building, and maintaining dashboards, scorecards, or analytical reporting products.
- Experience with data cleansing, validation, reconciliation, and quality assurance.
- Proficiency in Microsoft Excel, including formulas, pivot tables, charts, and data analysis.
- Strong analytical, communication, organizational, and problem-solving skills.
- Ability to work independently and manage multiple reporting and analytical priorities.

Preferred:
- Minimum of three years of data analysis or business intelligence experience within a staffing, workforce solutions, Managed Service Program, talent acquisition, HR technology, or related environment.
- Experience working with contingent workforce or human capital data.
- Experience with VMS platforms such as SAP Fieldglass, Beeline, VNDLY, Coupa, IQNavigator, or similar systems.
- Experience with Power BI administration, including workspace management, gateways, datasets, row-level security, and deployment practices.
- Experience with ETL or ELT processes, data warehousing, and data integration.
- Exposure to Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, Databricks, or other cloud data technologies.
- Experience with labor market or compensation benchmarking tools and datasets.
- Experience using Python or R for data preparation, analysis, automation, or statistical work.
- Knowledge of VBA or other workflow automation tools.
- Experience with Tableau or other business intelligence and visualization platforms.
- Experience with T-SQL development, indexing, execution plan analysis, stored procedures, or SQL performance optimization.
- Demonstrated success improving operational efficiency, reporting quality, or client outcomes through data insights.
- Microsoft Power BI Data Analyst certification (PL-300) or equivalent demonstrated experience..

Physical Requirements/Capabilities:

- Ability to use hands to finger, handle, or feel, and the ability to talk and hear.
- Ability to frequently sit for prolonged amounts of time, stand, walk, reach with hands and arm’s length, climb or balance, stoop or bend, push, pull, kneel, and crouch as job requires.
- Ability to regularly lift and/or move up to 10 pounds, occasionally lift and/or move up to 50 pounds.
- Must be able to use a computer for extended periods of time.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above 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. Please note this is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

📌 Data Analytics Engineer (Bengaluru)
🏢 Innova Solutions
📍 Bengaluru