Junior Data Analyst

Crew
Raleigh, NC
Duration: FTE

Location: NC-Raleigh, 100% Remote

Overview: Crew helps our clients deliver change through IT project delivery, business process improvement, and operational efficiency efforts. Our high-performing consultants are natural leaders who manage a wide range of responsibilities that vary from assignment to assignment. Our consultant training programs, investment in career development, and premier client portfolio ensure constant challenge and rapid growth for our employees. Crew data analysis associates bring data insights to life with predictive and descriptive analytics, create meaningful business intelligence and data visualization dashboards, and learn data profiling and cloud data practices.

Responsibilities

  • Document and maintain source → target mappings (tables, fields, transformations, acceptance criteria) for UKG → Workday objects
  • Perform data profiling and DQ checks (row counts, nulls, duplicates, value ranges, PK/FK integrity) using Excel, SQL, and basic Python/pandas
  • Target-side (Workday) execution: Prepare and validate Workday EIB spreadsheet loads; reconcile results using Workday reports/RaaS; handle CSV/JSON/XML exchanges via SFTP/FTP/ as provided by integration teams
  • Source-side (UKG) reality: Work with UKG extracts/APIs (Pro and/or Dimensions) supplied by engineering or vendors; validate mappings and transformed datasets prior to Workday load
  • Create and run validation test cases across conversion stages; log results/defects and drive to closure
  • Produce audit-ready evidence packages (before/after counts, reconciliations, screenshots/artifacts, sign-off materials)
  • Capture action items from workshops; update trackers (Jira/Confluence/SharePoint) promptly and communicate status clearly
  • Partner with integration teams (internal/vendor) to align on assumptions, formats, and timelines; not expected to design/build Workday Studio or iPaaS—your focus is data prep, profiling, and post-load validation

Qualifications

  • 1–3 years in data analysis, reporting, QA, or business analytics (internships/co-ops count)
  • Strong Excel skills (lookups, pivots, text/date functions; comfortable with large datasets)
  • Working SQL (select, joins, filters, aggregates) and introductory Python/pandas (or fast learner)
  • Understanding of core data quality concepts (completeness, accuracy, consistency, lineage)
  • Clear written/verbal communication; ability to summarize findings for non-technical stakeholders
  • Experience in Financial Services or other regulated environments (banking/cards/lending/deposits)

Preferred Qualifications

  • Exposure to Workday HCM (EIB templates, RaaS/reporting) and UKG (Pro/Dimensions) data domains
  • Experience writing S2T mapping docs and test cases
  • Familiarity with Power BI or similar for quick investigations/visual checks
  • Awareness of data controls/governance (reconciliations, approvals, audit trails)
  • iPaaS familiarity (MuleSoft, Boomi, Informatica, SnapLogic)—enough to read logs/understand job runs; not required to build

The salary range for this role is $62,000 to $85,000 or the hourly equivalent. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, Turnberry Solutions offers benefits such as, a comprehensive healthcare package (medical, dental, vision), disability and group term life insurance, health and flexible spending accounts, utilization bonus, 401k, flexible time off for salaried employees, and flexible work arrangements (all benefits are subject to eligibility requirements). No matter where or when you begin a career with Turnberry, you’ll find a far-reaching choice of benefits and incentives.

At Turnberry, inclusion is one of our core values. We are committed to creating a positive and connected work environment for all and are fully invested in and focused on hiring and growing a diverse team of high performers. We believe that uniqueness in ideas, experiences, and backgrounds make us a better Turnberry: Turnberry is an Equal Employment Opportunity employer, and recruits, employs, trains, compensates, and promotes regardless of age, ancestry, family medical or genetic information, gender identity and expression, marital, military, or veteran status; national and ethnic origin; physical or mental disability; political affiliation; pregnancy; race; religion; sex; sexual orientation; and any other protected characteristics.

Americans With Disabilities Act (ADA)

Turnberry will provide reasonable accommodation with our application process upon request as required to comply with applicable laws. If you have a disability and require accommodation assistance in this application process, please send an email to our Human Resources department at [email protected] .

Posted 2025-09-13

Recommended Jobs

QC Sanitation Janitor

Alamance Foods
Burlington, NC

Job Description Job Description Essential Job Responsibilities: The primary responsibility of this position is to work as a team with your team to complete all daily sanitation requirements in…

View Details
Posted 2025-07-28

Field Engineer 4

eTeam Inc
Davidson County, NC

Pay Rate: $20- $21.43/Hour Weekly Mileage: No driving, however if needed to assist other areas resource may be required to drive Candidate(s) are NOT paid to drive to and fro…

View Details
Posted 2025-09-08

Carpenters & Craftsmen - Interview Bonus + Sign-on Bonus

Morgan Stephens
Mooresville, NC

Job Title: Hiring: Full-Time Carpenters & Craftsmen – Interview Bonus + Sign-on Bonus if Hired Company: Morgan Stephens Location: Mooresville, NC 28115 Job Type: Full-Time About th…

View Details
Posted 2025-08-07

ServiceNow Administrator Developer - WFH / C2C Accepted

Data Management Group
Charlotte, NC

ServiceNow Administrator Developer As a member of the Data Management Group professional services arm, the ServiceNow Administrator Developer is a technical role responsible for development, client …

View Details
Posted 2025-09-02

Clinical Nurse Coordinator Adult Med Surg

Mission Hospital
Asheville, NC

Clinical Nurse Coordinator Adult Med Surg Location Asheville, NC : Introduction Unit: This is a Clinical Nurse Coordinator position on A4W Do you have the career opportunities as a(an) Clinical …

View Details
Posted 2025-09-16

Pediatric Radiologist - Partnership Track! State of the art facility!

NP Now
Raleigh, NC

A thriving Radiology group is looking to add a Pediatric Radiologist to their location in Raleigh North Carolina! Partnership Track available! Contact: Raymond Stiles843-574-8233raymond@nowhealth…

View Details
Posted 2025-07-26

Senior Chemistry Consultant - BWR

SI Solutions, LLC
Huntersville, NC

  Structural Integrity Associates, Inc. (SIA) is seeking a Senior Chemistry Consultant for our Nuclear business unit. The ideal candidate will be responsible for primarily BWR chemistry consulting wor…

View Details
Posted 2025-08-18

Ophthalmic Assistant

All Jobs
Wilmington, NC

Job Description Job Description Description: About the Role: Are you someone who loves helping people see the world more clearly—literally? We’re looking for a bright, energetic, and de…

View Details
Posted 2025-07-25

Certified Nursing Assistant (CNA)

Interim HealthCare - Charlotte, NC
Deep Run, NC

Job Description Job Description Seeking work-life balance? It’s built into this CNA opportunity! At Interim HealthCare, you decide when you work and when you don’t. Whether you’re managing a fami…

View Details
Posted 2025-07-27

Security National Life Insurance Company Agent

Team Nexa Insurance Solutions
Wilson, NC

Job Description Job Description **THIS POSITION REQUIRES THAT YOU HOLD A VALID LIFE INSURANCE PRODUCERS LICENSE** Are you tired of spending thousands per month on Leads? Are you tired of being t…

View Details
Posted 2025-09-01