SUMMARY OF RESPONSIBILITIES:
The Senior Data Analyst, Business Intelligence & Data Engineering is an elevated technical, analytical, and leadership role responsible for designing, developing, and delivering enterprise-grade reporting, analytical datasets, semantic models, and data solutions that support internal stakeholders and external MSP clients across the contingent workforce ecosystem. This role requires advanced technical ownership, data engineering capability, project delivery accountability, and team leadership.

The Senior Data Analyst leads complex initiatives from requirements through production deployment, mentors and directs analysts, partners with business and technology leaders, and ensures reporting solutions are accurate, scalable, secure, performant, and actionable.

DESCRIPTION OF ESSENTIAL DUTIES AND FUNCTIONS (each duty and function listed indicates % of time to total 100%):

• Enterprise Reporting, Visualization & Analytics Leadership (30%)
  
  • Lead the design, development, deployment, and maintenance of Power BI dashboards, paginated reports, analytical datasets, and executive scorecards for internal stakeholders and MSP clients.
  • Translate complex business requirements into clear, performant, visually intuitive reporting solutions that surface trends, exceptions, insights, and recommended actions.
  • Establish and enforce reporting design standards, semantic model governance, version control practices, quality assurance routines, and performance tuning expectations.
  • Develop reporting solutions for contingent workforce program metrics, including spend, suppliers, requisitions, bill rates, compliance, tenure, diversity, utilization, SLA performance, and program effectiveness.
  • Review and improve work produced by analysts to ensure accuracy, usability, stakeholder readiness, and alignment with AgileOne reporting standards.
• Data Modeling, Transformation & Engineering (25% of time)
  
  • Design and maintain advanced Power BI semantic models using dimensional modeling, star schemas, fact and dimension tables, calculated tables, role-playing dimensions, and reusable measures.
  • Develop complex DAX measures, calculation groups, time intelligence logic, and business rules to support scalable workforce analytics.
  • Write, optimize, and troubleshoot SQL queries, stored procedures, views, and data extracts across multiple source systems.
  • Build and support data ingestion, cleansing, transformation, reconciliation, and refresh workflows using Power Query, SQL, Microsoft Fabric pipelines, Azure data services, or comparable cloud tools.
  • Apply medallion architecture concepts across Bronze, Silver, and Gold analytical layers where appropriate, ensuring clean separation between raw, curated, and business-ready data assets.
  • Validate data lineage, integrity, and reconciliation across VMS platforms, enterprise systems, analytical layers, semantic models, and published reports.
• Project Management, Delivery & Stakeholder Leadership (20%)
  
  • Lead BI and data delivery projects from intake, discovery, requirements, design, build, testing, deployment, adoption, and post-implementation support.
  • Develop project plans, define milestones, estimate effort, assign work, manage dependencies, identify risks, escalate issues, and communicate status to leadership and business stakeholders.
  • Facilitate stakeholder workshops, requirements sessions, design reviews, testing cycles, and production readiness reviews.
  • Balance competing priorities across client, operational, leadership, and internal team demands while maintaining quality, timeline discipline, and transparent communication.
  • Ensure deliverables meet agreed scope, acceptance criteria, data quality expectations, security requirements, and business outcomes.
• Team Leadership, Coaching & Standards Management (15%)
  
  • Provide day-to-day leadership, coaching, mentorship, and technical guidance to Data Analysts and other team members.
  • Lead peer reviews, solution design reviews, code reviews, data model reviews, and report quality checks.
  • Assign or coordinate work across team members, monitor progress, remove blockers, and support workload prioritization.
  • Build reusable templates, documentation, standards, and best practices that improve team consistency, scalability, and knowledge sharing.
• Automation, Governance & Continuous Improvement (10%)
  
  • Leverage Power Automate, Fabric pipelines, scheduling tools, scripting, or comparable automation capabilities to reduce manual effort and improve reliability.
  • Document data sources, transformations, business logic, security assumptions, refresh processes, issue resolution steps, and support procedures.
  • Partner with data engineering, infrastructure, security, and governance teams to align reporting solutions with enterprise standards for access, privacy, performance, and maintainability.
  • Stay current with Power BI, Microsoft Fabric, Azure, AWS, and analytics platform capabilities and recommend improvements that elevate AgileOne BI delivery.
  • Perform other job-related duties as assigned.

REQUIRED QUALIFICATIONS:

