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
• 5+ years of experience.
• Communication with Stakeholders and Technical Teams
• 5+ years of experience

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

About the company

Tential Solutions