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).

• 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.

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

• 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.

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

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

• Sourcing in the US.
• Remote – EST preferred.