Data Analyst

Duration: 6 months contractShift: Standard Monday-Friday, approximately 8:00 AM - 4:00 PM local timeJob Description: Hands-on Data Analyst with strong operational analytics experience supporting HR, workforce planning, or resource management functions. Ideal candidates will have advanced Excel skills (pivot tables, VLOOKUPs, forecasting models), experience working with large and complex datasets, and the ability to clean, validate, transform, and integrate data from multiple systems.You should also have practical Power BI experience creating executive-level dashboards and visualizations.This role is best suited for someone who enjoys doing the day-to-day analytical work rather than operating strictly at a strategic or presentation layer.We are seeking a highly detail-oriented analyst to support execution tracking and operational management of the GDO hiring plan.This role will focus on maintaining data integrity across multiple hiring and onboarding data sources, enabling accurate reporting, and supporting end-to-end visibility from hiring plan through onboarding readiness.This is a critical role to ensure data consistency, streamline reporting, and support decision-making as GDO scales hiring across multiple programs and transitions.Key Responsibilities: Perform ongoing data entry and maintenance within SmartSheetManage and clean complex datasets from multiple systemsValidate and transform workforce/resource management dataBuild and maintain forecasting models in ExcelDevelop Power BI dashboards and executive-ready reporting visualizationsSupport operational analytics and workforce planning initiativesHandle large datasets exceeding 10,000+ lines of dataPreferred Background: Bachelor's degree requiredPreferred experience level closer to: Bachelor's + 5 years of relevant experienceStrong preference for candidates with: HR data analytics experienceWorkforce planning analyticsResource management analyticsOperational analytics environmentsBasic Qualifications: Bachelor Degree & 2+ years of experience (Engineering, Operations, OR Scientific)Must Have Skill Sets:3+ years of experience working with large datasets in an operations, analytics, or workforce planning environmentStrong data management skills, including data entry, cleansing, and validationProficiency in Excel (advanced), and experience with tools such as Smartsheet, Power BI, or similar platformsDay to Day Responsibilities:Hiring Plan Tracking & Data Management Maintain and update centralized hiring plan datasets across tools (e.g., Smartsheet, OrgVue, CapCity)Execute timely and accurate data entry for hiring plan updates, including roles, batches, onboarding status, and transitionsPerform ongoing data validation to identify and resolve discrepancies (e.g., duplicate roles, inconsistent classifications, missing fields)Data Transformation & Integration Consolidate and align data from multiple sources into a unified dataset to enable reporting and dashboardingSupport transformation of raw data into structured formats for Power BI or reporting toolsIdentify gaps in data fields (e.g., screening status, interview stages, financials) and recommend enhancementsExecution & Reporting Support Generate and maintain tracking reports on hiring progress, onboarding status, and execution risksSupport weekly and monthly reporting cycles by ensuring data is current, complete, and reconciledPartner with execution leads to validate hiring data and flag risks or delays (e.g., pipeline bottlenecks, onboarding readiness gaps)Program Transition & Onboarding Coordination Overlay hiring plan data with program transitions (e.g., ACT FAST, TWFS, or similar initiatives)Track movement of roles across functions or programs and ensure alignment with onboarding readinessSupport tracking of onboarding activities, including coordination inputs (e.g., trainer assignments, onboarding timelines)Data Governance & Process Improvement Help establish and maintain a clear "source of truth" for hiring plan and onboarding dataIdentify opportunities to simplify tracking processes and reduce duplication across systemsDocument data definitions, processes, and assumptions to improve consistencyAbout US Tech Solutions:US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com."US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran"AI Statement: By applying, you acknowledge that AI-assisted tools may be used during hiring.