• 7+ years of progressive experience in data analytics, business intelligence, reporting, data modeling, or related analytical roles.
• 3+ years of advanced Power BI experience, including Power BI Desktop, Power BI Service, semantic models, workspace management, performance tuning, and report governance.
• 3+ years of advanced SQL experience, including complex joins, aggregations, window functions, subqueries, stored procedures or views, performance optimization, and data validation.
• 2+ years of practical data engineering experience involving data ingestion, transformation, orchestration, pipelines, cloud data platforms, data lakes, warehouses, lakehouses, or curated analytical layers.
• Strong experience with VMS data structures and reporting concepts, including Fieldglass, Beeline, VNDLY, or comparable vendor management systems.
• Demonstrated experience managing and delivering projects, including scope definition, planning, milestone management, stakeholder communication, risk mitigation, testing, deployment, and post-launch support.
• Strong hands-on experience with DAX, including complex measures, calculation logic, time intelligence, reusable metrics, and performance optimization.
• Strong hands-on experience with Power Query (M), data cleansing, transformation design, and refresh troubleshooting.
• Solid understanding of dimensional modeling, relational databases, star schemas, fact/dimension design, semantic modeling, and analytics engineering best practices.
• Experience working with large, complex datasets from multiple sources and reconciling discrepancies across systems, extracts, reporting layers, and dashboards.
• Experience in contingent workforce, MSP, staffing, workforce solutions, procurement, HR, or related operational data environments.
• Knowledge of workforce metrics such as spend, bill rates, markups, requisitions, placements, tenure, compliance, diversity, supplier performance, SLA performance, utilization, and program performance.
• Ability to communicate complex technical and analytical concepts clearly to executive, operational, client, and technical audiences.

PREFERRED QUALIFICATIONS:

• Experience with Microsoft Fabric, including Lakehouse, Data Warehouse, Dataflows, pipelines, notebooks, semantic models, gateways, and refresh orchestration.
• Working knowledge of Azure data services such as Azure Data Lake Storage, Azure SQL, Synapse Analytics, Data Factory, Key Vault, Entra ID, networking, and security fundamentals.
• Exposure to AWS data environments, multi-cloud analytics strategies, or cross-platform data integration.
• Experience applying Power BI security models, row-level security, object-level security, workspace governance, data sensitivity labeling, and access control practices.
• Experience with advanced analytics, predictive modeling, machine learning concepts, or AI-assisted analytics use cases.
• Microsoft Power BI Data Analyst Associate, Fabric Analytics Engineer, Azure Data Engineer, PMP, Agile, Scrum, or similar certifications.

SUPERVISION EXERCISED/# OF STAFF:

• Functional leadership required. This role may directly or indirectly lead Data Analysts, contractors, offshore/onshore resources, or project team members depending on business need. Responsibilities may include work assignment, coaching, conducting performance reviews, providing technical direction, performance input, and project delivery leadership. Direct people management may be required based on organizational structure.

SKILLS REQUIREMENTS:

• Leadership and Behavioral Competencies
  • Leads through influence, clarity, accountability, and follow-through.
  • Able to manage concurrent priorities, deadlines, stakeholder expectations, and operational demands in a fast-paced environment.
  • Exercises independent judgment and discretion on matters of significance, including data interpretation, solution design, project priorities, risk mitigation, and stakeholder communication.
  • Demonstrates strong interpersonal skills, professional presence, and the ability to build trust with clients, managers, peers, and team members.
  • Able to coach, delegate, inspect work quality, provide constructive feedback, and help team members grow technical and business capabilities.
  • Able to work independently, collaborate effectively, and make informed decisions under pressure.

LANGUAGE/COMMUNICATION SKILLS REQUIRED (written & verbal):

• Ability to read, analyze, and interpret business requirements, reporting specifications, technical documentation, data models, and analytical concepts.
• Ability to present information with clarity to leaders, managers, clients, customers, technical teams, and general business audiences.

COMPUTER/SYSTEM SKILLS REQUIREMENTS:

• Advanced Power BI Desktop and Power BI Service.
• Advanced DAX, Power Query (M), and SQL.
• Microsoft Fabric, Azure data services, cloud data platforms, data warehouse/lakehouse concepts, and automation tools.
• Excel for analysis, reconciliation, validation, and stakeholder workbooks.
• VMS systems such as Fieldglass, Beeline, VNDLY, or comparable platforms.
• Collaboration and delivery tools such as Teams, SharePoint, Jira, Azure DevOps, Planner, Smartsheet, or similar tools.

CERTIFICATES, LICENSES, REGISTRATION REQUIREMENTS:

• None Required

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.

• Remote work environment.
• Available to work overtime when required to meet project, client, production support, or business-critical deadlines.
• Maintains professional appearance and professional conduct in all interactions.

MENTAL DEMANDS (list below indicates % of time):

• Problem solving 100%
• Working with interruptions 50%
• Analytical skills 100%
• Creativity 100%
• Organization 100%
• Communications - written 50%
• Communications - verbal 50%

PHYSICAL DEMANDS (list below indicates % of time):

• Stand: 5 %
• Sit: 90 %
• Squat: 0 %
• Walk: 0 %
• Bend: 0 %
• Repetitive Motion: Telephone Use, Keyboard Activity, up to 90%,
• Reaching and Grasping: 0%
• Climb: 0 %
• Twist: 0 %
• Operate Equipment: 0 %
• Air and other public transportation Business Travel: Less than 5 %
• Driving: Less than 0 %
• Lifting (lbs): Less than 10 lbs - less than 0% lifting
  
  • Percentage of time Low Lifting: Less than 0 %
  • Percentage of time High Lifting: Less than 0 %
• Carrying (lbs): Less than 10 lbs
  
  • Percentage of time Carrying: Less than 0 %

Benefits:

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.