Data Analyst (Excel)

What We Do/Project

Act as the lead data analyst for all required external worker data activities in Beeline (i.e. Project Spotlight)

Job Responsibilities / Typical Day in the Role

• Define the requirements for the EW Data Collection Tool to support worker data review, and cost coding changes based on Legal Entity shifts.
• Develop automation strategy for document extraction from Beeline.
• Develop transformation logic for data mapping.
• Data extracts from Beeline, mapping, and preparation for data loads into the EW Data Collection Tool.
• Prepare data load templates for data migration to Beeline.
• Data validation activities, including master data, volume counts, and spot checks.
• Identify additional areas to apply automation and develop for EW data collection and migration preparation.
  
  

Must Have Skills / Requirements

• Proficiency in Excel
• 5+ years of experience; Macros, Formulas, Pivot Tables, etc.
• CoPilot or other AI equivalent experience
• 5+ years of experience.
• Communication with Stakeholders and Technical Teams
• 5+ years of experience
  
  

Soft Skills

• Strong written and oral communication skills.
• Strong troubleshooting and problem-solving skills.
• High attention to detail and ability to manage multiple testing activities in parallel
• Demonstrated history of success.
• Desire to be working with data and helping businesses make better data driven decisions.
• Familiarity with data validation, testing, and cutover support
  
  

Technology Requirements

• Experience with database technologies.
• Proficient in MS Excel and Copilot
• Familiarity with the use of AI tools and automation for data extraction and collection.
  
  

Education / Certifications

• Bachelor's degree in a technical field such as computer science, computer engineering or related field required.
  
  

Additional Notes

• Sourcing in the US
• Remote – EST preferred.
  
  

#DICE